3 years ago

Category: Software, Database, Data

Welcome to this practical, non-exhaustive guide to some of the common issues you’ll encounter while using Postgres. There’s a good chance you’ve used EXPLAIN or perhaps even EXPLAIN ANALYZE to understand the source of your frustration, or perhaps the slowness of your database queries.

The extension is also available on AWS RDS instances, but you can opt in to a better feature called Performance Insights.

99% of your queries don’t touch it, and certainly not the ones that are looking for open issues.

In particular, the Index size/usage statistics and Duplicate indexes queries can give you a quick health report of your index setup.