Correlate monitoring and queries

dalibo / temboard

PostgreSQL Remote Control

https://labs.dalibo.com/temboard

Other

455 stars 54 forks source link

Correlate monitoring and queries #86

Open AlexanderKkK opened 7 years ago

AlexanderKkK commented 7 years ago

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?
On page Activity / Running queries to sort list by clicking on column header.
Notify by email in case of exceeding the set user-defined thresholds.

P/S Thank you for the tool!

julmon commented 7 years ago

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 commented 6 years ago

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.