I did a little preliminary research today on how to measure postgres performance, including on AWS.
Postgres can be configured to log query-related data.
These logs can be exported to tools like pgbadger or hosted tools like pganalyze. Datadog seems to have some options, too.