Thread: Historical Queries
Hi Pgsql-Admin experts,
Sorry , if this question is already answered.
In oracle we have *awr* report which gives historical queries stored in sysaux tablespace based on the retention defined. So i would like to know do we have any similar feature in postgreSQL?. If i am not wrong we use pg_stat_statement extension to get more details, but does it stores the historical queries in the database cluster? or do need to enable slow log queries and use pgbadger to get nice reports. Please advice and suggest.
-D
Hello,
Le ven. 19 juil. 2019 à 20:15, Dhandapani Shanmugam <postgresql95@gmail.com> a écrit :
Hi Pgsql-Admin experts,Sorry , if this question is already answered.In oracle we have *awr* report which gives historical queries stored in sysaux tablespace based on the retention defined. So i would like to know do we have any similar feature in postgreSQL?. If i am not wrong we use pg_stat_statement extension to get more details, but does it stores the historical queries in the database cluster? or do need to enable slow log queries and use pgbadger to get nice reports. Please advice and suggest.
the powa project aims to provide similar functionality. you can check the doc at https://powa.readthedocs.io/en/latest/
there should be a link to a demo version, and a v4 with quite some improvements is actually in beta