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

From: kunwar singh <krishsingh(dot)111(at)gmail(dot)com>
To: kyle Hailey <kylelf(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: How do Monitoring tools capture explain plan of a query
Date: 2023-04-23 19:28:31
Message-ID: CAJSrDUp00jeypVrJ4gGn5ok2mhd-v0iyu6k67bcuXqYc25+u+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thank you for the clarification Kyle 🙂

On Sat, Apr 22, 2023 at 12:17 PM kyle Hailey <kylelf(at)gmail(dot)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(dot)111(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jesper Pedersen 2023-04-24 08:23:23 Re: Postgres Metrics
Previous Message kyle Hailey 2023-04-22 16:17:00 Re: How do Monitoring tools capture explain plan of a query