8.14. Table Usage Metrics #

Metrics based on the pg_stat_all_tables and pg_statio_all_tables views:

  • 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