You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
make USE_PGXS=1 genparsermake USE_PGXS=1make USE_PGXS=1 install
and modify your postgres config:
shared_preload_libraries = 'sr_plan.so'
Usage
In your db:
CREATE EXTENSION sr_plan;
If you want to save the query plan is necessary to set the variable:
setsr_plan.write_mode= true;
Now plans for all subsequent requests will be stored in the table sr_plans. It must be remembered that all requests will be maintained including duplicates.Making an example query:
explain_jsonb_plan function allows you to display explain execute the plan of which lies in jsonb. By default, all the plans are off, you need enable it: