PostgreSQL Statistics 1,9291,929
Improvements for https://grafana.com/grafana/dashboards/6742.
Dependencies:
- postgres_exporter version 0.11.1
Changes includes:
- support for scraping multiple postgres exporters from a single prometheus instance
- only list databases scraped by a postgres exporter instance
- graph showing database size
Used Metrics 3434
-
pg_static
-
pg_settings_max_connections
-
pg_settings_shared_buffers_bytes
-
pg_settings_effective_cache_size_bytes
-
pg_settings_maintenance_work_mem_bytes
-
pg_settings_work_mem_bytes
-
pg_settings_max_wal_size_bytes
-
pg_settings_random_page_cost
-
pg_settings_seq_page_cost
-
pg_settings_max_worker_processes
-
pg_settings_max_parallel_workers
pg_database_size_bytes
-
pg_stat_activity_count
-
pg_stat_database_xact_commit
-
pg_stat_database_xact_rollback
-
pg_stat_database_tup_fetched
-
pg_stat_database_tup_returned
-
pg_stat_database_tup_inserted
-
pg_stat_database_tup_updated
-
pg_stat_database_tup_deleted
-
pg_stat_activity_max_tx_duration
-
pg_stat_database_blks_hit
-
pg_stat_database_blks_read
pg_stat_bgwriter_buffers_backend_total
pg_stat_bgwriter_buffers_alloc_total
pg_stat_bgwriter_buffers_backend_fsync_total
pg_stat_bgwriter_buffers_checkpoint_total
pg_stat_bgwriter_buffers_clean_total
-
pg_stat_database_conflicts
-
pg_stat_database_deadlocks
-
pg_locks_count
-
pg_stat_database_temp_bytes
pg_stat_bgwriter_checkpoint_write_time_total
pg_stat_bgwriter_checkpoint_sync_time_total