On Wed, Jan 15, 2014 at 7:36 AM, ambilalmca <ambilalmca@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
