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

Schema metadata checks ignore schemas owned by rdsadmin #19448

Open
rwc9u opened this issue Jan 21, 2025 · 0 comments
Open

Schema metadata checks ignore schemas owned by rdsadmin #19448

rwc9u opened this issue Jan 21, 2025 · 0 comments

Comments

@rwc9u
Copy link

rwc9u commented Jan 21, 2025

We were setting up the collecting of schema metrics to database monitoring for one of our databases. The metrics for tables in our public schema were not being reported. We identified that the table is owned by rdsadmin and schemas owned by rdsadmin are ignored

https://github.com/DataDog/integrations-core/blob/master/postgres/datadog_checks/postgres/metadata.py#L105-L115

I'm not sure why the schema is owned by rdsadmin. I suspect it was an artifact of our migration from a heroku to AWS aurora migration 4 years ago.

Looking at the SCHEMA_QUERY above the other ignores seem to get rid of other schemas that we wouldn't be interested in (e.g. pg_ schemas). Could we relax this query to remove the

AND r.rolname  !=       'rdsadmin'
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