From: | PAscal l <legrand_legrand2(at)outlook(dot)fr> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | pg_stat_sql_plans ALPHA released |
Date: | 2018-12-19 15:36:12 |
Message-ID: | LO2P265MB14078361E3B52D26D16BD288C4BE0@LO2P265MB1407.GBRP265.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 finished in success (cancelled, timeout, errors) is tracked,
- planid is based on normalized explain plan text,
- explain plan text is saved in logs (as auto_explain do)
but only one time per queryid/planid,
- first_call, last_call informations are kept for each entry,
- provides a SQL function retrieving queryid for a pid
permitting to join pg_stat_activity with pg_stat_sql_plan
- includes specific wait events for planing and extension activities
Some ideas where found in other postgres extensions like pg_store_plans,
pg_stat_plans, ... and patches from pgsql-hackers mailing list.
See https://github.com/legrandlegrand/pg_stat_sql_plans
Feedbacks are welcome
Regards
PAscal
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-12-19 15:40:49 | Re: Error on insert xml |
Previous Message | Oleksandr Shulgin | 2018-12-19 14:46:00 | Re: Error on insert xml |