With the default parameter group in Amazon RDS for PostgreSQL, the reports are not too useful. But it is easy to make a few changes to the parameters to get more detailed reports (the pgBadger documentation lists the relevant configuration settings).
Last week, I came across the very useful little tool rds-pgbadger (https://github.com/fpietka/rds-pgbadger). It simply takes an Amazon RDS for PostgreSQL instance name, and then downloads the log files from that instance and creates nice, graphical reports using the pgBadger (http://dalibo.github.io/pgbadger/, https://github.com/dalibo/pgbadger) log analyzer.
With the default parameter group in Amazon RDS for PostgreSQL, the reports are not too useful. But it is easy to make a few changes to the parameters to get more detailed reports (the pgBadger documentation lists the relevant configuration settings).