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

Missing overall cost/cardinality information in explain plan

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • Cheshire-Cat
    • query
    • Untriaged
    • MacOSX 64-bit
    • KS1 data can be obtained from backup on 172.23.123.167 in /tmp/backup
    • 1
    • Yes

    Description

      Overall cost/cardinality information is missing in explain plans for queries involving limit, order by, group by, sort, and other operators after processing of scans/joins.

      A simple example to reproduce the problem is:
      explain SELECT x.u016_i FROM KS1 x WHERE x.uniq_i = 1000 LIMIT 25;

      Attachments

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

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            vijay.sarathy Vijay Sarathy
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty