Promhub Logo Prom hub

Postgresql
46,751

Created 11/15/2022
Updated 11/15/2022
Revision 1
Categories
Databases
Grafana Version >=9.2.3
Datasources
PrometheusLoki

expose postgresql metrics to prometheus format with telegraf. Also scrape postgresql logs with loki from telegraf tail plugin. This can be used to monitor postgresql instances managed by a zalando postgresql oeprator with a telegraf sidecar.

Export Dashboard✕
Download
Copy to Clipboard
Dashboard screenshot 1

Used Metrics 33

  • postgresql_numbackends

  • postgresql_replication_lag

  • container_memory_usage_bytes

  • kube_pod_container_resource_limits

  • postgresql_nb_connections

  • disk_used_percent

  • container_start_time_seconds

  • postgresql_checkpoint_sync_time

  • postgresql_checkpoint_write_time

  • postgresql_checkpoints_req

  • postgresql_checkpoints_timed

  • postgresql_buffers_alloc

  • postgresql_buffers_backend

  • postgresql_buffers_checkpoint

  • postgresql_buffers_clean

  • postgresql_buffers_backend_fsync

  • postgresql_table_total_disc_size

  • postgresql_tup_deleted

  • postgresql_tup_fetched

  • postgresql_tup_inserted

  • postgresql_tup_returned

  • postgresql_tup_updated

  • postgresql_xact_commit

  • postgresql_xact_rollback

  • postgresql_blk_read_time

  • postgresql_blk_write_time

  • postgresql_blks_hit

  • postgresql_blks_read

  • json

  • line_format

  • source

  • database

  • message