Unable to get metrics from databases

[Yeroha]

What did you do?
I installed postgres_exporter 0.16.0 linux. I have 2 databases: test_db_1, test_db_2. Trying get metrics from tables pg_stat_user_tables for my databases, but i see metrics from only postgres DB. Inserted --auto-discover-databases to config file, but not working. User postgres_exporter has privileges on these databases
Why i'm not see metrics from DBs?

• postgres_exporter version:

  0.16.0

• PostgreSQL version:

  16.7.1

[scottishwidow]

@Yeroha hey!👋

According to the Flags section of the README, the --auto-discover-databases flag has been deprecated.

You might want to consider using the --extend.query-path option with a custom queries file instead.

[rhclayto]

--extend.query-path is also listed as DEPRECATED.

Adding new metrics via a config file (DEPRECATED)

This feature is deprecated in favor of built-in collector functions. For generic SQL database monitoring see the sql_exporter.

The -extend.query-path command-line argument specifies a YAML file containing additional queries to run. Some examples are provided in queries.yaml.

[DaveK-KNIME]

I'm having the same problem. I tried adding all DBs as individual data source names, which gives me errors about duplicate metrics. The --auto-discover-databases also does not seem to do anything for me. How should this be configured such that the pg_stat_user_tables are scraped for all DBs?

[HannesLindback]

I also have the same issue. Running postgres_exporter ----collector.stat_user_tables the metrics endpoint states that the scrape has succeeded but no metrics from the scrape is available:

pg_scrape_collector_duration_seconds{collector="stat_user_tables"} 0.007558851
pg_scrape_collector_success{collector="stat_user_tables"} 1

Other collectors seem to work without issue.

• Postgres-exporter version: 0.17.1
• Postgresql version: 17.5

[DaveK-KNIME]

My workaround is to use the (deprecated) custom queries feature (e.g. the queries from here). Together with --auto-discover-databases this gives me the metrics for the user tables for all DBs.