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

90th percentile query latency of WF1 increased by 40% on build 7.6.0-1483

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.6.0
    • 7.6.0
    • query
    • Untriaged
    • 0
    • Yes

    Description

      90th percentile query latency (ms), WF1, Windowing query, Plasma, not_bounded, s=1 c=1 i=1

       

      Build Latency Job
      7.6.0-1451 21,691 http://perf.jenkins.couchbase.com/job/arke/13211/
      7.6.0-1483 37,865 http://perf.jenkins.couchbase.com/job/arke/13251/
      7.6.0-1483 31,737 http://perf.jenkins.couchbase.com/job/arke/13269/
      7.6.0-1481
      (EP but no SD)      		 32,181 http://perf.jenkins.couchbase.com/job/arke/13270/
      7.6.0-1471
      (no EP)      		 23,008 http://perf.jenkins.couchbase.com/job/arke/13271/
      7.6.0-1479
      (EP and no
      parsedValue
      changes)      		 34,419 http://perf.jenkins.couchbase.com/job/arke/13272/
      7.6.0-1472 37,806 http://perf.jenkins.couchbase.com/job/arke/13293/
      HEAD plus
      EP with SD
      under flag
      control (so off)      		 30,316 http://perf.jenkins.couchbase.com/job/arke/13295/
      HEAD with no
      EP      		 21,985 http://perf.jenkins.couchbase.com/job/arke/13296/
      7.6.0-1525 29,963 http://perf.jenkins.couchbase.com/job/arke/13307/
      7.6.0-17788
      (invalid results)      		 11,592 http://perf.jenkins.couchbase.com/job/arke/13310/
      7.6.0-17790 19,095 http://perf.jenkins.couchbase.com/job/arke/13313/
      7.6.0-1534 19,624 http://perf.jenkins.couchbase.com/job/arke/13323/

       

      The query plans of these two builds are different.

       

      7.6.0-1451: http://perf.jenkins.couchbase.com/job/arke/13211/artifact/query_plan_0.json 

      7.6.0-1483: http://perf.jenkins.couchbase.com/job/arke/13269/artifact/query_plan_0.json

      The query plan of 7.6.0-1483 has extra information.

      "early_projection": [ "customer", "quantity", "sold_date", "state", "store" ],

      Attachments

        Issue Links

          is triggered by

          Improvement - An improvement or enhancement to an existing feature or task. MB-58465 Early Projection: only retain necessary fields after fetch

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              bo-chun.wang Bo-Chun Wang
              bo-chun.wang Bo-Chun Wang
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty