Re: Historical Queries

Hello,

Le ven. 19 juil. 2019 à 20:15, Dhandapani Shanmugam <postgresql95(at)gmail(dot)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

>