Slow bloat query about pgmetrics HOT 4 CLOSED

@agolden3 An option to omit bloat query is now available in the just released v1.13.0. Use "--omit=bloat".

from pgmetrics.

Thanks for this report. Yes, it was always the intention that alternate bloat queries be supported. While pgmetrics uses this one, there are other queries like this and this for example.

Will investigate this query you proposed, and see how it can be integrated.

As for collecting pg_catalog metrics, perhaps an option can be added, but will take it up as another issue/PR.

from pgmetrics.

Is there a way to omit the bloat query from ./pgmetrics reports? I receive the error pretty quickly after execution, and have not been able to generate a report.

pgmetrics: bloat query failed: context deadline exceeded.

from pgmetrics.

@agolden3 There is not, currently. But I suppose it does make sense to add an omit option for bloat; it can be time consuming.

You can either try increasing the timeout using the -t option, or rebuild pgmetrics with this line commented out.

from pgmetrics.