8.6. Метрики использования баз данных #
Метрики на основе представления pg_stat_database:
postgresql_databases_active_time_milliseconds_totalpostgresql_databases_backendspostgresql_databases_block_read_time_milliseconds_totalpostgresql_databases_blocks_hit_totalpostgresql_databases_blocks_read_totalpostgresql_databases_block_write_time_milliseconds_totalpostgresql_databases_checksum_failures_totalpostgresql_databases_checksum_last_failure_unixtimepostgresql_databases_commits_totalpostgresql_databases_conflicts_totalpostgresql_databases_deadlocks_totalpostgresql_databases_idle_in_transaction_time_milliseconds_totalpostgresql_databases_orphaned_filespostgresql_databases_orphaned_files_max_age_millisecondspostgresql_databases_orphaned_files_size_bytespostgresql_databases_rollbacks_totalpostgresql_databases_session_time_milliseconds_totalpostgresql_databases_sessions_abandoned_totalpostgresql_databases_sessions_fatal_totalpostgresql_databases_sessions_killed_totalpostgresql_databases_sessions_totalpostgresql_databases_size_bytespostgresql_databases_stats_reset_unixtimepostgresql_databases_temp_bytes_totalpostgresql_databases_temp_files_totalpostgresql_databases_tuples_deleted_totalpostgresql_databases_tuples_fetched_totalpostgresql_databases_tuples_inserted_totalpostgresql_databases_tuples_returned_totalpostgresql_databases_tuples_updated_totalpostgresql_cache_hit_ratio