search

powa-team / powa

PostgreSQL Workload Analyzer
http://powa.readthedocs.io/
PostgreSQL License
764 stars 57 forks source link

Add a hook for custom historisation #1

Closed marco44 closed 9 years ago

marco44 commented 10 years ago

POWA stores the history for pg_stat_statements. It would be great to be store the history for custom queries. I'm thinking about pg_qualstats specifically. (asked by Rdunklau)

marco44 commented 10 years ago

Yes, it could be interesting, but maybe not that simple to do this cleanly. Maybe we could add a «setup» table containing a list of function names to be called to perform the actions we are doing right now only for pg_stat_statements ? The table could look like create table actions ( action enum('capture','coalesce','purge','reset'), function text)

Then anything (powa itself included) could register its actions here ?

marco44 commented 10 years ago

Done. Ronan, please give a look...

rjuju commented 9 years ago

Commit 1ac9e4703aad9d70171aa8e58b1e8906e75a2bf5 added some security around those function calls.

However, we still need to think what to do with thoses hypothetical values in the GUI.

rjuju commented 9 years ago

Done with powa-web new UI.