Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-31640

subqueries should be advised, explained and monitored

    XMLWordPrintable

Details

    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

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            Build couchbase-server-7.2.0-1097 contains query commit 1bedb69 with commit message:
            MB-31640 add subquery timings

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-1097 contains query commit 1bedb69 with commit message: MB-31640 add subquery timings

            Build couchbase-server-7.1.1-3088 contains query commit 06b6fe8 with commit message:
            MB-31640 add subquery timings

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.1-3088 contains query commit 06b6fe8 with commit message: MB-31640 add subquery timings

            Build couchbase-server-7.2.0-1286 contains query commit 43b2bdf with commit message:
            MB-31640 Modify subquery explain

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-1286 contains query commit 43b2bdf with commit message: MB-31640 Modify subquery explain

            Build couchbase-server-7.1.1-3102 contains query commit 381d7ab with commit message:
            MB-31640 Modify subquery explain

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.1-3102 contains query commit 381d7ab with commit message: MB-31640 Modify subquery explain

            Build couchbase-server-7.1.1-3103 contains query commit e8b8c2c with commit message:
            MB-31640. Avoid go fmt go 1.17 and above

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.1-3103 contains query commit e8b8c2c with commit message: MB-31640 . Avoid go fmt go 1.17 and above

            Build couchbase-server-8.0.0-1011 contains query commit 43b2bdf with commit message:
            MB-31640 Modify subquery explain

            build-team Couchbase Build Team added a comment - Build couchbase-server-8.0.0-1011 contains query commit 43b2bdf with commit message: MB-31640 Modify subquery explain

            Build couchbase-server-7.2.0-1290 contains query commit b780405 with commit message:
            MB-31640 Include subqueries in FROM clause and setop arms

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-1290 contains query commit b780405 with commit message: MB-31640 Include subqueries in FROM clause and setop arms

            Build couchbase-server-7.1.1-3106 contains query commit 1de09d0 with commit message:
            MB-31640 Include subqueries in FROM clause and setop arms

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.1-3106 contains query commit 1de09d0 with commit message: MB-31640 Include subqueries in FROM clause and setop arms

            Build couchbase-server-8.0.0-1012 contains query commit b780405 with commit message:
            MB-31640 Include subqueries in FROM clause and setop arms

            build-team Couchbase Build Team added a comment - Build couchbase-server-8.0.0-1012 contains query commit b780405 with commit message: MB-31640 Include subqueries in FROM clause and setop arms
            wayne Wayne Siu added a comment -

            Marco Greco
            Is this ticket complete? Thanks.

            wayne Wayne Siu added a comment - Marco Greco Is this ticket complete? Thanks.
            marco.greco Marco Greco added a comment -

            Wayne Siu the explain and monitor parts are done. The advise part is under review and will be in by monday tops.

            marco.greco Marco Greco added a comment - Wayne Siu the explain and monitor parts are done. The advise part is under review and will be in by monday tops.

            Build couchbase-server-7.2.0-1324 contains query commit 22e8963 with commit message:
            MB-31640 advise subqueries

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-1324 contains query commit 22e8963 with commit message: MB-31640 advise subqueries

            Build couchbase-server-7.1.1-3120 contains query commit 96524ca with commit message:
            MB-31640 advise subqueries

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.1-3120 contains query commit 96524ca with commit message: MB-31640 advise subqueries

            Build couchbase-server-8.0.0-1018 contains query commit 22e8963 with commit message:
            MB-31640 advise subqueries

            build-team Couchbase Build Team added a comment - Build couchbase-server-8.0.0-1018 contains query commit 22e8963 with commit message: MB-31640 advise subqueries
            lynn.straus Lynn Straus added a comment -

            With 7.1.1 split into "early" 7.1.1 and "new" 7.1.2, all related Enhancements and features move to 7.1.2. Changing fixversion of 7.1.1 to 7.1.2.

            lynn.straus Lynn Straus added a comment - With 7.1.1 split into "early" 7.1.1 and "new" 7.1.2, all related Enhancements and features move to 7.1.2. Changing fixversion of 7.1.1 to 7.1.2.

            Manual tested on 7.1.2. Should be release noted since QWB does not handle subquery yet (see linked MB) for advise and explain.

            pierre.regazzoni Pierre Regazzoni added a comment - Manual tested on 7.1.2. Should be release noted since QWB does not handle subquery yet (see linked MB) for advise and explain.

            Build couchbase-server-7.2.0-5000 contains query commit 96524ca with commit message:
            MB-31640 advise subqueries

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-5000 contains query commit 96524ca with commit message: MB-31640 advise subqueries

            Build couchbase-server-7.2.0-5000 contains query commit 1de09d0 with commit message:
            MB-31640 Include subqueries in FROM clause and setop arms

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-5000 contains query commit 1de09d0 with commit message: MB-31640 Include subqueries in FROM clause and setop arms

            Build couchbase-server-7.2.0-5000 contains query commit e8b8c2c with commit message:
            MB-31640. Avoid go fmt go 1.17 and above

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-5000 contains query commit e8b8c2c with commit message: MB-31640 . Avoid go fmt go 1.17 and above

            Build couchbase-server-7.2.0-5000 contains query commit 381d7ab with commit message:
            MB-31640 Modify subquery explain

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-5000 contains query commit 381d7ab with commit message: MB-31640 Modify subquery explain

            Build couchbase-server-7.2.0-5000 contains query commit 06b6fe8 with commit message:
            MB-31640 add subquery timings

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-5000 contains query commit 06b6fe8 with commit message: MB-31640 add subquery timings

            People

              pierre.regazzoni Pierre Regazzoni
              marco.greco Marco Greco
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty