Hi ,
i have one N1QL query that query the bucket via created GSI index. And i
found the execution speed are vital different when run it in code or in cbq.
The code are written in golang with GOCB as below:
myQuery:=gocb.NewN1qlQuery(SELECT xxxxxx query statement)
no other operation before or after and it use nearly 1 min to finished.
When manually execute the exact same query in cbq, it finished in 44 ms !
Below are the explain result of the query, it uses the GSI index.
cbq> explain select `timestamp`,`value` from `monitor` where
endpoint='52833dc7331f080e7f589247f36805be0007aa80622ec989e21f0b7972923f23'
and metric='host.cpu_usage' and timestamp >1462476751 and timestamp
<1462501485;
{
"requestID": "2ad5be3e-5d7e-4e8e-8d18-69893a9849d4",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"index": "hostindex1",
"keyspace": "monitor",
"namespace": "default",
"spans": [
{
"Range": {
"High": [
"\"52833dc7331f080e7f589247f36805be0007aa80622ec989e21f0b7972923f23\"",
"\"host.cpu_usage\"",
"1462501485"
],
"Inclusion": 0,
"Low": [
"\"52833dc7331f080e7f589247f36805be0007aa80622ec989e21f0b7972923f23\"",
"\"host.cpu_usage\"",
"1462476751"
]
}
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Fetch",
"keyspace": "monitor",
"namespace": "default"
},
{
"#operator": "Filter",
"condition":
"(((((`monitor`.`endpoint`) =
\"52833dc7331f080e7f589247f36805be0007aa80622ec989e21f0b7972923f23\")
and ((`monitor`.`metric`) = \"host.cpu_usage\")) and (1462476751
\u003c (`monitor`.`timestamp`))) and ((`monitor`.`timestamp`) \u003c
1462501485))"
},
{
"#operator": "InitialProject",
"result_terms": [
{
"expr": "(`monitor`.`timestamp`)"
},
{
"expr": "(`monitor`.`value`)"
}
]
},
{
"#operator": "FinalProject"
}
]
}
}
]
}
],
"status": "success",
"metrics": {
"elapsedTime": "14.492699ms",
"executionTime": "14.439993ms",
"resultCount": 1,
"resultSize": 2650
}
}
Thanks if anyone know this issues or any clue.
--
jOe
--
You received this message because you are subscribed to the Google Groups
"Couchbase" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
