On Wed, Jan 15, 2014 at 7:36 AM, ambilalmca <ambilalmca(at)gmail(dot)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