pg_statio_all_tables columns

From: Xenofon Papadopoulos <xpapad(at)gmail(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: pg_statio_all_tables columns
Date: 2013-09-30 12:45:46
Message-ID: CANL7jAQr_rrkz2u+OS=mwvh1Aj5S5uTYSviu+vDPa-cc4DxiZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I am trying to understand the heap_blks_read and heap_blks_hit of
pg_statio_all_tables in 9.2
Do the numbers refer only to SELECT, or they take INSERT into account?
Would a heap_blks_read / ( heap_blks_read + heap_blks_hit ) ration of over
55% combined with a heap_blks_read value of over 50M indicate an issue with
the queries affecting that table, or it is normal if the table is heavily
written to?
Thanks

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Giuseppe Broccolo 2013-09-30 14:40:49 Re: pg_statio_all_tables columns
Previous Message hubert depesz lubaczewski 2013-09-30 07:05:11 Re: BASH script for collecting analyze-related info