SELECT highscores_for_steps_and_card(s.id, 591, 1) FROM stomp_steps s; QUERY PLAN -------------------------------------------------------------------------------------------------------------------- Seq Scan on stomp_steps s (cost=0.00..793.52 rows=2902 width=4) (actual time=1726.998..26729.717 rows=17 loops=1) Total runtime: 26729.822 ms DEBUG: plan: DETAIL: {PLANNEDSTMT :commandType 1 :canSetTag true :planTree {SEQSCAN :startup_cost 0.00 :total_cost 793.52 :plan_rows 2902 :plan_width 4 :targetlist ( {TARGETENTRY :expr {FUNCEXPR :funcid 240532 :funcresulttype 23 :funcretset true :funcformat 0 :args ( {VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1 } {CONST :consttype 23 :consttypmod -1 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ 79 2 0 0 ] } {CONST :consttype 23 :consttypmod -1 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ 1 0 0 0 ] } ) } :resno 1 :resname highscores_for_steps_and_card :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false } ) :qual <> :lefttree <> :righttree <> :initPlan <> :extParam (b) :allParam (b) :scanrelid 1 } :rtable ( {RTE :alias {ALIAS :aliasname s :colnames <> } :eref {ALIAS :aliasname s :colnames ("id" ...) } :rtekind 0 :relid 240100 :inh false :inFromCl true :requiredPerms 2 :checkAsUser 0 } ) :resultRelations <> :utilityStmt <> :intoClause <> :subplans <> :rewindPlanIDs (b) :returningLists <> :rowMarks <> :relationOids (o 240100) :nParamExec 0 } DEBUG: plan: DETAIL: {PLANNEDSTMT :commandType 1 :canSetTag true :planTree {LIMIT :startup_cost 615.59 :total_cost 615.60 :plan_rows 1 :plan_width 8 :targetlist ( {TARGETENTRY :expr {VAR :varno 65001 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1 } :resno 1 :resname id :ressortgroupref 0 :resorigtbl 240375 :resorigcol 1 :resjunk false } {TARGETENTRY :expr {VAR :varno 65001 :varattno 2 :vartype 700 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 14 } :resno 2 :resname <> :ressortgroupref 1 :resorigtbl 0 :resorigcol 0 :resjunk true } ) :qual <> :lefttree {SORT :startup_cost 615.59 :total_cost 615.60 :plan_rows 1 :plan_width 8 :targetlist ( {TARGETENTRY :expr {VAR :varno 65001 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1 } :resno 1 :resname id :ressortgroupref 0 :resorigtbl 240375 :resorigcol 1 :resjunk false } {TARGETENTRY :expr {VAR :varno 65001 :varattno 2 :vartype 700 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 14 } :resno 2 :resname <> :ressortgroupref 1 :resorigtbl 0 :resorigcol 0 :resjunk true } ) :qual <> :lefttree {SEQSCAN :startup_cost 0.00 :total_cost 615.58 :plan_rows 1 :plan_width 8 :targetlist ( {TARGETENTRY :expr {VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1 } :resno 1 :resname id :ressortgroupref 0 :resorigtbl 240375 :resorigcol 1 :resjunk false } {TARGETENTRY :expr {VAR :varno 1 :varattno 14 :vartype 700 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 14 } :resno 2 :resname <> :ressortgroupref 1 :resorigtbl 0 :resorigcol 0 :resjunk true } ) :qual ( {BOOLEXPR :boolop or :args ( {NULLTEST :arg {PARAM :paramkind 0 :paramid 1 :paramtype 23 :paramtypmod -1 } :nulltesttype 0 } {OPEXPR :opno 96 :opfuncid 65 :opresulttype 16 :opretset false :args ( {VAR :varno 1 :varattno 10 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 10 } {PARAM :paramkind 0 :paramid 1 :paramtype 23 :paramtypmod -1 } ) } ) } {BOOLEXPR :boolop or :args ( {NULLTEST :arg {PARAM :paramkind 0 :paramid 2 :paramtype 23 :paramtypmod -1 } :nulltesttype 0 } {OPEXPR :opno 96 :opfuncid 65 :opresulttype 16 :opretset false :args ( {VAR :varno 1 :varattno 4 :vartype 23 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4 } {PARAM :paramkind 0 :paramid 2 :paramtype 23 :paramtypmod -1 } ) } ) } ) :lefttree <> :righttree <> :initPlan <> :extParam (b) :allParam (b) :scanrelid 1 } :righttree <> :initPlan <> :extParam (b) :allParam (b) :numCols 1 :sortColIdx 2 :sortOperators 623 :nullsFirst true } :righttree <> :initPlan <> :extParam (b) :allParam (b) :limitOffset <> :limitCount {FUNCEXPR :funcid 481 :funcresulttype 20 :funcretset false :funcformat 2 :args ( {PARAM :paramkind 0 :paramid 3 :paramtype 23 :paramtypmod -1 } ) } } :rtable ( {RTE :alias {ALIAS :aliasname r :colnames <> } :eref {ALIAS :aliasname r :colnames ("id" "steps_id" ...) } :rtekind 0 :relid 240375 :inh false :inFromCl true :requiredPerms 2 :checkAsUser 0 } ) :resultRelations <> :utilityStmt <> :intoClause <> :subplans <> :rewindPlanIDs (b) :returningLists <> :rowMarks <> :relationOids (o 240375) :nParamExec 0 }