Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
query monitoring: postgres on AWS

I did a little preliminary research today on how to measure postgres performance, including on AWS.

How Postgres query performance measurement works

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.

Postgres query measurement on RDS

With postgres on AWS RDS, you need to do some extra configuration.

Mozilla's default Postgres-Datadog monitoring level

Currently / by default, Mozilla's datadog install has instance-level data about RDS instances (machine stats like CPU or IOPS usage):

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.