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

[postgres] include table count as a metric #1192

Closed
stefanfoulis opened this issue Nov 6, 2014 · 4 comments
Closed

[postgres] include table count as a metric #1192

stefanfoulis opened this issue Nov 6, 2014 · 4 comments

Comments

@stefanfoulis
Copy link

Amount of tables per database.

Possibly the instructions on how to prepare postgres for datadog would need to be changed, since currently only access to the pg_stat_database view is granted and the information is not in there.

@remh remh added this to the 5.2.0 milestone Nov 6, 2014
@LeoCavaille LeoCavaille changed the title include table count in postgres integration [postgres] include table count as a metric Jan 5, 2015
@LeoCavaille
Copy link
Member

@stefanfoulis I guess you would like to see info about user tables and not all tables (including toast tables), would something like converting this request to metrics make sense to you ?

SELECT count(*), schemaname FROM pg_stat_user_tables GROUP BY schemaname;

@remh remh modified the milestones: Future, 5.2.0 Jan 30, 2015
@stefanfoulis
Copy link
Author

@LeoCavaille yep, that looks about right :-)

@remh remh modified the milestones: 5.3.0, Future Feb 6, 2015
@remh remh modified the milestones: 5.4.0, 5.3.0 Mar 17, 2015
@remh
Copy link
Contributor

remh commented Mar 18, 2015

Will be done by #1373

postgresql.total_tables

@remh remh modified the milestones: 5.3.0, 5.4.0 Mar 18, 2015
@remh
Copy link
Contributor

remh commented Mar 18, 2015

PR is merged, this will go out with 5.3.0.

@remh remh closed this as completed Mar 18, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants