Postgres Pro
Downloads
Home   >   mailing lists

Re: How to know server status variable in postgresql? - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: How to know server status variable in postgresql?
Date
Msg-id CABRT9RDLRjsJJtaK6cxhCzZ9Q8vS2yy_JLXDcjDL0gi10tVXhA@mail.gmail.com
Whole thread Raw
In response to Re: How to know server status variable in postgresql?  (ambilalmca <ambilalmca@gmail.com>)
List pgsql-general
Tree view 
On Wed, Jan 15, 2014 at 7:36 AM, ambilalmca <ambilalmca@gmail.com> wrote:
> can you tell me the full query for that? because in pg_stat_all_tables contains many fields. i dont know whats the
correctone to get the result. 

>>>> *Number of cached blocks read,

>>>> Number of cached index blocks read,

They're in pg_statio_all_tables, it's all documented at:
http://www.postgresql.org/docs/current/static/monitoring-stats.html

Regards,
Marti

pgsql-general by date:

Previous
From: saggarwal
Date:
Subject: pg_depend OBJID not found
Next
From: Felix.徐
Date:
Subject: How are pg_operator and pg_type related with each other?