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

Indicate/include index partitioning data within explain plan

    XMLWordPrintable

Details

    • 1

    Description

      Some recent activity/questions show that it would be helpful to be able to see information about whether an index was partitioned for a given query via the explain plan.

      https://forums.couchbase.com/t/getting-2-document-results-of-same-id-when-filtering-documents/29245/14

      Attachments

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

        Activity

          Build couchbase-server-7.0.0-4437 contains query commit 8eccc0a with commit message:
          MB-44230 Add index partition info in explain

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-4437 contains query commit 8eccc0a with commit message: MB-44230 Add index partition info in explain
          bingjie.miao Bingjie Miao added a comment -

          In explain, IndexScan3 section, there should be a new field that looks something like:

                              "index_partition_by": "[`city`, `country`]",
          
          

          bingjie.miao Bingjie Miao added a comment - In explain, IndexScan3 section, there should be a new field that looks something like: "index_partition_by" : "[`city`, `country`]" ,

          Build couchbase-server-7.0.0-4446 contains query commit 2ed60ac with commit message:
          MB-44230 Add empty line for new index_partition_by in unmarshal for consistency

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-4446 contains query commit 2ed60ac with commit message: MB-44230 Add empty line for new index_partition_by in unmarshal for consistency
          wayne Wayne Siu added a comment -

          Re-opening it for 6.6.2.

          wayne Wayne Siu added a comment - Re-opening it for 6.6.2.

          Build couchbase-server-6.6.2-9500 contains query commit e3178e7 with commit message:
          MB-44230 Add index partition info in explain

          build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.2-9500 contains query commit e3178e7 with commit message: MB-44230 Add index partition info in explain

          Verified on 6.6.2-9529 and 7.0.0-4485

                              "#operator": "IndexScan3",
                              "covers": [
                                  "cover ((`travel-sample`.`city`))",
                                  "cover ((`travel-sample`.`country`))",
                                  "cover ((meta(`travel-sample`).`id`))"
                              ],
                              "index": "idx_city_country",
                              "index_id": "cb7e212e83350034",
                              "index_partition_by": "[`city`, `country`]",
                              "index_projection": {
                                  "entry_keys": [
                                      0,
                                      1
                                  ]
                              }, 

          pierre.regazzoni Pierre Regazzoni added a comment - Verified on 6.6.2-9529 and 7.0.0-4485                     "#operator" : "IndexScan3" ,                     "covers" : [                         "cover ((`travel-sample`.`city`))" ,                         "cover ((`travel-sample`.`country`))" ,                         "cover ((meta(`travel-sample`).`id`))"                     ],                     "index" : "idx_city_country" ,                     "index_id" : "cb7e212e83350034" ,                     "index_partition_by" : "[`city`, `country`]" ,                     "index_projection" : {                         "entry_keys" : [                             0 ,                             1                         ]                     },

          People

            pierre.regazzoni Pierre Regazzoni
            perry Perry Krug
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty