Postgres Pro
Downloads
Home   >   mailing lists

Re: explain (verbose off, normalized) vs query planid - Mailing list pgsql-hackers

From Robert Haas
Subject Re: explain (verbose off, normalized) vs query planid
Date
Msg-id CA+TgmoYzUjf=L39eBU0gzJgsW4VbWJEwHmjNEw5Pmp4GHO15aQ@mail.gmail.com
Whole thread Raw
In response to explain (verbose off, normalized) vs query planid  (legrand legrand <legrand_legrand@hotmail.com>)
Responses Re: explain (verbose off, normalized) vs query planid  (legrand legrand <legrand_legrand@hotmail.com>)
List pgsql-hackers
Tree view 
On Sat, May 12, 2018 at 6:07 PM, legrand legrand
<legrand_legrand@hotmail.com> wrote:
> It seems natural (to me) to calculate a hash value based on the normalized
> plan text
> generated by
>
> explain (costs off, normalized)
> or maybe
> explain (costs off, verbose, normalized)

I would think it would be preferable to do it based on the node tree,
like pg_stat_statements does for query fingerprinting.  But I guess it
might depend on what you want to do with it.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Garick Hamlin
Date:
Subject: Re: Allow COPY's 'text' format to output a header
Next
From: "David G. Johnston"
Date:
Subject: Re: Allow COPY's 'text' format to output a header