Skip to content

Instantly share code, notes, and snippets.

@sridevi-15

sridevi-15/select *, meta().plan from system:completed_requests

Created September 14, 2020 17:20
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/b6d471135d190799c176e6e78676ba0b to your computer and use it in GitHub Desktop.
Save sridevi-15/b6d471135d190799c176e6e78676ba0b to your computer and use it in GitHub Desktop.
Download ZIP
select *, meta().plan from system:completed_requests
Raw
select *, meta().plan from system:completed_requests
[
{
"completed_requests": {
"elapsedTime": "2.786858315s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "21.892µs",
"instantiate": "19.822µs",
"parse": "461.061µs",
"plan": "24.975µs",
"run": "2.786266912s"
},
"remoteAddr": "172.23.120.28:52343",
"requestId": "b2c412d5-1bc2-4cff-a3da-68bec93aec0e",
"requestTime": "2020-09-13T23:37:40.108-07:00",
"resultCount": 0,
"resultSize": 0,
"scanConsistency": "unbounded",
"serviceTime": "2.786816287s",
"state": "completed",
"statement": "CREATE PRIMARY INDEX ON `data-bucket`",
"userAgent": "libcouchbase/2.7.0",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.655250972s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10012,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "30.982µs",
"fetch": "1.32892553s",
"filter": "78.792552ms",
"indexScan": "65.86352ms",
"instantiate": "35.473µs",
"run": "1.655129742s",
"sort": "61.70819ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "462bad39-1223-4b93-9182-400cc92ded4b",
"requestTime": "2020-09-14T07:47:58.257-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.655182938s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.763356923s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10008,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "24.304µs",
"fetch": "1.427628s",
"filter": "80.853206ms",
"indexScan": "80.022039ms",
"instantiate": "33.156µs",
"run": "1.763217164s",
"sort": "62.246131ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "6d61d7ba-9b2f-4d83-bf2c-15d496a69e4b",
"requestTime": "2020-09-14T07:47:56.527-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.763268189s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.740299031s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10001,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "25.521µs",
"fetch": "1.392718564s",
"filter": "80.574382ms",
"indexScan": "61.915616ms",
"instantiate": "49.496µs",
"run": "1.73412572s",
"sort": "66.656827ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "8d450f3c-0707-4b64-a833-5ff4daccbfe8",
"requestTime": "2020-09-14T07:48:03.695-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.734195185s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.633335707s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10007,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "29.572µs",
"fetch": "1.314091557s",
"filter": "77.703806ms",
"indexScan": "58.533841ms",
"instantiate": "40.665µs",
"run": "1.633186823s",
"sort": "59.047657ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "1fa99ccb-bade-44af-b993-22ab3e146ea5",
"requestTime": "2020-09-14T07:48:05.39-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.63326756s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.688493855s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10014,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "12.977µs",
"fetch": "1.360530237s",
"filter": "77.417248ms",
"indexScan": "62.800503ms",
"instantiate": "25.329µs",
"run": "1.688371545s",
"sort": "62.919897ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "c641c058-547b-4026-8494-956331a9fdbf",
"requestTime": "2020-09-14T07:47:54.699-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.688409361s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.603363745s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10001,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "24.439µs",
"fetch": "1.275920579s",
"filter": "77.895557ms",
"indexScan": "59.063787ms",
"instantiate": "36.273µs",
"run": "1.597575403s",
"sort": "63.972502ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "e0e8c272-6c69-4632-969c-dbacb0661360",
"requestTime": "2020-09-14T07:48:08.92-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.597629532s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "3.016214154s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "27.666µs",
"instantiate": "19.901µs",
"parse": "372.358µs",
"plan": "46.823µs",
"run": "3.0156739s"
},
"remoteAddr": "172.23.120.28:37295",
"requestId": "474e13d4-95f1-4856-bcd1-331b4fee0ffd",
"requestTime": "2020-09-14T06:09:01.216-07:00",
"resultCount": 0,
"resultSize": 0,
"scanConsistency": "unbounded",
"serviceTime": "3.016158494s",
"state": "completed",
"statement": "CREATE PRIMARY INDEX ON `data-bucket`",
"userAgent": "libcouchbase/2.7.0",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.778495345s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10003,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "25.927µs",
"fetch": "1.409191777s",
"filter": "80.772675ms",
"indexScan": "64.848999ms",
"instantiate": "32.635µs",
"run": "1.778373664s",
"sort": "75.266618ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "b11c6501-98dc-4f8c-ae57-41ecfa34459d",
"requestTime": "2020-09-14T07:48:07.227-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.778422906s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "2.794325489s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "19.399µs",
"instantiate": "15.414µs",
"parse": "330.471µs",
"plan": "27.232µs",
"run": "2.793861721s"
},
"remoteAddr": "172.23.120.28:52372",
"requestId": "671789fc-581e-411a-9f16-bec69fbc8145",
"requestTime": "2020-09-13T23:41:02.917-07:00",
"resultCount": 0,
"resultSize": 0,
"scanConsistency": "unbounded",
"serviceTime": "2.794278703s",
"state": "completed",
"statement": "CREATE PRIMARY INDEX ON `data-bucket`",
"userAgent": "libcouchbase/2.7.0",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.77651548s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10015,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "20.76µs",
"fetch": "1.431902864s",
"filter": "83.778685ms",
"indexScan": "76.151675ms",
"instantiate": "32.79µs",
"run": "1.776406239s",
"sort": "65.962825ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "e9a2c0cf-0b2f-406e-829f-af6dedf02a9f",
"requestTime": "2020-09-14T07:48:10.76-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.776456822s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "3.034499205s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "23.506µs",
"instantiate": "26.291µs",
"parse": "460.146µs",
"plan": "5.034605ms",
"run": "3.028883469s"
},
"remoteAddr": "172.23.120.28:37788",
"requestId": "0d5ed967-14de-48d6-9056-3f381044aacd",
"requestTime": "2020-09-14T07:04:41.607-07:00",
"resultCount": 0,
"resultSize": 0,
"scanConsistency": "unbounded",
"serviceTime": "3.034450536s",
"state": "completed",
"statement": "CREATE PRIMARY INDEX ON `data-bucket`",
"userAgent": "libcouchbase/2.7.0",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.70991116s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10006,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "20.975µs",
"fetch": "1.375770125s",
"filter": "81.579712ms",
"indexScan": "67.088635ms",
"instantiate": "36.678µs",
"run": "1.709801412s",
"sort": "63.294637ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "79302487-6e5f-49f7-9066-ae90036106bd",
"requestTime": "2020-09-14T07:48:00.03-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.709854807s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
},
{
"completed_requests": {
"elapsedTime": "1.786076979s",
"errorCount": 0,
"node": "172.23.106.102:8091",
"phaseCounts": {
"fetch": 10008,
"filter": 10000,
"indexScan": 10000,
"sort": 10000
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 1
},
"phaseTimes": {
"authorize": "22.545µs",
"fetch": "1.419881901s",
"filter": "77.600316ms",
"indexScan": "64.3001ms",
"instantiate": "36.009µs",
"run": "1.785959029s",
"sort": "65.792759ms"
},
"preparedName": "a8a93793-9ffc-524f-a66d-ed54a6eb7e91",
"preparedText": "PREPARE SELECT META(`data-bucket`).id as id, meta(`data-bucket`).xattrs._sync.rev as r, meta(`data-bucket`).xattrs._sync.sequence as s, meta(`data-bucket`).xattrs._sync.channels as c FROM `data-bucket` USE INDEX (sg_allDocs_x1) WHERE meta(`data-bucket`).xattrs._sync.sequence > 0 AND META(`data-bucket`).id NOT LIKE '\\\\_sync:%' AND meta(`data-bucket`).xattrs._sync IS NOT MISSING AND (meta(`data-bucket`).xattrs._sync.flags IS MISSING OR BITTEST(meta(`data-bucket`).xattrs._sync.flags,1) = false) ORDER BY META(`data-bucket`).id",
"remoteAddr": "172.23.121.54:53540",
"requestId": "1bcb5ecd-f822-4615-a6f9-c8077f91df9e",
"requestTime": "2020-09-14T07:48:01.879-07:00",
"resultCount": 10000,
"resultSize": 988900,
"scanConsistency": "scan_plus",
"serviceTime": "1.786011094s",
"state": "completed",
"userAgent": "Go-http-client/1.1",
"users": "data-bucket"
}
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment