Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sridevi-15/82098c6e5602c2b022bdfbe093572748 to your computer and use it in GitHub Desktop.
Save sridevi-15/82098c6e5602c2b022bdfbe093572748 to your computer and use it in GitHub Desktop.
select *, meta().plan from system:active_requests
[
{
"active_requests": {
"clientContextID": "de0536cc-f4e2-40c5-85c1-36ca8d7f12c8",
"elapsedTime": "4.721113ms",
"executionTime": "4.679893ms",
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 16,
"primaryScan": 3
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"primaryScan": 1
},
"phaseTimes": {
"authorize": "1.741875ms",
"fetch": "13.196µs",
"instantiate": "29.327µs",
"parse": "473.93µs",
"plan": "140.858µs",
"primaryScan": "2.079501ms"
},
"remoteAddr": "172.23.106.102:38373",
"requestId": "6b9a3ef5-2819-4d04-9a62-768190f46408",
"requestTime": "2020-09-14T10:11:12.546-07:00",
"scanConsistency": "unbounded",
"state": "running",
"statement": "select *, meta().plan from system:active_requests",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36 (Couchbase Query Workbench (7.0.0-3016-enterprise))",
"users": "Administrator"
},
"plan": {
"#operator": "Authorize",
"#stats": {
"#phaseSwitches": 4,
"execTime": "5.278µs",
"servTime": "1.736597ms"
},
"privileges": {
"List": [
{
"Priv": 4,
"Props": 0,
"Target": "#system:active_requests"
}
]
},
"~child": {
"#operator": "Sequence",
"#stats": {
"#phaseSwitches": 1,
"execTime": "4.912µs"
},
"~children": [
{
"#operator": "PrimaryScan",
"#stats": {
"#itemsOut": 3,
"#phaseSwitches": 15,
"execTime": "33.304µs",
"kernTime": "24.473µs",
"servTime": "2.046197ms"
},
"index": "#primary",
"keyspace": "active_requests",
"namespace": "#system",
"using": "system"
},
{
"#operator": "Fetch",
"#stats": {
"#itemsIn": 3,
"#phaseSwitches": 10,
"execTime": "13.196µs",
"kernTime": "2.107786ms",
"servTime": "1.096367ms",
"state": "services"
},
"keyspace": "active_requests",
"namespace": "#system"
},
{
"#operator": "InitialProject",
"#stats": {
"#phaseSwitches": 2,
"execTime": "1.738µs",
"kernTime": "3.261121ms",
"state": "kernel"
},
"result_terms": [
{
"expr": "self",
"star": true
},
{
"expr": "(meta(`active_requests`).`plan`)"
}
]
},
{
"#operator": "Stream",
"#stats": {
"#phaseSwitches": 2,
"execTime": "2.132µs",
"kernTime": "3.337016ms",
"state": "kernel"
}
}
]
},
"~versions": [
"7.0.0-N1QL",
"7.0.0-3016-enterprise"
]
}
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment