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