pg_stat_sql_plans ALPHA released

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

Responses

Browse pgsql-general by date

  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