andriik/postgres-performance-insights-exporter repository overview

docker run -it --rm --net host \
  -e DB_NAME=test \
  -e DB_USER=postgres \
  -e DB_PASSWORD=pass \
  -e DB_HOST=127.0.0.1 \
  -e DB_PORT=5432 \
  --name postgres-performance-insights-exporter \
  andriik/postgres-performance-insights-exporter

usage: postgres-performance-insights-exporter.py [-h] [--port PORT] [--db-name DB_NAME] [--db-user DB_USER] [--db-password DB_PASSWORD] [--db-host DB_HOST] [--db-port DB_PORT]
                                                 [--max-string-size MAX_STRING_SIZE] [--interval INTERVAL]

PostgreSQL Performance Insights Exporter for Prometheus

options:
  -h, --help            show this help message and exit
  --port PORT           Port to start the Prometheus metrics server on (default: 9153)
  --db-name DB_NAME     PostgreSQL database name (default: test)
  --db-user DB_USER     PostgreSQL user (default: postgres)
  --db-password DB_PASSWORD
                        PostgreSQL password (default: pass)
  --db-host DB_HOST     PostgreSQL host (default: 127.0.0.1)
  --db-port DB_PORT     PostgreSQL port (default: 5432)
  --max-string-size MAX_STRING_SIZE
                        Maximum size of query string to store (default: 1000)
  --interval INTERVAL   This determines how frequently the script will fetch data from PostgreSQL (default: 1)