Metrics based on the
pg_stat_all_tables,
pg_statio_all_tables,
and
pg_tables
views:
postgresql.tables.analyze_count
postgresql.tables.autoanalyze_count
postgresql.tables.autovacuum_count
postgresql.tables.heap_blocks_hit
postgresql.tables.heap_blocks_read
postgresql.tables.heap_size_bytes
postgresql.tables.toast_heap_blocks_hit
postgresql.tables.index_blocks_read
postgresql.tables.index_scan
postgresql.tables.index_tuples_fetch
postgresql.tables.last_analyze_time_unixtime
postgresql.tables.last_autoanalyze_time_unixtime
postgresql.tables.last_autovacuum_time_unixtime
postgresql.tables.last_vacuum_time_unixtime
postgresql.tables.seq_scan
postgresql.tables.seq_tuples_fetch
postgresql.tables.size_bytes
postgresql.tables.toast_heap_blocks_hit
postgresql.tables.toast_heap_blocks_read
postgresql.tables.toast_index_blocks_hit
postgresql.tables.toast_index_blocks_read
postgresql.tables.toast_size_bytes
postgresql.tables.tuples_dead
postgresql.tables.tuples_deleted
postgresql.tables.tuples_hot_updated
postgresql.tables.tuples_inserted_since_vacuum
postgresql.tables.tuples_inserted
postgresql.tables.tuples_live
postgresql.tables.tuples_modified_since_analyze
postgresql.tables.tuples_updated
postgresql.tables.vacuum_count
Starting from Postgres Pro and PostgreSQL 18, the following additional metrics are available:
postgresql.tables.total_autoanalyze_time_milliseconds
postgresql.tables.total_autovacuum_time_milliseconds
postgresql.tables.total_analyze_time_milliseconds
postgresql.tables.total_vacuum_time_milliseconds