4.6. Database Usage Metrics #
Metrics based on the pg_stat_database view, collected by the following plugins:
the databases plugin:
postgresql.databases.active_time_milliseconds{database}postgresql.databases.backends{database}postgresql.databases.block_read_time_milliseconds{database}postgresql.databases.blocks_hit{database}postgresql.databases.blocks_read{database}postgresql.databases.block_write_time_milliseconds{database}postgresql.databases.checksum_failures{database}postgresql.databases.checksum_last_failure_unixtime{database}postgresql.databases.commits{database}postgresql.databases.conflicts{database}postgresql.databases.deadlocks{database}postgresql.databases.idle_in_transaction_time_milliseconds{database}postgresql.databases.orphaned_files{database}postgresql.databases.orphaned_files_max_age_milliseconds{database}postgresql.databases.orphaned_files_size_bytes{database}postgresql.databases.rollbacks{database}postgresql.databases.session_time_milliseconds{database}postgresql.databases.sessions_abandoned{database}postgresql.databases.sessions_fatal{database}postgresql.databases.sessions_killed{database}postgresql.databases.sessions{database}postgresql.databases.size_bytes{database}postgresql.databases.stats_reset_unixtime{database}postgresql.databases.temp_bytes{database}postgresql.databases.temp_files{database}postgresql.databases.tuples_deleted{database}postgresql.databases.tuples_fetched{database}postgresql.databases.tuples_inserted{database}postgresql.databases.tuples_returned{database}postgresql.databases.tuples_updated{database}available from Postgres Pro and PostgreSQL 18:
postgresql.databases.parallel_workers_to_launch{database}postgresql.databases.parallel_workers_launched{database}
the cache plugin:
postgresql.cache.hit_ratio