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

Show "sort count" in Query Workbench with Order By queries

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Minor
    • 5.5.0
    • 4.5.0
    • UI

    Description

      When issuing a query with an 'Order By' clause, cbq-engine returns in the metrics the 'sortCount' field, which indicates how many documents matched the query.

      This is different from "resultCount" which indicates the exact number of documents returned.

      If the user specifies both an "Order By" and also "Limit", the "sortCount" field tells how many documents there would be if there was no "Limit".

      Keshav requested that this be surfaced somewhere in the UI.

      Attachments

        Activity

          People

            eben Eben Haber
            eben Eben Haber
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty