Join us for our webinar on June 18th, 9:30am Pacific Time: Optimizing slow queries with EXPLAIN to fix bad query plans - register now.

Collect Postgres EXPLAIN plans using auto_explain

The recommended way to set up Automated EXPLAIN is to use the Postgres auto_explain module. This module is part of core Postgres but is not enabled by default. It can instrument all queries on your system and log detailed execution information for ones slower than a certain threshold. With our recommended configuration, performance impact is minimal.

Here are the instructions for environments that support auto_explain:

For other environments, we also offer an alternative log-based Automated EXPLAIN mechanism.

EXPLAIN plans are visualized on the associated query detail page, and include EXPLAIN insights:

query details explain plan

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →