diff options
| author | dan <Dan Kennedy> | 2023-06-30 18:31:37 +0000 |
|---|---|---|
| committer | dan <Dan Kennedy> | 2023-06-30 18:31:37 +0000 |
| commit | 24b368da8dac15cb7d3997ae4fa27d76f0fc682a (patch) | |
| tree | 78a1da7a2f8421b6172bf8168d515d5f1d3d9357 /src/select.c | |
| parent | 1bfe92a691ebab1a80f0743b1483c13adb206c1b (diff) | |
| parent | 4cd3a59a79ef2864bc071a2e7219720f8957673c (diff) | |
| download | sqlite-24b368da8dac15cb7d3997ae4fa27d76f0fc682a.tar.gz sqlite-24b368da8dac15cb7d3997ae4fa27d76f0fc682a.zip | |
Add support for sqlite3_stmt_scanstatus_v2() profiling of GROUP BY clauses that use a temp b-tree, and for sub-queries implemented as co-routines.
FossilOrigin-Name: 7afad1f759f7ceda873c6d869422fd56fe4399c2d24d47ad9bc3b84b06d830d1
Diffstat (limited to 'src/select.c')
| -rw-r--r-- | src/select.c | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/src/select.c b/src/select.c index 71610484b..4af812fa0 100644 --- a/src/select.c +++ b/src/select.c @@ -8009,9 +8009,13 @@ int sqlite3Select( int nCol; int nGroupBy; - explainTempTable(pParse, +#ifdef SQLITE_ENABLE_STMT_SCANSTATUS + int addrExp; /* Address of OP_Explain instruction */ +#endif + ExplainQueryPlan2(addrExp, (pParse, 0, "USE TEMP B-TREE FOR %s", (sDistinct.isTnct && (p->selFlags&SF_Distinct)==0) ? - "DISTINCT" : "GROUP BY"); + "DISTINCT" : "GROUP BY" + )); groupBySort = 1; nGroupBy = pGroupBy->nExpr; @@ -8036,18 +8040,23 @@ int sqlite3Select( } pAggInfo->directMode = 0; regRecord = sqlite3GetTempReg(pParse); + sqlite3VdbeScanStatusCounters(v, addrExp, 0, sqlite3VdbeCurrentAddr(v)); sqlite3VdbeAddOp3(v, OP_MakeRecord, regBase, nCol, regRecord); sqlite3VdbeAddOp2(v, OP_SorterInsert, pAggInfo->sortingIdx, regRecord); + sqlite3VdbeScanStatusRange(v, addrExp, sqlite3VdbeCurrentAddr(v)-2, -1); sqlite3ReleaseTempReg(pParse, regRecord); sqlite3ReleaseTempRange(pParse, regBase, nCol); TREETRACE(0x2,pParse,p,("WhereEnd\n")); sqlite3WhereEnd(pWInfo); pAggInfo->sortingIdxPTab = sortPTab = pParse->nTab++; sortOut = sqlite3GetTempReg(pParse); + sqlite3VdbeScanStatusCounters(v, addrExp, sqlite3VdbeCurrentAddr(v), 0); sqlite3VdbeAddOp3(v, OP_OpenPseudo, sortPTab, sortOut, nCol); sqlite3VdbeAddOp2(v, OP_SorterSort, pAggInfo->sortingIdx, addrEnd); VdbeComment((v, "GROUP BY sort")); VdbeCoverage(v); pAggInfo->useSortingIdx = 1; + sqlite3VdbeScanStatusRange(v, addrExp, -1, sortPTab); + sqlite3VdbeScanStatusRange(v, addrExp, -1, pAggInfo->sortingIdx); } /* If there are entries in pAgggInfo->aFunc[] that contain subexpressions |