Re: How to know server status variable in postgresql?

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-tp5785677p5787156.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.