missing pg_stat_statements

[john047]

What did you do?
istalled postgres_exporter

What did you expect to see?
metrics of pg_stat_statements

What did you see instead? Under which circumstances?
pg_stat_statements missing by curl localhost:9187/metrics

Environment
Ubuntu 20.04.4 LTS

• System information:

  Linux 5.4.0-88-generic x86_64

• postgres_exporter version:

postgres_exporter, version 0.11.0 (branch: HEAD, revision: 58cc383e8c7f1df12bf29f7f16d32025f44af12c)
build user:       root@e4cb8260868d
build date:       20220728-12:59:17
go version:       go1.18.4
platform:         linux/amd64

• postgres_exporter flags:

insert list of flags used here

• PostgreSQL version:

  PostgreSQL 14.2 (Ubuntu 14.2-1.pgdg20.04+1)

[apampurin]

Hi!
A year without messages, but I got the same issue.
I'm using postgres-exporter:v0.13.2 image with --collector.stat_statements argument.
This is starting debug log output:

ts=2023-08-15T10:34:08.189Z caller=main.go:86 level=warn msg="Error loading config" err="Error opening config file \"postgres_exporter.yml\": open postgres_exporter.yml: no such file or directory"
ts=2023-08-15T10:34:08.189Z caller=proc.go:250 msg="Excluded databases" databases=[]
ts=2023-08-15T10:34:08.190Z caller=main.go:142 level=warn msg="Failed to create PostgresCollector" err="dial tcp 127.0.0.1:5432: connect: connection refused"
ts=2023-08-15T10:34:08.191Z caller=tls_config.go:274 level=info msg="Listening on" address=[::]:9187
ts=2023-08-15T10:34:08.191Z caller=tls_config.go:277 level=info msg="TLS is disabled." http2=false address=[::]:9187
ts=2023-08-15T10:34:41.234Z caller=server.go:74 level=info msg="Established new database connection" fingerprint=127.0.0.1:5432
ts=2023-08-15T10:34:41.258Z caller=postgres_exporter.go:594 level=debug msg="Querying PostgreSQL version" server=127.0.0.1:5432
ts=2023-08-15T10:34:41.259Z caller=postgres_exporter.go:622 level=info msg="Semantic version changed" server=127.0.0.1:5432 from=0.0.0 to=15.2.0
ts=2023-08-15T10:34:41.259Z caller=postgres_exporter.go:296 level=debug msg="Column is being forced to discard due to version incompatibility" column=sent_location
ts=2023-08-15T10:34:41.259Z caller=postgres_exporter.go:296 level=debug msg="Column is being forced to discard due to version incompatibility" column=replay_location
ts=2023-08-15T10:34:41.259Z caller=postgres_exporter.go:296 level=debug msg="Column is being forced to discard due to version incompatibility" column=pg_xlog_location_diff
ts=2023-08-15T10:34:41.259Z caller=postgres_exporter.go:296 level=debug msg="Column is being forced to discard due to version incompatibility" column=flush_location
ts=2023-08-15T10:34:41.259Z caller=postgres_exporter.go:296 level=debug msg="Column is being forced to discard due to version incompatibility" column=write_location
ts=2023-08-15T10:34:41.259Z caller=postgres_exporter.go:296 level=debug msg="Column is being forced to discard due to version incompatibility" column=procpid
ts=2023-08-15T10:34:41.259Z caller=pg_setting.go:35 level=debug msg="Querying pg_setting view" server=127.0.0.1:5432
ts=2023-08-15T10:34:41.263Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_replication_slots
ts=2023-08-15T10:34:41.267Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_stat_archiver
ts=2023-08-15T10:34:41.270Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_stat_activity
ts=2023-08-15T10:34:41.278Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_stat_database_conflicts
ts=2023-08-15T10:34:41.279Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_locks
ts=2023-08-15T10:34:41.282Z caller=namespace.go:193 level=debug msg="Querying namespace" namespace=pg_stat_replication
ts=2023-08-15T10:35:41.247Z caller=postgres_exporter.go:594 level=debug msg="Querying PostgreSQL version" server=127.0.0.1:5432

Only related metrics I can find:

# HELP pg_settings_pg_stat_statements_max Server Parameter: pg_stat_statements.max
# TYPE pg_settings_pg_stat_statements_max gauge
pg_settings_pg_stat_statements_max{server="127.0.0.1:5432"} 5000
# HELP pg_settings_pg_stat_statements_save Server Parameter: pg_stat_statements.save
# TYPE pg_settings_pg_stat_statements_save gauge
pg_settings_pg_stat_statements_save{server="127.0.0.1:5432"} 1
# HELP pg_settings_pg_stat_statements_track_planning Server Parameter: pg_stat_statements.track_planning
# TYPE pg_settings_pg_stat_statements_track_planning gauge
pg_settings_pg_stat_statements_track_planning{server="127.0.0.1:5432"} 0
# HELP pg_settings_pg_stat_statements_track_utility Server Parameter: pg_stat_statements.track_utility
# TYPE pg_settings_pg_stat_statements_track_utility gauge
pg_settings_pg_stat_statements_track_utility{server="127.0.0.1:5432"} 0

[SuperQ]

This was fixed in #876 but the fix has not been released yet.