PROMETHEUS-POSTGRES-EXPORTER(1)

💖 PROMETHEUS-POSTGRES-EXPORTER 💖

okay bestie, sit down, hydrate, because we're talking about prometheus-postgres-exporter — that's the prometheus-postgres-exporter(1) girlies, section 1 of your manual, the one you call when you need your PostgreSQL stats looking cute and Prometheus-shaped. she's an exporter. she takes Postgres metrics and hands them over. no cap. ✨

---

🌸 SYNOPSIS 🌸

prometheus-postgres-exporter [<flags>]

---

🦋 DESCRIPTION 🦋

so the original page... leaves this one blank. literally nothing. iconic silence, honestly. but that's fine because everything you actually need lives down in OPTIONS, and she did not hold back there. let's go. 👑

---

✨ OPTIONS ✨

• -h, --help — shows you context-sensitive help 💅 and psst, you can also try --help-long and --help-man if you want the extended cut.

🧚 collectors 🧚

every single one of these turns a collector on or off, and the default is stated right there, so read carefully bestie. i've kept all of them exactly as she wrote them.

• --collector.buffercache_summary — turns on the buffercache_summary collector (default: disabled).
• --collector.database — turns on the database collector (default: enabled).
• --collector.database_wraparound — turns on the database_wraparound collector (default: disabled).
• --collector.locks — turns on the locks collector (default: enabled).
• --collector.long_running_transactions — turns on the long_running_transactions collector (default: disabled).
• --collector.postmaster — turns on the postmaster collector (default: disabled).
• --collector.process_idle — turns on the process_idle collector (default: disabled).
• --collector.replication — turns on the replication collector (default: enabled).
• --collector.replication_slot — turns on the replication_slot collector (default: enabled).
• --collector.roles — turns on the roles collector (default: enabled).
• --collector.stat_activity_autovacuum — turns on the stat_activity_autovacuum collector (default: disabled).
• --collector.stat_bgwriter — turns on the stat_bgwriter collector (default: enabled).
• --collector.stat_checkpointer — turns on the stat_checkpointer collector (default: disabled).
• --collector.stat_database — turns on the stat_database collector (default: enabled).
• --collector.stat_progress_vacuum — turns on the stat_progress_vacuum collector (default: enabled).
• --collector.stat_statements — turns on the stat_statements collector (default: disabled).
• --collector.stat_statements.include_query — lets you select the statement query together with queryId (default: disabled).
• --collector.stat_statements.query_length=120 — the max length of the statement text. one hundred and twenty, exactly as written.
• --collector.stat_statements.limit=100 — the max number of statements to return.
• --collector.stat_statements.exclude_databases — a comma-separated list of database names to exclude (default: none).
• --collector.stat_statements.exclude_users — a comma-separated list of user names to exclude (default: none).
• --collector.stat_user_tables — turns on the stat_user_tables collector (default: enabled).
• --collector.stat_wal_receiver — turns on the stat_wal_receiver collector (default: disabled).
• --collector.statio_user_indexes — turns on the statio_user_indexes collector (default: disabled).
• --collector.statio_user_tables — turns on the statio_user_tables collector (default: enabled).
• --collector.wal — turns on the wal collector (default: enabled).
• --collector.xlog_location — turns on the xlog_location collector (default: disabled).

🎀 config + web stuff 🎀

• --config.file — the Postgres exporter configuration file. that's the one.
• --web.systemd-socket — use systemd socket activation listeners instead of port listeners. Linux only, bestie, don't try it elsewhere.
• --web.listen-address=:9187 — the addresses where the metrics and the web interface get exposed. it's repeatable so you can stack multiple addresses. examples she gave: :9100 or [::1]:9100 for http, and vsock://:9100 for vsock 👑
• --web.config.file — path to a configuration file that can enable TLS or authentication. see: https://github.com/prometheus/exporter-toolkit/blob/master/docs/web-configuration.md
• --web.telemetry-path — the path under which to expose metrics.

🍓 turning things off + discovery 🍓

• --disable-default-metrics — do not include default metrics.
• --disable-settings-metrics — do not include pg_settings metrics.
• --auto-discover-databases — whether to discover the databases on a server dynamically. (DEPRECATED) ⚠️
• --extend.query-path — path to custom queries to run. (DEPRECATED) ⚠️
• --dumpmaps — don't run anything, just dump the maps. she said do not run. we listen. 💀
• --constantLabels — a list of label=value separated by comma(,). (DEPRECATED) ⚠️
• --exclude-databases — a list of databases to remove when autoDiscoverDatabases is enabled (DEPRECATED) ⚠️
• --include-databases — a list of databases to include when autoDiscoverDatabases is enabled (DEPRECATED) ⚠️
• --metric-prefix — a metric prefix, for when you want non-default prefixes (so, anything that isn't "pg") on each of the metrics. yes, it's giving rebrand. 💅
• --collection-timeout — timeout for collecting the statistics when the database is slow. be patient with her.
• --version — show the application version.

🌈 logging 🌈

• --log.level=info — only log messages with the given severity or above. one of: [debug, info, warn, error]
• --log.format=logfmt — output format of log messages. one of: [logfmt, json]

---

⚠️ heads up bestie: --auto-discover-databases, --extend.query-path, --constantLabels, --exclude-databases and --include-databases are all marked DEPRECATED. they still work, but she's side-eyeing them.

⚠️ --dumpmaps literally says do not run, simply dump the maps. do not run it expecting normal exporter behaviour. ✋

---

and that's the whole page, no skips, no shortcuts, every single flag accounted for 🫶 this was prometheus-postgres-exporter, version 0...., dated March 2026, and she ate. periodt. 💖✨🎀🦋🌸💅