On Sat, May 12, 2018 at 6:07 PM, legrand legrand <legrand_legr...@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