[ { "prepareds": { "avgElapsedTime": "16.136761ms", "avgServiceTime": "15.997561ms", "encoded_plan": "H4sIAAAAAAAA/6RU72/aMBD9V6JbP4BkTQM0dbO0DykJGhItKKGrpgkFy7kGt8HJbKcrq7K/fbJDKKU/1m1fIPY933v37uw7QMmLFNOkzJkECkDgEpmpFA4LaVSRa6DvCAiZ4q1fii+otCgk0AEBydYIFKZREEZJPPfn53GSoRlW2hRrVPpkM2HanFkUgaJExUyhgN7Bm/sFxPi9Qskt5BdfiTxVKIF+ewjyK7MqlPhpUaUSNyLHDLVNNRHaOPicqQwNUEjxklW5ocPzeD49DSMgMFPiBuhxvahbkn9S8SrQ2BoVcyYHsHUNKAzPk4tkHCSB/Zn48byNJSIFCsfYv+Q9/uHjcY9zfN/fRUtVXCE3zvA7W/maqU1yjRugRlVYE7jGjS4ZR0eyK9h2pt3e+gEEdMmkdoLxlnHT5CCgmMzQba9EtgIKRz0ngOfVrtV58aMJ1OQe1n8O1n8AGzwHG0C9qBcEKi1kBhQyLdzBfTtHaPgK/qbOwwwzplieYw7/1fuRyA0qIMALmYqmI9DpdDrLVs7y7XLourzsep+8o17XYzL1DgHBDtDvPo2w49EgBt3uo2rGUhjB8lkzGEBAoa5ykxhU67a3pQUeZLWsLtnT4dE4sqwvIE7HQTAJX4Q0yl8AnPgT/2zokizqRW3v48Pqpip1JutC/bmkneZHaUZC3ltkiQ7isVHI1u4gaJFJ99zZsdhJBApXupBAYMuzvzEO9lfuOu+tG6PanZqAwVv7Ls2icOZHofeK59IbRdNTLw4n4XDuWT7ibWXYj4bAfllq+78V3RxrPfIuPodR6DUz6SbS888CrxlBN4Dbtc3ixq2R5p18bdmg/h0AAP//G1EdDx8GAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.781274496 -0800 PST", "maxElapsedTime": "101.033635ms", "maxServiceTime": "100.97309ms", "minElapsedTime": "1.565295ms", "minServiceTime": "1.488424ms", "name": "ORDER_STATUS_getCustomersByLastName", "node": "172.23.107.87:8091", "statement": "PREPARE ORDER_STATUS_getCustomersByLastName FROM SELECT C_ID, C_FIRST, C_MIDDLE, C_LAST, C_BALANCE FROM CUSTOMER WHERE C_W_ID = $1 AND C_D_ID = $2 AND C_LAST = $3 ORDER BY C_FIRST", "uses": 2198 } }, { "prepareds": { "avgElapsedTime": "5.817153ms", "avgServiceTime": "5.685011ms", "encoded_plan": "H4sIAAAAAAAA/6RTYW/aMBT8K9atUkGy0Fq6abK0DwhSaWIFloRNiKJgJa9g1TiZ46B2Lfvtk7MySqHStH17eb7cO987P4BMmmeUJYWWBgLguCHpKkvd3Dib6xLiLYcyGd11CvWVbKlyA9HmMHJFEBgE35Jh2AvCpCoy6ShyeXoLjrwgK11uIR7wZveBiL5XZFICx890qXRmyUBM90Gdyi1zq354VGHVWmlaUOmpPqvS1fBY2gU5CGR0IyvtRBQPu31wjKxaQ3zYzDbbCf8koU/3USoNOG7pvoTAtNFweVI6q8yicfK+yR4f2TVa16irZ0fvms0ZNnyfbiSt1Jo0/kvUJbl0+SSpkKn3f3ttv45t78mSAxFdnRs66EbkwFGSSxzZVVkPLaRbQqAxr+nnrXmUfBl3BvGneDJvgmMtdeUnnZzVdEfgk7i3jzx/Dfk7Pd1BvI9vv4YPg6thHBz+cAG/85d3M9m4ziU4pFayfGbZ37o427yk7akylTY7dhQ5S3JVS0GpFqZ+TBCm0prD0Z2P7CgMRp0wYEffDrsMh1dsPOp14oDVutg4Clg/mERsepDA09bpQfxmLApittsY+8hOzjird+Lrc1//cd132r6z89W3LrD5FQAA///WZbVHHgQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.316081033 -0800 PST", "maxElapsedTime": "99.619212ms", "maxServiceTime": "99.532029ms", "minElapsedTime": "729.16µs", "minServiceTime": "678.117µs", "name": "NEW_ORDER_updateStock", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_updateStock FROM UPDATE STOCK USE KEYS [to_string($6) || '.' || to_string($5)] SET S_QUANTITY = $1, S_YTD = $2, S_ORDER_CNT = $3, S_REMOTE_CNT = $4", "uses": 413607 } }, { "prepareds": { "avgElapsedTime": "9.315923ms", "avgServiceTime": "9.194729ms", "encoded_plan": "H4sIAAAAAAAA/6RTXWvbMBT9K+KsDw2IsaSUroI9hMRlZlkTYtMORnCEfeOoVWRPkrt2xfvtw3bdZil72AZ+0dXR8fngPoJMWmSUJaWWBgLg2JD0laVJYbwttIN4x6FMRvfjUl2RdaowECccRu4IAlE8n3xKZsFVMEty8vMwA0dRkpW+sBCPePNyQETfKjIpgeNnulU6s2Qgvv4OGld+W1j1o0GVVt0pTTm5hmqmnG/hsbQ5eQhktJGV9mIaRvEynMTgWFh1B3FWr+r+J/+kImwsR6k0J3jyD4FpmITT5DoJp/0wURkEzs/k6en70eZkeL7JTrPh821pixtKfZvZY+NmJ+1DcksPEN5WVHPc0oMrZUot+7OJJtx+/OQRHK6UxrVK6V6mvuPgsNLk1I63Kt9C4GjUCkh19dyWLr53FzV/gQ3/BBuiXtUrjsopk0Mgd6p9uB/QBfl0i78xcMiwkFZqTRr/VdSF0p4sONLCZKqLGsfHx+tezfrtuutsPWAf2NFwwKTJ2CGgvx4NBq+EhkZ5JfWiKxMcllylfeLJ7vo+ygZ4wHkZfImTeUvdBHoYoDIvnPWqbr4DSOQtyV37Fk7lpt3MJqU9bgjcuMKg5vB03yzFYhksxsuAvV5NdrGcf2ZRMAsmMdvj6Oa9dnb9MVgGrAutjYyNL6ds+nQaof4VAAD//7OcZDM4BAAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.841003454 -0800 PST", "maxElapsedTime": "68.12498ms", "maxServiceTime": "68.05042ms", "minElapsedTime": "1.14614ms", "minServiceTime": "1.096645ms", "name": "STOCK_LEVEL_getOId", "node": "172.23.107.87:8091", "statement": "PREPARE STOCK_LEVEL_getOId FROM SELECT D_NEXT_O_ID FROM DISTRICT WHERE D_W_ID = $1 AND D_ID = $2", "uses": 3692 } }, { "prepareds": { "avgElapsedTime": "6.023914ms", "avgServiceTime": "5.885152ms", "encoded_plan": "H4sIAAAAAAAA/6RTXWvbMBT9K+IuUBtEWJutDMEePMfdQ5vWxM4gpMER9m0ipsieJId2bfbbh0y8xUkz2PaU+H6dwzlHz4AqLwssskpyBQyAwgNyW2sMS2V1KQ2wtxSEKvAxqMQX1EaUCtiAguJrBAZxMB1Ft2lWVwW3+DkMa2PLNWqgUFaouS01sGd48/sDEvxWo8oRKPzIV0IWGhWwWXcoqO2q1OK7m6q02AiJSzTu1I0wthlPuV6iBQYFPvBaWhZOkvRuFI2BQqzFBtiH7XzbgvwTi2t8SnKugMJXfDLAYOZ5nmfLzFgt1NLrvfPJywu5h/49NP/2Wu/9071L35/DlnbBYq65lCjhvyhfoc1XO8IVz51He7o419ryTrYjHqEsFR5VE7RAwaDNLOq1aXArblfAwFu0CIv+Isw+BTfBbRgtfKCw4bJ2WL3z5uDrC9N0mO1y1F26+MNSG7zwcGkAzvVD8qqYNAkFClwKbrqy/IVY8+3h8aEwOdfFa63EauTrhhAYsVTN0wKmaikpWHx06Y3HURyMI3LqJZGr8d2ITOJhkEakZUcmSUSuo2lCZsdxPOufuZ9uGE80Ln2fzEkSpeSXceQj6Z1T0vHF1S5cbU92VxvA9mcAAAD//7udfthFBAAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.963490371 -0800 PST", "maxElapsedTime": "92.188906ms", "maxServiceTime": "92.108031ms", "minElapsedTime": "901.009µs", "minServiceTime": "843.932µs", "name": "PAYMENT_updateGCCustomer", "node": "172.23.107.87:8091", "statement": "PREPARE PAYMENT_updateGCCustomer FROM UPDATE CUSTOMER USE KEYS [(to_string($4) || '.' || to_string($5) || '.' || to_string($6)) ] SET C_BALANCE = $1, C_YTD_PAYMENT = $2, C_PAYMENT_CNT = $3", "uses": 36051 } }, { "prepareds": { "avgElapsedTime": "3.305026ms", "avgServiceTime": "3.169568ms", "encoded_plan": "H4sIAAAAAAAA/6SSYYvaQBCG/8ryVrgElqPqp+43qWmRXhNJrEdRCUsy5y1dN3Z3Y201/e0lVu9y196XFgLZeWZIXvaZA8gUVUllvtXSQAAcdyR9beltZbyttIN4zaFMSfvRVs3JOlUZiCGHkRuCQBzd5kk6jtK8sCQ9xfQtsSVZcFRbstJXFuKAV48FMvpakykIHD+Le6VLSwZi8XRoVPv7yqof7dTWqp3StCbXfupGOX8an0m7Jg+Bku5krb14yAKOqVU7iDfNqrn85Z9izKWuKSukAceuPTsILBZBEAS+yp23yqyD3iBkxyNb4nqJ06nTGoYv9/phyNlhiTjJx/lkvIRgvQFnJ5BcQP8Mbi9g2KxWaPjTnFNppdakwbGR+0ul3Aai/18XkJEpJ8aR9eCQWknXlQ6OL/TdbWVBz3C7Hhd+9vNH6LFyhbQlmlXTPs+6mbckNzgZdGptTmsJYWqtOTztW/PTNJqO0oi9tIXsXZp8ZJM4i9IZm8Sz5HEy+BB95mw+uvkUhb9fWTBL8myWTuL3rdLjkV1dX7XKOnj4d9x/EHn21uvzrtfegHcl9oZNiOZXAAAA//83D1BEfgMAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.062867483 -0800 PST", "maxElapsedTime": "72.257704ms", "maxServiceTime": "72.205437ms", "minElapsedTime": "396.463µs", "minServiceTime": "346.391µs", "name": "NEW_ORDER_createNewOrder", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_createNewOrder FROM INSERT INTO NEW_ORDER(KEY, VALUE) VALUES(TO_STRING($2)|| '.' || TO_STRING($3)|| '.' || TO_STRING($1), {\"NO_O_ID\":$1,\"NO_D_ID\":$2,\"NO_W_ID\":$3})", "uses": 41252 } }, { "prepareds": { "avgElapsedTime": "3.379756ms", "avgServiceTime": "3.247752ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkVWV7mOS3iKQTogUWu5sQRcEKF3Ab7MwxFV3Jfvvk8JF0HXvYpEiOr4/vPefo+AVQp2aO8yTPpAYGQGGB0m0sdo121mQFsCsKSs9xG+TqK9pCGQ3sIwUt1wgMBtG3ZBiHUZx0kiU67kz62NMLAxRMjlY6Y4G9wLt6Axy/b1CnCBR+piuVzS1qYJPXoGDjVsaqHx6VW/WkMlxi4VvdqMJVcCHtEh0wmONCbjLHuBh2+0BhZNUTsE/ltDxO+CcKfXzmqdRA4RGfC2AwabWcSQpnlV623n9ok92O3MPlPVR/jaNOuz2Fkr5ud40uXR2a5TL15h0Jey+PtYOYN9dH0soswwz+S1NPK6dkNrLmAVMHFCwWm8wlDu26qNC4zT2wNavIzS5nPPlyFwxET4xn7YrVHxBhIILzp2MRnj/ch6c7EOchcXQ7FNHfMWGPi+Sq4wHTN84rXUsup6X/foNwZ1Guq7tQqKWu3oB3eK8NGDwUxkfhNKlZOmloFo+uNWu1kmZ1LMLjtqTgcOtDPYqjURBH5NwDI9fx8Jbw6CbqClJPo2TP2K9jEfrlxM5vagYVcq/l0MubSe54RPrRmJOJGCZcxL3BZ5/13Y5cXF74nDfKHR/zXwEAAP//i/Iq7kUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.798973265 -0800 PST", "maxElapsedTime": "64.392181ms", "maxServiceTime": "64.324656ms", "minElapsedTime": "532.447µs", "minServiceTime": "479.35µs", "name": "NEW_ORDER_1_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_1_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_01 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 40568 } }, { "prepareds": { "avgElapsedTime": "3.418009ms", "avgServiceTime": "3.271203ms", "encoded_plan": "H4sIAAAAAAAA/6SSb2vbPBTFv4q4T6A2iPKk2Z9O70ziDTPPDrbXUpJghH2biilyJsshW+p99mE7apNtfbOBQTrnXqzLPb8DoCqqEst8K7kCBkDhHrlpNE4rZXQla2D/UxCqxL23FTeoa1EpYBMKim8QGET+bR4nMz/JC43cYKxL1ECh2qLmptLADvDfs4AUvzaoCgQKP4oHIUuNCtjivMlrzEOlxfeua6vFTkhcY939KhS16dszrtdogEGJ97yRhvVDpEBhrsUO2Lt21don/mqGGy4bTAuugMKuu9fAYLFwHMcxVV4bLdTaGU1c8vhIlnC5hP52UrpyX66NXZeSwxLi3AvDPIynXrgERkbXlHTm1EuSwE/yYNa7b46u1a8GPbP6atB+lCV3+WC9Hqxjw3hQcZhPo6x33g7Ore2YtKsVtPR8BXOuuZQogcKG760S9QbY+J92m6IqA1WjNkCBS8G73T4F+AW/1Vte4KnX0WbNY+K/jTsTdcF1Ce2q7b5fqqnRyDfQY1GLteopB6YaKSkY3HcszRN/7iU++SPU5H0SfyJBlPpJRoIoi8kwHXE++neU3HjhZ98djpQ4WZynWRJEHywjF5cX3UFOClcvFcaWjj4dG98xbxv3MbvR5IwOC8czDJaFM6gsU09IWCJOeRxdty60PwMAAP//cl6W3SUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.05860233 -0800 PST", "maxElapsedTime": "69.215945ms", "maxServiceTime": "69.136386ms", "minElapsedTime": "502.128µs", "minServiceTime": "442.882µs", "name": "NEW_ORDER_createOrder", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_createOrder FROM INSERT INTO ORDERS (KEY, VALUE) VALUES (TO_STRING($3) || '.' || TO_STRING($2) || '.' || TO_STRING($1), {\"O_ID\":$1, \"O_D_ID\":$2, \"O_W_ID\":$3, \"O_C_ID\":$4, \"O_ENTRY_D\":$5, \"O_CARRIER_ID\":$6, \"O_OL_CNT\":$7, \"O_ALL_LOCAL\":$8})", "uses": 41252 } }, { "prepareds": { "avgElapsedTime": "3.261159ms", "avgServiceTime": "3.134865ms", "encoded_plan": "H4sIAAAAAAAA/6SSUWvbMBDHv4r5bw8tiLGxh4HeTKqCadMaO9sYJTjCuSTqFMmTziVd8T77kJPQddleNjAY6X53+ul0TyDX+iUtm85qBwkIrEhzH2jiHQdvI+RbAeOWtMs784lCNN5BvhdwekuQuFGfm9vqQlXNmrhg2hZu5SHgOwqafYB8wqvnBWr61pNrCQI/2o2xy0AO8u4llPe88cF8T1QXzIOxtKaYSl2byCM+02FNDIklrXRvWRYzNYVAGcwD5IdhPhwP+CeDK3qsW+0g8JUeIyTu2DeRg3Hrs9fvzucYxMuES+J2c8A73abWHIxSo45bB9mT7FIHbS1Z/Jd04Qwbbcvg76llCASKveWGKWzjSNOuS+DZIrkt3iyKpqyKiVqcj0an0Zt8+vfgRT7LU3B+0gvjni2G+ZC+35CaA+ntmIto1m6cuXTpfVlI3Eef2r93+HU9Gh83BgGmXZqDslJlXqnsjwOZXVa306xW12oyyw4lRLavnf7pzD2Tbpd9rFV2pb7U2cmr/wwAAP//XZmkYjIDAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.018528657 -0800 PST", "maxElapsedTime": "99.563167ms", "maxServiceTime": "99.489866ms", "minElapsedTime": "466.864µs", "minServiceTime": "422.258µs", "name": "NEW_ORDER_getItemInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_getItemInfo FROM SELECT I_PRICE, I_NAME, I_DATA FROM ITEM USE KEYS [to_string($1)]", "uses": 413607 } }, { "prepareds": { "avgElapsedTime": "14.567755ms", "avgServiceTime": "14.439391ms", "encoded_plan": "H4sIAAAAAAAA/6STb0sbTRTFv8pwHl8YnqGkWv8w4IvUrCjUGpLYICVsLrPXzdTJ7HZm1mpl+9nLbjStiRRsXy0793LuOb/LfQA7XWScpaUlBwVIXDPFyvNx4aIvbIDqShiX8V2vNJ/YB1M4qF0JRwuGwqB3dZ58HKdVmVHkCXmeF1Xg92TJaYZEUbKnWHioB/z36wcj/lrxsuWHnhubeXZQn5839ao4L7z53nSV3twayzmHRuqDCbFtH5PPOUIh42uqbFST3jA5vbgcJZAYeHMLdVhP66cpf2XjrMk/0uR28QgDCpPT9Kz/9J+aDAoHu929w+6ePmD9rruf7a+qpS++sI4tu4cmyYL8fXrD91DRV1xL3PB9KEk3SH8P0FB+en8MCIlQkgutS74jHZciEp5czu3z3ORzKGzttA60rVZrs8W3ZaGe1lOJKhiXQyEPBrV8nnpAnqxli39id8JRz/GqgOtGToyN7CGhC5eZJUVsb89WOrM3s0l61p91xJHY2ulsCBzbwvHG64hblhzTyH6x5FlSbMCta1+N+7MOJG7JVvzS8LZB/C+23nYashuTXHbZHggkyBoKaxReA2dar8v3TdDks5dKo+iZFq0lBJO79rahXGWtROS75nAGw2TQGybiz6csToYX5+Jy0O+NE7EyKUbJWLTxxdHjt4EgJqfJMBHNUtqVoP4ZAAD//yyTi2VrBAAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.927987029 -0800 PST", "maxElapsedTime": "99.847739ms", "maxServiceTime": "99.787552ms", "minElapsedTime": "1.440249ms", "minServiceTime": "1.38511ms", "name": "PAYMENT_updateWarehouseBalance", "node": "172.23.107.87:8091", "statement": "PREPARE PAYMENT_updateWarehouseBalance FROM UPDATE WAREHOUSE SET W_YTD = W_YTD + $1 WHERE W_ID = $2", "uses": 39561 } }, { "prepareds": { "avgElapsedTime": "6.17968ms", "avgServiceTime": "6.047041ms", "encoded_plan": "H4sIAAAAAAAA/6RTXWvbMBT9K+KsUJuJsq17GII9eI4Lo+ka4qRQ0pAI+zYRUyRPkkO71vvtw6bZ8rE8bHuT7z3cc+65x08gU9iSylmlpYEAOO5JhtpRak1wVnuINxzKlPSQVOqGnFfWQJxzGLkiCPSy/uebbHg7q6tSBkprH+yKHDhsRU4G6yCe8Or3B3L6VpMpCBw/iqXSpSMDMdkFJXVYWqe+t6jKqbXStCDfjuorHzr4SLoFBQiUdC9rHUQ6zkfXV9kQHAOn1hAfmmmzIfknFZf0mBfSgOMrPXoITKIoioKd+eCUWUQn72P2/MzucHaH7rXVOo+P997F8RQN3yUbSCe1Jo3/knxBoVi+CK5k0Z5oy5f2aJvyi20HOlJtDR1Ucwrg8BRmgdzKd7yVDEsIRPMNw/xsns4+Jf3kS5rNY3Cspa5brugYhr1mJ29jtIfa5zPluIsUOKRW0u9u8hf7TZv94T3lC+nKP7Xy4EiuOkHwamG6nwHC1FpzBHpoAzcYZoNkmLEj2WcXw+srNh70klHGNuLYOM/YZXabs8lhgE7PTg/Ss1Xfjw7LsxH7ZSL7uPVu7UTzMwAA///7tGMH2AMAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.812264653 -0800 PST", "maxElapsedTime": "79.081995ms", "maxServiceTime": "79.031883ms", "minElapsedTime": "874.061µs", "minServiceTime": "812.208µs", "name": "DELIVERY_updateCustomer", "node": "172.23.107.87:8091", "statement": "PREPARE DELIVERY_updateCustomer FROM UPDATE CUSTOMER USE KEYS [(to_string($4) || '.' || to_string($3) || '.' || to_string($2))] SET C_BALANCE = C_BALANCE + $1", "uses": 36723 } }, { "prepareds": { "avgElapsedTime": "43.474242ms", "avgServiceTime": "43.332877ms", "encoded_plan": "H4sIAAAAAAAA/6SU3WvbPBTG/xXxvL1IQLw0H+/HBLsItcsCWROctmGM4AjrxNGqyJ4sd+2K97cPO19L21x0uwnknMdHz3l+SE8gm2SKVJwbaSEAjiVJXzq6yKx3mSkgzjm0VfQwyPUtuUJnFqLHYeWaIBCEo+FtGH2Ky1xJT2OnyI20JXBkOTnpMwfxhL8OfzClryXZpJb8SFbaKEcW4vOxaFD6Veb091qVO32vDaVU1KNGuvCN/Fq6lDwEFC1labwYR0EYxaPhVQiOidP3EP9X82p3zG/5GNarTxNpe9jmAIHxKB7HwyAO6p9ZPAx2vVgrCHRU53zZXZ7/86/6r999J/fd3GVfKPFNhE/1WmvpHuM7eoTwrqSK444ei1wmdbJH29Rp7xrbdcFR5NIWjWV6kInfTOFw0qbUlFc6XUHgrNtYSEy5x2eyb5tGxQ+y3ilZ70jWPyXro5pXc46y0DaFQFro5sNfA51IJ40hgz/Cckk+WeFteT13cqmNJweOJLNKb6ig1Wq1FodRi78XW9iLNnvPzrptJq1ir2iCvabXPima7UX9dvuFoQuTWXpRnVKDmnzsya03uHPpaxKvuNhdx2DRBse9NGUdwVmnJvNisFU3za0FhzRaFs9TfFO68+r5AYEuEunUa62pdyTXjSkUOrXNmwNhS2M4PD3U13oShZNBFLJTTwy7jMYf2c0kGFyH7OCPTcNrdhRFnXeHzT6EUci2NBuWbHAVsC26BtyuMNsW+qh+BgAA//+kGWT7IwUAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.789806686 -0800 PST", "maxElapsedTime": "163.056127ms", "maxServiceTime": "162.970687ms", "minElapsedTime": "6.347063ms", "minServiceTime": "6.276348ms", "name": "DELIVERY_updateOrderLine", "node": "172.23.107.87:8091", "statement": "PREPARE DELIVERY_updateOrderLine FROM UPDATE ORDER_LINE SET OL_DELIVERY_D = $1 WHERE OL_O_ID = $2 AND OL_D_ID = $3 AND OL_W_ID = $4", "uses": 36723 } }, { "prepareds": { "avgElapsedTime": "1.631948927s", "avgServiceTime": "1.631769984s", "encoded_plan": "H4sIAAAAAAAA/7RWbY+bRhD+K6upP9gSOtnmemmQ7oNlk5bUBdeQRFVq4S2M8fbwLt1d0rue6G+vFvAZv6RpcukXS5555u2ZZ4BHQJ6IFNO4yCkHB8CCDVJdSpwKrqXIFThDCxhP8X5SsLcoFRMcHNsCTncIDoRRMP0xnrtv3XlMuWIZ6lCL5G4qSq7BAlGgpFpIcB7hm8MfCPGPEnmCYMHfyZblqUQOzvtj0KTUWyHZXwZVSPaB5ZihMqnmTOkaHlGZoQYHUtzQMtdOsJy5y3ju+S5YsJDsAzgvKusCsO68g1lV+1a+qFfPcBQmlNtgAVXggICWOXAgmMdB7M3imfl5F3uzvS9mKTgwSkfDzXgz/PYmfXE9fkmfvIUUv2Oia9IfDQc7Kh/iO3wAR8sSKwvu8EEVNDG7OBrd7GfvaEcGC1RBuap7x3ua6CaLBZLyDGvzlmVbcKBn1y0kedksfGRBLv40jmswbO5h42OY/QQbH8FGH4ONoFpVKwtKxXgGDmSK1YFdZl+hTrZdUj9n5NNkCyppnmMOz1q2j0pjOheieC0YN73lrG5PGcnzOMlpqUwb/X5/LdZX62Beb309ILekv1brq3XYGgaE8pQcYN4prDEMBs/r+FyeqiPPMKq7qWuNjqVpj2z8bpwmN+OXiZ3Ymy+T5v7YLquS13TGuRDFXpH/Vagn9H5EZ6eojjZPiP9Ughb1mapV8Bw2qlV1lp3lGiVYkAiesmYJRmyX9NYbnWps9uQan+kvaHy/lsOhnZCevQf0rlubUeYR9pCiEezPbyZ+5EW/dLLcDAZnBHmcaUbz76UoC8NTlknMqDbP9/eQmNdHP2VKM55ockL/AFYWZCbQ6M0ErC5w5HGNcocpoxq/VpWzNfCvN8H/8qRqWV40xwoWSFRlrmNDTXNftUCnfhS3zYEFeF+Y2E+NUF3mY1/LrOR8K6GWSHd1LCiW8fprw4zWbcEBXu5+QwmVBRrvzWt7sXQXk6VL/vWDg7xaBj8RErpzdxqRafDGj/ozL4w8fxr1xVWbfjAgk5B06rVhh5cJEcTzfXdJXgee35QkigQ+aZKY0yK3t0RdNU9xMvFn5Cm98dSuuhZ594O7dEknjvRGh4BZaxofTOaqDvd3yY63pHddO0yZ/b0drg2qfwIAAP//hxBPl9oJAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:16.532485139 -0800 PST", "maxElapsedTime": "2.369427215s", "maxServiceTime": "2.369323303s", "minElapsedTime": "217.090099ms", "minServiceTime": "216.993773ms", "name": "STOCK_LEVEL_ansigetStockCount", "node": "172.23.107.87:8091", "statement": "PREPARE STOCK_LEVEL_ansigetStockCount FROM SELECT COUNT(DISTINCT(o.OL_I_ID)) AS CNT_OL_I_ID FROM ORDER_LINE o INNER JOIN STOCK s ON (o.OL_W_ID == s.S_W_ID AND o.OL_I_ID == s.S_I_ID) WHERE o.OL_W_ID = $1 AND o.OL_D_ID = $2 AND o.OL_O_ID < $3 AND o.OL_O_ID >= $4 AND s.S_QUANTITY < $6", "uses": 3692 } }, { "prepareds": { "avgElapsedTime": "8.866439ms", "avgServiceTime": "8.731307ms", "encoded_plan": "H4sIAAAAAAAA/6ST0WvbOhTG/xXx3T40IC63KaW3gj2E2mWGrg1OWAojOMI+cdQqsifJXbvi/e3Dcp12WfewDfxinU+fzvc7nCeQyauCiqzW0kAAHGuSvrF0XhlvK+0g/uNQpqCHSa0+knWqMhDHHEZuCQJX8SK7TqM4zUrykXLeqtyDo6rJSl9ZiCf88/KDGX1uyOQEjm/5RunCkoH49KNo0vhNZdXXTlVbda80leQ6q0vlfJDPpS3JQ6CgtWy0F1Eym6fJ+RwcU6vuIU7bZTs88kddJF3qWS7NMZ4RQCBKsiTKFlkSDYeZKiBwdipPTv4fr4+PztbFSXG0q9a2uqXcB2xPXZqttI/ZHT1CeNtQy3FHj66WOQX3XYiO73D8nBEcrpbGhU7pQea+9+Cw0pQUjjeq3EDgoG8g181uYLr60hda/iIb/0o2RrtslxyNU6aEQOlUuPga0AX5fIPfCbDvMJVWak0afzWoC6U9WXDklSlUjxqHh4eroZvVv6soS6LViL1jB0cjJk3B9suLnWA8Gv3UaGKUV1JP+2GCw5JrtM882e0wj7oT7rnOJzer3u3t+lV8M8+uw9Md8H3Ayry82S7b7tuTzLwluQ134VRpwvJ2FF95Q+DWVQYcoaHht+Xw9NDt0DSNp5M0Zm8uM7tIrz+wWXwZn89ZMODslXlfHkKxxfs4jVlHO7Bmk6uI9XADWrTfAwAA//87tdGfdAQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.036189805 -0800 PST", "maxElapsedTime": "86.625579ms", "maxServiceTime": "86.52568ms", "minElapsedTime": "1.097857ms", "minServiceTime": "1.044582ms", "name": "NEW_ORDER_getDistrict", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_getDistrict FROM SELECT D_TAX, D_NEXT_O_ID FROM DISTRICT WHERE D_ID = $1 AND D_W_ID = $2", "uses": 41252 } }, { "prepareds": { "avgElapsedTime": "3.361198ms", "avgServiceTime": "3.237073ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkoXY8TPJbRNIJ0QKL3U2IomCFC7gNduaYiq5kv31y+ErXsYdViuT4+vjec46OXwB1amY4S/JMamAAFOYo3dpix2hnTVYAu6Sg9Aw3Qa6+oS2U0cDaFLRcITDoR9+TQRxGcdJOFui4M+ljV88NUDA5WumMBfYCH04b4PhjjTpFoPArXapsZlEDG78GBWu3NFb99KjcqieV4QIL3+pGFa6CC2kX6IDBDOdynTnGxaDTAwpDq56AfS4n5WHCf1Ho4TNPpQYKj/hcAINxo+FMUjir9KLx8VOTbLfkHlr3UP3Vjq6azQmU9HW7a3Tpct8sl6k370DYe3mo7cW8uT6UVmYZZvAuTV2tnJLZ0JoHTB1QsFisM5c4tKuiQuMm98DGtCI3bU158vUu6IuuGE2bFau/IMJABOdPRyI8f7gLT6cvzkPi6HYgon9jwi4XyWXbAyZvnFf6JLmclP77A8KdRbmq7kKhFrp6A97hnTZg8FAYH4XjpHrpqKFePLhWr52U1KsjER62JQWHGx/qYRwNgzgi5x4YuY4Ht4RHN1FHkNM0SnaM/ToSoV+O7PzmxKBC7rTse3kzyR2PSC8acTIWg4SLuNv/4rO+3ZKL1oXPea185WP+OwAA//8VUTQlRQQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.309242347 -0800 PST", "maxElapsedTime": "63.898421ms", "maxServiceTime": "63.820959ms", "minElapsedTime": "527.868µs", "minServiceTime": "478.048µs", "name": "NEW_ORDER_3_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_3_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_03 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 41115 } }, { "prepareds": { "avgElapsedTime": "3.366956ms", "avgServiceTime": "3.226525ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBD9KuI2aAKitFthoP9M7I6QNsksdSOkwRHOJVHrSJ6slHSN99mHnB9212V/bGCQdXq6e+/x9AKoUzPDWZJnUgMDoDBH6dYWO0Y7a7IC2AUFpWe4CXL1FW2hjAb2kYKWKwQG/ehbMojDKE6ukgU67kz62NVzAxRMjlY6Y4G9wLt6Axy/r1GnCBR+pkuVzSxqYOPXoGDtlsaqHx6VW/WkMlxg4VvdqMJVcCHtAh0wmOFcrjPHuBh0ekBhaNUTsE/lpDxM+CcKPXzmqdRA4RGfC2AwbrWcSQpnlV603n9ok+2W3MP5PVR/jaPLdnsCJX3d7hpdutw3y2XqzTsQ9l4eansxb64PpZVZhhn8l6auVk7JbGjNA6YOKFgs1plLHNpVUaFxk3tga1qRm55PefLlLuiLrhhN2xWrPyDCQASnT0ciPH24C0+nL05D4uh2IKK/Y8IuF8nFlQdM3jivdC25nJT++w3CnUW5qu5CoRa6egPe4Z02YPBQGB+F46Rm6aihWTy41qzVSprVkQgP25KCw40P9TCOhkEckVMPjFzHg1vCo5uoI0g9jZIdY7+OROiXIzu/qRlUyJ2WfS9vJrnjEelFI07GYpBwEXf7n33Wt1tydn7mc94oX/qY/woAAP//OeLpxkUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.259963795 -0800 PST", "maxElapsedTime": "54.492301ms", "maxServiceTime": "54.409862ms", "minElapsedTime": "517.503µs", "minServiceTime": "470.18µs", "name": "NEW_ORDER_4_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_4_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_04 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 42546 } }, { "prepareds": { "avgElapsedTime": "17.348794ms", "avgServiceTime": "17.216124ms", "encoded_plan": "H4sIAAAAAAAA/6RV32+jRhD+V9D0HmIJVbWtKi1SHwhgHZJ/ICA9JZVFVjCx9w4v7u5yTRrRv72axdg4yZG092LvfPvt7Mw3s8MToMirAotsXzIBDoAN98h0LdGrhJZVqcD5yQYuCnxw9/x3lIpXApypDYLtEByI3JtFsEyzDWqvVrraoVRXj3Om9JIINlR7lExXEpwn+OFkQIJ/1ihyovyTb3lZSBTg/HFOcmu9rST/m1h7yb/yEjeoyNWcK23oKZMb1OBAgfesLrXjXSfpahHEYEMk+VdwLpt1013yv6J4FykkjZKciSkcBAMHvOvsUxb6mU8/czdJu72MF+DAJU7u83H+y6+X4zzHnyfH3b2sPmOujdZPlPmOycfsCz6Co2WNjQ1f8FHtWY7mkmPCVJQOPugBNqg9E8oEjA8s160PGyQTGzTwlm+24MCHsQkgL+tjlcvqr3ajsU+0ybdokzPa9Fu0KTTrZm1DrbjYgAMbxc3Bvpwz1PkW/kuezz1ETLKyxBK+q/YzXmqUYENeiYK3FYGLi4uLuy6cux/vPFPlu5H1m/VhPLKYKKznBP9ImIxeZ1B7tIzpaPQim1BwzVkZtY0BNkhUdakzjXLX1XZPxGde6Vbj7PXtWRjTrQOMRej782CQ0kY+QEjSOAjSbPwe0mSQ5IXpzRte3HQ42tswGtyPPq6Wwx6ScOkNM7w48MNhTVpKNg8XgzQ/TLzV9XLY15U7d98K6Sb1s8OwHk7/MNC9N3i+m7pEWDfrhgbsebuuZGFejark2z16bMIXbmZcnHqeLnq2n2iJbGcOguIbYT5d9M6PmoADn1UlwIa2ec5sU4KXCBWlj1KqZ/ahJn3M5NAHQr9vmdnfs9tX1Ud6up/B1I19wDTfGUAdfw60r+0VbNLHeh3Rh2/DqDMbGzQ+0Mc1ioPIjQNr+HNvzeLVwkqCeeClFklgWwdlaNHmTCtSg/67SHvrCa2pUC3mpubAbRjRnxHDbJAIhmkKdlpR6cjqSkTrQyfQspey8XfS3BxyU7dNoWtP69PHIA6sdr6b6W65S99qx7kZ5gebMjKj21rFfhBbVzdd5tD8GwAA///HfI3pZgkAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.853929969 -0800 PST", "maxElapsedTime": "152.045568ms", "maxServiceTime": "151.967354ms", "minElapsedTime": "1.584327ms", "minServiceTime": "1.531549ms", "name": "PAYMENT_getCustomersByLastName", "node": "172.23.107.87:8091", "statement": "PREPARE PAYMENT_getCustomersByLastName FROM SELECT C_ID, C_FIRST, C_MIDDLE, C_LAST, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_SINCE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_YTD_PAYMENT, C_PAYMENT_CNT, C_DATA FROM CUSTOMER WHERE C_W_ID = $1 AND C_D_ID = $2 AND C_LAST = $3 ORDER BY C_FIRST", "uses": 23821 } }, { "prepareds": { "avgElapsedTime": "3.385436ms", "avgServiceTime": "3.250381ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBD9KuI2aAKitBtloP9M7I6QNsksdSOkwRHOJVHrSJ6slHSN99mHnB9212V/bGCQdXq6e+/x9AKoUzPDWZJnUgMDoDBH6dYWO0Y7a7IC2AUFpWe4CXL1FW2hjAb2kYKWKwQG/ehbMojDKE6ukgU67kz62NVzAxRMjlY6Y4G9wLt6Axy/r1GnCBR+pkuVzSxqYOPXoGDtlsaqHx6VW/WkMlxg4VvdqMJVcCHtAh0wmOFcrjPHuBh0ekBhaNUTsE/lpDxM+CcKPXzmqdRA4RGfC2AwbrWcSQpnlV603n9ok+2W3MP5PVR/jaPLdnsCJX3d7hpdutw3y2XqzTsQ9l4eansxb64PpZVZhhn8l6auVk7JbGjNA6YOKFgs1plLHNpVUaFxk3tga1qRm55PefLlLuiLrhhN2xWrPyDCQASnT0ciPH24C0+nL05D4uh2IKK/Y8IuF8nFlQdM3jivdC25nJT++w3CnUW5qu5CoRa6egPe4Z02YPBQGB+F46Rm6aihWTy41qzVSprVkQgP25KCw40P9TCOhkEckVMPjFzHg1vCo5uoI0g9jZIdY7+OROiXIzu/qRlUyJ2WfS9vJrnjEelFI07GYpBwEXf7n33Wt1tydn7mc94oX/qY/woAAP//9rNmo0UEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.251866421 -0800 PST", "maxElapsedTime": "67.288299ms", "maxServiceTime": "67.222092ms", "minElapsedTime": "519.496µs", "minServiceTime": "469.421µs", "name": "NEW_ORDER_5_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_5_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_05 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 41096 } }, { "prepareds": { "avgElapsedTime": "3.38362ms", "avgServiceTime": "3.249475ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkIdgeJvktIumEaIHF7iZEUbDCBdwGO3NMRVey3z45fKXr2MMmRXJ8fXzvOUfHL4A6NXOcJ3kmNTAACguUbmOxa7SzJiuAtSkoPcdtkKuvaAtlNLCPFLRcIzAYRN+SYRxGcdJpJ0t03Jn0sacXBiiYHK10xgJ7gXfnDXD8vkGdIlD4ma5UNreogU1eg4KNWxmrfnhUbtWTynCJhW91owpXwYW0S3TAYI4Luckc42LY7QOFkVVPwD6V0/I44Z8o9PGZp1IDhUd8LoDBpNFwJimcVXrZeP+hSXY7cg+te6j+akedZnMKJX3d7hpdujo0y2Xq3TsS9mYeawcxb66PpJVZhhn8l6aeVk7JbGTNA6YOKFgsNplLHNp1UaFxm3tgY1aRm7VmPPlyFwxET4xnzYrVHxBhIILLp2MRXj7cp6c7EJchcXQ7FNHfMWGPi6TT9oDpG+eVPksup6X/foNwZ1Guq7tQqKWuHoF3eK8NGDwUxkfhNKleOmmoF4+u1WtnJfXqWITHbUnB4daHehRHoyCOyMUXRq7j4S3h0U3UFeQ8jpI9Zb+OReiXEz2/OVOokHsxh17eTXLHI9KPxpxMxDDhIu4NPvuw73bkqnXlg14rd3zOfwUAAP//mNv6pUcEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.184675718 -0800 PST", "maxElapsedTime": "74.207298ms", "maxServiceTime": "74.105136ms", "minElapsedTime": "514.605µs", "minServiceTime": "461.592µs", "name": "NEW_ORDER_10_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_10_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_10 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 40659 } }, { "prepareds": { "avgElapsedTime": "10.58327ms", "avgServiceTime": "10.460685ms", "encoded_plan": "H4sIAAAAAAAA/6RUbU/bPBT9K9F5+ACS9ajAgMnSPkQQRCReojZbBVOVWsklNbhOZjsMhrLfPjmhpbxs7EXqB9/j0+Nzz7VzD9J5VVCR1UpocIDhkoRrDO1X2plKWfABg9QF3Ya1/ETGykqDbzNoMSdwJOH5SXSaZiW5sTA0qxpLYKhqMsJVBvwe/z0WGNGXhnTuKd/zmVSFIQ3++SkpbNysMvKbZ9VG3khFJVkvdSyt6+ipMCU5cBR0KRrl+DgcRkdnH0cRGBIjb8D32km7OOWvbMS+61Eu9DYeIgDH+CiLDxZ1Jgtw7G0Pdt4PdvI9yt8Ndovd5W5tqivKXZfYve9kLsxddk134M401DJc052tRe6DXG3AZ7vAHxoEg62Ftp1LuhW560UYjNAldfBMljNwrG12DnLVLIelqq/9RjtpJwyNlboER2klWva060Ny+Qx/ZO25RCKMUIoU/in+Q6kcGTDklS5knyLW16dLN9P/p+MsPphuBB+Ctc2NFzZiLZ0UKumnAAZDtlEuc2TmixxrT3yueRqeRNNe7yeMUTqMojTb/C3W1q9Z+3F6/pZOmL5h6CJOPGHyYppSPybQTlr/e0YZOUNi3v0XVpa6e/5+Yr01cFzZSoOhD2a17ow9BfpcXsG2VrGLOFmULYOjW/+Uk2GUhMMoeO2TEhwOz06CUXQc7adBb4QFj+etrLf82hvvsTDtiBdx0kssYwvGR9EwCvwN6u4P2h8BAAD//yPMLd4OBQAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.903128905 -0800 PST", "maxElapsedTime": "86.580918ms", "maxServiceTime": "86.497525ms", "minElapsedTime": "1.057357ms", "minServiceTime": "1.010371ms", "name": "PAYMENT_getWarehouse", "node": "172.23.107.87:8091", "statement": "PREPARE PAYMENT_getWarehouse FROM SELECT W_NAME, W_STREET_1, W_STREET_2, W_CITY, W_STATE, W_ZIP FROM WAREHOUSE WHERE W_ID = $1", "uses": 39561 } }, { "prepareds": { "avgElapsedTime": "6.248096ms", "avgServiceTime": "6.096212ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2/aMBTFv0p01geQrArI/kiW9oAg1ZC6gUJVNFUoWMkluDNO5jhduyr77JMdKCtdedgkHrDPz773nnvjR5BOi4yypFRCgwMMaxK2NjQqtDWFqsB7DFJndD8s5TWZShYaPGTQYkvgGEeXk+so/prkZEeTDAxFSUbYwoA/4s1hgTl9r0mnBIZf6UaqzJAGv3kODWu7KYz86ajSyDupKKfKXXUpK+vxK2FysuDIaC1qZfk0HkfxHAwzI+/APzTLZh/in3KYuGrnqdAhGNLijkwFftP+CzqdVRtvdb6aJpPxqtvdU0fa+KS6OKmOXqhbsuIJ6Z6vZOb05a434JjGicvHh/W3Y6clMgPH+3Uv7L3rv037g3UmeumTWprillLr2+rmwZqH5Bs9uJJ7rM8GLHR2up1SpOQD7ex2E7Df3PUCDFUpdOU9pXuRWnBramIwQufktzcy34DjrO9TSFX9NFKq+NEKDTtgg9ewwTMsfA0L0SybJUNdSZ2DI6+kP/hnx2fCCKVI4b/m5kIqS8b3TGeydRSdTufVwQk+Bmf9biB0FvwVGh+wQfcEtzhwYbf7orqJllYKNWsbDQZDVa1sYsls950qHXhqEt1HdVyuPlzaLBv3O0Lm1pDY+rOoZK79y+K8be8Fx21VaDQMlu7dJz2Lo9kwjoKjVyW4iKefg3l0GY2ugvZsu9UmGiw+RXEUOFe9pcHwyzho7fPe7daL3TpE8zsAAP//xvatN/kEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.765664545 -0800 PST", "maxElapsedTime": "74.811297ms", "maxServiceTime": "74.760117ms", "minElapsedTime": "721.47µs", "minServiceTime": "669.007µs", "name": "DELIVERY_getCId", "node": "172.23.107.87:8091", "statement": "PREPARE DELIVERY_getCId FROM SELECT O_C_ID FROM ORDERS WHERE O_ID = $1 AND O_D_ID = $2 AND O_W_ID = $3", "uses": 36723 } }, { "prepareds": { "avgElapsedTime": "18.958335ms", "avgServiceTime": "18.826674ms", "encoded_plan": "H4sIAAAAAAAA/6SUf2ujTBDH34rM0z8SWB6a5Hmu3ML9EarlBBu9aFrKEcyiE7OtWb117bVXvNd+uGqs7YXeDwhBZz/OfL8zwz4BiiiLMQ7zlAmgAAS2yFQp8TwTSmZpAfSUABcxPsxzfoWy4JkAOiMg2B6Bgrs0rWXoB/Ng5YcJKlfGKB0usAACWY6SqUwCfYJ/+hfw8UuJIkIg8D3a8TSWKIB+HkLzUu0yyb/VVC75PU8xwaJO5fBCaTxgMkEFFGLcsjJVtFHj2AsLCHiS3wM9q9ZVV+aPdNi1eT9iYgZtJ2rbTuiGthma9d91aJvdWchjoDCJJ6fb6fb0/3fx2X/T9+xwmsvsFiOlm/hU29oz+Rje4SNQJUusCNzhY5GzqO9t66bud3fQ2gUCRc5EoSXjA4tUk4WAZCJBHd7xZAcUThrxUVoeBphmX5uDivTY9Bg2HWCTY9gEqnW1JlAWXCRAISm4/vB5Qy9QRTv4Pacvc3hMsjTFFP5qtBc8VSiBQJSJmDdTgdFoNNr0gjb/blxHj3gzNj4YJ5OxwURs/IQxD8x0fBRyD9BsPH5lyxZccZZ6zZYAAYlFmapQodx3Y85r8HVif+V5zk0rVCc+itq/wHxazReBHdy8xc0v3dUieIsyLce+spY3oa67frURXPSmq3VV/14gvpLI9vpbKHgi9CVVD/2gASjcFpkAAoOCg3DtfBDobA6Cz1rZxSsCCh/qq8ZbWt58aRnHLz7jYuleGr7lWOeBMUxHjFaEfuiK65fGhH7sxTep+m4a1x+tunazkHodjfnCNNrt07vXBdw2MIPqRwAAAP//fDEvo+gFAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.799776462 -0800 PST", "maxElapsedTime": "89.477155ms", "maxServiceTime": "89.424544ms", "minElapsedTime": "3.148877ms", "minServiceTime": "3.091197ms", "name": "ORDER_STATUS_getOrderLines", "node": "172.23.107.87:8091", "statement": "PREPARE ORDER_STATUS_getOrderLines FROM SELECT OL_SUPPLY_W_ID, OL_I_ID, OL_QUANTITY, OL_AMOUNT, OL_DELIVERY_D FROM ORDER_LINE WHERE OL_W_ID = $1 AND OL_D_ID = $2 AND OL_O_ID = $3", "uses": 3644 } }, { "prepareds": { "avgElapsedTime": "8.771586ms", "avgServiceTime": "8.647736ms", "encoded_plan": "H4sIAAAAAAAA/6SUb2vbMBDGv4p51hcxiNI0G90EexFmlxW6ODilYZSQaNbFEVPlTJLbbsX77MOq0/RfKNve2aef7k7Po9MtyBSVJDlfa2HAAYYlCV9b+lQZbyvtwA8YlJF0M1yrc7JOVQZ8wGDEJYEjSU9PztP861ySJk8jus6sJAuGak1W+MqC3+LN9gcT+lGTKQgMv4uV0tKSAb94DA1rv6qs+tVSa6uulKaSXJvqVDkf8DNhS/LgkLQUtfZ8lE7nWZ6kORjGVl2B9w+aWbMp8099nLQnnxTCDMBQVFdkHfjF3VfU6y3uay72F6Nsns1PkkUcb9gXiORVYvqMuCQvHmLx/kLJFpl11oCjSx12owvPlWzlWR4d0fIdyf77t/JD/xsYvtNPtxZF699D0VpLN/FOVDC4tTAuCEM3ovDg3tbEYIUpKYRXqlyBY28Q6ha6vr8jurq+W2jYFuvvwvqPsMNd2CGaWTNjqJ0yJThKp8LGh7aNhRVak8Z/mX+stA9XuaiMVD70gV6v94q30cdorx9HwshoJzrdoofxK2y2ZQdx/OysEzIyCcMHBqGVcE9s/Qu3m1nzNH2iXCGsfGlp4i2JS4QZc6o04eEAN7XWDJ5u2uEc5+l4mKfRjnciOs6zL+1iepbefd+3GE0/p3kadboGUaPhKIk69YJ0m0DWBQZo/gQAAP//pUvDbNQEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.779821544 -0800 PST", "maxElapsedTime": "89.725425ms", "maxServiceTime": "85.91756ms", "minElapsedTime": "709.346µs", "minServiceTime": "651.877µs", "name": "DELIVERY_deleteNewOrder", "node": "172.23.107.87:8091", "statement": "PREPARE DELIVERY_deleteNewOrder FROM DELETE FROM NEW_ORDER WHERE NO_D_ID = $1 AND NO_W_ID = $2 AND NO_O_ID = $3", "uses": 36723 } }, { "prepareds": { "avgElapsedTime": "3.363859ms", "avgServiceTime": "3.23196ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkoXZ7QPJbRNIJ0QKL3U2IomCFC7gNduaYiq5kv31y+ErXsYdViuT4+vjec46OXwB1amY4S/JMamAAFOYo3dpix2hnTVYAu6Sg9Aw3Qa6+oS2U0cA+U9ByhcCgH31PBnEYxUk7WaDjzqSPXT03QMHkaKUzFtgLfDhtgOOPNeoUgcKvdKmymUUNbPwaFKzd0lj106Nyq55UhgssfKsbVbgKLqRdoAMGM5zLdeYYF4NODygMrXoC1i4n5WHCf1Ho4TNPpQYKj/hcAINxo+FMUjir9KLx8VOTbLfkHlr3UP3Vjq6azQmU9HW7a3Tpct8sl6k370DYe3mo7cW8uT6UVmYZZvAuTV2tnJLZ0JoHTB1QsFisM5c4tKuiQuMm98DGtCI3bU158vUu6IuuGE2bFau/IMJABOdPRyI8f7gLT6cvzkPi6HYgon9jwi4XyWXbAyZvnFf6JLmclP77A8KdRbmq7kKhFrp6A97hnTZg8FAYH4XjpHrpqKFePLhWr52U1KsjER62JQWHGx/qYRwNgzgi5x4YuY4Ht4RHN1FHkNM0SnaM/ToSoV+O7PzmxKBC7rTse3kzyR2PSC8acTIWg4SLuNv/4rO+3ZKL1oXPea185WP+OwAA//9oEHhoRQQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.793745 -0800 PST", "maxElapsedTime": "69.089956ms", "maxServiceTime": "69.036036ms", "minElapsedTime": "534.452µs", "minServiceTime": "466.262µs", "name": "NEW_ORDER_7_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_7_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_07 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 40881 } }, { "prepareds": { "avgElapsedTime": "3.551087ms", "avgServiceTime": "3.384957ms", "encoded_plan": "H4sIAAAAAAAA/6RTXU/bMBT9K9ZdJRLJqgZFY7K0h5CGFyhETTqpKlVqJZfWmutktlPBoPvtk6NmIy2gbTwlPvfr+J7jR0CVlwUWWSW5AgZA4Q65rTWGpbK6lAbYRwpCFXgfVOIraiNKBWxAQfE1AoM4mI6i6zSrq4JbPA/D2thyjRoolBVqbksN7BE+/DlAgt9rVDkChZ/5SshCowI26yYFtV2VWvxwWZUWGyFxica1uhLGNukp10u0wKDAO15Ly8JJkt6MojFQiLXYAPu8nW/bIf/F4hIfkpwroPANHwwwmHme59kyM1YLtfR6n3zy9ERuoX8LzV8n9HrszPfnsKXdYTHXXEqU8C7KF2jz1Y5wxXOn0bO9ONVaeLe2Ax6hLBUeoAlaoGDQZhb12jRzK25XwMBbtBMW/UWYnQdXwXUYLXygsOGydrN6x03Dlwum6TDb+ahbdPJGUWu8cL9o8EbRMEiDbvYpOI/sX1UVk8bPQIFLwU13if+w2vl2v/lQmJzr4qVQYjXydUMIjFiq5iECU7WUFCzeO6/H4ygOxhF57d2Ri/HNiEziYZBGpGVHJklELqNpQmaH5j3qH7kP+ZvAme+TOUmilPyWmXwhvWNKOio67MRhz0Ry2MBhTgN3OIXtrwAAAP//FR7g24AEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.919336515 -0800 PST", "maxElapsedTime": "44.505517ms", "maxServiceTime": "44.435947ms", "minElapsedTime": "487.387µs", "minServiceTime": "424.728µs", "name": "PAYMENT_updateBCCustomer", "node": "172.23.107.87:8091", "statement": "PREPARE PAYMENT_updateBCCustomer FROM UPDATE CUSTOMER USE KEYS [(to_string($6) || '.' || to_string($6) || '.' || to_string($7)) ] SET C_BALANCE = $1, C_YTD_PAYMENT = $2, C_PAYMENT_CNT = $3, C_DATA = $4", "uses": 3510 } }, { "prepareds": { "avgElapsedTime": "3.378768ms", "avgServiceTime": "3.240088ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkVe32sMpvEUknRAssdjchioIVLuA22JljKrqS/fbJ4SPpOvawSZEcXx/fe87R8QugTs0MZ0meSQ0MgMIcpVtb7BjtrMkKYBcUlJ7hJsjVV7SFMhrYRwparhAY9KNvySAOozi5ShbouDPpY1fPDVAwOVrpjAX2Au/qDXD8vkadIlD4mS5VNrOogY1fg4K1WxqrfnhUbtWTynCBhW91owpXwYW0C3TAYIZzuc4c42LQ6QGFoVVPwD6Vk/Iw4Z8o9PCZp1IDhUd8LoDBuNVyJimcVXrRev+hTbZbcg/n91D9NY4u2+0JlPR1u2t06XLfLJepN+9A2Ht5qO3FvLk+lFZmGWbwX5q6Wjkls6E1D5g6oGCxWGcucWhXRYXGTe6BrWlFbno+5cmXu6AvumI0bVes/oAIAxGcPh2J8PThLjydvjgNiaPbgYj+jgm7XCQXVx4weeO80rXkclL67zcIdxblqroLhVro6g14h3fagMFDYXwUjpOapaOGZvHgWrNWK2lWRyI8bEsKDjc+1MM4GgZxRE49MHIdD24Jj26ijiD1NEp2jP06EqFfjuz8pmZQIXda9r28meSOR6QXjTgZi0HCRdztf/ZZ327J2fmZz3mjfOlj/isAAP//viE9EUUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.835777445 -0800 PST", "maxElapsedTime": "69.288916ms", "maxServiceTime": "69.238879ms", "minElapsedTime": "523.916µs", "minServiceTime": "474.203µs", "name": "NEW_ORDER_8_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_8_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_08 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 41503 } }, { "prepareds": { "avgElapsedTime": "3.443745ms", "avgServiceTime": "3.317661ms", "encoded_plan": "H4sIAAAAAAAA/6RTcWvbPhD9KuJ+P6gNomzrHwP95zoOmCZLsJ3BSIMj7GuizpE8SS7JWu+zDznxmixrNzYw+HT3dO+94/QIKAtVYpnXFZfAACjcIbeNxlBJq1VlgL2hIGSJ26AWH1EboSSwKwqSbxAYTJJBlORpFmSzNF+hDRtj1Qb19a6P4hIoqBo1t0oDe4T/ng+Q4pcGZYFA4VuxFlWpUQKbn4KCxq6VFl8dqtbiQVS4QuNajYSxHTzjeoUWGJR4x5vKsnCWZpNxlACFqRYPwN63i7Yn+SsVN7hLCy6BwmfcGWAw9zzPsyo3Vgu58v5/65OnJ3ILl7fQRUeld/7LtSvfX0BLT8mGaIv1garmhZv0kSM3+z59MHzWYco1ryqs4J9Mx1JYwaupVvdYWKCg0TSVzS3qjenQuK0d0Fv2+paXyzCPB0u/k/Tr8jBO0uxVxDgeDEbRq5BR8Jse18Eo+BB2TRZnAxby2Va7aN33EyS1GvmmuwtGrGT3LtwUf3QGBvdGuZU4WDpOxIPjkxN7fN776zMtBYtbt7/TJJoGSUT+5F2RYTIZkzQaRWFGHCElBx0u2DO4yHG7/0H1/lo/KTJLI3ITfUrJ/HyZLy4v3O90lV8oXPk+WUD7PQAA//8qXXMrVAQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.369380418 -0800 PST", "maxElapsedTime": "48.057456ms", "maxServiceTime": "47.990881ms", "minElapsedTime": "627.881µs", "minServiceTime": "573.68µs", "name": "ORDER_STATUS_getCustomerByCustomerId", "node": "172.23.107.87:8091", "statement": "PREPARE ORDER_STATUS_getCustomerByCustomerId FROM SELECT C_ID, C_FIRST, C_MIDDLE, C_LAST, C_BALANCE FROM CUSTOMER USE KEYS [(to_string($1) || '.' || to_string($2) || '.' || to_string($3)) ]", "uses": 1446 } }, { "prepareds": { "avgElapsedTime": "3.876466709s", "avgServiceTime": "3.87635905s", "encoded_plan": "H4sIAAAAAAAA/6SUUU/jOBDHv4o1xwMgq6IUDrDEA9cEKVyvqdKKezhVqZVMUx+unbUdoIuyn33lhJayZbUsPHo8Gv/mP3/PE6DKdI55WkqugAFQmCN3lcG+Vs5oaYEdURAqx8erUtyisUIrYD0Kii8RGIwncf/vdBDehoO0QBebHI39axUI64zIHFDQJRrutAH2BH+8HGCMXypUGQKFb9lCyNygAvbf66Sryi20EV99VmnEvZBYoPWlBsK6Jn3CTYEOGOQ455V0LIjGkyTqT4DCyIh7YGc1fSMtToIwGW8lTes1yYdQIy/SOOOqBxS49S/Bs3TAIIjSKEj/TaNgHUxFDgwuzvjp6fnxvNe9mOeneXdzWxr9P2aukfvJ977kZpXe4QqYMxXWFO5wZUueYVN907Kfyzr83CpQsCVXtkHGR565tgYFw1WBTXghigUw2GsBMlltBi31Q3tRT+sphcoKVQCDwgrwum5LcI0uW2x3/37EH0uNuOFSooRPzWSI1mE+0Lq80UJ5MikaOO2NqdJM8sp6jP39WT7rzII0CmYH5JLsz/SsM4vTNnDwOYpdZ+gtZ8RJ88prW/SOuidz7B13T+Yc/zy/+JgtNhZ/2xSqUSeVWpdrQ7zXJ9ty/cQxr1J+0zsaPtVHPa13ygvp0ACFTKtctPrtTH2ve7DDFSnhBJejVnegYNBW0qUOzXKtVOkTLcq5/2mOmw3FDoR6qeQhdznHziBfQrOMrChUs4z9qA+BwSHUFBw++jU2SsLRVRKSXyxgcp3E/5BxOAj7E3LYnsj6L5KcRMNhmJCbOBqSVmWiSTwkeceLQi4vie60v4A8LNDg5oL4hfA9AAD//7X2oNBABgAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:15.886782548 -0800 PST", "maxElapsedTime": "9.244240109s", "maxServiceTime": "9.244175456s", "minElapsedTime": "511.153113ms", "minServiceTime": "511.029199ms", "name": "STOCK_LEVEL_getOrdersByDistrict", "node": "172.23.107.87:8091", "statement": "PREPARE STOCK_LEVEL_getOrdersByDistrict FROM SELECT * FROM DISTRICT d INNER JOIN ORDERS o ON d.D_ID == o.O_D_ID where d.D_ID = $1", "uses": 3692 } }, { "prepareds": { "avgElapsedTime": "3.339429ms", "avgServiceTime": "3.212649ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkVe32MNVvEUknRAssdjchioIVLuA22JljKrqS/fbJ4SPpOvawSZEcXx/fe87R8QugTs0MZ0meSQ0MgMIcpVtb7BjtrMkKYBcUlJ7hJsjVV7SFMhrYRwparhAY9KNvySAOozi5ShbouDPpY1fPDVAwOVrpjAX2Au/qDXD8vkadIlD4mS5VNrOogY1fg4K1WxqrfnhUbtWTynCBhW91owpXwYW0C3TAYIZzuc4c42LQ6QGFoVVPwD6Vk/Iw4Z8o9PCZp1IDhUd8LoDBuNVyJimcVXrRev+hTbZbcg/n91D9NY4u2+0JlPR1u2t06XLfLJepN+9A2Ht5qO3FvLk+lFZmGWbwX5q6Wjkls6E1D5g6oGCxWGcucWhXRYXGTe6BrWlFbno+5cmXu6AvumI0bVes/oAIAxGcPh2J8PThLjydvjgNiaPbgYj+jgm7XCQXVx4weeO80rXkclL67zcIdxblqroLhVro6g14h3fagMFDYXwUjpOapaOGZvHgWrNWK2lWRyI8bEsKDjc+1MM4GgZxRE49MHIdD24Jj26ijiD1NEp2jP06EqFfjuz8pmZQIXda9r28meSOR6QXjTgZi0HCRdztf/ZZ327J2fmZz3mjfOlj/isAAP//cXCydEUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.141230201 -0800 PST", "maxElapsedTime": "69.485276ms", "maxServiceTime": "69.437571ms", "minElapsedTime": "522.607µs", "minServiceTime": "469.369µs", "name": "NEW_ORDER_9_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_9_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_09 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 40889 } }, { "prepareds": { "avgElapsedTime": "3.362362ms", "avgServiceTime": "3.237679ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkoZY9TPJbRNIJ0QKL3U2IomCFC7gNduaYiq5kv31y+ErXsYdViuT4+vjec46OXwB1amY4S/JMamAAFOYo3dpix2hnTVYAu6Sg9Aw3Qa6+oS2U0cA+UdByhcCgH31PBnEYxUk7WaDjzqSPXT03QMHkaKUzFtgLfDhtgOOPNeoUgcKvdKmymUUNbPwaFKzd0lj106Nyq55UhgssfKsbVbgKLqRdoAMGM5zLdeYYF4NODygMrXoC9rmclIcJ/0Whh888lRooPOJzAQzGjYYzSeGs0ovGx3aTbLfkHlr3UP3Vjq6azQmU9HW7a3Tpct8sl6k370DYe3mo7cW8uT6UVmYZZvAuTV2tnJLZ0JoHTB1QsFisM5c4tKuiQuMm98DGtCI3bU158vUu6IuuGE2bFau/IMJABOdPRyI8f7gLT6cvzkPi6HYgon9jwi4XyWXbAyZvnFf6JLmclP77A8KdRbmq7kKhFrp6A97hnTZg8FAYH4XjpHrpqKFePLhWr52U1KsjER62JQWHGx/qYRwNgzgi5x4YuY4Ht4RHN1FHkNM0SnaM/ToSoV+O7PzmxKBC7rTse3kzyR2PSC8acTIWg4SLuNv/4rO+3ZKL1oXPea185WP+OwAA///aALtARQQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.48420394 -0800 PST", "maxElapsedTime": "76.405601ms", "maxServiceTime": "76.325286ms", "minElapsedTime": "507.522µs", "minServiceTime": "457.94µs", "name": "NEW_ORDER_2_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_2_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_02 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 41582 } }, { "prepareds": { "avgElapsedTime": "11.49549ms", "avgServiceTime": "11.361853ms", "encoded_plan": "H4sIAAAAAAAA/6SUUWvbMBSF/4o460MDYiwJZa1gD6F2mWFLgpMugxEcYd04WhXZk+UuXfF++7DTpG2yDbo96t7jo3O/i3wPsmmuSCWFkRYC4FiS9JWjy9x6l5sS4g2Htoo2g0J/Ilfq3EL0OaxcEwSG4SwZxUEYJ9qmjtZk/ZA2fuQUuUiBIy/ISZ87iHu8ejxgQt8qsimB42e60kY5shBfnosGlV/lTv9oVIXTt9pQRmVj9UGXvpVPpcvIQ0DRUlbGiyCaTOPocgqOsdO3EOf1vN5d8k8pomb8SSptHw8sIBBESRQksyQKdsVEKwhcvJVnZ+e9Zb97sVRnqrvvFi7/Sqlv+d0306ylu0tu6A7Cu4pqjhu6KwuZUuu+H6IBvSs/zAiOspC2bJPSRqZ+68HhpM2oLa90toLASa8NkJpqvzmTf982av4o6/9J1kc9r+ccValtBoGs1O2HTwGNpZPGkMF/Yb4in67wEgyHOa608eTAkeZW6S1qnJ6eLnY+i9eLIImCRYe9Yye9DpNWscP2bC/odzpHV1ya3NJRdULtTsgnntx6u5dC+obsgfsw/DxNRu0V4LiVpmoGOuk2lI9MrboulPQNNmm0LJ8TeQGneX1oHugylU79rjXxjuS6DYRSZ7b9H0DYyhgOT5vmsY3jcDyIQ/b358+u4tFHdj0OBtOQ7TKySThlT0A0pLts9j6MQxY8nHtsMAzYdhftJlD/CgAA//9dhQ5nrAQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.050375998 -0800 PST", "maxElapsedTime": "99.780411ms", "maxServiceTime": "99.694465ms", "minElapsedTime": "1.914459ms", "minServiceTime": "1.860708ms", "name": "NEW_ORDER_incrementNextOrderId", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_incrementNextOrderId FROM UPDATE DISTRICT SET D_NEXT_O_ID = $1 WHERE D_ID = $2 AND D_W_ID = $3", "uses": 41252 } }, { "prepareds": { "avgElapsedTime": "3.400561ms", "avgServiceTime": "3.253799ms", "encoded_plan": "H4sIAAAAAAAA/6STb2+bMBCHv4p1i9REsqqm6f7U77KFTmgUGJBUURMhC66pNcdkxlTdGvbZJyjQ0LV7sUWRYj/3Uzhxzz0AqiRLMY13kitgABRukJtC46dMGZ3JHNgJBaFSvJ/uxAJ1LjIFbEJB8S0CA9e6ir1gZgVxopEb9HSK2hEKgUK2Q81NpoE9wJunC4T4vUCVVJFfya2QqUYF7LofmhbmNtPiZ5XaaXEnJG4wr/7KEbmp4xHXGzTAIMUbXkjDHhtxbNcCCr4Wd8DOy3XZPuaf+lhwWWCYcAUU7qpzDgyur4f1x2RxbrRQm+FgMiL7PVnB8Qrq00HpdPR6bfyX2tloRMnDCjwnnl56czdaASODc0pqNLMce2EFy3hW4/cttsMott0Lr6bjkxbH9mPutAF2C942wJ1ffrSCGp01yGsz4wZ8nU/dyI6WNfzQwHDu+84yvmrD7xregUm5XkNJ++/V55pLiRIobPl9exP5Ftj4vwYWokptlaM2QIFLwauB9cz4hj/yHU/wOa+UbguNUn+0PRN5wnUK5bqsvs+qodHIt1A7l4uNqlcJmCqkpGDwvpLVDyx/Gljk1c0hF4F3SWw3tIKI2G7kkacuh1+sJSWLqTO3Ro8/4TDy4jAKbPdzJeF+T46OjyqRDvDpy3j8Mj6rrOsJ0M2/saiTqBnxYPLcoU6hRrPOsr4snSs9mTuXD3TrbOs24WkRDowfjE/KEZS/AwAA//+S12Dx2QQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.322298462 -0800 PST", "maxElapsedTime": "91.601878ms", "maxServiceTime": "91.529836ms", "minElapsedTime": "489.148µs", "minServiceTime": "407.049µs", "name": "NEW_ORDER_createOrderLine", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_createOrderLine FROM INSERT INTO ORDER_LINE(KEY, VALUE) VALUES(TO_STRING($3)|| '.' || TO_STRING($2)|| '.' || TO_STRING($1)|| '.' || TO_STRING($4), { \"OL_O_ID\":$1, \"OL_D_ID\":$2, \"OL_W_ID\":$3, \"OL_NUMBER\":$4, \"OL_I_ID\":$5, \"OL_SUPPLY_W_ID\":$6, \"OL_DELIVERY_D\":$7, \"OL_QUANTITY\":$8, \"OL_AMOUNT\":$9, \"OL_DIST_INFO\":$10})", "uses": 413607 } }, { "prepareds": { "avgElapsedTime": "12.705103ms", "avgServiceTime": "12.578351ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2/aMBTFv4p11wciuRWBTd0s7QGVVEOigEJVNHUoeMkluDNO5jj9syr77JOdhP4X0/YW3/x8bZ9z7HtAFWcJJlEuuQIGQGGN3JQaTzJldCYLYF0KQiV4O8jFBepCZApYn4LiWwQGw2A8ugjCr1GKZoI3U52gBgpZjpqbTAO7h3cPA5jjzxJVjEDhd7wRMtGogF0+hQal2WRa/LJUrsW1kJhiYVuNRWEcfs51igYYJLjmpTRsEiyiaTgMQqAw0+Ia2HG1rNpV/mkbfwWNrDTzmKs+UIiza9QFsMv6i3Q6q92+VkeryTSaRqPhyvNa9hViuJdYvCC2aPhjzDtaicQiy8Y7YNC0drOhKUcisRKuj49x/QET/+P75JP/ffc319kVxsY5bqNi9F30A+/sAbvUpz2rrx3nPLZReGyBFFth7fGhTkrLNHYBhSLnqnBy4i2PDTCjS6SguUrRlYWKZVnHrUtBZjfAoHPoe1DRe9iIdAMMDny32R3Yb8ED/wnWewvrQbWslhTKQqgUGKSFcBMfWzzjmkuJEv4rTadCGnc14kwlohYVOp3OnhyQz+TA9whXCXkTXTygPa9hrVLkW9nt9mOyJ4ye9+LIIyWM4HJWBwAoaCxKaSKDetualltwX87tHXyug3poXC2rl8TYZYe2S/iOesbMjUa+de2hEKlyb5b1pVkbGFwVmYKKgsFbm8RZGMwGYUBee7DIaTg9I/NgHJyck6ZDXdsdiyy+BGFAGmOcK2QwGZJGfqd9W3DTnfZIDn0yHp2NzokP1Z8AAAD///PElqVvBQAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.744342168 -0800 PST", "maxElapsedTime": "142.003162ms", "maxServiceTime": "141.947973ms", "minElapsedTime": "805.509µs", "minServiceTime": "752.986µs", "name": "DELIVERY_getNewOrder", "node": "172.23.107.87:8091", "statement": "PREPARE DELIVERY_getNewOrder FROM SELECT NO_O_ID FROM NEW_ORDER WHERE NO_D_ID = $1 AND NO_W_ID = $2 AND NO_O_ID > -1 LIMIT 1", "uses": 36750 } }, { "prepareds": { "avgElapsedTime": "8.97655ms", "avgServiceTime": "8.83327ms", "encoded_plan": "H4sIAAAAAAAA/6RU70+jShT9V8h5frDJ5OUVY3xOsh9IwSyJuqQla3TT0Anc0lE6sMPg6hr2b9/AiK3VdX8lfODeezice85kHkAqLTPKkqoQChxgWJIwjaZJqYwuixr8PwapMrrzKvmRdC1LBX7AoMSawBF5l2fBeZzkZHxZGy1TA4ayIi1MqcEf8M+mwIw+N6RSAsO3dCWLTJMC//Qc5DVmVWr5tUNVWt7KgnKqO6pTWZseHgudkwFHRkvRFIb74SyehpMYDJGWt+BH7bwdfvJHKsJu51kq1AEeDQCHHyahn1wkoT80E5mB4/hIHB7+7y4PxsfL7DAbP00rXV5TanrTHrpt1kLfJzd0D250Qy3DDd3XlUipZ39aonN3aD/uCIa6EqruldKdSI3lYNBC5dS3VzJfgWPP7QWkRfMUV1F+sYOWbWDjH8HGaOftnKGppcrBkdey/3DboBMy6Qq/s8AuQyS0KAoq8FdBncjCkAZDWqpMWquxv7+/GNQs/l3YzBYj552zNx45QmXOLmAYu6PRC6GhkkaKIrJhgkFT3RQmMaTXQx5VB9zhPPfOgoWlex0wi6dBECfjXwG5b4ImYXz5ExYvflvMVRh18/mLoKXa7N7O2+7ZgcyMJrHuv0Utc9VfIV2aVhg4rutSgcF6sl33up43rCev9Nzt3lUYDWXLYOiuuw+iaRB508B55VpyTqYfzpxZcBpMYsfqYM7md1vvbvfe6bY9L+6BV2FkKQbTnIv3wTRw7NnqT5bjnfuO/1i5aL8HAAD//zYCF8hgBQAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.918654065 -0800 PST", "maxElapsedTime": "95.256762ms", "maxServiceTime": "95.182822ms", "minElapsedTime": "1.042998ms", "minServiceTime": "988.105µs", "name": "PAYMENT_getDistrict", "node": "172.23.107.87:8091", "statement": "PREPARE PAYMENT_getDistrict FROM SELECT D_NAME, D_STREET_1, D_STREET_2, D_CITY, D_STATE, D_ZIP FROM DISTRICT WHERE D_W_ID = $1 AND D_ID = $2", "uses": 39561 } }, { "prepareds": { "avgElapsedTime": "16.898766032s", "avgServiceTime": "16.89864984s", "encoded_plan": "H4sIAAAAAAAA/7RVUW/bNhD+K8QtDzZAGHbTRZiAPGSyuqlzLUN22ofCkFnqqnCjSY2ksmSF99sHUpbbzCpWrN2bffcddfy+744fABXXFVZlI5mCGIDCe2SuNZho5YyWFuIpBaEqfLhpxGs0VmgF8SUFxfYIMaw3efJLuUhfp4uyRpe01uk9mtxUaOyPj3NhnRHcAQXdoGFOG4g/wHcf/8Aaf29RcQQKf/E7ISuDCuK3T0E3rbvTRvzpUY0R90JijdYftRDWBfiGmRodxFDhe9ZKFye3603+Ki2AwsqIe4ijAx2A5cU8LdafgLaHvpP/1GrmyVpzpi6BArMQAwcKXN+jsRC/7X6R0WjHd5NdUmbz3XjcAz6G559LvDlL7NExnx1PdqLyqe1RMYghuS2zeTgsFMIxU4rKM/CMR9OK/3CF1WwWReyUbYz+FbkLUnuPOPNY/oaPvv0pnW2DBHvWBSF2psUDBQ9oGMfw1RPz3iZ9+Mg4ULANUzYwhw+Mu+4MCoapGkNYKC7bzmtTClL/ATGoVkrwEt6J+g5iuJiFhk/Ayx54MYPD9rCl0FqhaoihtiIUfirTihkmJUr4KrGXaB1WC62bl1ooL7gUQXPtHa9KLllr/d1HQ7KTa3IK691kl5fHxPjrujq3oB624JOPnllKD1oqL0LBUytF0fMIrzB6fvnsavou+h6e+OE0YsNuUIHEUmrd9E74V4McPfCZYRpyxSB0wCfbwz+t8kJIhybQoyrRjcWZoPOTpBez8ZnbMiWcYPIno9vGa1LXBmvm8ChHq9yoEtYJxR0ZajQoUPvqfhC3A41myqHZYyWYw2/6qTNC1De+y/8ynEfSV902AwoGbStd6UnqzdWYYI0vaPowTEN/upfjXJG1M8j2oRasqFV4W/1lLmZho+3foYEDBYcP/k1aFenqpkjJF76q5EWRvyLrdJEmG5Lkt8vNaJ6tN9ky2Yz4xHc+HncY0q9kwkm2XKYFeZlnS9INJtEkX5KugFxfEz3pdgJ583NapCExDyniN+vfAQAA//9PjYsJNQgAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.099908009 -0800 PST", "maxElapsedTime": "20.694229117s", "maxServiceTime": "20.694177724s", "minElapsedTime": "5.783763542s", "minServiceTime": "5.783704579s", "name": "STOCK_LEVEL_getCustomerOrdersByDistrict", "node": "172.23.107.87:8091", "statement": "PREPARE STOCK_LEVEL_getCustomerOrdersByDistrict FROM SELECT COUNT(DISTINCT(c.C_ID)) FROM CUSTOMER c INNER JOIN ORDERS o ON c.C_ID == o.O_C_ID WHERE c.C_D_ID = $1", "uses": 3692 } }, { "prepareds": { "avgElapsedTime": "3.435193ms", "avgServiceTime": "3.290605ms", "encoded_plan": "H4sIAAAAAAAA/6SSb2+bMBDGv4p1i1SQrGpt1q3zO9SwBa35I6CZoiRCFlxTa47JbBOlS9hnnyCQNFv3ZpOQ8PPcAcc9vx2gSvMMs2QtuQIGQOERuS003uXK6lwaYG8pCJXh1luLCWojcgWsS0HxFQKDsTcd+MM4Ecqgtn1hbK6fgUK+Rs1troHt4M1JQITfC1QpAoWf6ZOQmUYFbHbe5BX2KdfiR9W11mIjJC7RVK+6F8bW7THXS7TAIMNHXkjL+kEUj8IpUBhrsQH2sVyU7Tf+aYgJlwVGKVdAYVOdDTCYzRzHcWyeGKuFWjqdK5fs92QOl3OoTy9K1+7fa13XpWQ3h37iDUYPw3gOjHQ+UFI5d0kvCXq1c906jb5q9dfW6R6cnhd7tb49ar/W7xvd9r876OPzN+ViASU9//Ux11xKlEBhxbetEmYF7Oq/dhqhyoKaFKDApeDVTk/JfcNns+YpnpkVaK3bhP3HwD1hUq4zKBdldf1WjaxGvoIaCCOWqgYcmCqkpGBxW2E0Dv2xF/rkVZ7Jp3A0IMEw8sOYBMN4RJrxnC/+lJKJd//gu4dbRJx4lERxGAw/V3Ts9+Ti8qJK/4V9/brdbZlo8j7F3cR34qHJ7xh/I8/T7dycwdCycCSuBa6Bp3NbulD+CgAA//95EMxMFAQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.97466809 -0800 PST", "maxElapsedTime": "64.606049ms", "maxServiceTime": "64.548607ms", "minElapsedTime": "490.353µs", "minServiceTime": "433.568µs", "name": "PAYMENT_insertHistory", "node": "172.23.107.87:8091", "statement": "PREPARE PAYMENT_insertHistory FROM INSERT INTO HISTORY(KEY, VALUE) VALUES (TO_STRING($1)|| '.' || TO_STRING($2)|| '.' || TO_STRING($3), {\"H_C_ID\":$1, \"H_C_D_ID\":$2, \"H_C_W_ID\":$3, \"H_D_ID\":$4, \"H_W_ID\":$5, \"H_DATE\":$6, \"H_AMOUNT\":$7, \"H_DATA\":$8})", "uses": 39561 } }, { "prepareds": { "avgElapsedTime": "3.350906ms", "avgServiceTime": "3.217279ms", "encoded_plan": "H4sIAAAAAAAA/6SSUWvbMBSF/4q4G9QGEbblYaC34KgQmjbBTjZGGhzh3DrqFMmT5JKu9X77kFOTZGn3sIFBlvT53HOvzxOgLswa13mlhAYGQOEOha8tJkZ7a5QD9oGC1GvcDSr5Ba2TRgPrU9Bii8Dghn/NJ+mQp3mJPqmdN1u0QMFUaIU3FtgTvDtsIMMfNeoCgcKvYiPV2qIGtjiFBrXfGCt/Bqqy8kEqLNEFqbF0vsVnwpbogcEa70StPEvm2WxyzVOgMLXyAdjnZtl0Rf7JxRU+ZoXQQOE7PjpgsIiiKPImd95KXUbvP8bk+ZncQu8W2rejq0/x23f9OF5CQ0+LXaIvNi+lKlGE0R51FIbdHb80fKYwFVYohQr+q+mRll4KNbXmHgsPFCy6Wvnco926lsZdFcBo1flb9VZJPhxlyWR+M1vFrbHXofEg+zuQpHw4apHl2YCkPthqlk14/kAyb1Fs22/ByVK3QQ5T6ISBwb0z4Y8eDB+fBX/dvqHgcRcSNk35dJBy8mrUyWU6uSYZH/NkRg6qlOzVwrqvvQe7bsk84+SKf8vI4jxRF72LsJzm6Y2LfhyTJTS/AwAA//+AT8SDygMAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.041283215 -0800 PST", "maxElapsedTime": "64.601477ms", "maxServiceTime": "64.549289ms", "minElapsedTime": "499.497µs", "minServiceTime": "447.69µs", "name": "NEW_ORDER_getCustomer", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_getCustomer FROM SELECT C_DISCOUNT, C_LAST, C_CREDIT FROM CUSTOMER USE KEYS [(to_string($1) || '.' || to_string($2) || '.' || to_string($3)) ]", "uses": 41252 } }, { "prepareds": { "avgElapsedTime": "11.706095ms", "avgServiceTime": "11.572914ms", "encoded_plan": "H4sIAAAAAAAA/6RUX2vbPhT9KuL8+pCA+JF/G0Owh1C7LNAtwWkbxgiOsG8crYrsyXLXrniffVhO06ZNoWwvhqtzfO895yDdg0ySp5TGhZYGAuBYk3SVpdPcOJvrEqLHoUxKt+NCXZEtVW4ghhxGbgkCQXg+uQqjr3FVpNLR1KZkS3DkBVnpcgtxj/8eC8zpR0UmIXD8TjZKp5YMxLdD0rhym9yqXw2rsOpGacqobFqdq9J5+oW0GTkIpLSWlXZiGgVhNAfHzKobiA/1sn4Y8Vc7TBrN80SaIXYGQGAaxdN4EsRB81nEk+ABi1UKgffr3rD3rj9K+oN1KnvJHi1s/p0S5727byRtpb2Lr+kOwtmKao5ruisLmZAfslPSWPxwuJMJjrKQpvTr0q1MXNuBw0qTkT/eqGwDgZOBH5/oap+Zzn+2QM0facPXaMMD2ug12gj1sl5yVKUyGQSyUvkfn5o5k1ZqTRr/FMkZuWSDt3v1fIszpR1ZcCS5SVWbBjqdTmfVtln9v2rSXXXZR3Yy6DJpUnYIBnt42D2GL/b4qNt9Mf9U54ZenM7Jp0oudmS3bbKFdI3pB71Px1E0CSM/ARw3UleN2JN+4/+Lnia99BcSHFIrWT716s3+LevnjQNVJtKmx6C5syS3fhmUKjP+GYEwldYcjm6byzqLwtk4CtnRV4OdRdPP7HIWjC9C1i7G5uEFeyq9sbbPFp/CKGTTXT1g4y8Ba8Px0ezqxa4eof4TAAD//2zJazvpBAAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.784126763 -0800 PST", "maxElapsedTime": "80.495401ms", "maxServiceTime": "80.442135ms", "minElapsedTime": "1.536944ms", "minServiceTime": "1.47971ms", "name": "DELIVERY_updateOrders", "node": "172.23.107.87:8091", "statement": "PREPARE DELIVERY_updateOrders FROM UPDATE ORDERS SET O_CARRIER_ID = $1 WHERE O_ID = $2 AND O_D_ID = $3 AND O_W_ID = $4", "uses": 36723 } }, { "prepareds": { "avgElapsedTime": "18.563138ms", "avgServiceTime": "18.425939ms", "encoded_plan": "H4sIAAAAAAAA/7RUXW/aSBT9K9bZPGBptAqwu9GO1AcUnBYJAoIkqIqQmdoXM409dmfGKWnk/vZqzFdJiKq26Yslzz3345xzZx5BKspjisMiFQocYFiQsKWm81xZnacG/JRBqphWnULekDYyV+BtBiUyAkc36PdugvH70JTZsN/J8lJZMOQFaWFzDf6Iv/Y/mNCnklREYPgaLWUaa1Lgt4egTmmXuZZfHKrQ8l6mlJBxpfrS2Bp+JXRCFhwxLUSZWj4cd4Nx2O9dBmAYaXkPflbNqm2bX5qj52hPIqHa2GgAjmE/HIa9bth1n2nY625joYzB0Yybp4vW4vTf/+Kzf1r/i1200PlHimwt36OjlQn9EN7RA7jVJVUMd/RgChE5VQ/YOKW3gQ1dMJhCKFOPTCsR2XUVBi1UQvXxUiZLcJw06xGitNxZl+af14GK7WGtl2CtA1j7JVgb1ayaMZRGqgQciZF14veCXpCNlvg5pk9rjIQWaUopfsvaC5la0mCIchXLtStoNBqN+X6g+d/zjdlz33vjnTR9T6jYO4Lp7jAt/0XQdAdq+/4zWj0lrRTpW52XBRhEkmhKhHVrfwtTZkcKdgbD68urue9jxpC4RLdOLmFWzarnDSzpjGIpLL1Wl6f2SvV6DP6I7RuVR+u7CAZNpkxt6KRZXyZhXK3rQbgbDwy0Klz2j0hUxxXZdnOmPPdlYjWJrM6FkYmqX19H7nAIDlVmH0ijYrC0ck/faByMOuPAO/YEexfj4cCbBP3g/MqbXA8au0q+15l4B7XX2D0tb/ouGAfeZvfrzfc6l11vs+j1mm8PppuDNqpvAQAA//8Z4eTuTQYAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.770637921 -0800 PST", "maxElapsedTime": "101.682049ms", "maxServiceTime": "101.63387ms", "minElapsedTime": "2.038687ms", "minServiceTime": "1.96442ms", "name": "DELIVERY_sumOLAmount", "node": "172.23.107.87:8091", "statement": "PREPARE DELIVERY_sumOLAmount FROM SELECT SUM(OL_AMOUNT) AS SUM_OL_AMOUNT FROM ORDER_LINE WHERE OL_O_ID = $1 AND OL_D_ID = $2 AND OL_W_ID = $3", "uses": 36723 } }, { "prepareds": { "avgElapsedTime": "212.808552ms", "avgServiceTime": "212.683913ms", "encoded_plan": "H4sIAAAAAAAA/7RVe2/bNhD/KsTNQG2AMPzIWkxA/jBspVPrSZ6ltigSQ+aki8xFJjWS6pKl2mcfKMnxIy6GbZn/sK27371+99AjoEhkimlc5EyAA0DhFpkpFU6lMErmGpwBBS5SvJ8U/CMqzaUAZ0xBsC2CA2EUTN/Hc/ejO48zNKGRyd1UlsIABVmgYkYqcB7hu/0DhPhbiSJBoPBnsuF5qlCAc30MmpRmIxX/w6IKxb/wHDPU1tWca1PDI6YyNOBAireszI0TLGfuMp57vgsUFop/AedNRc8A66wPMKtql8q/ytWz/IQJE2OgwDQ4IKFlDRwI5nEQe7N4Zr8+xd5sp4t5Cg4M0+HgdnQ7+P51+uZi9AN70hZK/oqJqQl/tBxsmXqI7/ABHKNKrCjc4YMuWGL7cFS67c1O0ZYMFHTBhK5zx3uWmMYLBcVEhrV4w7MNONAZ1ykkedk0e0ghl79bxQVYNnew0TFs/AQbHcGG34INoVpVKwql5iIDBzLNa8NDZq/QJJtDUv9JyafO3kkudr70sa/dQJxnTgpLuzXrdo2MtVFcZN3uWq7762Be93Td65GvX8kN9G+g/ncG5zW43rPEFkyxPMcc/tMUXvHcoAIKiRQpb+YGuvXnOFNySTrDHmEiJXvV7Ek16p3qgkZ3Uw4G44R0xjtA56KVXZIT7N6FXvfXYfzzh4kfedHnAy+vzxDhCW44y98qWRa2U1mmMGPG7v01JPasdFOuDReJIae0wopCZg3bXl2vqlX1PIBBtcWUM4MvFeV0ZLl4uQr+l0FpWV409wUoKNRlbmJLTXMg6hWZ+lHcJgcU8L6wtn9XQnWej10s25LnXQmNQratbUHzTNRvIFvaYQoOiHL7CyqoKBi8t+d8sXQXk6VLvvkSIlfL4CdCQnfuTiMyDT74UXfmhZHnT6Ou7Leuez0yCclBrNZsf2CIJJ7vu0vyLvD8JhzRJPDJe/dzSLpREIfR0vPfNj7tltU34FX/lf0hJ/o25qcf3aVLnizqrSQTf9aIZq1otBfZ1dov4Tk5XpLORa3Q/f3S7VcOqr8CAAD//017xu/zBwAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.850133389 -0800 PST", "maxElapsedTime": "443.820939ms", "maxServiceTime": "443.760285ms", "minElapsedTime": "79.936102ms", "minServiceTime": "79.884883ms", "name": "STOCK_LEVEL_getStockCount", "node": "172.23.107.87:8091", "statement": "PREPARE STOCK_LEVEL_getStockCount FROM SELECT COUNT(DISTINCT(o.OL_I_ID)) AS CNT_OL_I_ID FROM ORDER_LINE o INNER JOIN STOCK s ON KEYS (TO_STRING(o.OL_W_ID) || '.' || TO_STRING(o.OL_I_ID)) WHERE o.OL_W_ID = $1 AND o.OL_D_ID = $2 AND o.OL_O_ID < $3 AND o.OL_O_ID >= $4 AND s.S_QUANTITY < $6", "uses": 3692 } }, { "prepareds": { "avgElapsedTime": "3.686597ms", "avgServiceTime": "3.563672ms", "encoded_plan": "H4sIAAAAAAAA/6RV7W6bShB9FTT3SrElFN04P67EPwJEXcUfCEglJ7EwwhNnUwzuso6SJvTZq1mgXuoEV62ExMzZwzBzZnb3FTBPixWu4m2W5GABmHCPidwJdIpciiIrwfrPBJ6v8Nne8s8oSl7kYJ2bkCcbBAt8ez7xplG8RunsSllsUFy8tBZbgQnFFkUiCwHWK/yzdyDErzvMUwQTvqcPPFsJzMG67ZLsnXwoBP9GrK3gTzzDNZYUasxLqehRItYowYIV3ie7TFrOdRjNJl4AJviCP4H1f7Wo2p/8URZX+BKmSQ4mfMGXEiy4HQwGA1nEpRQ8Xw/+PRsab2/GHZzegbK0pdHw47Xz4XABldn92SXK9KH51TZJSWStIpK9hZuCDyL4iUiyDDP4q6JZziVPMl8Uj5hKMEFguctkLFFsSsXG5y0RB8s2v+Xp0omZuxyqlN5fvmRBGPUyJsx1x14vZWwfiRFGgedF8dnvkEa9JIdF8yNR7Kg/2xvm9677n2bT/gghmzr9DCfwXNavSU2Jx2zSS3NZ6Myup/2xLuyxfSyleeTGzfHQX35zhDhHeK4d2URYHOwYnu/ntFpU9PxCCaXAZKO+hZKvc3XG0bb4WQpY8FgWtMfrnnd8pdwhQlrqKGXY8RspdUzNvw4wV/dosnW/3gw6osnVgWmIdEDNTAegQe0C9SZ5BxvpmNZIHb5hfutWJkh8pkPYDzzfDjzjyL1gXAaziRF6Y8+JDNLANBppyKiLJovkoHebqmaPyKZO1ZgdqQ9umE8vpYZaIBUUU3Vsb1HvyGt7RHYzCmRqNat4e9HVR3Zk1yW0E2pch55x5c1D4/bwYjg5PaFX91r4YOF8ODQWUP0IAAD//xWSRPqbBwAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.893537123 -0800 PST", "maxElapsedTime": "68.246491ms", "maxServiceTime": "68.194709ms", "minElapsedTime": "689.441µs", "minServiceTime": "635.068µs", "name": "PAYMENT_getCustomerByCustomerId", "node": "172.23.107.87:8091", "statement": "PREPARE PAYMENT_getCustomerByCustomerId FROM SELECT C_ID, C_FIRST, C_MIDDLE, C_LAST, C_STREET_1, C_STREET_2, C_CITY, C_STATE, C_ZIP, C_PHONE, C_SINCE, C_CREDIT, C_CREDIT_LIM, C_DISCOUNT, C_BALANCE, C_YTD_PAYMENT, C_PAYMENT_CNT, C_DATA FROM CUSTOMER USE KEYS [(to_string($1) || '.' || to_string($2) || '.' || to_string($3)) ]", "uses": 15744 } }, { "prepareds": { "avgElapsedTime": "3.391617ms", "avgServiceTime": "3.26726ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBD9KuI2aAKitBt0oP9M7I6QNsksdSOkwRHOJVHrSJ6slHSN99mHnB9212V/bGCQdXq6e+/x9AKoUzPDWZJnUgMDoDBH6dYWO0Y7a7IC2AUFpWe4CXL1FW2hjAb2kYKWKwQG/ehbMojDKE6ukgU67kz62NVzAxRMjlY6Y4G9wLt6Axy/r1GnCBR+pkuVzSxqYOPXoGDtlsaqHx6VW/WkMlxg4VvdqMJVcCHtAh0wmOFcrjPHuBh0ekBhaNUTsE/lpDxM+CcKPXzmqdRA4RGfC2AwbrWcSQpnlV603n9ok+2W3MP5PVR/jaPLdnsCJX3d7hpdutw3y2XqzTsQ9l4eansxb64PpZVZhhn8l6auVk7JbGjNA6YOKFgs1plLHNpVUaFxk3tga1qRm55PefLlLuiLrhhN2xWrPyDCQASnT0ciPH24C0+nL05D4uh2IKK/Y8IuF8nFlQdM3jivdC25nJT++w3CnUW5qu5CoRa6egPe4Z02YPBQGB+F46Rm6aihWTy41qzVSprVkQgP25KCw40P9TCOhkEckVMPjFzHg1vCo5uoI0g9jZIdY7+OROiXIzu/qRlUyJ2WfS9vJrnjEelFI07GYpBwEXf7n33Wt1tydn7mc94oX/qY/woAAP//p0H3DUUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.952617435 -0800 PST", "maxElapsedTime": "59.227643ms", "maxServiceTime": "59.178247ms", "minElapsedTime": "540.742µs", "minServiceTime": "490.706µs", "name": "NEW_ORDER_6_getStockInfo", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_6_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_06 FROM STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "uses": 42768 } }, { "prepareds": { "avgElapsedTime": "13.725261ms", "avgServiceTime": "13.60921ms", "encoded_plan": "H4sIAAAAAAAA/6RUYWvbOhT9K+K+fkhAPF5iHusE+5AlLgukTbCzlTKCI+wbR60ie5LctSvebx+SEydpm1G2LwbpHB3de+6RnwBVWmSYJaXkChgAhRVyW2kcFsrqQhpg/1EQKsOHQSm+oDaiUMACCopvEBhMo1EYJfF8MP8cJznaCTd2qjPUQKEoUXNbaGBP8M9+ATF+q1ClCBR+pmshM40K2Ndj0qCy60KLH45VanEvJOZonNREGOvpc65ztMAgwxWvpGW+mBgozLS4B/auXtS7K/6ohjeRxs6cOOUqgK1T3pbkOhmPkpH7DJPxaIclIgMG/f/f91ar3nkvyM6DFfZbtNTFLabWm/zk+t5w/Zjc4SMwqyusKdzhoyl52nrv2nWz2G1uvQAKpuTK+HLxgae2UaCgucrRb69FvgYGZz1/fSqrdriy+N4ANd3T+qdo/SNacIoWQL2oFxQqI1QODHIj/MFDMy/Qpmt4e5fPz8+45lKihL+a+4WQ1ic4LVQmmmlAp9PpLJtilv8up36+yy75QM56XcJVRo7hUQv3u6/hwxYPut0XfYyVsILLWRMHoKDRVNImFvVmN9PSEY80naKXeg0cDqJoHEa/J4VX8+gm8YxFvajdAzoubPe2pdgI9/RcdkyhDyvL0KS7sJ2u8oXyxCu2R3ovsyHU3hFX3DM8thr5xiuDEbny/zE3/8PegcGtKRRQaJs93NoTagoWH1yLsyicDaKQnPzVkYtoeknicBIO58RpUHJ4pVttr2qYjRfk+lPoVH2QfIzI4GpEmuT43GzXw+06aA6Sjzf+EjIK4yGZjC/Hc9KD+lcAAAD//x5dao3MBQAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.793086482 -0800 PST", "maxElapsedTime": "132.235164ms", "maxServiceTime": "132.18336ms", "minElapsedTime": "1.554037ms", "minServiceTime": "1.462821ms", "name": "ORDER_STATUS_getLastOrder", "node": "172.23.107.87:8091", "statement": "PREPARE ORDER_STATUS_getLastOrder FROM SELECT O_ID, O_CARRIER_ID, O_ENTRY_D FROM ORDERS WHERE O_W_ID = $1 AND O_D_ID = $2 AND O_C_ID = $3 ORDER BY O_ID DESC LIMIT 1", "uses": 3644 } }, { "prepareds": { "avgElapsedTime": "11.669003ms", "avgServiceTime": "11.524445ms", "encoded_plan": "H4sIAAAAAAAA/6SUUU/bMBSF/4p1xgPVrGm0QgNLPHQkaJUGq9owhKYqtZLb1MN1MtthMJT99ikOhdGySWxPVe89uT73O7LvQCYrc8rTSksDAXAsSPra0nFpvC21g3jLoUxON8NKfSbrVGkgBhxGrggC4+HlaXyWpHWVS0+Rct6qzL+XWpqMwFFWZKUvLcQdXj3+wZS+1dRJfmZLpXNLBuLLU9Gw9svSqh+tqrLqWmkqyLWjPirngzyRtiAPgZwWstZeRKNpMhkdJ+AYW3UNcdDMmvUh/+Ri1G4/zaQZ4B4FBKJROorSi3QUrYupyiFw+E7u7x/0F4O9w0W+n+89dCtbfqXMB3x37TYraW/TK7qF8LamhuOKbl0lMwrTH5ZoOa/L9zuCw1XSuOCUbmTmuxkcVpqCQnmpiiUEdjrPma4fgtPl967R8EdZ/0+yPppZM+OonTIFBAqnwoe/AxpLK7Umjf/CfEI+W+IlGDZ9nCjtyYIjK02uOtTY3d2dr+fM38y7zOY9dsR2+j0mTc42Bev2oNfbOuJYl4a2qlMKmZBPPdlVl0slfUt2Y/ZlEs174LiWuqbg7pk+e8129not+K1zTH4eLho4pFbSPYX0AnSzZnN4pFwmbf5ca+otyVUwBKcKE14ICFNrzeHppr1/40k8Hk5i9tcHgZ1MPp2y83E0TGK2tsimccLC6uzo/rcFwC4+xJOYdYGxkBcbnkWsDSjEg+ZXAAAA//+mw6QHwAQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:09.955361099 -0800 PST", "maxElapsedTime": "88.525399ms", "maxServiceTime": "88.472935ms", "minElapsedTime": "1.681393ms", "minServiceTime": "1.625828ms", "name": "PAYMENT_updateDistrictBalance", "node": "172.23.107.87:8091", "statement": "PREPARE PAYMENT_updateDistrictBalance FROM UPDATE DISTRICT SET D_YTD = D_YTD + $1 WHERE D_W_ID = $2 AND D_ID = $3", "uses": 39561 } }, { "prepareds": { "avgElapsedTime": "10.479845ms", "avgServiceTime": "10.352578ms", "encoded_plan": "H4sIAAAAAAAA/6STUWvbMBzEv4q59aEFMVK6tkOwh9C6NNCtwcnmwQiOkP+11SqSJ8ldsuB99iGnSdcMBtvAL/rrfL77yVqDjLQllUWjhQEHGO5IhNbRhTXBWe3BBwzKlLQcNuoTOa+sAT9hMGJB4PiQ5sVtdplmRUUhF45q23qaimUmAoHBNuREsA58jVfPC0zoa0tGRskPWStdOjLgX16Khm2orVPfo6px6lFpqshHqxvlQy+fCldRAEdJd6LVgefDLL2+/ThJwTB26hH8vJt126/8U4xRrD+RwpzgiQU48utidLldF6oEx/nJ4PTt4FSek3wzOCvPdruNs/ckQ49uHZsshFsVD7QCD66ljuGBVr4RMhL9tUCEvJ0/FQSDb4TxfUpaChk2JgxOmIr6ca2qGhwHx30CqdvdqWn7bbPRzboZQ+uVqcBReYWOvWx9RUHW+Kto+xZj4YTWpPFf+K+UDuTAIK0p1YYiDg/nuzTz1/O8GF3Oj5J3ycHx0W8xRkYFJfR4cwpgcORbHYpAbrHl2EThvud0+Hl+FFHto1Hm2a6bdfHZk0yCI7Ho34VXlekvVazfu4Lj3luDjiHQMv6+4ywdD7M0+eN9Sq6y2/fJJL1JL6ZJb7SZ7FIn+XWapUmk0bNA9zMAAP//ZXS+iuMDAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-04 15:14:10.023307273 -0800 PST", "maxElapsedTime": "87.231788ms", "maxServiceTime": "86.368019ms", "minElapsedTime": "908.738µs", "minServiceTime": "836.876µs", "name": "NEW_ORDER_getWarehouseTaxRate", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_getWarehouseTaxRate FROM SELECT W_TAX FROM WAREHOUSE WHERE W_ID = $1", "uses": 41252 } } ]