A new version of pg_stat_sql_plans (version 0.2) has been released.
Main changes are:
- planid is build at planning time, making it reusable by cached plans,
- expose current queryid, planid per pid in pg_stat_activity,
- planning counters are now calculated per (queryid,planid),
- includes a spec
PG_STAT_SQL_PLANS is an extension mixing
pg_stat_statements and auto_explain with a planid.
It is implementing many Oracle like features:
- queryid is based on normalized sql text (no jumbling),
- stored query text isn't normalized,
- a text normalization SQL function is provided,
- sql not finish
