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

Hello,

as described in:
http://www.postgresql-archive.org/Re-FEATURE-PATCH-pg-stat-statements-with-plans-v02-td6015488.html

I'm wondering about the best way to build a query planid. 

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)

this normalized output can be done by adding a modified get_const_expr in
ruleutils.c as proposed in attached file.

Would this "explain normalized" feature be interesting for core team and or
users ?

Regards
PAscal

get_const_expr_normalized.c
<http://www.postgresql-archive.org/file/t348768/get_const_expr_normalized.c>  






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