Now verify that your query is saved:

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

select query_hash, enable,valid,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.

In addition sr plan allows you to save a parameterized query plan. In this case, we have some constants in the query are not essential.

For the parameters we use a special function_p (anyelement) example:

select query_hashfrom sr_planswhere query_hash=1000+_p(10);

if we keep the plan for the query and enable it to be used also for the following queries:

select query_hashfrom sr_planswhere query_hash=1000+_p(11);

select query_hashfrom sr_planswhere query_hash=1000+_p(-5);