8.6. Database Usage Metrics #
Metrics based on the pg_stat_database view:
postgresql.databases.active_time_millisecondspostgresql.databases.backendspostgresql.databases.block_read_time_millisecondspostgresql.databases.blocks_hitpostgresql.databases.blocks_readpostgresql.databases.block_write_time_millisecondspostgresql.databases.checksum_failurespostgresql.databases.checksum_last_failure_unixtimepostgresql.databases.commitspostgresql.databases.conflictspostgresql.databases.deadlockspostgresql.databases.idle_in_transaction_time_millisecondspostgresql.databases.orphaned_filespostgresql.databases.orphaned_files_max_age_millisecondspostgresql.databases.orphaned_files_size_bytespostgresql.databases.rollbackspostgresql.databases.session_time_millisecondspostgresql.databases.sessions_abandonedpostgresql.databases.sessions_fatalpostgresql.databases.sessions_killedpostgresql.databases.sessionspostgresql.databases.size_bytespostgresql.databases.stats_reset_unixtimepostgresql.databases.temp_bytespostgresql.databases.temp_filespostgresql.databases.tuples_deletedpostgresql.databases.tuples_fetchedpostgresql.databases.tuples_insertedpostgresql.databases.tuples_returnedpostgresql.databases.tuples_updatedpostgresql.cache.hit_ratio
Metrics based on the pg_stat_database view, available from Postgres Pro and PostgreSQL 18:
postgresql.databases.parallel_workers_to_launchpostgresql.databases.parallel_workers_launched