8.14. Table Usage Metrics #
Metrics based on the pg_stat_all_tables and pg_statio_all_tables views:
postgresql_tables_analyze_count_totalpostgresql_tables_autoanalyze_count_totalpostgresql_tables_autovacuum_count_totalpostgresql_tables_heap_blocks_hit_totalpostgresql_tables_heap_blocks_read_totalpostgresql_tables_heap_size_bytespostgresql_tables_toast_heap_blocks_hit_totalpostgresql_tables_index_blocks_read_totalpostgresql_tables_index_scan_totalpostgresql_tables_index_tuples_fetch_totalpostgresql_tables_last_analyze_time_unixtimepostgresql_tables_last_autoanalyze_time_unixtimepostgresql_tables_last_autovacuum_time_unixtimepostgresql_tables_last_vacuum_time_unixtimepostgresql_tables_seq_scan_totalpostgresql_tables_seq_tuples_fetch_totalpostgresql_tables_size_bytespostgresql_tables_toast_heap_blocks_hit_totalpostgresql_tables_toast_heap_blocks_read_totalpostgresql_tables_toast_index_blocks_hit_totalpostgresql_tables_toast_index_blocks_read_totalpostgresql_tables_toast_size_bytespostgresql_tables_tuples_deadpostgresql_tables_tuples_deleted_totalpostgresql_tables_tuples_hot_updated_totalpostgresql_tables_tuples_inserted_since_vacuum_totalpostgresql_tables_tuples_inserted_totalpostgresql_tables_tuples_livepostgresql_tables_tuples_modified_since_analyze_totalpostgresql_tables_tuples_updated_totalpostgresql_tables_vacuum_count_total