postgres=# prepare s(int) as select * from tst01 t where id < $;

PREPARE

postgres=# 

** In PostgresMain

In exec_simple_query loop for parsetree_list++++++++++++++++++++++++++Before pg_plan_queries

***************In pg_plan_queries -------start

................In pg_plan_queries...query->commandType == CMD_UTILITY

***************In pg_plan_queries -------end

In exec_simple_query loop for parsetree_list++++++++++++++++++++++++++After pg_plan_queries

...In exec_simple_query....Before PortalRun

.....In PortalRun ------------start

.......In PortalRunUtility ---------------start

.........In ProcessUtility----Start

.........In ProcessUtility----End

.......In PortalRunUtility ---------------end

.....In PortalRun ------------end

...In exec_simple_query....After PortalRun

postgres=# execute s();

 id

----

( row)

postgres=# 

In exec_simple_query loop for parsetree_list++++++++++++++++++++++++++Before pg_plan_queries

***************In pg_plan_queries -------start

................In pg_plan_queries...query->commandType == CMD_UTILITY

***************In pg_plan_queries -------end

In exec_simple_query loop for parsetree_list++++++++++++++++++++++++++After pg_plan_queries

...In exec_simple_query....Before PortalRun

.....In PortalRun ------------start

xxxxxxIn FillPortalStore ...........start

.......In PortalRunUtility ---------------start

.........In ProcessUtility----Start

..........In standard_ProcessUtility ... Before ExecuteQuery

xxxxxxxxxxxIn ExecuteQuery--------start

++++++++++++In GetCachedPlan ........start

.............In BuildCachedPlan, Before pg_plan_queries

***************In pg_plan_queries -------start

................In pg_plan_queries...query->commandType != CMD_UTILITY

..................In pg_plan_query........start

*******************In planner ........start

___________________In standard_planner........start

********************In subquery_planner........start

++++++++++++++++++++++In grouping_planner......start

************************In query_planner......start

........................In make_one_rel......start

...........................In set_base_rel_pathlists......start

-----------------------------In set_rel_pathlist......start

******************************In set_plain_rel_pathlist......start

-------------------------------Before add_path of seqscan

-------------------------------After add_path of seqscan

-------------------------------Before create_index_paths

-------------------------------After create_index_path

-------------------------------Before create_tidscan_paths

-------------------------------After create_tidscan_paths

-------------------------------Before set_cheapest

-------------------------------After set_cheapest

******************************In set_plain_rel_pathlist......end

-----------------------------In set_rel_pathlist......end

...........................In set_base_rel_pathlists......end

........................In make_one_rel......end

************************In query_planner......end

++++++++++++++++++++++In grouping_planner......end

********************In subquery_planner........end

___________________In standard_planner........end

*******************In planner ........end

..................In pg_plan_query........end

***************In pg_plan_queries -------end

.............In BuildCachedPlan, After pg_plan_queries

++++++++++++In GetCachedPlan ........end

.....In PortalRun ------------start

.....In PortalRun ------------end

xxxxxxxxxxxIn ExecuteQuery--------end

..........In standard_ProcessUtility ... After ExecuteQuery

.........In ProcessUtility----End

.......In PortalRunUtility ---------------end

xxxxxxIn FillPortalStore ...........end

.....In PortalRun ------------end

...In exec_simple_query....After PortalRun