Correlate monitoring and queries

[AlexanderKkK]

1. When you click on one of the diagrams on page Supervision / Charts / Last day, could you display the list of the queries that were worked at that moment, looks like on page Activity / Running queries?
2. On page Activity / Running queries to sort list by clicking on column header.
3. Notify by email in case of exceeding the set user-defined thresholds.

P/S Thank you for the tool!

[julmon]

Hi,

Thank you for your interest. Implementation of points 2 and 3 is planned. For the first one, it's a nice idea but will need some studies on how to collect (pg_stat_activity vs pg_stat_statements) and store these queries into the repository.

Regards,

[blogh]

Hi,

Do you have a better idea of how you might use pg_stat_statements in temboard ? I think it would increase temboard's appeal a lot :)

I had two more ideas:

• the ability to run a pgbadger from tembaord would be nice. (or some kind of log "mining")
• the ability to run an explain on a runnning query would be nice also. (but it might be tricky because of search path issues)

Anyway thx for the great product and the continuous efforts ! Regards.