PostgreSQL Monitoring Dashboard
가져오는 방법
Datadog에서 Dashboards → New Dashboard → ⚙ Configure → Import dashboard JSON 순으로 이동한 뒤 이 JSON을 붙여넣으세요.
반응
PostgreSQL Performance Monitoring Dashboard This dashboard provides comprehensive monitoring for PostgreSQL databases using pg_exporter metrics. KEY SECTIONS: - Instance Information: PostgreSQL version, settings, and uptime - Critical Alerts: Connection pool utilization and performance warnings - Connection Analysis: Active connections, idle transactions, and connection age - Query Performance: Top queries by execution time, calls, and I/O (requires pg_stat_statements extension) - Cache & I/O: B
변환 품질
좋음 91쿼리가 손실 없이 변환된 패널의 비율입니다. 일부만 변환됐거나 지원되지 않는 패널은 원본 PromQL을 노트 위젯에 그대로 남겨 둡니다.
- 기본 통합11
- OpenMetrics126
- 일부 변환14
- 미지원7
Datadog 기본 통합 메트릭으로 매핑되지 않은 항목
OpenMetrics 이름을 그대로 사용한 메트릭입니다. Datadog 기본 통합으로 수집 중이라면 메트릭 이름을 맞춰 주세요.
pg_stat_io_evictions_total ×4pg_stat_io_reads_total ×4pg_settings_checkpoint_timeout_seconds ×3postgres_pg_stat_statements_total_exec_time_seconds ×3postgres_pg_stat_statements_calls_total ×3pg_stat_user_tables_seq_scan ×3pg_stat_io_hits_total ×3pg_stat_activity_idle_in_transaction ×2pg_stat_activity_idle_in_transaction_aborted ×2pg_stat_activity_max_connections ×2pg_stat_activity_idle_connections ×2pg_stat_activity_count ×2pg_stat_database_sessions_total ×2pg_stat_database_session_time_seconds_total ×2pg_stat_checkpointer_timed_total ×2pg_stat_checkpointer_requested_total ×2pg_stat_wal_records_total ×2pg_stat_wal_fpi_total ×2postgres_pg_stat_statements_wal_bytes_total ×2postgres_pg_stat_statements_temp_blks_written_total ×2postgres_pg_stat_statements_temp_blks_read_total ×2postgres_pg_stat_statements_cache_hit_ratio ×2pg_blocked_sessions ×2pg_stat_user_tables_n_tup_upd ×2pg_stat_user_tables_idx_scan ×2pg_stat_user_tables_heap_blks_hit_total ×2pg_stat_user_tables_heap_blks_read_total ×2pg_database_size_bytes ×2pg_index_idx_blks_hit_total ×2pg_index_idx_blks_read_total ×2pg_stat_activity_on_cpu_backends ×2pg_stat_io_read_bytes_total ×2pg_stat_io_write_bytes_total ×2pg_stat_io_fsyncs_total ×2pg_sequence_used_ratio ×2pg_stat_slru_blks_read_total ×2pg_system_cpu_seconds_total ×2pg_exporter_process_cpu_percent ×2pg_version_infopg_postmaster_start_time_secondspg_settings_max_connectionspg_settings_autovacuumpg_settings_fsyncpg_settings_synchronous_commitpg_settings_max_locks_per_transactionpg_settings_shared_buffers_bytespg_settings_work_mem_bytespg_settings_maintenance_work_mem_bytespg_settings_wal_buffers_bytespg_settings_autovacuum_max_workers지원되지 않는 패널
- Data Checksums
state-timeline - Last Checksum Failure
stat - Sequences ≥ 90% Consumed
stat - CPU Busy (normalized across cores)
timeseries - Collector Health Timeline
state-timeline - Time Since Last Scrape
bargauge - Uptime
stat
리비전 이력
- 리비전 1Converted from grafana.com revision 11JSON 다운로드
이 대시보드 평가하기
평가하려면 로그인이 필요합니다.댓글 0개
아직 댓글이 없습니다.