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

t; > Kyle > > > > On Sat, Apr 22, 2023 at 8:29 AM kunwar singh > wrote: > >> Postgres noob question. >> >> For example say datadog >> >> https://docs.datadoghq.com/database_monitoring/query_metrics/#explain-plans >> >> Do they run E

How do Monitoring tools capture explain plan of a query

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

What is equivalent of v$sesstat and v$sql_plan in postgres?

If not , how can I get the same functionality by writing a query/job/procedure? Something which doesn't require me to install a plugin , it is RDS PostgreSQL so cannot install /enable plugin without downtime to a critical production database v$sesstat use case - I run a query , I would like to se

Re: Is there any tool which will help me run and explain analyze about 150 queries?

> On Fri, Apr 7, 2023 at 9:40 PM Jerry Sievers > wrote: > >> kunwar singh writes: >> >> > Hi Listers, >> > Anyone here use such a tool for Postgres? Any recommendations? >> > >> > Say I have 150 queries in Postgres 11 and I want to upgrade

Re: Is there any tool which will help me run and explain analyze about 150 queries?

unning queries by setting a limit. I recently > enabled it in GCP Cloud SQL, but I haven't seen any results in the logs > yet. I need to figure out which parameters to enable to get it working. > > > > > On Fri, Apr 7, 2023 at 10:57 AM kunwar singh > wrote: >

Is there any tool which will help me run and explain analyze about 150 queries?

Hi Listers, Anyone here use such a tool for Postgres? Any recommendations? Say I have 150 queries in Postgres 11 and I want to upgrade to Postgres 15. I want to run explain analyze for 150 in both versions for comparative analysis. I am looking for the easiest way to do it with a tool :) -- Che