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-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