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

kunwar singh <krishsingh.111@gmail.com>

From: kunwar singh <krishsingh.111@gmail.com>
To: kyle Hailey <kylelf@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Date: 2023-04-23T19:28:31Z
Lists: pgsql-performance
Thank you for the clarification Kyle 🙂

On Sat, Apr 22, 2023 at 12:17 PM kyle Hailey <kylelf@gmail.com> wrote:

>
> 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
>>
> --
Cheers,
Kunwar