8.14. Метрики использования таблиц #
Метрики на основе представлений pg_stat_all_tables
и pg_statio_all_tables
:
postgresql_tables_analyze_count_total
postgresql_tables_autoanalyze_count_total
postgresql_tables_autovacuum_count_total
postgresql_tables_heap_blocks_hit_total
postgresql_tables_heap_blocks_read_total
postgresql_tables_heap_size_bytes
postgresql_tables_toast_heap_blocks_hit_total
postgresql_tables_index_blocks_read_total
postgresql_tables_index_scan_total
postgresql_tables_index_tuples_fetch_total
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_total
postgresql_tables_seq_tuples_fetch_total
postgresql_tables_size_bytes
postgresql_tables_toast_heap_blocks_hit_total
postgresql_tables_toast_heap_blocks_read_total
postgresql_tables_toast_index_blocks_hit_total
postgresql_tables_toast_index_blocks_read_total
postgresql_tables_toast_size_bytes
postgresql_tables_tuples_dead
postgresql_tables_tuples_deleted_total
postgresql_tables_tuples_hot_updated_total
postgresql_tables_tuples_inserted_since_vacuum_total
postgresql_tables_tuples_inserted_total
postgresql_tables_tuples_live
postgresql_tables_tuples_modified_since_analyze_total
postgresql_tables_tuples_updated_total
postgresql_tables_vacuum_count_total