8.6. Database Usage Metrics #

Metrics based on the pg_stat_database view:

  • postgresql.databases.active_time_milliseconds

  • postgresql.databases.backends

  • postgresql.databases.block_read_time_milliseconds

  • postgresql.databases.blocks_hit

  • postgresql.databases.blocks_read

  • postgresql.databases.block_write_time_milliseconds

  • postgresql.databases.checksum_failures

  • postgresql.databases.checksum_last_failure_unixtime

  • postgresql.databases.commits

  • postgresql.databases.conflicts

  • postgresql.databases.deadlocks

  • postgresql.databases.idle_in_transaction_time_milliseconds

  • postgresql.databases.orphaned_files

  • postgresql.databases.orphaned_files_max_age_milliseconds

  • postgresql.databases.orphaned_files_size_bytes

  • postgresql.databases.rollbacks

  • postgresql.databases.session_time_milliseconds

  • postgresql.databases.sessions_abandoned

  • postgresql.databases.sessions_fatal

  • postgresql.databases.sessions_killed

  • postgresql.databases.sessions

  • postgresql.databases.size_bytes

  • postgresql.databases.stats_reset_unixtime

  • postgresql.databases.temp_bytes

  • postgresql.databases.temp_files

  • postgresql.databases.tuples_deleted

  • postgresql.databases.tuples_fetched

  • postgresql.databases.tuples_inserted

  • postgresql.databases.tuples_returned

  • postgresql.databases.tuples_updated

  • postgresql.cache.hit_ratio

Metrics based on the pg_stat_database view, available from Postgres Pro and PostgreSQL 18:

  • postgresql.databases.parallel_workers_to_launch

  • postgresql.databases.parallel_workers_launched