Description
n1ql "max()" is much slower than "min()" operation on couchbase 4.5 preview edition.
the detail:
SELECT min(time_first) FROM statis_user_success
{{{
"requestID": "c5e8b6df-9f0e-4690-b3a7-350d07b1e2e4",
"signature":
,
"results":
{
"0":
},
"status": "success",
"metrics":
}}}
SELECT max(time_first) FROM statis_user_success
{{{
"requestID": "c5e8b6df-9f0e-4690-b3a7-350d07b1e2e4",
"signature":
,
"results":
{
"0":
},
"status": "success",
"metrics":
}}}
SELECT * FROM statis_user_success limit 3
{{[
{
"statis_user_success":
},
{
"statis_user_success":
},
{
"statis_user_success":
}
]}}
SELECT * FROM system:indexes where keyspace_id='statis_user_success' and name='idx_time_first'
{{[
{
"indexes":
}
]}}
explain select min(time_first) from statis_user_success
{{[
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"covers": [
"cover ((`statis_user_success`.`time_first`))",
"cover ((meta(`statis_user_success`).`id`))"
],
"index": "idx_time_first",
"index_id": "9d8f7238fa7276a5",
"keyspace": "statis_user_success",
"limit": "1",
"namespace": "default",
"spans": [
{
"Range":
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"maxParallelism": 1,
"~child": {
"#operator": "Sequence",
"~children": [
]
}
},
,
,
{
"#operator": "Parallel",
"maxParallelism": 1,
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
},
"text": "select min(time_first) from statis_user_success"
}
]}}
explain select max(time_first) from statis_user_success
{{[
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"covers": [
"cover ((`statis_user_success`.`time_first`))",
"cover ((meta(`statis_user_success`).`id`))"
],
"index": "idx_time_first",
"index_id": "9d8f7238fa7276a5",
"keyspace": "statis_user_success",
"namespace": "default",
"spans": [
{
"Range":
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
]
}
},
,
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
},
"text": "statis_user_success"
}
]}}