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