Re: How to know server status variable in postgresql?

[ambilalmca <ambilalmca@xxxxxxxxx>]

@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 <[hidden email]> 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] <[hidden email]> wrote:

On Fri, Jan 10, 2014 at 2:57 PM, ambilalmca <[hidden email]> 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])

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.
NAML

---

View this message in context: Re: How to know server status variable in postgresql?
Sent from the PostgreSQL - general mailing list archive at Nabble.com.