Thread: How do Monitoring tools capture explain plan of a query

Datadog runs explain on a subset of queries , should  be most of the top queries, and doesn't use auto_explain (though there is an request to use it if it is already set up)

Kyle

On Sat, Apr 22, 2023 at 8:29 AM kunwar singh <krishsingh.111@gmail.com> wrote:

Postgres noob question.

For example say datadog

https://docs.datadoghq.com/database_monitoring/query_metrics/#explain-plans

Do they run EXPLAIN on all queries?

Or is it automatic in postgres? Like when auto_explain is enabled?

--

Cheers,
Kunwar