Postgres Pro
Downloads
Home   >   mailing lists

pg_statio_all_tables columns - Mailing list pgsql-performance

From Xenofon Papadopoulos
Subject pg_statio_all_tables columns
Date
Msg-id CANL7jAQr_rrkz2u+OS=mwvh1Aj5S5uTYSviu+vDPa-cc4DxiZQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_statio_all_tables columns
Re: pg_statio_all_tables columns
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: BASH script for collecting analyze-related info
Next
From: Giuseppe Broccolo
Date:
Subject: Re: pg_statio_all_tables columns