Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

statio_user_tables shows only postgres database schemas #984

Open
vvitad opened this issue Dec 11, 2023 · 0 comments
Open

statio_user_tables shows only postgres database schemas #984

vvitad opened this issue Dec 11, 2023 · 0 comments

Comments

@vvitad
Copy link

vvitad commented Dec 11, 2023

What did you do?
installed and configured postgres_exporter. aside postgres database, there is another one, let's call it userdb
What did you expect to see?
metrics like pg_statio_user_tables_tidx_blocks_read for tables in database userdb
What did you see instead? Under which circumstances?
I see only metrics for schemas in postgres database. looks like it doesn't have access by default there? to see pg_stat_user_tables for schemas in userdb I need to connect to it first, but you say in readme that connection string should consist of only postgres database

Environment

  • System information:
    Linux 3.10.0-1160.6.1.el7.x86_64 x86_64

  • postgres_exporter version:
    postgres_exporter, version 0.15.0 (branch: HEAD, revision: 68c176b)
    build user: root@88f74f2c2888
    build date: 20231027-14:38:56
    go version: go1.21.3
    platform: linux/amd64
    tags: unknown

  • postgres_exporter flags:
    PG_EXPORTER_DISABLE_SETTINGS_METRICS=false
    DATA_SOURCE_URI=:7430/postgres?sslmode=disable&host=/tmp
    DATA_SOURCE_USER=postgres
    --web.listen-address=0.0.0.0:9187 --collector.stat_statements --collector.statio_user_indexes
    --collector.long_running_transactions --collector.database_wraparound
    --collector.stat_activity_autovacuum --log.level=debug

  • PostgreSQL version:
    postgresql 11

  • Logs:
    no errors
    collector.go:206 level=debug msg="collector succeeded" name=statio_user_tables duration_seconds=4.023973512

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant