Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2012-12-14 12:50:45 CST LOCATION: elog_node_display, print.c:85
- 2012-12-14 12:50:45 CST STATEMENT: SELECT name,value FROM mdl_config_plugins WHERE plugin = $1
- 2012-12-14 12:50:45 CST LOG: 00000: duration: 0.482 ms bind <unnamed>: SELECT name,value FROM mdl_config_plugins WHERE plugin = $1
- 2012-12-14 12:50:45 CST DETAIL: parameters: $1 = 'blocks/section_links'
- 2012-12-14 12:50:45 CST LOCATION: exec_bind_message, postgres.c:1805
- 2012-12-14 12:50:45 CST LOG: 00000: execute <unnamed>: SELECT name,value FROM mdl_config_plugins WHERE plugin = $1
- 2012-12-14 12:50:45 CST DETAIL: parameters: $1 = 'blocks/section_links'
- 2012-12-14 12:50:45 CST LOCATION: exec_execute_message, postgres.c:1940
- 2012-12-14 12:50:45 CST LOG: 00000: duration: 0.114 ms
- 2012-12-14 12:50:45 CST LOCATION: exec_execute_message, postgres.c:2011
- 2012-12-14 12:50:45 CST DEBUG: 00000: CommitTransactionCommand
- 2012-12-14 12:50:45 CST LOCATION: finish_xact_command, postgres.c:2450
- 2012-12-14 12:50:45 CST DEBUG: 00000: CommitTransaction
- 2012-12-14 12:50:45 CST LOCATION: ShowTransactionState, xact.c:4316
- 2012-12-14 12:50:45 CST DEBUG: 00000: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
- 2012-12-14 12:50:45 CST LOCATION: ShowTransactionStateRec, xact.c:4354
- 2012-12-14 12:50:45 CST DEBUG: 00000: parse <unnamed>: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST LOCATION: exec_parse_message, postgres.c:1146
- 2012-12-14 12:50:45 CST STATEMENT: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST DEBUG: 00000: StartTransactionCommand
- 2012-12-14 12:50:45 CST LOCATION: start_xact_command, postgres.c:2426
- 2012-12-14 12:50:45 CST STATEMENT: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST DEBUG: 00000: StartTransaction
- 2012-12-14 12:50:45 CST LOCATION: ShowTransactionState, xact.c:4316
- 2012-12-14 12:50:45 CST STATEMENT: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
- 2012-12-14 12:50:45 CST LOCATION: ShowTransactionStateRec, xact.c:4354
- 2012-12-14 12:50:45 CST STATEMENT: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST LOG: 00000: parse tree:
- 2012-12-14 12:50:45 CST DETAIL: {QUERY
- :commandType 1
- :querySource 0
- :canSetTag true
- :utilityStmt <>
- :resultRelation 0
- :intoClause <>
- :hasAggs false
- :hasWindowFuncs false
- :hasSubLinks false
- :hasDistinctOn false
- :hasRecursive false
- :hasModifyingCTE false
- :hasForUpdate false
- :cteList <>
- :rtable (
- {RTE
- :alias <>
- :eref
- {ALIAS
- :aliasname mdl_course_sections
- :colnames ("id" "course" "section" "name" "summary" "summaryformat" "
- sequence" "visible" "availablefrom" "availableuntil" "showavailabilit
- y" "groupingid")
- }
- :rtekind 0
- :relid 27635
- :relkind r
- :inh true
- :inFromCl true
- :requiredPerms 2
- :checkAsUser 0
- :selectedCols (b 10 11 16)
- :modifiedCols (b)
- }
- )
- :jointree
- {FROMEXPR
- :fromlist (
- {RANGETBLREF
- :rtindex 1
- }
- )
- :quals
- {BOOLEXPR
- :boolop and
- :args (
- {OPEXPR
- :opno 410
- :opfuncid 467
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 2
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 2
- :location 90
- }
- {PARAM
- :paramkind 0
- :paramid 1
- :paramtype 20
- :paramtypmod -1
- :paramcollid 0
- :location 99
- }
- )
- :location 97
- }
- {OPEXPR
- :opno 418
- :opfuncid 476
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 3
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 3
- :location 129
- }
- {CONST
- :consttype 23
- :consttypmod -1
- :constcollid 0
- :constlen 4
- :constbyval true
- :constisnull false
- :location 139
- :constvalue 4 [ 11 0 0 0 0 0 0 0 ]
- }
- )
- :location 137
- }
- )
- :location 102
- }
- }
- :targetList (
- {TARGETENTRY
- :expr
- {VAR
- :varno 1
- :varattno 3
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 3
- :location 7
- }
- :resno 1
- :resname section
- :ressortgroupref 1
- :resorigtbl 27635
- :resorigcol 3
- :resjunk false
- }
- {TARGETENTRY
- :expr
- {VAR
- :varno 1
- :varattno 8
- :vartype 21
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 8
- :location 16
- }
- :resno 2
- :resname visible
- :ressortgroupref 0
- :resorigtbl 27635
- :resorigcol 8
- :resjunk false
- }
- )
- :returningList <>
- :groupClause <>
- :havingQual <>
- :windowClause <>
- :distinctClause <>
- :sortClause (
- {SORTGROUPCLAUSE
- :tleSortGroupRef 1
- :eqop 410
- :sortop 412
- :nulls_first false
- :hashable true
- }
- )
- :limitOffset <>
- :limitCount <>
- :rowMarks <>
- :setOperations <>
- :constraintDeps <>
- }
- 2012-12-14 12:50:45 CST LOCATION: elog_node_display, print.c:85
- 2012-12-14 12:50:45 CST STATEMENT: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST LOG: 00000: rewritten parse tree:
- 2012-12-14 12:50:45 CST DETAIL: (
- {QUERY
- :commandType 1
- :querySource 0
- :canSetTag true
- :utilityStmt <>
- :resultRelation 0
- :intoClause <>
- :hasAggs false
- :hasWindowFuncs false
- :hasSubLinks false
- :hasDistinctOn false
- :hasRecursive false
- :hasModifyingCTE false
- :hasForUpdate false
- :cteList <>
- :rtable (
- {RTE
- :alias <>
- :eref
- {ALIAS
- :aliasname mdl_course_sections
- :colnames ("id" "course" "section" "name" "summary" "summaryformat" "
- sequence" "visible" "availablefrom" "availableuntil" "showavailabilit
- y" "groupingid")
- }
- :rtekind 0
- :relid 27635
- :relkind r
- :inh true
- :inFromCl true
- :requiredPerms 2
- :checkAsUser 0
- :selectedCols (b 10 11 16)
- :modifiedCols (b)
- }
- )
- :jointree
- {FROMEXPR
- :fromlist (
- {RANGETBLREF
- :rtindex 1
- }
- )
- :quals
- {BOOLEXPR
- :boolop and
- :args (
- {OPEXPR
- :opno 410
- :opfuncid 467
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 2
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 2
- :location 90
- }
- {PARAM
- :paramkind 0
- :paramid 1
- :paramtype 20
- :paramtypmod -1
- :paramcollid 0
- :location 99
- }
- )
- :location 97
- }
- {OPEXPR
- :opno 418
- :opfuncid 476
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 3
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 3
- :location 129
- }
- {CONST
- :consttype 23
- :consttypmod -1
- :constcollid 0
- :constlen 4
- :constbyval true
- :constisnull false
- :location 139
- :constvalue 4 [ 11 0 0 0 0 0 0 0 ]
- }
- )
- :location 137
- }
- )
- :location 102
- }
- }
- :targetList (
- {TARGETENTRY
- :expr
- {VAR
- :varno 1
- :varattno 3
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 3
- :location 7
- }
- :resno 1
- :resname section
- :ressortgroupref 1
- :resorigtbl 27635
- :resorigcol 3
- :resjunk false
- }
- {TARGETENTRY
- :expr
- {VAR
- :varno 1
- :varattno 8
- :vartype 21
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 8
- :location 16
- }
- :resno 2
- :resname visible
- :ressortgroupref 0
- :resorigtbl 27635
- :resorigcol 8
- :resjunk false
- }
- )
- :returningList <>
- :groupClause <>
- :havingQual <>
- :windowClause <>
- :distinctClause <>
- :sortClause (
- {SORTGROUPCLAUSE
- :tleSortGroupRef 1
- :eqop 410
- :sortop 412
- :nulls_first false
- :hashable true
- }
- )
- :limitOffset <>
- :limitCount <>
- :rowMarks <>
- :setOperations <>
- :constraintDeps <>
- }
- )
- 2012-12-14 12:50:45 CST LOCATION: elog_node_display, print.c:85
- 2012-12-14 12:50:45 CST STATEMENT: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST LOG: 00000: duration: 1.422 ms parse <unnamed>: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST LOCATION: exec_parse_message, postgres.c:1385
- 2012-12-14 12:50:45 CST DEBUG: 00000: bind <unnamed> to <unnamed>
- 2012-12-14 12:50:45 CST LOCATION: exec_bind_message, postgres.c:1429
- 2012-12-14 12:50:45 CST LOG: 00000: plan:
- 2012-12-14 12:50:45 CST DETAIL: {PLANNEDSTMT
- :commandType 1
- :hasReturning false
- :hasModifyingCTE false
- :canSetTag true
- :transientPlan false
- :planTree
- {SORT
- :startup_cost 29.12
- :total_cost 29.14
- :plan_rows 8
- :plan_width 10
- :targetlist (
- {TARGETENTRY
- :expr
- {VAR
- :varno 65001
- :varattno 1
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 3
- :location -1
- }
- :resno 1
- :resname section
- :ressortgroupref 1
- :resorigtbl 27635
- :resorigcol 3
- :resjunk false
- }
- {TARGETENTRY
- :expr
- {VAR
- :varno 65001
- :varattno 2
- :vartype 21
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 8
- :location -1
- }
- :resno 2
- :resname visible
- :ressortgroupref 0
- :resorigtbl 27635
- :resorigcol 8
- :resjunk false
- }
- )
- :qual <>
- :lefttree
- {BITMAPHEAPSCAN
- :startup_cost 4.33
- :total_cost 29.00
- :plan_rows 8
- :plan_width 10
- :targetlist (
- {TARGETENTRY
- :expr
- {VAR
- :varno 1
- :varattno 3
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 3
- :location 7
- }
- :resno 1
- :resname section
- :ressortgroupref 1
- :resorigtbl 27635
- :resorigcol 3
- :resjunk false
- }
- {TARGETENTRY
- :expr
- {VAR
- :varno 1
- :varattno 8
- :vartype 21
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 8
- :location 16
- }
- :resno 2
- :resname visible
- :ressortgroupref 0
- :resorigtbl 27635
- :resorigcol 8
- :resjunk false
- }
- )
- :qual <>
- :lefttree
- {BITMAPINDEXSCAN
- :startup_cost 0.00
- :total_cost 4.33
- :plan_rows 8
- :plan_width 0
- :targetlist <>
- :qual <>
- :lefttree <>
- :righttree <>
- :initPlan <>
- :extParam (b)
- :allParam (b)
- :scanrelid 1
- :indexid 71786
- :indexqual (
- {OPEXPR
- :opno 410
- :opfuncid 467
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 1
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 2
- :location 90
- }
- {CONST
- :consttype 20
- :consttypmod -1
- :constcollid 0
- :constlen 8
- :constbyval true
- :constisnull false
- :location -1
- :constvalue 8 [ 119 0 0 0 0 0 0 0 ]
- }
- )
- :location 97
- }
- {OPEXPR
- :opno 418
- :opfuncid 476
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 2
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 3
- :location 129
- }
- {CONST
- :consttype 23
- :consttypmod -1
- :constcollid 0
- :constlen 4
- :constbyval true
- :constisnull false
- :location 139
- :constvalue 4 [ 11 0 0 0 0 0 0 0 ]
- }
- )
- :location 137
- }
- )
- :indexqualorig (
- {OPEXPR
- :opno 410
- :opfuncid 467
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 2
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 2
- :location 90
- }
- {CONST
- :consttype 20
- :consttypmod -1
- :constcollid 0
- :constlen 8
- :constbyval true
- :constisnull false
- :location -1
- :constvalue 8 [ 119 0 0 0 0 0 0 0 ]
- }
- )
- :location 97
- }
- {OPEXPR
- :opno 418
- :opfuncid 476
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 3
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 3
- :location 129
- }
- {CONST
- :consttype 23
- :consttypmod -1
- :constcollid 0
- :constlen 4
- :constbyval true
- :constisnull false
- :location 139
- :constvalue 4 [ 11 0 0 0 0 0 0 0 ]
- }
- )
- :location 137
- }
- )
- }
- :righttree <>
- :initPlan <>
- :extParam (b)
- :allParam (b)
- :scanrelid 1
- :bitmapqualorig (
- {OPEXPR
- :opno 410
- :opfuncid 467
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 2
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 2
- :location 90
- }
- {CONST
- :consttype 20
- :consttypmod -1
- :constcollid 0
- :constlen 8
- :constbyval true
- :constisnull false
- :location -1
- :constvalue 8 [ 119 0 0 0 0 0 0 0 ]
- }
- )
- :location 97
- }
- {OPEXPR
- :opno 418
- :opfuncid 476
- :opresulttype 16
- :opretset false
- :opcollid 0
- :inputcollid 0
- :args (
- {VAR
- :varno 1
- :varattno 3
- :vartype 20
- :vartypmod -1
- :varcollid 0
- :varlevelsup 0
- :varnoold 1
- :varoattno 3
- :location 129
- }
- {CONST
- :consttype 23
- :consttypmod -1
- :constcollid 0
- :constlen 4
- :constbyval true
- :constisnull false
- :location 139
- :constvalue 4 [ 11 0 0 0 0 0 0 0 ]
- }
- )
- :location 137
- }
- )
- }
- :righttree <>
- :initPlan <>
- :extParam (b)
- :allParam (b)
- :numCols 1
- :sortColIdx 1
- :sortOperators 412
- :collations 0
- :nullsFirst false
- }
- :rtable (
- {RTE
- :alias <>
- :eref
- {ALIAS
- :aliasname mdl_course_sections
- :colnames ("id" "course" "section" "name" "summary" "summaryformat" "
- sequence" "visible" "availablefrom" "availableuntil" "showavailabilit
- y" "groupingid")
- }
- :rtekind 0
- :relid 27635
- :relkind r
- :inh false
- :inFromCl true
- :requiredPerms 2
- :checkAsUser 0
- :selectedCols (b 10 11 16)
- :modifiedCols (b)
- }
- )
- :resultRelations <>
- :utilityStmt <>
- :intoClause <>
- :subplans <>
- :rewindPlanIDs (b)
- :rowMarks <>
- :relationOids (o 27635)
- :invalItems <>
- :nParamExec 0
- }
- 2012-12-14 12:50:45 CST LOCATION: elog_node_display, print.c:85
- 2012-12-14 12:50:45 CST STATEMENT: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST LOG: 00000: duration: 1.034 ms bind <unnamed>: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST DETAIL: parameters: $1 = '119'
- 2012-12-14 12:50:45 CST LOCATION: exec_bind_message, postgres.c:1805
- 2012-12-14 12:50:45 CST LOG: 00000: execute <unnamed>: SELECT section, visible
- FROM mdl_course_sections
- WHERE course = $1 AND
- section < 11
- ORDER BY section
- 2012-12-14 12:50:45 CST DETAIL: parameters: $1 = '119'
- 2012-12-14 12:50:45 CST LOCATION: exec_execute_message, postgres.c:1940
- 2012-12-14 12:50:45 CST LOG: 00000: duration: 7.752 ms
- 2012-12-14 12:50:45 CST LOCATION: exec_execute_message, postgres.c:2011
- 2012-12-14 12:50:45 CST DEBUG: 00000: CommitTransactionCommand
- 2012-12-14 12:50:45 CST LOCATION: finish_xact_command, postgres.c:2450
- 2012-12-14 12:50:45 CST DEBUG: 00000: CommitTransaction
- 2012-12-14 12:50:45 CST LOCATION: ShowTransactionState, xact.c:4316
- 2012-12-14 12:50:45 CST DEBUG: 00000: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
- 2012-12-14 12:50:45 CST LOCATION: ShowTransactionStateRec, xact.c:4354
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement