Repository files navigation

Dependencies: >= Python 3.2, Mako, pycparserIf you only have a Python you can use the virtual environment:

virtualenv envsource ./env/bin/activatepip install -r ./requirements.txt

Then you need to generate C code and compiled it:

make USE_PGXS=1 genparsermake USE_PGXS=1make USE_PGXS=1 install

and modify your postgres config:

shared_preload_libraries = 'sr_plan.so'

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:

select query_hashfrom sr_planswhere query_hash=10;

disable saving the query:

setsr_plan.write_mode= false;

Now verify that your query is saved:

select query_hash, enable, query, explain_jsonb_plan(plan)from sr_plans;

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:

update sr_plansset enable=truewhere query_hash=812619660;

(812619660 for example only)After that, the plan for the query will be taken from the sr_plans.