Re: add a new explain option including_query for include query string inside the json plan output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Cc: jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: add a new explain option including_query for include query string inside the json plan output
Date: 2024-06-25 14:23:53
Message-ID: 1319007.1719325433@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> writes:
> On Tue, 25 Jun 2024 at 10:55, jian he <jian(dot)universality(at)gmail(dot)com> wrote:
>> for json format, add a new option to let the explain json output also
>> include the actual query string.

> Wouldn't the user be able to keep track of the query they wanted
> explained by themselves? If not, why?

Indeed. I do not think this is a good idea at all, even if the
question of "where did you get the query string from" could be
resolved satisfactorily.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2024-06-25 14:26:00 Re: Backporting BackgroundPsql
Previous Message Tom Lane 2024-06-25 14:21:58 Re: improve ssl error code, 2147483650