pg_store_plans
The PostgreSQL extension pg_store_plans is a contrib module that provides a way to store execution plans generated by the query planner.
Last updated
The PostgreSQL extension pg_store_plans is a contrib module that provides a way to store execution plans generated by the query planner.
Last updated
The open-source project is accessible on GitHub:
PG_STORE_PLANS store execution plans like PG_STAT_STATEMENTS does for queries.
Once the settings are configured, there is no further action required. Resetting pg_store_plans is unnecessary.
Datasentinel collects execution plan activity metrics for all queries at regular intervals to enable detailed analyzes on the GUI.
Upon installation, you gain access to:
Historical statistics for each query ID's plan.
Execution plans.
See for more details.
Use this extension with caution in your high-load production clusters as it could lead to an increased burden.
To mitigate this, consider setting the min_duration parameter to a value greater than 0.
To be installed in the internal database named postgres
< 10
1.3.1
>= 10 and < 13
1.4
13
1.5
14
1.6.1
15
1.7
16
1.8
Ensure you have set the PATH variable to your PostgreSQL installation directory
postgresql.conf
Add the following lines
connect to the internal database named postgres with superuser privileges
Connected as datasentinel user and in postgres database