LockReleaseAll: lockmethod=1, pid=1740 LockReleaseAll: reinitializing lockQueue LockReleaseAll: done query: insert into alpha( payload ) values( 'one' ); after rewriting: { QUERY :command 3 :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :unionall false :distinctClause <> :sortClause <> :rtable ({ RTE :relname alpha :ref { ATTR :relname alpha :attrs <>} :relid 319938 :inh false :inFromCl false :inJoinSet false :skipAcl false}) :targetlist ({ TARGETENTRY :resdom { RESDOM :resno 2 :restype 25 :restypmod -1 :resname payload :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constisnull false :constvalue 7 [ 7 0 0 0 111 110 101 ] :constbyval false }} { TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 23 :opType func :oper { FUNC :funcid 1574 :functype 23 :funcisindex false :funcsize 0 :func_fcache @ 0x0 :func_tlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname \ :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk fal! se } :expr { VAR :varno -1 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold -1 :varoattno 1}}) :func_planlist <>} :args ({ CONST :consttype 25 :constlen -1 :constisnull false :constvalue 13 [ 13 0 0 0 115 101 113 95 97 108 112 104 97 ] :constbyval false })}}) :qual <> :groupClause <> :havingQual <> :hasAggs false :hasSubLinks false :unionClause <> :intersectClause <> :limitOffset <> :limitCount <> :rowMark <>} LockReleaseAll: lockmethod=1, pid=1740 LockReleaseAll: reinitializing lockQueue LockReleaseAll: done query: insert into alpha( payload ) values( 'two' ); after rewriting: { QUERY :command 3 :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :unionall false :distinctClause <> :sortClause <> :rtable ({ RTE :relname alpha :ref { ATTR :relname alpha :attrs <>} :relid 319938 :inh false :inFromCl false :inJoinSet false :skipAcl false}) :targetlist ({ TARGETENTRY :resdom { RESDOM :resno 2 :restype 25 :restypmod -1 :resname payload :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constisnull false :constvalue 7 [ 7 0 0 0 116 119 111 ] :constbyval false }} { TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 23 :opType func :oper { FUNC :funcid 1574 :functype 23 :funcisindex false :funcsize 0 :func_fcache @ 0x0 :func_tlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname \ :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk fal! se } :expr { VAR :varno -1 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold -1 :varoattno 1}}) :func_planlist <>} :args ({ CONST :consttype 25 :constlen -1 :constisnull false :constvalue 13 [ 13 0 0 0 115 101 113 95 97 108 112 104 97 ] :constbyval false })}}) :qual <> :groupClause <> :havingQual <> :hasAggs false :hasSubLinks false :unionClause <> :intersectClause <> :limitOffset <> :limitCount <> :rowMark <>} LockReleaseAll: lockmethod=1, pid=1740 LockReleaseAll: reinitializing lockQueue LockReleaseAll: done query: select * from alpha; after rewriting: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :unionall false :distinctClause <> :sortClause <> :rtable ({ RTE :relname alpha :ref { ATTR :relname alpha :attrs <>} :relid 319938 :inh false :inFromCl true :inJoinSet true :skipAcl false}) :targetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1}} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 25 :restypmod -1 :resname payload :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 2 :vartype 25 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2}}) :qual <> :groupClause <> :havingQual <> :hasAggs false :hasSubLinks false :unionClause <> :intersectClause <> :limitOffset <> :limitCount <> :rowMark <>} LockReleaseAll: lockmethod=1, pid=1740 LockReleaseAll: reinitializing lockQueue LockReleaseAll: done query: insert into beta( ref, info ) values( 1, '1.1' ); after rewriting: { QUERY :command 3 :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :unionall false :distinctClause <> :sortClause <> :rtable ({ RTE :relname beta :ref { ATTR :relname beta :attrs <>} :relid 319957 :inh false :inFromCl false :inJoinSet false :skipAcl false}) :targetlist ({ TARGETENTRY :resdom { RESDOM :resno 2 :restype 23 :restypmod -1 :resname ref :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constisnull false :constvalue 4 [ 1 0 0 0 ] :constbyval true }} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 25 :restypmod -1 :resname info :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constisnull false :constvalue 7 [ 7 0 0 0 49 46 49 ] :constbyval false }} { TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 23 :opType func :oper! { FUNC :funcid 1574 :functype 23 :funcisindex false :funcsize 0 :func_fcache @ 0x0 :func_tlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname \ :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno -1 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold -1 :varoattno 1}}) :func_planlist <>} :args ({ CONST :consttype 25 :constlen -1 :constisnull false :constvalue 12 [ 12 0 0 0 115 101 113 95 98 101 116 97 ] :constbyval false })}}) :qual <> :groupClause <> :havingQual <> :hasAggs false :hasSubLinks false :unionClause <> :intersectClause <> :limitOffset <> :limitCount <> :rowMark <>} query: SELECT oid FROM "alpha" WHERE "id" = $1 FOR UPDATE OF "alpha" after rewriting: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :unionall false :distinctClause <> :sortClause <> :rtable ({ RTE :relname alpha :ref { ATTR :relname alpha :attrs <>} :relid 319938 :inh false :inFromCl true :inJoinSet true :skipAcl false}) :targetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :qual { EXPR :typeOid 16 :opType op :oper { OPER :opno 96 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 23 :param_tlist <>})} :groupClause <> :havingQual <> :hasAggs false :hasSubLinks false :unionClause <> :intersectClause <> :limitOffset <> :limitCount <> :rowMark ({ ROWMARK :rti 1 :in! fo 3})} LockReleaseAll: lockmethod=1, pid=1740 LockReleaseAll: reinitializing lockQueue LockReleaseAll: done proc_exit(0) shmem_exit(0) LockReleaseAll: lockmethod=1, pid=1740 LockReleaseAll: lockmethod=2, pid=1740 exit(0)