Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.0.3
-
Untriaged
-
Unknown
Description
Test:
Avg. Query Throughput (queries/sec), AG8, Aggregation query, Plasma, not_bounded
Index:
CREATE INDEX ag8 ON `bucket-1`(customer.county, DATE_PART_STR(sold_date, 'year'), DATE_PART_STR(sold_date, 'month'), customer.gender, customer.marital_status, customer.education_status, customer.purchase_estimate, customer.credit_rating, customer.dep_count, customer.dep_employed_count, customer.dep_college_count);
Query:
SELECT customer.gender, customer.marital_status, customer.education_status, customer.purchase_estimate, customer.credit_rating, customer.dep_count, customer.dep_employed_count, customer.dep_college_count, COUNT(1) AS cnt FROM `bucket-1` WHERE customer.county IN $1 AND DATE_PART_STR(sold_date, 'year') = $2 AND DATE_PART_STR(sold_date, 'month') BETWEEN $3 AND $3 + 3 GROUP BY customer.gender, customer.marital_status, customer.education_status, customer.purchase_estimate, customer.credit_rating, customer.dep_count, customer.dep_employed_count, customer.dep_college_count ORDER BY customer.gender, customer.marital_status, customer.education_status, customer.purchase_estimate, customer.credit_rating, customer.dep_count, customer.dep_employed_count, customer.dep_college_count LIMIT 100;
scan_consistency = not_bounded
6.0.3-2851: http://perf.jenkins.couchbase.com/job/arke/2279/
Throughput: 55.0
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2279/172.23.97.12.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2279/172.23.97.13.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2279/172.23.97.14.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2279/172.23.97.15.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2279/172.23.97.18.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2279/172.23.97.19.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2279/172.23.97.20.zip
6.0.3-2852: http://perf.jenkins.couchbase.com/job/arke/2277/
Throughput: 43.0
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2277/172.23.97.12.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2277/172.23.97.13.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2277/172.23.97.14.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2277/172.23.97.15.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2277/172.23.97.18.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2277/172.23.97.19.zip
https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-arke-2277/172.23.97.20.zip
Attachments
Issue Links
- relates to
-
MB-36433 [BP - 5.5.6] 30% drop in TP for array queries
- Closed
For Gerrit Dashboard: MB-36197 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
116387,4 | MB-36197 Group by query throughput regression | alice | query | Status: MERGED | +2 | +1 |
116445,1 | MB-36197 group by performance regression | master | query | Status: ABANDONED | 0 | 0 |
116468,2 | MB-36197 Group by query throughput regression | vulcan | query | Status: MERGED | +2 | +1 |