Метрики
Страница содержит описание групп метрик которые есть в
коллекторе.
Метрики активности
Метрики на основе pg_stat_activity:
- postgresql_activity_connections
- postgresql_activity_transactions_max_duration_milliseconds
- postgresql_activity_vacuums
- postgresql_activity_vacuums_max_duration_milliseconds
- postgresql_activity_wait_events
Метрики архивирования WAL
журнала
Метрики на основе pg_stat_archiver:
- postgresql_archiver_archived_count_total
- postgresql_archiver_failed_count_total
- postgresql_archiver_last_archived_time_unixtime
- postgresql_archiver_last_failed_time_unixtime
- postgresql_archiver_stats_reset_unixtime
Метрики фоновой записи
Метрики на основе pg_stat_bgwriter:
- postgresql_bgwriter_buffers_allocated_total
- postgresql_bgwriter_buffers_backend_fsync_total
- postgresql_bgwriter_buffers_backend_total
- postgresql_bgwriter_buffers_checkpoint_total
- postgresql_bgwriter_buffers_clean_total
- postgresql_bgwriter_checkpoint_sync_time_milliseconds_total
- postgresql_bgwriter_checkpoint_write_time_milliseconds_total
- postgresql_bgwriter_checkpoints_requested_total
- postgresql_bgwriter_checkpoints_timed_total
- postgresql_bgwriter_maxwritten_clean_total
- postgresql_bgwriter_stats_reset_unixtime
Метрики раздувания таблиц
и индексов
Метрики на основе информации из системного каталога:
- postgresql_bloat_index_bytes
- postgresql_bloat_table_bytes
Метрики
утилизации общего кэша (pg_buffercache)
Метрики на основе pg_buffercache:
- postgresql_buffercache_used
- postgresql_buffercache_unused
- postgresql_buffercache_dirty
- postgresql_buffercache_pinned
- postgresql_buffercache_usagecount_avg
Метрики использования баз
данных
Метрики на основе pg_stat_database:
- postgresql_databases_active_time_milliseconds_total
- postgresql_databases_backends
- postgresql_databases_block_read_time_milliseconds_total
- postgresql_databases_blocks_hit_total
- postgresql_databases_blocks_read_total
- postgresql_databases_block_write_time_milliseconds_total
- postgresql_databases_checksum_failures_total
- postgresql_databases_checksum_last_failure_unixtime
- postgresql_databases_commits_total
- postgresql_databases_conflicts_total
- postgresql_databases_deadlocks_total
- postgresql_databases_idle_in_transaction_time_milliseconds_total
- postgresql_databases_orphaned_files
- postgresql_databases_orphaned_files_max_age_milliseconds
- postgresql_databases_orphaned_files_size_bytes
- postgresql_databases_rollbacks_total
- postgresql_databases_session_time_milliseconds_total
- postgresql_databases_sessions_abandoned_total
- postgresql_databases_sessions_fatal_total
- postgresql_databases_sessions_killed_total
- postgresql_databases_sessions_total
- postgresql_databases_size_bytes
- postgresql_databases_stats_reset_unixtime
- postgresql_databases_temp_bytes_total
- postgresql_databases_temp_files_total
- postgresql_databases_tuples_deleted_total
- postgresql_databases_tuples_fetched_total
- postgresql_databases_tuples_inserted_total
- postgresql_databases_tuples_returned_total
- postgresql_databases_tuples_updated_total
Метрики
использования пользовательских функций
Метрики на основе pg_stat_user_functions:
- postgresql_functions_calls_total
- postgresql_functions_self_time_milliseconds_total
- postgresql_functions_time_milliseconds_total
Метрики использования
индексов
Метрики на основе pg_stat_all_indexes, pg_statio_all_indexes:
- postgresql_indexes_blocks_hit_total
- postgresql_indexes_blocks_read_total
- postgresql_indexes_scan_total
- postgresql_indexes_size_bytes
- postgresql_indexes_tuples_fetch_total
- postgresql_indexes_tuples_read_total
Метрики блокировок
Метрики на основе pg_locks:
- postgresql_locks_all
- postgresql_locks_waiting
- postgresql_locks_waiting_max_duration_milliseconds
Метрики подготовленных
транзакций
Метрики на основе pg_prepared_xacts:
- postgresql_prepared_transactions_all_total
- postgresql_prepared_transactions_max_duration_milliseconds
Метрики репликации
Общие
- postgresql_replication_status_info
Метрики ведущего узла, на основе pg_stat_replication:
- postgresql_replication_walsender_all_lag_bytes
- postgresql_replication_walsender_all_lag_milliseconds
- postgresql_replication_walsender_flush_lag_bytes
- postgresql_replication_walsender_flush_lag_milliseconds
- postgresql_replication_walsender_info
- postgresql_replication_walsender_pending_lag_bytes
- postgresql_replication_walsender_replay_lag_bytes
- postgresql_replication_walsender_replay_lag_milliseconds
- postgresql_replication_walsender_write_lag_bytes
- postgresql_replication_walsender_write_lag_milliseconds
Метрики ведомого узла, на основе pg_stat_wal_receiver:
- postgresql_replication_walreceiver_flush_lag_bytes
- postgresql_replication_walreceiver_info
- postgresql_replication_walreceiver_ping_milliseconds
- postgresql_replication_walreceiver_received_bytes
Метрики слотов репликации
Метрики на основе pg_replication_slots:
- postgresql_replication_slots_info
- postgresql_replication_slots_lag_bytes
- postgresql_replication_slots_safe_wal_size_bytes
- postgresql_replication_slots_wal_retain_bytes
- postgresql_replication_slots_transactions_retain_age_unixtime
Метрики по SQL-запросам и
операторам
Метрики на основе pg_stat_statements:
- postgresql_statements_blocks_read_time_milliseconds_total
- postgresql_statements_blocks_write_time_milliseconds_total
- postgresql_statements_calls_total
- postgresql_statements_exec_time_milliseconds_total
- postgresql_statements_jit_emission_count_total
- postgresql_statements_jit_emission_time_milliseconds_total
- postgresql_statements_jit_functions_total
- postgresql_statements_jit_generation_time_milliseconds_total
- postgresql_statements_jit_inlining_count_total
- postgresql_statements_jit_inlining_time_milliseconds_total
- postgresql_statements_jit_optimization_count_total
- postgresql_statements_jit_optimization_time_milliseconds_total
- postgresql_statements_local_blocks_dirtied_total
- postgresql_statements_local_blocks_hit_total
- postgresql_statements_local_blocks_read_total
- postgresql_statements_local_blocks_written_total
- postgresql_statements_plan_time_milliseconds_total
- postgresql_statements_plans_total
- postgresql_statements_query_info
- postgresql_statements_rows_total
- postgresql_statements_shared_blocks_dirtied_total
- postgresql_statements_shared_blocks_hit_total
- postgresql_statements_shared_blocks_read_total
- postgresql_statements_shared_blocks_written_total
- postgresql_statements_temp_blocks_read_time_milliseconds_total
- postgresql_statements_temp_blocks_read_total
- postgresql_statements_temp_blocks_write_time_milliseconds_total
- postgresql_statements_temp_blocks_written_total
- postgresql_statements_wal_bytes_total
- postgresql_statements_wal_fpi_total
- postgresql_statements_wal_records_total
Метрики использования таблиц
Метрики на основе pg_stat_all_tables, pg_statio_all_tables:
- postgresql_tables_analyze_count_total
- postgresql_tables_autoanalyze_count_total
- postgresql_tables_autovacuum_count_total
- postgresql_tables_heap_blocks_hit_total
- postgresql_tables_heap_blocks_read_total
- postgresql_tables_heap_size_bytes
- postgresql_tables_index_blocks_hit_total
- postgresql_tables_index_blocks_read_total
- postgresql_tables_index_scan_total
- postgresql_tables_index_tuples_fetch_total
- postgresql_tables_last_analyze_time_unixtime
- postgresql_tables_last_autoanalyze_time_unixtime
- postgresql_tables_last_autovacuum_time_unixtime
- postgresql_tables_last_vacuum_time_unixtime
- postgresql_tables_seq_scan_total
- postgresql_tables_seq_tuples_fetch_total
- postgresql_tables_size_bytes
- postgresql_tables_toast_heap_blocks_hit_total
- postgresql_tables_toast_heap_blocks_read_total
- postgresql_tables_toast_index_blocks_hit_total
- postgresql_tables_toast_index_blocks_read_total
- postgresql_tables_toast_size_bytes
- postgresql_tables_tuples_dead
- postgresql_tables_tuples_deleted_total
- postgresql_tables_tuples_hot_updated_total
- postgresql_tables_tuples_inserted_since_vacuum_total
- postgresql_tables_tuples_inserted_total
- postgresql_tables_tuples_live
- postgresql_tables_tuples_modified_since_analyze_total
- postgresql_tables_tuples_updated_total
- postgresql_tables_vacuum_count_total
Метрики
использования табличных пространств
Метрики на основе pg_tablespace и системных функций:
- postgresql_tablespaces_active_temp_files
- postgresql_tablespaces_active_temp_files_max_age_milliseconds
- postgresql_tablespaces_active_temp_files_size_bytes
- postgresql_tablespaces_size_bytes
Прочие метрики
- postgresql_up
- postgresql_version
- postgresql_version_num
Метрики использования WAL
журнала
Метрики на основе pg_stat_wal:
- postgresql_wal_buffers_full_total
- postgresql_wal_bytes_total
- postgresql_wal_fpi_total
- postgresql_wal_records_total
- postgresql_wal_stats_reset_unixtime
- postgresql_wal_sync_time_milliseconds_total
- postgresql_wal_sync_total
- postgresql_wal_write_time_milliseconds_total
- postgresql_wal_write_total
Метрики утилизации
ввода-вывода
Метрики на основе pg_stat_io:
- postgresql_io_reads_total
- postgresql_io_writes_total
- postgresql_io_writebacks_total
- postgresql_io_extends_total
- postgresql_io_hits_total
- postgresql_io_evictions_total
- postgresql_io_reuses_total
- postgresql_io_fsyncs_total
- postgresql_io_read_bytes_total
- postgresql_io_write_bytes_total
- postgresql_io_writeback_bytes_total
- postgresql_io_extend_bytes_total
- postgresql_io_read_time_milliseconds_total
- postgresql_io_write_time_milliseconds_total
- postgresql_io_writeback_time_milliseconds_total
- postgresql_io_extend_time_milliseconds_total
- postgresql_io_fsync_time_milliseconds_total