Set up automatic EXPLAIN plan collection
- Automatic explain plan collection requires Log Insights to be set up successfully
pganalyze integrates with two mechanisms for collecting EXPLAIN plans automatically:
Postgres collects EXPLAIN (or EXPLAIN ANALYZE) data as part of query processing, based on
auto_explain.log_min_duration, reflecting the actual plan that was used
- Log-based EXPLAIN
pganalyze collector runs EXPLAIN (without ANALYZE) on all queries logged based on
log_min_duration_statement, after the query has completed
Generally we recommend utilizing auto_explain where available, as it provides higher data quality.
Log-based EXPLAIN is not guaranteed to show the same plan that was executed, and cannot show execution metrics like I/O timing or buffer usage.
|Amazon RDS||Yes||Yes (Recommended)|
|Google Cloud SQL||Yes||No|
|Self-managed VM||Yes||Yes (Recommended)|
We are constantly evaluating new platform to support - please reach out if you're missing an integration, to help us prioritize.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →