aboutsummaryrefslogtreecommitdiffstats
path: root/docker-compose/docker-compose.yml
diff options
context:
space:
mode:
authorhalil.cakal <halil.cakal@est.tech>2025-01-29 13:24:02 +0000
committerhalil.cakal <halil.cakal@est.tech>2025-01-30 16:04:07 +0000
commit59f1cc4c5994da34f2c48a2347499f9cfb7bd836 (patch)
treef9f962ca4ab4aed16eeb760b4fecb3a506418ecf /docker-compose/docker-compose.yml
parentdfb5651ab58e15dd683e111156d7a22687e79a01 (diff)
Add new dashboard to monitor some of the stats of PostgreSQL
- add postgres-exporter service to expose postgresql db metrics to prometheus - add new job scraper to prometheus for both kpi and endurance jobs - add new dashboard: postgresql-statistics to the grafana Issue-ID: CPS-2585 Change-Id: Ia7ede41d00364918b1054d9b5a38e2feea4fc8e5 Signed-off-by: halil.cakal <halil.cakal@est.tech>
Diffstat (limited to 'docker-compose/docker-compose.yml')
-rw-r--r--docker-compose/docker-compose.yml12
1 files changed, 12 insertions, 0 deletions
diff --git a/docker-compose/docker-compose.yml b/docker-compose/docker-compose.yml
index fe6966005f..11a2c7912e 100644
--- a/docker-compose/docker-compose.yml
+++ b/docker-compose/docker-compose.yml
@@ -202,6 +202,7 @@ services:
- ./config/grafana/jvm-micrometer-dashboard.json:/var/lib/grafana/dashboards/jvm-micrometer-dashboard.json
- ./config/grafana/inventory-dashboard.json:/var/lib/grafana/dashboards/inventory-dashboard.json
- ./config/grafana/data-dashboard.json:/var/lib/grafana/dashboards/data-dashboard.json
+ - ./config/grafana/postgresql-statistics-dashboard.json:/var/lib/grafana/dashboards/postgresql-statistics-dashboard.json
- grafana:/var/lib/grafana
environment:
- GF_SECURITY_ADMIN_PASSWORD=admin
@@ -230,6 +231,17 @@ services:
profiles:
- tracing
+ postgres-exporter:
+ image: quay.io/prometheuscommunity/postgres-exporter
+ environment:
+ - DATA_SOURCE_NAME=postgresql://${DB_USERNAME:-cps}:${DB_PASSWORD:-cps}@${DB_CONTAINER_NAME:-dbpostgresql}:5432/postgres?sslmode=disable
+ ports:
+ - ${POSTGRES_EXPORTER_PORT_RANGE:-9187-9188}:9187
+ depends_on:
+ - dbpostgresql
+ profiles:
+ - monitoring
+
volumes:
grafana:
driver: local