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.
