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);