PG_STATIO_USER_TABLES Sistem Tablosu - View to monitor disk I/O Activity For Individual Tables

Örnek

Şöyle yaparız

SELECT relname, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit
FROM pg_statio_user_tables;

Açıklaması şöyle

This query returns a row for each table in the database, with columns for the number of blocks read and hit for both the table and its indexes. A high ratio of “hit” to “read” indicates that data is being retrieved from the cache, which is typically a good sign of good performance.