Re: explain (verbose off, normalized) vs query planid

This is for tracking planid into pg_stat_statements too.

A first try is available here
http://www.postgresql-archive.org/Poc-pg-stat-statements-with-planid-td6014027.html

reusing pg_stat_plans's "Plan tree Jumbling algorithm" from Peter Geoghegan.

Hashing the normalized query plan text in one pass (that is also based on
plan tree),
compared to that Jumbling method seems simple to maintain (if explain works,
planid is available and accurate).
Today actual planid jumbling comes from pg9.3, doesn't compile anymore, and
I'm not able to verify
if declarativ partitionning is properly handled ...

Would there be some functional or performances reasons to prefer jumbling to
hashing normalized plan text?

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html