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