Postgres Pro OpenTelemetry Collector : Documentation: 0.5: 8.14. Table Usage Metrics : Postgres Professional

8.14. Table Usage Metrics
Prev	Up	Chapter 8. Metrics	Home	Next

8.14. Table Usage Metrics #

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

Prev	Up	Next
8.13. SQL Query and Statement Metrics	Home	8.15. Tablespace Usage Metrics

epub pdf