pgwatch3/docker-compose.yml at master · muni106/pgwatch3 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
version: "3.9"

services:
  postgres:
    # if you want vanilla experience use "postgres:latest" image and remove "timescaledb" from shared_preload_libraries
    image: &pgimage timescale/timescaledb:latest-pg16
    user: postgres
    command:
      - "-cshared_preload_libraries=pg_stat_statements,timescaledb"
      - "-cpg_stat_statements.track=all"
      - "-ctrack_io_timing=on"
      - "-ctrack_functions=pl"
    ports:
      - "5432:5432"
    environment:
      POSTGRES_HOST_AUTH_METHOD: trust
    volumes:
      - "./docker/bootstrap/create_role_db.sql:/docker-entrypoint-initdb.d/create_role_db.sql"
    healthcheck:
      test: ["CMD-SHELL", "pg_isready"]
      interval: 10s
      timeout: 5s
      retries: 5

  grafana:
    image: grafana/grafana:latest
    user: "0:0"
    environment:
      GF_DATABASE_TYPE: postgres
      GF_DATABASE_HOST: postgres:5432
      GF_DATABASE_NAME: pgwatch3_grafana
      GF_DATABASE_USER: pgwatch3
      GF_DATABASE_PASSWORD: pgwatch3admin
      GF_DATABASE_SSL_MODE: disable
      GF_AUTH_ANONYMOUS_ENABLED: true
      GF_DASHBOARDS_DEFAULT_HOME_DASHBOARD_PATH: /var/lib/grafana/dashboards/1-global-db-overview.json
      GF_INSTALL_PLUGINS: marcusolsson-treemap-panel
    ports:
      - "3000:3000"
    restart: unless-stopped
    volumes:
      - "./grafana/postgres_datasource.yml:/etc/grafana/provisioning/datasources/pg_ds.yml"
      - "./grafana/postgres_dashboard.yml:/etc/grafana/provisioning/dashboards/pg_db.yml"
      - "./grafana/postgres/v10:/var/lib/grafana/dashboards"
    depends_on:
      postgres:
        condition: service_healthy

  pgwatch3:
    # uncomment build section below for dev experience
    build:
      context: .
      dockerfile: ./docker/Dockerfile
    image: cybertecpostgresql/pgwatch3:latest
    environment:
      PW3_CONFIG: postgresql://pgwatch3@postgres:5432/pgwatch3
      PW3_SINK: postgresql://pgwatch3@postgres:5432/pgwatch3_metrics
    ports:
      - "8080:8080"
    depends_on:
      postgres:
        condition: service_healthy


  add-test-db:
    image: *pgimage
    environment:
      PGHOST: postgres
      PGUSER: postgres # we need superuser to create extensions
      PGDATABASE: pgwatch3
    command: >
      psql -v ON_ERROR_STOP=1
        -f /tmp/00_helpers/get_table_bloat_approx/9.5/metric.sql
        -f /tmp/00_helpers/get_table_bloat_approx_sql/12/metric.sql
        -c "INSERT INTO pgwatch3.monitored_db (md_name, md_preset_config_name, md_connstr)
          SELECT 'test', 'exhaustive', 'postgresql://pgwatch3:pgwatch3admin@postgres/pgwatch3'
          WHERE NOT EXISTS (SELECT * FROM pgwatch3.monitored_db WHERE md_name = 'test')"
    volumes:
      - "./src/metrics/sql/00_helpers:/tmp/00_helpers"
    depends_on:
      postgres:
        condition: service_healthy
    profiles:
      - add-test-db

  pgbench:
    image: *pgimage
    environment:
      PGHOST: postgres
      PGUSER: pgwatch3
      PGDATABASE: pgwatch3
    command: >
      sh -c "pgbench --initialize --scale=50 &&
        pgbench --progress=5 --client=10 --jobs=2 --transactions=10000 &&
        pgbench --initialize --init-steps=d"
    depends_on:
      postgres:
        condition: service_healthy
    profiles:
      - pgbench

  # prometheus:
  #   image: prom/prometheus
  #   command:
  #     - '--config.file=/etc/prometheus/prometheus.yml'
  #   ports:
  #     - 9090:9090
  #   restart: unless-stopped
  #   volumes:
  #     - "./docker/prometheus.yml:/etc/prometheus/prometheus.yml"