Horton

Thread

  1. How do Monitoring tools capture explain plan of a query

    kunwar singh <krishsingh.111@gmail.com> — 2023-04-22T15:28:39Z

    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

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

    kyle Hailey <kylelf@gmail.com> — 2023-04-22T16:17:00Z

    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
>

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

    kunwar singh <krishsingh.111@gmail.com> — 2023-04-23T19:28:31Z

    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