pganalyze

What do you like best?

It is very easy to find out the slow running queries ,they can be tuned and performance increases

Allows us to see the CPU ,I/O metrics and check any abnormality through the mails received to us.

Weekly performance and health of the server reports are generated

What do you dislike?

Nothing much could be said as disadvantage as of now.It is more advanced than pgbadger

What problems are you solving with the product? What benefits have you realized?

There are multiple PostgreSQL servers in different environments as dev,test,pre prod,prod and all the servers could be easily maintained and checked for alerts

Any performance tuning suggestions also given by pganalyze like index utilization for a table or vaccuum when was it done last