@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 <ambilal...@gmail.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+s1045698n5786458...@n5.nabble.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.
