Attachment 650335 Details for Bug 873379 – postgres log for the transaction idle since 00:49 this morning and hanging the httpd process

postgres log for the transaction idle since 00:49 this morning and hanging the httpd process

postgres log for stuck transaction.txt (text/plain), 35.94 KB, created by James Hogarth on 2012-11-23 11:22:46 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: James Hogarth

Created: 2012-11-23 11:22:46 UTC

Size: 35.94 KB

patch

obsolete

>spaceuser%spaceschema%1468%10767046%22/64LOG:  duration: 2.071 ms
>spaceuser%spaceschema%1468%10767046%22/64LOG:  statement: 
>            update rhnActionConfigRevision
>               set failure_id = NULL
>             where server_id = 1000010030
>               and action_id = 6081
>
>spaceuser%spaceschema%1468%10767046%22/64LOG:  parse tree:
>spaceuser%spaceschema%1468%10767046%22/64DETAIL:     {QUERY 
>           :commandType 2 
>           :querySource 0 
>           :canSetTag true 
>           :utilityStmt <> 
>           :resultRelation 1 
>           :intoClause <> 
>           :hasAggs false 
>           :hasWindowFuncs false 
>           :hasSubLinks false 
>           :hasDistinctOn false 
>           :hasRecursive false 
>           :cteList <> 
>           :rtable (
>              {RTE 
>              :alias <> 
>              :eref 
>                 {ALIAS 
>                 :aliasname rhnactionconfigrevision 
>                 :colnames ("id" "action_id" "server_id" "config_revision_id" "failure
>                 _id" "created" "modified")
>                 }
>              :rtekind 0 
>              :relid 17025 
>              :inh true 
>              :inFromCl false 
>              :requiredPerms 6 
>              :checkAsUser 0 
>              :selectedCols (b 10 11)
>              :modifiedCols (b 13)
>              }
>           )
>	:jointree 
>              {FROMEXPR 
>              :fromlist (
>                 {RANGETBLREF 
>                 :rtindex 1
>                 }
>              )
>              :quals 
>                 {BOOLEXPR 
>                 :boolop and 
>                 :args (
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 3 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 3 
>                       :location 76
>                       }
>                       {FUNCEXPR 
>                       :funcid 1740 
>                       :funcresulttype 1700 
>                       :funcretset false 
>                       :funcformat 2 
>                       :args (
>                          {CONST 
>                          :consttype 23 
>                          :consttypmod -1 
>                          :constlen 4 
>                          :constbyval true 
>                          :constisnull false 
>                          :location 88 
>                          :constvalue 4 [ 46 -15 -102 59 0 0 0 0 ]
>                          }
>                       )
>                       :location -1
>                       }
>                    )
>                    :location 86
>                    }
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 2 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 2 
>                       :location 110
>                       }
>                       {FUNCEXPR 
>                       :funcid 1740 
>                       :funcresulttype 1700 
>                       :funcretset false 
>                       :funcformat 2 
>                       :args (
>                          {CONST 
>                          :consttype 23 
>                          :consttypmod -1 
>                          :constlen 4 
>                          :constbyval true 
>                          :constisnull false 
>                          :location 122 
>                          :constvalue 4 [ -63 23 0 0 0 0 0 0 ]
>                          }
>                       )
>                       :location -1
>                       }
>                    )
>                    :location 120
>                    }
>                 )
>                 :location 106
>                 }
>              }
>           :targetList (
>              {TARGETENTRY 
>              :expr 
>                 {CONST 
>                 :consttype 1700 
>                 :consttypmod -1 
>                 :constlen -1 
>                 :constbyval false 
>                 :constisnull true 
>                 :location 60 
>                 :constvalue <>
>                 }
>              :resno 5 
>              :resname failure_id 
>              :ressortgroupref 0 
>              :resorigtbl 0 
>              :resorigcol 0 
>              :resjunk false
>              }
>           )
>           :returningList <> 
>           :groupClause <> 
>           :havingQual <> 
>           :windowClause <> 
>           :distinctClause <> 
>           :sortClause <> 
>           :limitOffset <> 
>           :limitCount <> 
>           :rowMarks <> 
>           :setOperations <>
>           }
>
>spaceuser%spaceschema%1468%10767046%22/64STATEMENT:  
>            update rhnActionConfigRevision
>               set failure_id = NULL
>             where server_id = 1000010030
>               and action_id = 6081
>
>spaceuser%spaceschema%1468%10767046%22/64LOG:  rewritten parse tree:
>spaceuser%spaceschema%1468%10767046%22/64DETAIL:  (
>           {QUERY 
>           :commandType 2 
>           :querySource 0 
>           :canSetTag true 
>           :utilityStmt <> 
>           :resultRelation 1 
>           :intoClause <> 
>           :hasAggs false 
>           :hasWindowFuncs false 
>           :hasSubLinks false 
>           :hasDistinctOn false 
>           :hasRecursive false 
>           :cteList <> 
>           :rtable (
>              {RTE 
>              :alias <> 
>              :eref 
>                 {ALIAS 
>                 :aliasname rhnactionconfigrevision 
>                 :colnames ("id" "action_id" "server_id" "config_revision_id" "failure
>                 _id" "created" "modified")
>                 }
>              :rtekind 0 
>              :relid 17025 
>              :inh true 
>              :inFromCl false 
>              :requiredPerms 6 
>              :checkAsUser 0 
>              :selectedCols (b 10 11)
>              :modifiedCols (b 13)
>              }
>           )
>	  :jointree 
>              {FROMEXPR 
>              :fromlist (
>                 {RANGETBLREF 
>                 :rtindex 1
>                 }
>              )
>              :quals 
>                 {BOOLEXPR 
>                 :boolop and 
>                 :args (
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 3 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 3 
>                       :location 76
>                       }
>                       {FUNCEXPR 
>                       :funcid 1740 
>                       :funcresulttype 1700 
>                       :funcretset false 
>                       :funcformat 2 
>                       :args (
>                          {CONST 
>                          :consttype 23 
>                          :consttypmod -1 
>                          :constlen 4 
>                          :constbyval true 
>                          :constisnull false 
>                          :location 88 
>                          :constvalue 4 [ 46 -15 -102 59 0 0 0 0 ]
>                          }
>                       )
>                       :location -1
>                       }
>                    )
>                    :location 86
>                    }
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 2 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 2 
>                       :location 110
>                       }
>                       {FUNCEXPR 
>                       :funcid 1740 
>                       :funcresulttype 1700 
>                       :funcretset false 
>                       :funcformat 2 
>                       :args (
>                          {CONST 
>                          :consttype 23 
>                          :consttypmod -1 
>                          :constlen 4 
>                          :constbyval true 
>                          :constisnull false 
>                          :location 122 
>                          :constvalue 4 [ -63 23 0 0 0 0 0 0 ]
>                          }
>                       )
>                       :location -1
>                       }
>                    )
>                    :location 120
>                    }
>                 )
>                 :location 106
>                 }
>              }
>           :targetList (
>              {TARGETENTRY 
>              :expr 
>                 {CONST 
>                 :consttype 1700 
>                 :consttypmod -1 
>                 :constlen -1 
>                 :constbyval false 
>                 :constisnull true 
>                 :location 60 
>                 :constvalue <>
>                 }
>              :resno 5 
>              :resname failure_id 
>              :ressortgroupref 0 
>              :resorigtbl 0 
>              :resorigcol 0 
>              :resjunk false
>              }
>           )
>           :returningList <> 
>           :groupClause <> 
>           :havingQual <> 
>           :windowClause <> 
>           :distinctClause <> 
>           :sortClause <> 
>           :limitOffset <> 
>           :limitCount <> 
>           :rowMarks <> 
>           :setOperations <>
>           }
>        )
>        
>spaceuser%spaceschema%1468%10767046%22/64STATEMENT:  
>            update rhnActionConfigRevision
>               set failure_id = NULL
>             where server_id = 1000010030
>               and action_id = 6081
>
>spaceuser%spaceschema%1468%10767046%22/64LOG:  plan:
>spaceuser%spaceschema%1468%10767046%22/64DETAIL:     {PLANNEDSTMT 
>           :commandType 2 
>           :canSetTag true 
>           :transientPlan false 
>           :planTree 
>              {BITMAPHEAPSCAN 
>              :startup_cost 4.30 
>              :total_cost 15.16 
>              :plan_rows 3 
>              :plan_width 55 
>              :targetlist (
>                 {TARGETENTRY 
>                 :expr 
>                    {VAR 
>                    :varno 1 
>                    :varattno 1 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 1 
>                    :location -1
>                    }
>                 :resno 1 
>                 :resname id 
>                 :ressortgroupref 0 
>                 :resorigtbl 0 
>                 :resorigcol 0 
>                 :resjunk false
>                 }
>                 {TARGETENTRY 
>                 :expr 
>                    {VAR 
>                    :varno 1 
>                    :varattno 2 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 2 
>                    :location -1
>                    }
>                 :resno 2 
>                 :resname action_id 
>                 :ressortgroupref 0 
>                 :resorigtbl 0 
>                 :resorigcol 0 
>                 :resjunk false
>                 }
>                 {TARGETENTRY 
>                 :expr 
>                    {VAR 
>                    :varno 1 
>                    :varattno 3 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 3 
>                    :location -1
>                    }
>                 :resno 3 
>                 :resname server_id 
>                 :ressortgroupref 0 
>                 :resorigtbl 0 
>                 :resorigcol 0 
>                 :resjunk false
>                 }
>                 {TARGETENTRY 
>                 :expr 
>                    {VAR 
>                    :varno 1 
>                    :varattno 4 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 4 
>                    :location -1
>                    }
>                 :resno 4 
>                 :resname config_revision_id 
>                 :ressortgroupref 0 
>                 :resorigtbl 0 
>                 :resorigcol 0 
>                 :resjunk false
>                 }
>                 {TARGETENTRY 
>                 :expr 
>                    {CONST 
>                    :consttype 1700 
>                    :consttypmod -1 
>                    :constlen -1 
>                    :constbyval false 
>                    :constisnull true 
>                    :location 60 
>                    :constvalue <>
>                    }
>                 :resno 5 
>                 :resname failure_id 
>                 :ressortgroupref 0 
>                 :resorigtbl 0 
>                 :resorigcol 0 
>                 :resjunk false
>                 }
>                 {TARGETENTRY 
>                 :expr 
>                    {VAR 
>                    :varno 1 
>                    :varattno 6 
>                    :vartype 1184 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 6 
>                    :location -1
>                    }
>                 :resno 6 
>                 :resname created 
>                 :ressortgroupref 0 
>                 :resorigtbl 0 
>                 :resorigcol 0 
>                 :resjunk false
>                 }
>                 {TARGETENTRY 
>                 :expr 
>                    {VAR 
>                    :varno 1 
>                    :varattno 7 
>                    :vartype 1184 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 7 
>                    :location -1
>                    }
>                 :resno 7 
>                 :resname modified 
>                 :ressortgroupref 0 
>                 :resorigtbl 0 
>                 :resorigcol 0 
>                 :resjunk false
>                 }
>                 {TARGETENTRY 
>                 :expr 
>                    {VAR 
>                    :varno 1 
>                    :varattno -1 
>                    :vartype 27 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno -1 
>                    :location -1
>                    }
>                 :resno 8 
>                 :resname ctid 
>                 :ressortgroupref 0 
>                 :resorigtbl 0 
>                 :resorigcol 0 
>                 :resjunk true
>                 }
>              )
>              :qual <> 
>              :lefttree 
>                {BITMAPINDEXSCAN 
>                 :startup_cost 0.00 
>                 :total_cost 4.29 
>                 :plan_rows 3 
>                 :plan_width 0 
>                 :targetlist <> 
>                 :qual <> 
>                 :lefttree <> 
>                 :righttree <> 
>                 :initPlan <> 
>                 :extParam (b)
>                 :allParam (b)
>                 :scanrelid 1 
>                 :indexid 17055 
>                 :indexqual (
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 1 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 2 
>                       :location 110
>                       }
>                       {CONST 
>                       :consttype 1700 
>                       :consttypmod -1 
>                       :constlen -1 
>                       :constbyval false 
>                       :constisnull false 
>                       :location -1 
>                       :constvalue 10 [ 40 0 0 0 0 0 0 0 -63 23 ]
>                       }
>                    )
>                    :location 120
>                    }
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 2 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 3 
>                       :location 76
>                       }
>                       {CONST 
>                       :consttype 1700 
>                       :consttypmod -1 
>                       :constlen -1 
>                       :constbyval false 
>                       :constisnull false 
>                       :location -1 
>                       :constvalue 14 [ 56 0 0 0 0 0 2 0 10 0 1 0 30 0 ]
>                       }
>                    )
>                    :location 86
>                    }
>                 )
>                 :indexqualorig (
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 2 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 2 
>                       :location 110
>                       }
>                       {CONST 
>                       :consttype 1700 
>                       :consttypmod -1 
>                       :constlen -1 
>                       :constbyval false 
>                       :constisnull false 
>                       :location -1 
>                       :constvalue 10 [ 40 0 0 0 0 0 0 0 -63 23 ]
>                       }
>                    )
>                    :location 120
>                    }
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 3 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 3 
>                       :location 76
>                       }
>                       {CONST 
>                       :consttype 1700 
>                       :consttypmod -1 
>                       :constlen -1 
>                       :constbyval false 
>                       :constisnull false 
>                       :location -1 
>                       :constvalue 14 [ 56 0 0 0 0 0 2 0 10 0 1 0 30 0 ]
>                       }
>                    )
>                    :location 86
>                    }
>                 )
>                 }
>              :righttree <> 
>              :initPlan <> 
>              :extParam (b)
>              :allParam (b)
>              :scanrelid 1 
>              :bitmapqualorig (
>                 {OPEXPR 
>                 :opno 1752 
>                 :opfuncid 1718 
>                 :opresulttype 16 
>                 :opretset false 
>                 :args (
>                    {VAR 
>                    :varno 1 
>                    :varattno 2 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 2 
>                    :location 110
>                    }
>                    {CONST 
>                    :consttype 1700 
>                    :consttypmod -1 
>                    :constlen -1 
>                    :constbyval false 
>                    :constisnull false 
>                    :location -1 
>                    :constvalue 10 [ 40 0 0 0 0 0 0 0 -63 23 ]
>                    }
>                 )
>                 :location 120
>                 }
>                 {OPEXPR 
>                 :opno 1752 
>                 :opfuncid 1718 
>                 :opresulttype 16 
>                 :opretset false 
>                 :args (
>                    {VAR 
>                    :varno 1 
>                    :varattno 3 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 3 
>                    :location 76
>                    }
>                    {CONST 
>                    :consttype 1700 
>                    :consttypmod -1 
>                    :constlen -1 
>                    :constbyval false 
>                    :constisnull false 
>                    :location -1 
>                    :constvalue 14 [ 56 0 0 0 0 0 2 0 10 0 1 0 30 0 ]
>                    }
>                 )
>                 :location 86
>                 }
>              )
>              }
>           :rtable (
>              {RTE 
>              :alias <> 
>              :eref 
>                 {ALIAS 
>                 :aliasname rhnactionconfigrevision 
>                 :colnames ("id" "action_id" "server_id" "config_revision_id" "failure
>                 _id" "created" "modified")
>                 }
>              :rtekind 0 
>              :relid 17025 
>              :inh false 
>              :inFromCl false 
>              :requiredPerms 6 
>              :checkAsUser 0 
>              :selectedCols (b 10 11)
>              :modifiedCols (b 13)
>              }
>           )
>           :resultRelations (i 1)
>           :utilityStmt <> 
>           :intoClause <> 
>           :subplans <> 
>           :rewindPlanIDs (b)
>           :returningLists <> 
>           :rowMarks <> 
>           :relationOids (o 17025)
>           :invalItems <> 
>           :nParamExec 0
>           }
>        
>spaceuser%spaceschema%1468%10767046%22/64STATEMENT:  
>            update rhnActionConfigRevision
>               set failure_id = NULL
>             where server_id = 1000010030
>               and action_id = 6081
>        
>spaceuser%spaceschema%1468%10767046%22/64LOG:  duration: 4.051 ms
>spaceuser%spaceschema%1468%10767046%22/64LOG:  statement: 
>            select acr.id
>              from rhnActionConfigRevision acr
>             where acr.server_id = 1000010030
>        
>spaceuser%spaceschema%1468%10767046%22/64LOG:  parse tree:
>spaceuser%spaceschema%1468%10767046%22/64DETAIL:     {QUERY 
>           :commandType 1 
>           :querySource 0 
>           :canSetTag true 
>           :utilityStmt <> 
>           :resultRelation 0 
>           :intoClause <> 
>           :hasAggs false 
>           :hasWindowFuncs false 
>           :hasSubLinks false 
>           :hasDistinctOn false 
>           :hasRecursive false 
>           :cteList <> 
>           :rtable (
>              {RTE 
>              :alias 
>                 {ALIAS 
>                 :aliasname acr 
>                 :colnames <>
>                 }
>              :eref 
>                 {ALIAS 
>                 :aliasname acr 
>                 :colnames ("id" "action_id" "server_id" "config_revision_id" "failure
>                 _id" "created" "modified")
>                 }
>              :rtekind 0 
>              :relid 17025 
>              :inh true 
>              :inFromCl true 
>              :requiredPerms 2 
>              :checkAsUser 0 
>              :selectedCols (b 9 11)
>              :modifiedCols (b)
>              }
>           )
>           :jointree 
>              {FROMEXPR 
>              :fromlist (
>                 {RANGETBLREF 
>                 :rtindex 1
>                 }
>              )
>              :quals 
>                 {OPEXPR 
>                 :opno 1752 
>                 :opfuncid 1718 
>                 :opresulttype 16 
>                 :opretset false 
>                 :args (
>                    {VAR 
>                    :varno 1 
>                    :varattno 3 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 3 
>                    :location 69
>                    }
>                    {FUNCEXPR 
>                    :funcid 1740 
>                    :funcresulttype 1700 
>                    :funcretset false 
>                    :funcformat 2 
>                    :args (
>                       {CONST 
>                       :consttype 23 
>                       :consttypmod -1 
>                       :constlen 4 
>                       :constbyval true 
>                       :constisnull false 
>                       :location 85 
>                       :constvalue 4 [ 46 -15 -102 59 0 0 0 0 ]
>                       }
>                    )
>                    :location -1
>                    }
>                 )
>                 :location 83
>                 }
>              }
>           :targetList (
>              {TARGETENTRY 
>              :expr 
>                 {VAR 
>                 :varno 1 
>                 :varattno 1 
>                 :vartype 1700 
>                 :vartypmod -1 
>                 :varlevelsup 0 
>                 :varnoold 1 
>                 :varoattno 1 
>                 :location 12
>                 }
>              :resno 1 
>              :resname id 
>              :ressortgroupref 0 
>              :resorigtbl 17025 
>              :resorigcol 1 
>              :resjunk false
>              }
>           )
>           :returningList <> 
>           :groupClause <> 
>           :havingQual <> 
>           :windowClause <> 
>           :distinctClause <> 
>           :sortClause <> 
>           :limitOffset <> 
>           :limitCount <> 
>           :rowMarks <> 
>           :setOperations <>
>           }
>        
>spaceuser%spaceschema%1468%10767046%22/64STATEMENT:  
>            select acr.id
>              from rhnActionConfigRevision acr
>             where acr.server_id = 1000010030
>
>spaceuser%spaceschema%1468%10767046%22/64LOG:  rewritten parse tree:
>spaceuser%spaceschema%1468%10767046%22/64DETAIL:  (
>           {QUERY 
>           :commandType 1 
>           :querySource 0 
>           :canSetTag true 
>           :utilityStmt <> 
>           :resultRelation 0 
>           :intoClause <> 
>           :hasAggs false 
>           :hasWindowFuncs false 
>           :hasSubLinks false 
>           :hasDistinctOn false 
>           :hasRecursive false 
>           :cteList <> 
>           :rtable (
>              {RTE 
>              :alias 
>                 {ALIAS 
>                 :aliasname acr 
>                 :colnames <>
>                 }
>              :eref 
>                 {ALIAS 
>                 :aliasname acr 
>                 :colnames ("id" "action_id" "server_id" "config_revision_id" "failure
>                 _id" "created" "modified")
>                 }
>              :rtekind 0 
>              :relid 17025 
>              :inh true 
>              :inFromCl true 
>              :requiredPerms 2 
>              :checkAsUser 0 
>              :selectedCols (b 9 11)
>              :modifiedCols (b)
>              }
>           )
>           :jointree 
>              {FROMEXPR 
>              :fromlist (
>                 {RANGETBLREF 
>                 :rtindex 1
>                 }
>              )
>              :quals 
>                 {OPEXPR 
>                 :opno 1752 
>                 :opfuncid 1718 
>                 :opresulttype 16 
>                 :opretset false 
>                 :args (
>                    {VAR 
>                    :varno 1 
>                    :varattno 3 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 3 
>                    :location 69
>                    }
>                    {FUNCEXPR 
>                    :funcid 1740 
>                    :funcresulttype 1700 
>                    :funcretset false 
>                    :funcformat 2 
>                    :args (
>                       {CONST 
>                       :consttype 23 
>                       :consttypmod -1 
>                       :constlen 4 
>                       :constbyval true 
>                       :constisnull false 
>                       :location 85 
>                       :constvalue 4 [ 46 -15 -102 59 0 0 0 0 ]
>                       }
>                    )
>                    :location -1
>                    }
>                 )
>                 :location 83
>                 }
>              }
>           :targetList (
>              {TARGETENTRY 
>              :expr 
>                 {VAR 
>                 :varno 1 
>                 :varattno 1 
>                 :vartype 1700 
>                 :vartypmod -1 
>                 :varlevelsup 0 
>                 :varnoold 1 
>                 :varoattno 1 
>                 :location 12
>                 }
>              :resno 1 
>              :resname id 
>              :ressortgroupref 0 
>              :resorigtbl 17025 
>              :resorigcol 1 
>              :resjunk false
>              }
>           )
>           :returningList <> 
>           :groupClause <> 
>           :havingQual <> 
>           :windowClause <> 
>           :distinctClause <> 
>           :sortClause <> 
>           :limitOffset <> 
>           :limitCount <> 
>           :rowMarks <> 
>           :setOperations <>
>           }
>        )
>        
>spaceuser%spaceschema%1468%10767046%22/64STATEMENT:  
>            select acr.id
>              from rhnActionConfigRevision acr
>             where acr.server_id = 1000010030
>
>spaceuser%spaceschema%1468%10767046%22/64LOG:  plan:
>spaceuser%spaceschema%1468%10767046%22/64DETAIL:     {PLANNEDSTMT 
>           :commandType 1 
>           :canSetTag true 
>           :transientPlan false 
>           :planTree 
>              {BITMAPHEAPSCAN 
>              :startup_cost 75.83 
>              :total_cost 275.96 
>              :plan_rows 2010 
>              :plan_width 8 
>              :targetlist (
>                 {TARGETENTRY 
>                 :expr 
>                    {VAR 
>                    :varno 1 
>                    :varattno 1 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 1 
>                    :location 12
>                    }
>                 :resno 1 
>                 :resname id 
>                 :ressortgroupref 0 
>                 :resorigtbl 17025 
>                 :resorigcol 1 
>                 :resjunk false
>                 }
>              )
>              :qual <> 
>              :lefttree 
>                 {BITMAPINDEXSCAN 
>                 :startup_cost 0.00 
>                 :total_cost 75.33 
>                 :plan_rows 2010 
>                 :plan_width 0 
>                 :targetlist <> 
>                 :qual <> 
>                 :lefttree <> 
>                 :righttree <> 
>                 :initPlan <> 
>                 :extParam (b)
>                 :allParam (b)
>                 :scanrelid 1 
>                 :indexid 17056 
>                 :indexqual (
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 1 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 3 
>                       :location 69
>                       }
>                       {CONST 
>                       :consttype 1700 
>                       :consttypmod -1 
>                       :constlen -1 
>                       :constbyval false 
>                       :constisnull false 
>                       :location -1 
>                       :constvalue 14 [ 56 0 0 0 0 0 2 0 10 0 1 0 30 0 ]
>                       }
>                    )
>                    :location 83
>                    }
>                 )
>                 :indexqualorig (
>                    {OPEXPR 
>                    :opno 1752 
>                    :opfuncid 1718 
>                    :opresulttype 16 
>                    :opretset false 
>                    :args (
>                       {VAR 
>                       :varno 1 
>                       :varattno 3 
>                       :vartype 1700 
>                       :vartypmod -1 
>                       :varlevelsup 0 
>                       :varnoold 1 
>                       :varoattno 3 
>                       :location 69
>                       }
>                       {CONST 
>                       :consttype 1700 
>                       :consttypmod -1 
>                       :constlen -1 
>                       :constbyval false 
>                       :constisnull false 
>                       :location -1 
>                       :constvalue 14 [ 56 0 0 0 0 0 2 0 10 0 1 0 30 0 ]
>                       }
>                    )
>                    :location 83
>                    }
>                 )
>                 }
>              :righttree <> 
>              :initPlan <> 
>              :extParam (b)
>              :allParam (b)
>              :scanrelid 1 
>              :bitmapqualorig (
>                 {OPEXPR 
>                 :opno 1752 
>                 :opfuncid 1718 
>                 :opresulttype 16 
>                 :opretset false 
>                 :args (
>                    {VAR 
>                    :varno 1 
>                    :varattno 3 
>                    :vartype 1700 
>                    :vartypmod -1 
>                    :varlevelsup 0 
>                    :varnoold 1 
>                    :varoattno 3 
>                    :location 69
>                    }
>                    {CONST 
>                    :consttype 1700 
>                    :consttypmod -1 
>                    :constlen -1 
>                    :constbyval false 
>                    :constisnull false 
>                    :location -1 
>                    :constvalue 14 [ 56 0 0 0 0 0 2 0 10 0 1 0 30 0 ]
>                    }
>                 )
>                 :location 83
>                 }
>              )
>              }
>           :rtable (
>              {RTE 
>              :alias 
>                 {ALIAS 
>                 :aliasname acr 
>                 :colnames <>
>                 }
>              :eref 
>                 {ALIAS 
>                 :aliasname acr 
>                 :colnames ("id" "action_id" "server_id" "config_revision_id" "failure
>                 _id" "created" "modified")
>                 }
>              :rtekind 0 
>              :relid 17025 
>              :inh false 
>              :inFromCl true 
>              :requiredPerms 2 
>              :checkAsUser 0 
>              :selectedCols (b 9 11)
>              :modifiedCols (b)
>              }
>           )
>           :resultRelations <> 
>           :utilityStmt <> 
>           :intoClause <> 
>           :subplans <> 
>           :rewindPlanIDs (b)
>           :returningLists <> 
>           :rowMarks <> 
>           :relationOids (o 17025)
>           :invalItems <> 
>           :nParamExec 0
>           }
>        
>spaceuser%spaceschema%1468%10767046%22/64STATEMENT:  
>            select acr.id
>              from rhnActionConfigRevision acr
>             where acr.server_id = 1000010030
>
>spaceuser%spaceschema%1468%10767046%22/64LOG:  duration: 60.884 ms
>
>

Actions: View

Attachments on bug 873379: 638747 | 644715 | 645559 | 646275 | 646369 | 649139 | 649654 | 650335