On Wed, Jan 15, 2014 at 7:36 AM, ambilalmca <ambilal...@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 correct one 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
