Details
-
Improvement
-
Resolution: Fixed
-
Major
-
6.5.0
Description
A placeholder to track an annoyance in N1QL: subqueries are planned as part of execution, and thus are not explained.
Also, since the request plan is missing the subquery, they are not monitored.
We should have a way to hang a subquery plan to an expression.
And ideally, we should have a cache of plans so that we don't reprepare over and over again.
Attachments
Issue Links
- duplicates
-
MB-21936 N1QL:As of now there is no plan seen in explain clause of a query including subqueries
-
- Closed
-
For Gerrit Dashboard: MB-31640 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
174006,11 | MB-31640 add subquery timings | master | query | Status: MERGED | +2 | +1 |
175163,3 | MB-31640 add subquery timings | neo | query | Status: MERGED | +2 | +1 |
175475,3 | MB-31640 Modify subquery explain | master | query | Status: MERGED | +2 | +1 |
175480,2 | MB-31640 Modify subquery explain | neo | query | Status: MERGED | +2 | +1 |
175482,1 | MB-31640. Avoid go fmt go 1.17 and above | master | query | Status: ABANDONED | 0 | 0 |
175483,2 | MB-31640. Avoid go fmt go 1.17 and above | neo | query | Status: MERGED | +2 | +1 |
175484,2 | MB-31640 Include subqueries in FROM clause and setop arms | master | query | Status: MERGED | +2 | +1 |
175505,2 | MB-31640 Include subqueries in FROM clause and setop arms | neo | query | Status: MERGED | +2 | +1 |
175524,6 | MB-31640 advise subqueries | master | query | Status: MERGED | +2 | +1 |
175566,2 | MB-31640 advise subqueries | neo | query | Status: MERGED | +2 | +1 |
179552,3 | MB-53588 Display optimizer hints from subquries in explain | master | query | Status: MERGED | +2 | +1 |
183136,3 | MB-54044 Display optimizer hints from subquries in explain | neo | query | Status: MERGED | +2 | +1 |