AVG Phase time
//Monday 13 Feb 2023
//Code to review long complete requests and provide
//avg time for every phaseTime
//This code will parse entire JSON file and summarize the complete requests.
//Paste entire JSON file in requests.
const requests =[
{
"completed_requests": {
"clientContextID": "INTERNAL-5f58ce9f-7c7a-40c8-9630-017c1a9f7839",
"elapsedTime": "2.005578608s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "3.169625ms",
"instantiate": "9.694µs",
"parse": "304.426µs",
"plan": "9.19µs",
"run": "2.00520614s"
},
"remoteAddr": "10.21.33.134:47987",
"requestId": "b26687fd-d439-42c7-8c23-fdcbf59d6d17",
"requestTime": "2023-02-10T15:40:01.859-06:00",
"resultCount": 1,
"resultSize": 37886,
"scanConsistency": "unbounded",
"serviceTime": "2.005537442s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "plw1714ps"
}
},
{
"completed_requests": {
"clientContextID": "4c26ec32-0cbb-4725-8a1d-c6e46f3d41a6",
"elapsedTime": "2.733269478s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 41508,
"filter": 41508,
"indexScan": 41508,
"sort": 42108
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "21.362µs",
"fetch": "2.077107993s",
"filter": "737.771462ms",
"indexScan": "125.998346ms",
"instantiate": "47.372µs",
"parse": "2.647256ms",
"plan": "890.267µs",
"run": "2.72959754s",
"sort": "461.371883ms"
},
"remoteAddr": "10.132.163.232:59404",
"requestId": "873f9a74-8dda-403d-9db6-87ee926ee391",
"requestTime": "2023-01-27T10:06:25.775-06:00",
"resultCount": 100,
"resultSize": 363710,
"scanConsistency": "unbounded",
"serviceTime": "2.733200315s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 100 OFFSET 500",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-8df0d095-bfe8-4363-ad5b-c620ff3cb03c",
"elapsedTime": "2.662978561s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "6.891222ms",
"instantiate": "1.514826ms",
"parse": "7.29081ms",
"plan": "12.347911ms",
"run": "2.640809189s"
},
"remoteAddr": "10.21.33.134:58393",
"requestId": "18fa379c-53c8-4bd5-9020-023ad252eca6",
"requestTime": "2023-02-02T09:24:15.944-06:00",
"resultCount": 1,
"resultSize": 31671,
"scanConsistency": "unbounded",
"serviceTime": "2.662944871s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "pl1x476ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-9690cfe2-c949-460b-b4b9-84130cc9239e",
"elapsedTime": "2.568956995s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "4.615709ms",
"instantiate": "6.881µs",
"parse": "299.369µs",
"plan": "6.736µs",
"run": "2.568601826s"
},
"remoteAddr": "10.21.33.134:34047",
"requestId": "fb116588-2db9-4eed-a328-cc7c02e08104",
"requestTime": "2023-02-02T16:29:24.777-06:00",
"resultCount": 1,
"resultSize": 83099,
"scanConsistency": "unbounded",
"serviceTime": "2.56892157s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply0329ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-4a2360bd-e49b-4c70-bfa4-ee925d8e89cd",
"elapsedTime": "2.961679503s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "2.090866ms",
"instantiate": "10.906µs",
"parse": "398.638µs",
"plan": "1.061476ms",
"run": "2.96014557s"
},
"remoteAddr": "10.21.33.134:54184",
"requestId": "83d37d0d-6cfd-470b-b18c-f481dfee1e1d",
"requestTime": "2023-02-02T11:07:25.113-06:00",
"resultCount": 1,
"resultSize": 87692,
"scanConsistency": "unbounded",
"serviceTime": "2.961626474s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "pl1x476ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-325aa2c0-acfb-4c9e-869d-52fd31a8ab7b",
"elapsedTime": "2.197249206s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "9.136735ms",
"instantiate": "1.71846ms",
"parse": "2.96376ms",
"plan": "1.401951ms",
"run": "2.189302074s"
},
"remoteAddr": "10.21.33.134:40445",
"requestId": "b4534b80-85e3-4048-8b19-0d39cc640017",
"requestTime": "2023-02-10T15:40:01.639-06:00",
"resultCount": 1,
"resultSize": 57026,
"scanConsistency": "unbounded",
"serviceTime": "2.197195675s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "plw1714ps"
}
},
{
"completed_requests": {
"clientContextID": "8d3b5b78-09e1-441b-95a7-a5e1094a93de",
"elapsedTime": "3.063211553s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 41508,
"filter": 41508,
"indexScan": 41508,
"sort": 42008
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "31.242µs",
"fetch": "2.038408154s",
"filter": "880.771152ms",
"indexScan": "116.240246ms",
"instantiate": "772.403µs",
"parse": "1.444813ms",
"plan": "697.917µs",
"run": "3.060168487s",
"sort": "461.916776ms"
},
"remoteAddr": "10.132.163.239:43080",
"requestId": "f4bcbda5-ad2b-4f43-8a0c-5be8b63cfa91",
"requestTime": "2023-01-27T10:06:25.337-06:00",
"resultCount": 100,
"resultSize": 375368,
"scanConsistency": "unbounded",
"serviceTime": "3.063120097s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 100 OFFSET 400",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-dc93c1a6-2ffa-4fc5-84c7-50a1352aa57e",
"elapsedTime": "1.858856342s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "1.359663ms",
"instantiate": "10.168µs",
"parse": "325.502µs",
"plan": "10.164µs",
"run": "1.858456193s"
},
"remoteAddr": "10.21.33.134:43492",
"requestId": "3002bf2a-3fbb-4f0c-9a0f-77c05e57a5d7",
"requestTime": "2023-02-02T16:31:03.044-06:00",
"resultCount": 1,
"resultSize": 52396,
"scanConsistency": "unbounded",
"serviceTime": "1.858811753s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply0329ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-0454ebad-7531-4574-abee-facf57910c10",
"elapsedTime": "2.847757683s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "1.816135ms",
"instantiate": "11.099µs",
"parse": "298.673µs",
"plan": "10.224µs",
"run": "2.84739317s"
},
"remoteAddr": "10.21.33.134:45850",
"requestId": "44ee5e71-3563-4b15-b2a2-28918137149a",
"requestTime": "2023-02-02T11:07:24.483-06:00",
"resultCount": 1,
"resultSize": 34586,
"scanConsistency": "unbounded",
"serviceTime": "2.847721632s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "pl1x476ps"
}
},
{
"completed_requests": {
"clientContextID": "e397bb14-65bc-49b5-ab5d-d81f1e678c21",
"elapsedTime": "21.114894375s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 271590,
"filter": 271590,
"indexScan": 271590,
"sort": 271600
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "15.82µs",
"fetch": "18.726998401s",
"filter": "4.636861967s",
"indexScan": "615.667ms",
"instantiate": "19.739µs",
"parse": "1.162233ms",
"plan": "632.594µs",
"run": "21.113004734s",
"sort": "1.464434833s"
},
"remoteAddr": "10.132.163.248:33952",
"requestId": "2b2c5946-1f3a-41ca-b866-860cd7165fa7",
"requestTime": "2023-01-27T09:48:49.021-06:00",
"resultCount": 10,
"resultSize": 39923,
"scanConsistency": "unbounded",
"serviceTime": "21.11483321s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "cb77ad93-c4a9-4d1b-be53-70a2e3fcf774",
"elapsedTime": "8.275774965s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 144431,
"filter": 144431,
"indexScan": 144431,
"sort": 144441
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "17.872µs",
"fetch": "4.635443436s",
"filter": "2.443851167s",
"indexScan": "341.26079ms",
"instantiate": "31.947µs",
"parse": "1.392203ms",
"plan": "668.045µs",
"run": "8.273590824s",
"sort": "715.729299ms"
},
"remoteAddr": "10.132.163.248:60648",
"requestId": "c6db9f9a-89bf-48c6-808e-30553c8a686f",
"requestTime": "2023-01-27T10:05:21.159-06:00",
"resultCount": 10,
"resultSize": 43033,
"scanConsistency": "unbounded",
"serviceTime": "8.275701871s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "df4b3a2b-0e92-4234-8e5a-6d67b905419c",
"elapsedTime": "5.754344806s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 97539,
"filter": 97539,
"indexScan": 97539,
"sort": 97549
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "21.27µs",
"fetch": "3.494579196s",
"filter": "1.609101661s",
"indexScan": "232.11194ms",
"instantiate": "35.874µs",
"parse": "1.555537ms",
"plan": "658.213µs",
"run": "5.751984378s",
"sort": "442.115274ms"
},
"remoteAddr": "10.132.163.232:57944",
"requestId": "e52d67ae-bea4-4044-8699-5955d749140a",
"requestTime": "2023-01-27T10:05:29.155-06:00",
"resultCount": 10,
"resultSize": 34287,
"scanConsistency": "unbounded",
"serviceTime": "5.754250604s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "e7343535-5df7-4cb2-9829-32d821e0f595",
"elapsedTime": "4.523717113s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 81939,
"filter": 81939,
"indexScan": 81939,
"sort": 81949
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "25.406µs",
"fetch": "2.504895585s",
"filter": "1.288683705s",
"indexScan": "235.017036ms",
"instantiate": "24.702µs",
"parse": "1.415398ms",
"plan": "673.442µs",
"run": "4.521492235s",
"sort": "379.274435ms"
},
"remoteAddr": "10.132.163.155:48686",
"requestId": "666c3e85-1bab-48c0-a778-bcee684504f2",
"requestTime": "2023-01-27T09:59:20.109-06:00",
"resultCount": 10,
"resultSize": 40801,
"scanConsistency": "unbounded",
"serviceTime": "4.523631253s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-68bc829e-4657-4043-8456-95fff303b645",
"elapsedTime": "2.565932809s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "2.070382ms",
"instantiate": "8.822µs",
"parse": "280.085µs",
"plan": "17.072µs",
"run": "2.56558026s"
},
"remoteAddr": "10.21.33.134:39473",
"requestId": "1337729e-7e4d-40bd-9f25-9eb19eb0cd6f",
"requestTime": "2023-02-02T16:29:24.399-06:00",
"resultCount": 1,
"resultSize": 61937,
"scanConsistency": "unbounded",
"serviceTime": "2.56589352s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply0329ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-8481ad05-674c-4152-9981-eefad24bd641",
"elapsedTime": "1.87600106s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "2.198032ms",
"instantiate": "6.736µs",
"parse": "300.826µs",
"plan": "7.018µs",
"run": "1.875648473s"
},
"remoteAddr": "10.21.33.134:34047",
"requestId": "25b090ea-fea5-4868-b471-68ebbfcaf074",
"requestTime": "2023-02-02T16:29:32.088-06:00",
"resultCount": 1,
"resultSize": 58138,
"scanConsistency": "unbounded",
"serviceTime": "1.875968655s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply0329ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-9db5e589-cd76-4d31-a6ad-712ba3dfcdc8",
"elapsedTime": "1.864153868s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "9.387403ms",
"instantiate": "1.849907ms",
"parse": "3.403507ms",
"plan": "1.058724ms",
"run": "1.857381437s"
},
"remoteAddr": "10.21.33.134:58711",
"requestId": "4af0c382-2671-4958-85e9-e749a77d4ab0",
"requestTime": "2023-02-10T21:58:50.368-06:00",
"resultCount": 1,
"resultSize": 34192,
"scanConsistency": "unbounded",
"serviceTime": "1.864105543s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "plw1714ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-daa9acd5-ead3-4bcc-b62a-5522b36a88b4",
"elapsedTime": "1.999349086s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "2.46517ms",
"instantiate": "8.836µs",
"parse": "379.928µs",
"plan": "9.611µs",
"run": "1.998899861s"
},
"remoteAddr": "10.21.33.134:50813",
"requestId": "1144e48e-9a3c-4c6e-a810-1a76e518b81a",
"requestTime": "2023-02-10T21:58:50.873-06:00",
"resultCount": 1,
"resultSize": 33502,
"scanConsistency": "unbounded",
"serviceTime": "1.99930705s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "plw1714ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-eca704b9-452c-4b04-be50-018278f031ba",
"elapsedTime": "2.583887681s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "6.569337ms",
"instantiate": "10.145µs",
"parse": "468.878µs",
"plan": "19.894µs",
"run": "2.583334628s"
},
"remoteAddr": "10.21.33.134:56573",
"requestId": "81390a4f-3c6c-4d4b-9d98-50ffeebb7d22",
"requestTime": "2023-02-02T09:24:16.276-06:00",
"resultCount": 1,
"resultSize": 74351,
"scanConsistency": "unbounded",
"serviceTime": "2.583843774s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "pl1x476ps"
}
},
{
"completed_requests": {
"clientContextID": "c37b4f29-aca3-4213-80b9-8a624c7c1534",
"elapsedTime": "1.009457646s",
"errorCount": 0,
"node": "prodcouchsm300clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1
},
"phaseTimes": {
"authorize": "18.084µs",
"fetch": "4.599µs",
"filter": "35.264µs",
"indexScan": "1.006007855s",
"instantiate": "16.546µs",
"parse": "1.231622ms",
"plan": "1.943151ms",
"run": "1.00618304s"
},
"remoteAddr": "10.132.163.38:36769",
"requestId": "f324e815-1b27-488d-94b3-bbc6cce0fd82",
"requestTime": "2023-02-02T08:36:51.832-06:00",
"resultCount": 0,
"resultSize": 0,
"scanConsistency": "unbounded",
"serviceTime": "1.009400261s",
"state": "completed",
"statement": "SELECT meta(bksmtscb).id,meta(bksmtscb).cas,amount,ledgerType,transactionType,transactionCode,correlationId,status,isComplete,sourceSystem,sourceSystemDescription,description,category,memo,checkNumber,scheduledForDate,scheduledOnDate,expirationDate,reconciliationMatches,reconciledTransactionId,reconciledByPartyType,reconciledByPartyId,createdDatetime,updatedDatetime,seriesId,enrichment,correspondingAccount,confirmationId FROM bksmtscb WHERE documentType=$docType AND deletedDatetime is missing AND accountCorrelationId=$accountCorrelationId AND scheduledForDate >= $startDate AND scheduledForDate <= $endDate",
"userAgent": "couchbase-java/3.4.1 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 1.8.0_345-b01)",
"users": "bksmtscb_p2"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-19c85b17-4c2e-44b3-bb59-f57ab0100191",
"elapsedTime": "2.170685667s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "3.773422ms",
"instantiate": "12.888µs",
"parse": "420.472µs",
"plan": "11.638µs",
"run": "2.170190828s"
},
"remoteAddr": "10.21.34.49:51560",
"requestId": "efa4af25-d738-4e70-83a5-29269711314d",
"requestTime": "2023-02-09T13:23:50.139-06:00",
"resultCount": 1,
"resultSize": 81453,
"scanConsistency": "unbounded",
"serviceTime": "2.170646886s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-7b1ff410-d216-4175-bdea-8f1bcbcbc88b",
"elapsedTime": "2.151871617s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "2.576244ms",
"instantiate": "15.776µs",
"parse": "414.398µs",
"plan": "37.8µs",
"run": "2.151343541s"
},
"remoteAddr": "10.21.34.49:38162",
"requestId": "7965c359-813c-43c8-ad2c-4533c62afa4b",
"requestTime": "2023-02-09T13:23:54.736-06:00",
"resultCount": 1,
"resultSize": 58713,
"scanConsistency": "unbounded",
"serviceTime": "2.151825138s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-5ee7ec04-99ae-40ac-8f8c-c3c03e850ef3",
"elapsedTime": "1.859635497s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "3.174869ms",
"instantiate": "1.442662ms",
"parse": "3.563177ms",
"plan": "844.362µs",
"run": "1.853182281s"
},
"remoteAddr": "10.21.34.49:45083",
"requestId": "3f1da0ef-a2fd-42f0-8d80-500f87fffa6f",
"requestTime": "2023-02-10T14:44:36.63-06:00",
"resultCount": 1,
"resultSize": 36090,
"scanConsistency": "unbounded",
"serviceTime": "1.859588044s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "dcb38f28-6a27-4b18-9fcb-f75b245cf4b9",
"elapsedTime": "2.459435296s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 41508,
"filter": 41508,
"indexScan": 41508,
"sort": 41608
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "33.791µs",
"fetch": "1.264737325s",
"filter": "611.359417ms",
"indexScan": "112.092321ms",
"instantiate": "32.63µs",
"parse": "1.593036ms",
"plan": "1.755641ms",
"run": "2.45591242s",
"sort": "255.895754ms"
},
"remoteAddr": "10.132.163.254:60276",
"requestId": "01980a25-b57b-4790-913c-b1f49690c702",
"requestTime": "2023-01-27T10:05:56.371-06:00",
"resultCount": 100,
"resultSize": 389689,
"scanConsistency": "unbounded",
"serviceTime": "2.459324771s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 100",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "45495e44-855f-4723-90ed-638022b45f7f",
"elapsedTime": "2.691527272s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 41508,
"filter": 41508,
"indexScan": 41508,
"sort": 41908
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "24.691µs",
"fetch": "1.531466043s",
"filter": "725.993525ms",
"indexScan": "118.482748ms",
"instantiate": "677.671µs",
"parse": "1.306839ms",
"plan": "702.045µs",
"run": "2.688739094s",
"sort": "423.201108ms"
},
"remoteAddr": "10.132.163.232:37068",
"requestId": "d5c6fe24-7f31-4472-9b82-5f5110e7ef4f",
"requestTime": "2023-01-27T10:06:24.087-06:00",
"resultCount": 100,
"resultSize": 490484,
"scanConsistency": "unbounded",
"serviceTime": "2.691444067s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 100 OFFSET 300",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-ca958a2b-6d4c-476d-9f20-db29bbc0a819",
"elapsedTime": "2.182388839s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "14.028832ms",
"instantiate": "16.621µs",
"parse": "354.547µs",
"plan": "20.707µs",
"run": "2.181930121s"
},
"remoteAddr": "10.21.34.49:59564",
"requestId": "8367cb74-5ccf-4617-8d72-eb0e3e16d42f",
"requestTime": "2023-02-09T13:23:54.733-06:00",
"resultCount": 1,
"resultSize": 52457,
"scanConsistency": "unbounded",
"serviceTime": "2.182334987s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-59534941-c14b-476b-898b-888e1a7250e8",
"elapsedTime": "1.716640513s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "1.484465ms",
"instantiate": "10.654µs",
"parse": "656.968µs",
"plan": "1.009906ms",
"run": "1.714899944s"
},
"remoteAddr": "10.21.34.49:53898",
"requestId": "27b77807-0242-4f41-8275-6b4d392583a3",
"requestTime": "2023-02-10T14:44:36.927-06:00",
"resultCount": 1,
"resultSize": 44870,
"scanConsistency": "unbounded",
"serviceTime": "1.716586648s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-c0e2e7cf-bbca-4a1a-9af4-8bf863c6a8d3",
"elapsedTime": "2.087435796s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "2.399938ms",
"instantiate": "10.164µs",
"parse": "405.596µs",
"plan": "1.595195ms",
"run": "2.085362661s"
},
"remoteAddr": "10.21.34.49:53898",
"requestId": "7f6ee9f8-86ab-4dc4-b6b1-7d340af31bc2",
"requestTime": "2023-02-10T14:44:40.455-06:00",
"resultCount": 1,
"resultSize": 61941,
"scanConsistency": "unbounded",
"serviceTime": "2.087382746s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-0d95c8cc-80d3-45fd-aea9-0ba68473c299",
"elapsedTime": "2.06214935s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "3.812509ms",
"instantiate": "9.124µs",
"parse": "257.184µs",
"plan": "7.736µs",
"run": "2.061826283s"
},
"remoteAddr": "10.21.34.49:45083",
"requestId": "72856d30-e593-4652-8bf7-faec432acc1c",
"requestTime": "2023-02-10T14:44:40.441-06:00",
"resultCount": 1,
"resultSize": 71140,
"scanConsistency": "unbounded",
"serviceTime": "2.062106683s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "8dd69cd3-8cb9-480b-8eb9-c4ab8d14840e",
"elapsedTime": "5.089251912s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 93354,
"filter": 93354,
"indexScan": 93354,
"sort": 93364
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "37.261µs",
"fetch": "2.733978024s",
"filter": "1.313929067s",
"indexScan": "189.423357ms",
"instantiate": "2.88818ms",
"parse": "2.225915ms",
"plan": "3.611885ms",
"run": "5.080388188s",
"sort": "396.308589ms"
},
"remoteAddr": "10.132.163.248:55362",
"requestId": "ea34ffae-8929-4e62-b3b0-eacd6d9da21f",
"requestTime": "2023-01-27T09:59:01.642-06:00",
"resultCount": 10,
"resultSize": 30845,
"scanConsistency": "unbounded",
"serviceTime": "5.089157418s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-7b5b29b0-9492-4e38-9a86-0de527aee0c9",
"elapsedTime": "2.047613697s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "11.052505ms",
"instantiate": "1.486524ms",
"parse": "5.05443ms",
"plan": "811.242µs",
"run": "2.038531314s"
},
"remoteAddr": "10.21.34.49:59564",
"requestId": "e6596a8b-663c-4740-87e6-f4370c04c8b8",
"requestTime": "2023-02-09T13:23:49.508-06:00",
"resultCount": 1,
"resultSize": 55989,
"scanConsistency": "unbounded",
"serviceTime": "2.046348924s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-533dbd34-4626-4add-8b63-fa6ce4e2ccc3",
"elapsedTime": "2.0347339s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "3.597456ms",
"instantiate": "9.962µs",
"parse": "7.427589ms",
"plan": "9.907µs",
"run": "2.027201269s"
},
"remoteAddr": "10.21.34.49:52267",
"requestId": "25905362-591e-4473-998e-7be5191b9f46",
"requestTime": "2023-02-10T14:44:40.63-06:00",
"resultCount": 1,
"resultSize": 35462,
"scanConsistency": "unbounded",
"serviceTime": "2.034657021s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "cda9ceda-c954-40a3-8d29-b1199e7f6362",
"elapsedTime": "5.279610519s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 76329,
"filter": 76329,
"indexScan": 76329,
"sort": 76339
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "32.182µs",
"fetch": "2.962629241s",
"filter": "1.581446733s",
"indexScan": "248.873571ms",
"instantiate": "67.58µs",
"parse": "1.365479ms",
"plan": "843.128µs",
"run": "5.277214584s",
"sort": "447.171213ms"
},
"remoteAddr": "10.132.163.155:48180",
"requestId": "899096e7-4d1a-4a44-bae6-5db9ac129efe",
"requestTime": "2023-01-27T10:05:39.485-06:00",
"resultCount": 10,
"resultSize": 34098,
"scanConsistency": "unbounded",
"serviceTime": "5.279511634s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-41ff3613-8f57-43a1-aadf-da6767e98875",
"elapsedTime": "2.08713156s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "3.176307ms",
"instantiate": "14.597µs",
"parse": "440.895µs",
"plan": "14.769µs",
"run": "2.086577244s"
},
"remoteAddr": "10.21.34.49:51560",
"requestId": "cea617b3-4c16-4575-b1c7-2cf570ac9a91",
"requestTime": "2023-02-09T13:23:54.627-06:00",
"resultCount": 1,
"resultSize": 34150,
"scanConsistency": "unbounded",
"serviceTime": "2.087060533s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-0c27c54c-f715-47be-b974-46cf5d6c435f",
"elapsedTime": "2.002691731s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "1.967503ms",
"instantiate": "13.792µs",
"parse": "3.00819ms",
"plan": "14.662µs",
"run": "1.999565204s"
},
"remoteAddr": "10.21.34.49:34774",
"requestId": "de1fcca5-213e-469c-a3bf-7e5afdda2530",
"requestTime": "2023-02-09T13:23:54.926-06:00",
"resultCount": 1,
"resultSize": 55403,
"scanConsistency": "unbounded",
"serviceTime": "2.002616844s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "9f8a6f46-ad50-4ba9-8ecc-fdf3c1203957",
"elapsedTime": "1.424244325s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1
},
"phaseTimes": {
"authorize": "20.469µs",
"fetch": "2.992µs",
"filter": "14.463µs",
"indexScan": "1.422227778s",
"instantiate": "15.441µs",
"parse": "887.064µs",
"plan": "915.082µs",
"run": "1.42236319s"
},
"remoteAddr": "10.132.163.38:55996",
"requestId": "611f74f6-1fa5-4ca6-bd1e-c860c33b6f3b",
"requestTime": "2023-02-02T08:36:52.232-06:00",
"resultCount": 0,
"resultSize": 0,
"scanConsistency": "unbounded",
"serviceTime": "1.424194711s",
"state": "completed",
"statement": "SELECT meta(bksmtscb).id,meta(bksmtscb).cas,amount,ledgerType,startDate,endDate,frequency,description,occurrences,status,category,seriesType,fromSeriesId,toSeriesId,createdDatetime,deletedDatetime FROM bksmtscb WHERE documentType=$docType AND seriesType=$serType AND accountCorrelationId=$accountCorrelationId",
"userAgent": "couchbase-java/3.4.1 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 1.8.0_345-b01)",
"users": "bksmtscb_p2"
}
},
{
"completed_requests": {
"clientContextID": "INTERNAL-146c1638-801a-42f5-9eb1-40026bbe0ec1",
"elapsedTime": "2.100257323s",
"errorCount": 0,
"node": "prodcouchsm301clsat.usaa.com:8091",
"phaseOperators": {
"authorize": 1
},
"phaseTimes": {
"authorize": "2.451614ms",
"instantiate": "11.755µs",
"parse": "346.261µs",
"plan": "10.372µs",
"run": "2.099838171s"
},
"remoteAddr": "10.21.34.49:38979",
"requestId": "976fd2a5-c29c-4572-a4d0-f66ac6ed8465",
"requestTime": "2023-02-10T14:44:40.673-06:00",
"resultCount": 1,
"resultSize": 39907,
"scanConsistency": "unbounded",
"serviceTime": "2.100215407s",
"state": "completed",
"statement": "infer `bkmsgacb` with {\"infer_timeout\":5, \"max_schema_MB\":1};",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 (Couchbase Query Workbench (6.6.5-10080-enterprise))",
"users": "ply6770ps"
}
},
{
"completed_requests": {
"clientContextID": "682442bd-1dda-4785-9684-c68a39d78b8b",
"elapsedTime": "2.375776157s",
"errorCount": 0,
"node": "prodcouchsm302clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 41508,
"filter": 41508,
"indexScan": 41508,
"sort": 41518
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "15.496µs",
"fetch": "1.467650553s",
"filter": "639.313702ms",
"indexScan": "92.683889ms",
"instantiate": "17.692µs",
"parse": "1.350921ms",
"plan": "580.79µs",
"run": "2.373733696s",
"sort": "185.248872ms"
},
"remoteAddr": "10.132.163.232:53428",
"requestId": "793d473a-41a3-4e87-a5de-fccfa40406ac",
"requestTime": "2023-01-27T10:05:48.046-06:00",
"resultCount": 10,
"resultSize": 34302,
"scanConsistency": "unbounded",
"serviceTime": "2.375704533s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "d2dac208-7a72-4eba-99ef-1e28c8f55207",
"elapsedTime": "19.669869698s",
"errorCount": 0,
"node": "prodcouchsm302clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 310760,
"filter": 310760,
"indexScan": 310760,
"sort": 310770
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "22.829µs",
"fetch": "16.989515125s",
"filter": "4.937913273s",
"indexScan": "622.669645ms",
"instantiate": "27.545µs",
"parse": "1.664245ms",
"plan": "713.042µs",
"run": "19.667357641s",
"sort": "1.623798292s"
},
"remoteAddr": "10.132.163.155:47966",
"requestId": "7d74af23-eead-4e4b-997f-c0d56def4769",
"requestTime": "2023-01-27T10:05:17.166-06:00",
"resultCount": 10,
"resultSize": 35791,
"scanConsistency": "unbounded",
"serviceTime": "19.66978145s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "7fb81375-6697-4c00-bdf0-35b44b1dddda",
"elapsedTime": "5.016140562s",
"errorCount": 0,
"node": "prodcouchsm302clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 93354,
"filter": 93354,
"indexScan": 93354,
"sort": 93364
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "26.081µs",
"fetch": "2.732485232s",
"filter": "1.454571352s",
"indexScan": "244.405608ms",
"instantiate": "26.561µs",
"parse": "1.869845ms",
"plan": "840.372µs",
"run": "5.013269167s",
"sort": "423.640331ms"
},
"remoteAddr": "10.132.163.232:58616",
"requestId": "636f4bf6-1586-4da8-ad41-c601147fe0af",
"requestTime": "2023-01-27T09:59:07.085-06:00",
"resultCount": 10,
"resultSize": 30845,
"scanConsistency": "unbounded",
"serviceTime": "5.016029798s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "74cb1fb8-dd16-466d-8769-908706f7f2d2",
"elapsedTime": "2.856174103s",
"errorCount": 0,
"node": "prodcouchsm302clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 35856,
"filter": 35856,
"indexScan": 35856,
"sort": 35866
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "22.719µs",
"fetch": "2.716228608s",
"filter": "2.048304541s",
"indexScan": "60.377249ms",
"instantiate": "23.517µs",
"parse": "1.51755ms",
"plan": "1.620716ms",
"run": "2.85292144s",
"sort": "84.042035ms"
},
"remoteAddr": "10.132.163.254:49744",
"requestId": "cedc2674-e870-4e81-a76b-562d93d50078",
"requestTime": "2023-01-27T10:01:07.604-06:00",
"resultCount": 10,
"resultSize": 35722,
"scanConsistency": "unbounded",
"serviceTime": "2.856099138s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND requestData.templateId = $1 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "41fc776f-9854-4131-9631-b8d7fb3ba24c",
"elapsedTime": "2.245710799s",
"errorCount": 0,
"node": "prodcouchsm302clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 41508,
"filter": 41508,
"indexScan": 41508,
"sort": 41708
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "30.831µs",
"fetch": "1.317043833s",
"filter": "631.872356ms",
"indexScan": "93.281598ms",
"instantiate": "805.163µs",
"parse": "1.520303ms",
"plan": "658.379µs",
"run": "2.242610738s",
"sort": "317.877549ms"
},
"remoteAddr": "10.132.163.248:56378",
"requestId": "d26549ec-b6fd-41f0-9885-c5d1e750169d",
"requestTime": "2023-01-27T10:06:19.237-06:00",
"resultCount": 100,
"resultSize": 396220,
"scanConsistency": "unbounded",
"serviceTime": "2.245616571s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 100 OFFSET 100",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "1e9c65c2-1cc4-46b3-96c2-5e78c078f4f9",
"elapsedTime": "2.397725528s",
"errorCount": 0,
"node": "prodcouchsm302clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 41508,
"filter": 41508,
"indexScan": 41508,
"sort": 41808
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "21.303µs",
"fetch": "1.313709157s",
"filter": "658.454172ms",
"indexScan": "90.635796ms",
"instantiate": "25.435µs",
"parse": "1.461089ms",
"plan": "786.295µs",
"run": "2.395368892s",
"sort": "320.703604ms"
},
"remoteAddr": "10.132.163.155:48118",
"requestId": "ee140ee7-c476-4124-867f-dbe91115e244",
"requestTime": "2023-01-27T10:06:22.529-06:00",
"resultCount": 100,
"resultSize": 392102,
"scanConsistency": "unbounded",
"serviceTime": "2.39765753s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 100 OFFSET 200",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
},
{
"completed_requests": {
"clientContextID": "292ee379-53ad-4467-bf36-a590e8700ff8",
"elapsedTime": "15.498729752s",
"errorCount": 0,
"node": "prodcouchsm302clsat.usaa.com:8091",
"phaseCounts": {
"fetch": 271590,
"filter": 271590,
"indexScan": 271590,
"sort": 271600
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"sort": 2
},
"phaseTimes": {
"authorize": "21.011µs",
"fetch": "8.894713644s",
"filter": "4.254807304s",
"indexScan": "550.983556ms",
"instantiate": "1.174445ms",
"parse": "1.195797ms",
"plan": "3.539135ms",
"run": "15.492740969s",
"sort": "1.323232062s"
},
"remoteAddr": "10.132.163.254:51024",
"requestId": "e3c8fe02-7675-45ae-8855-c6e2b30e393e",
"requestTime": "2023-01-27T09:48:56.543-06:00",
"resultCount": 10,
"resultSize": 39923,
"scanConsistency": "unbounded",
"serviceTime": "15.498667205s",
"state": "completed",
"statement": "SELECT META(`bkmsgacb`).id AS __id, META(`bkmsgacb`).cas AS __cas, `status`, `createdOn`, `updatedOn`, `requestedBy`, `isSloBreached`, `sloBucket`, `sloBreachedOn`, `archiveId`, `isWorkItemCreated`, `retryCount`, `messageInstanceId`, `errors`, `requestData`, `primaryChannel`, `deliveryOrderContact` FROM `bkmsgacb` WHERE `_class` = \"com.usaa.bank.messaging.correspondence.internal.dtos.couchbase.deliveryOrder.DeliveryOrderDetails\" AND createdOn <= $1 AND createdOn >= $2 ORDER BY createdOn DESC LIMIT 10",
"userAgent": "couchbase-java/3.4.0 (Linux 4.18.0-305.57.1.el8_4.x86_64 amd64; OpenJDK 64-Bit Server VM 11.0.17+8-LTS)",
"users": "bkmsgacbpa"
}
}
];
let phaseTimes = new Map();
//function to travese the JSON file.
const countAndSumPhaseTimes = onePhaseTime=>{
if(onePhaseTime){
//This will loop through every value of onePhaseTime
for (const [key, value] of Object.entries(onePhaseTime)) {
//Convert time into seconds
const time = value.split(/^(\d+\.\d+)(\D+)$/).filter((x)=> x); //Splits time in numeric part and unit
const num = parseFloat(time[0]);
const unit = time[1];
let seconds=0;
//Possible cases in completed request file are ms, µs, s
switch(unit){
case 'ms':
seconds= num / 1000;
break;
case 'µs':
seconds= num / 1000000;
break;
case 's':
seconds= num;
break;
default:
throw new Error(`Unrecognized time unit: ${unit}`);
}
if(!phaseTimes.has(key)){
const countWithTime=[1,seconds]
phaseTimes.set(key,countWithTime)
}
else{
let modifiedCountWithTime = phaseTimes.get(key);
//Increasing count as found one more occurrence
modifiedCountWithTime[0]++;
//Adding time of new request
modifiedCountWithTime[1]+=seconds;
}
}
}
}
const outputAvg= ()=>{
let averagePhaseTime= []
phaseTimes.forEach((value, key) => {
const avgPT= value[1]/value[0];
averagePhaseTime.push ([key, avgPT]);
});
averagePhaseTime =averagePhaseTime.sort(function(a, b) {
if (a[1] == b[1]) {
return a[0] - b[0];
}
return b[1] - a[1];
});
return averagePhaseTime;
}
//Main function
const avgPhaseTimes = requests =>{
requests.forEach(request => {
const requestPhases = request.completed_requests.phaseTimes;
countAndSumPhaseTimes(requestPhases);
});
const avgOfPhaseTimes=outputAvg();
console.log("Average time for every Phase in decreasing order in seconds are:")
console.table(avgOfPhaseTimes);
};
avgPhaseTimes(requests);
INFO