Re: How to know server status variable in postgresql?

@sameer, can you tell me the full query for that? because in pg_stat_all_tables
contains many fields. i dont know whats the correct one to get the result.

Thanks & Regards,
A.Mohamed Bilal

On Wed, Jan 15, 2014 at 10:57 AM, Mohamed Bilal <ambilalmca(at)gmail(dot)com>wrote:

> because that is also one of the important counter to know postgresql
> server status. thats why i am asking @sameer
>
> Thanks & Regards,
> A.Mohamed Bilal
>
>
> On Sat, Jan 11, 2014 at 7:15 PM, Sameer Kumar [via PostgreSQL] <
> ml-node+s1045698n5786458h43(at)n5(dot)nabble(dot)com> wrote:
>
>>
>> On Fri, Jan 10, 2014 at 2:57 PM, ambilalmca <[hidden email]<http://user/SendEmail.jtp?type=node&node=5786458&i=0>
>> > wrote:
>>
>>> @ sameer khan,
>>
>> That's Sameer Kumar :-)
>>
>>> i got query for all except
>>
>>
>>
>>> *Number of cached blocks read,
>>>
>> check pg_stat_all_tables
>>
>>> Number of cached index blocks read,
>>
>> check pg_stat_all_indexes
>>
>>> Number of cached sequence blocks read*.
>>>
>> Why do you need this info?
>>
>>> can you tell query for these three counters only?
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://postgresql.1045698.n5.nabble.com/How-to-know-server-status-variable-in-postgresql-tp5785677p5786228.html
>>> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>>>
>>>
>>> --
>>> Sent via pgsql-general mailing list ([hidden email]<http://user/SendEmail.jtp?type=node&node=5786458&i=1>
>>> )
>>>
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-general
>>>
>>
>>
>>
>> ------------------------------
>> If you reply to this email, your message will be added to the
>> discussion below:
>>
>> http://postgresql.1045698.n5.nabble.com/How-to-know-server-status-variable-in-postgresql-tp5785677p5786458.html
>> To unsubscribe from How to know server status variable in postgresql?, click
>> here<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5785677&code=YW1iaWxhbG1jYUBnbWFpbC5jb218NTc4NTY3N3wtMTY2NzIwNTA1Mg==>
>> .
>> NAML<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>>
>
>

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-know-server-status-variable-in-postgresql-tp5785677p5787159.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.