[ { "prepareds": { "avgElapsedTime": "15.479944ms", "avgServiceTime": "15.409444ms", "encoded_plan": "H4sIAAAAAAAA/6SUb2/aOhTGv0p0bl+AZF1dyL13laW9SEnQkGhBCV01TShYyWlwG5zMdroylH32yTahjLXdpr1pY/vn5zznD94BiqzKMU/rkgmgAARukelG4qgSWlalAjoYEuAix8eg5u9RKl4JoP8SEGyDQGEWh1GcJotgcZ2kBepRo3S1QakutlOm9JWhHKxqlpkbOd6yptRAoKpRMl1JoDv462kBQaPXleRfzM1a8gdeYoHKUFOuNNCPO1gwWaB+UqOj62Qxu4xiIDCX/AHom3bZEviarXmZnwZI8FODIjP6DpAorOwxNDFJJxkTPuwrABRG1+lNOgnT0PyZBsmiO0t5DhTO82zg3577//2TDf/3GTuc1rK6w0zb4u1MUhsmt+k9boFq2WBL4B63XYWOcnm+cKpmQlnD+Mgy7TQISCYKtNtrXqyBwtnAGsjKxrXNJ1BWn91BS56w4UvY8DvMfwnzoV22SwKN4qIACoXi9uJxOceoszX8Tp6nCnMmWVliCX/U1jEvNUogkFUi564j0Ov1eqvOzurv1ch2edX33npng77HRO6dAuEBGPafJ8x4OMLv93/IZiK45qycu8EAAhJVU+pUo9x0va0NeKJqolqx54/Hk9hEfYW4nIThNHoVcc5fAS6CaXA1siLLdtme5jaTuS2xquTPEzo4Xp7KJFoi24ANAIoXwj5NpusHB0DhTlUCCOyFjjcm4fHK/lqP1q4O3U5LQOOjeVHmcTQP4sj7hZfNG8ezSy+JptFo4Zl4xNvbMB8ugPkyoc3/vWl3rSuCd/MuiiPPjZwdOC+4Cj03YXa+9mujYqfJWfMuPnTRoP0WAAD//z3+IW7LBQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.158720204 -0800 PST m=+4882.649598937", "maxElapsedTime": "227.755453ms", "maxServiceTime": "227.722351ms", "minElapsedTime": "1.661291ms", "minServiceTime": "1.617216ms", "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": 2046 } }, { "prepareds": { "avgElapsedTime": "7.890153ms", "avgServiceTime": "7.810861ms", "encoded_plan": "H4sIAAAAAAAA/6STb2vbMBDGv4p4VmgCotA/G8OwFyFxYWRNMtvZCGlwhH1NRBXZk+TQLs0++5DTLX8Lg707nX56dHrutALprMgpT0slNAKA44GEqwy1C+1MoSyCyysOqXN6apXyGxkrC43ghkOLBSFAL/ye9qNOGKVVmQtHsSuyR2y2bSkyz+T0ICrlwFGUZIQrDIIV3m0XaFVuXhj5k8BRGrmUimZkPfVFWodgvEIizIzcVi2Ik367C46BkUsEH9eTNcevbC5Vfqge04+KdObFN4AhXWvuQl16jjOhwfFIzxYBxo2GK1LrjNSzxtmHJnt5Yfe4uEcd7Wy9bzYnWPN9uYEwQilS+K+ibsll89eSXs388+xTBh8W0VaFpqNsTL4VllzqyCxsfWkp3BwBGtNafnoxjdOvw1Yv+ZyMpk1wLIWq/E1nl7XcCXyUdPbJq7fIzbi0e8k+f/0WH4V3/SQ8PnAD3/PDt+l8WA8iOISSwu5Y9q8uTtaHsh1pM2HyYyudIbHYnICVM11/HgS6UorD0ZMf2EEUDlpRyE5+FXYb9e/YcNBpJSGrq2LDOGTdcBSz8dH8nV+cHw3fhMVhwrb9Yp/Y2SVndUd8fOXjv577zLXPbF31qRusfwcAAP//j15reA4EAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.8761699 -0800 PST m=+4883.367048848", "maxElapsedTime": "686.788222ms", "maxServiceTime": "686.753831ms", "minElapsedTime": "716.82µs", "minServiceTime": "680.112µ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": 384531 } }, { "prepareds": { "avgElapsedTime": "10.854291ms", "avgServiceTime": "10.793628ms", "encoded_plan": "H4sIAAAAAAAA/6RTX2vbPhT9KuL8+tCA+LEkhYJgDyFxmVnWhNi0g1Ec1b5x1CqyJ8ldu+B99mG7XkK6PYw96t6j4/PH2oNMWmSUJaWWBgLg2JD0laVpYbwttIMYjjiUyeh5Uqobsk4VBuKCw8gdQSCKF9OPyTy4CeZJTn4RZuh2rpRpA8hoIyvtwVGUZKUvLMQe/x0OmFR+W1j1ncBRWvWkNOXkGtRcOQ/xZY9Y2pz8gU3MwihehdMYHEurniAu67ua40e6VTo7/UBEXysyacPfASyZlvYYFDYeo1SaMV4NQ2AWJuEsuU3CWT9MVAYBObrYpKN3m3s5HmeX9/LXtrTFA6W+DWnfuNlJ+5I80guEtxXVHI/00kdzZOL3iblSGtcqpWeZ+o6Dw0qTUzveqnwLgbNRKyDVVVfPmEMX37pFzQ+w4Z9gQ9R39R1H5ZTJIZA71V48DuiKfLrF3xg4ZVhKK7UmjX8q6kppTxYcaWEy1UWN8/Pzda9m/f+662w9YO/Z2XDApMnYKaBfjwaDN0JDo7ySetmVCQ5LrtI+8WR3fR9lAzzhvA4+x8mipW4DrU+JI29J7tBu4FRu2sfWxHB0GQIPrjCoOTw9N3/9chUsJ6uAvX1s7Gq1+MSiYB5MY3bE0c17cez2Q7AKWJdKmwmbXM/Y7PU0Qv0zAAD//yBTNVYLBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:58.094668727 -0800 PST m=+4881.585547471", "maxElapsedTime": "217.587736ms", "maxServiceTime": "217.531988ms", "minElapsedTime": "1.27385ms", "minServiceTime": "1.204905ms", "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": 3418 } }, { "prepareds": { "avgElapsedTime": "8.783536ms", "avgServiceTime": "8.702775ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9YdUhPJQoJ21WRpD1lI99DSRiRMQhQFK7kFa8bJbAe1o+y3Tw6w8lEmTXuC3K9zdM7xClDlZYFFVkmugAFQeEJua41hqawupQHW6VIQqsDnoBLfUBtRKmBXFBRfIDCIg1E/uk+zuiq4xa9hWBtbLlDDZsJUPHdjBT7xWlqgUFaouS01sBV8ePuAoLbzUoufCBQqLZZC4gyNm7oTxgIbryDleob27RoLh0n60I8GQCHWYgns03qypvArnwtZHAMk+KNGlbv7mwGNqjm7P3SLL0nOFVD4ji8GGIw9z/NsmRmrhZp5rSufvL6SR2g/QvNvr/XRP9+79v0JrOkhWMw1lxIl/BflG7T5fEt4q/aeLu+ZcMwjlKXCk2qCzi6DNrOoF6bBrbidAwNvukOYtqdh9iW4C+7DaOoDhSWXtcNqdZqD7y+M0l62Dc7hUvcvS7ukhcdLl+BcPyavimETSaDApeDmUJZ/EGuyPj7eEybnujhVzGrki80GGDFTzVMCpmopKVh8dtmNB1EcDCJy7uGQm8FDnwzjXpBGZMeNDJOI3EajhIxPw3jRvnA/h1E807j2fTIhSZSSP7aRz6TVoeTAFVfrutqe6K52CevfAQAA///L4EneNQQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.600523701 -0800 PST m=+4883.091402413", "maxElapsedTime": "523.594873ms", "maxServiceTime": "523.553605ms", "minElapsedTime": "797.302µs", "minServiceTime": "759.433µ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": 33298 } }, { "prepareds": { "avgElapsedTime": "4.796809ms", "avgServiceTime": "4.7265ms", "encoded_plan": "H4sIAAAAAAAA/6SSUYvaQBSF/0o4FTaBYSHal86b1LRIt4kk1qWohCG56w4dJ3ZmYm01/e0luq6p7D7tU+aec7j3ku/uQbqoSirzjRIaHGB4IOFqQx8r7UylLHjYZ5C6pN1wI2dkrKw0+HsGLdYEjji6z5N0FKV5YUg4iulXYkoyOCXsRhRtrKQHUSsHhmpDRrjKgO/x7lJgWLvHysg/BIaNkVupaEW2Td1J68Dne0yFWZG7dOPPw8EwMXIL/qFZNgx/i0epyusJGf2sSRftgFPAkD727YZmQtWUFUKDYdu+LTjmc9/3fVfl1hmpV36vH3iHg7fA7QLHV8caBK97YRAwb79AnOSjfDxagHu9PvOOQnIWwifh/iwMmuUSDft/z4kwQilSYFiL3bmSdg0evukHZKTLsbZkWlhCSWG7lMHwg36fqXbll2hfLz2SthCmRLNsrq3MGRLrkwMrV/p4huC6VorB0a7lPkmjyTCNvNeOzvuUJl+9cZxF6dQbx9PkkvS/RN+ZNxvefYuC0yfzp0meTdNx/LkFejh4N7c3LbCOPHhZDp8xPlHrhaxLtddnXYS9QROg+RcAAP//qdO28G4DAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.532459193 -0800 PST m=+4883.023337994", "maxElapsedTime": "637.992022ms", "maxServiceTime": "637.954189ms", "minElapsedTime": "461.71µs", "minServiceTime": "425.586µ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": 38462 } }, { "prepareds": { "avgElapsedTime": "4.611153ms", "avgServiceTime": "4.538472ms", "encoded_plan": "H4sIAAAAAAAA/6STb2/aMBDGv4p1m1SQrGpUkyblXUTSCbUFFrubEEXBCge4DXZmm4oOss8+OeFPhsre7JW5ux9PHj+5bAFVpmc4S4tcKAgAKMxRuLXBrlbO6NxC0LmhINUMN2Ehv6OxUisIPlNQYoUQQD/+kQ6SKE7STrpAx5zOXnpqrqEmbCEyj81wLta5Awq6QCOcNhBs4cOpgHDtltrIXwgUCiNfZY4LtJ66l9ZBMN4CF2aB7qQWMD7o3gGFoZGvEHwpJyWF39lS5rNzdYY/16gyL14DBlWl2YTu8I1lQgGFF3yzEMC41XI6tc5ItWh9vGmT3Y48wfUTVL8ao067PYGS/i13iy5b7sX2MRwMvxfN+d+Hwog8xxz+6049JZ0U+dDoZ8x8/gbtOnepQ7OyFY2bwoOtaWVuej1l6bfHsM97fDRtV67eIaKQh5enIx5dHtbb0u3zy0gSPwx4/G8m6jGefup4YFJOyvP0mDMoVlBNwMqFqtbaR1ibhwCerfbv+ijVbB1NNpuHWJq9k9Vmd8SjQ1lScLjxWztM4mGYxOTSJ0Nuk8EDYfF93OXk9DRKasf+HPHIH0d3vjg5qMj6LnstnxZ5ZDG5i0eMjPkgZTzp9b/6Zd7tyNX1lV/kRrvj9/hPAAAA//9PZIriGAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.866878784 -0800 PST m=+4883.357757537", "maxElapsedTime": "657.727959ms", "maxServiceTime": "657.689466ms", "minElapsedTime": "488.842µs", "minServiceTime": "453.107µ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": 38866 } }, { "prepareds": { "avgElapsedTime": "4.785693ms", "avgServiceTime": "4.700366ms", "encoded_plan": "H4sIAAAAAAAA/6SSb2+bPBTFv4p1n0gFyaqUtM/W+R1K2ITGIALWqmoiZMFtas0xmTFVt5R99gmI80/tq73C55yri+Xz2wKqoiqxzDeSK2AAFB6Rm0bjtFJGV7IGNp5QEKrEF28jblHXolLArikovkZgEPl3eZzM/CQvNHKDsS5RwxDXG150MyU+8kYaoFBtUHNTaWBb+O8gwGvMU6XFbwQKGy2ehcQV1t1UKGoD7GELGdcrNIdtrP9rChTmWjwD+9QuWwp/iichy/P1Kf5sUBXd9mFAo+qXHg/dctlgWnAFFJ67cw0MHh4cx3FMlddGC7VyRlcueX0lC7hcQH86iibu+9nYdSnZLiDOvTDMw3jqhQtgZHRDSWdOvSQJ/CQPZr37YedafT3omdWTQftRltzng/X/YO0GxoOKw3waZb3zcXDu7MRVu1xCS0+fYM41lxIlUFjzF6tEvQY2/qe3TVGVgapRdxBwKXj3tvsCf+Avi8ree4uf8+vORF1wXUK7bM+j1Gjk6yGBWqxUTzUw1UhJweBLR9I88ede4pM3GSafk/gbCaLUTzISRFlMhrsR56t/T8mtF3733eGTEieL8zRLguiLJeTi8qL7kKNg8l4wtmz03djydm3bsnfNja5O2LBoHFCwJJwgZYnaA2F5OKZxdNO60P4NAAD//0a9eiAVBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.529061032 -0800 PST m=+4883.019939775", "maxElapsedTime": "500.70615ms", "maxServiceTime": "500.660024ms", "minElapsedTime": "513.655µs", "minServiceTime": "474.299µ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": 38462 } }, { "prepareds": { "avgElapsedTime": "4.425844ms", "avgServiceTime": "4.356128ms", "encoded_plan": "H4sIAAAAAAAA/6SSUWvbMBzEv4q57aEFMegYDPRmUhVMm9bY2cYowRH2P446RfIkuaQL3mcfsjPapdlTn4x8v//pTtIeZGrbUFN1WhpwgGFNMvSOZtYEZ7UHv/jIoExDu7RTX8l5ZQ34JwYjtwSOW/GtuisuRVG1FLJA28ysLSbZd7KOTENr2esABtuRk8E68D3ePS+Q9mFjnfpFYOicelSaWvKRulE+gN/vsZCupfDsxrOFmIMhd+oR/POwHBh+1xulm2Pzkn72ZOroPQGOzGj5Erqmp7KWBgw/6MmD4z7YygenTHv2/uJ8iYH9O3BFod4c8EPPQ6JT1Y+nc+mk1qTxptCZUUFJnTv7QHU8X0e+16EK5LZ+pGnXRfBsFbOtPqyyKi+ymVidj4leq7fp/P/iZbpIo7gclsNxoTI4kluMCrxqzfiMYqtpDhwP3sbznTZ5uR4j/f0xMATaxYvOC5GnhUhOPrHkqribJ6W4EbNFcrBgyeQdv3HPiYnxky+lSK7F9zJ5da1/AgAA//++ILy7BQMAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.430853849 -0800 PST m=+4882.921732587", "maxElapsedTime": "776.658649ms", "maxServiceTime": "776.615584ms", "minElapsedTime": "426.524µs", "minServiceTime": "393.973µ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": 384531 } }, { "prepareds": { "avgElapsedTime": "19.126029ms", "avgServiceTime": "19.050375ms", "encoded_plan": "H4sIAAAAAAAA/6STX2vbMBTFv4o460PDxKB/WIKgD1nj0sK6hiRdKCM4F/vG0arIniR37YL32YftNu2SMih7MpaOzr3nd7lrsE3ylNO4MGShAIkFUygdn+Y2uNx4qINDCW1Tvu8X+is7r3MLdSxhacVQGPZvLqMvk7gsUgo8JcfLvPT8iQzZhNHqfEFJLU55QaUJkMgLdhRyB7XGu+cf9MuwzJ3+Vb8snL7ThjP2teqz9gHq2xoTchmHZzc17Y+i86vrcQSJodN3UL1qVkn8TpbapNsVxvyj5La1VuDYNr4vRRd14HFC9giP6aEwPY8vBk//sU6h0Ot2F3zc5cXi+GO31zvY3BYu/85JaGCt6yQrcg/xLT9ABVdyJXHLD09YXgZ4HZcvyPqmS76nJLQmEo5sxs3xUmdLKOwdNh0kpmzndCRh8p/tRTWrZhKl1zaDQuY1Kvl36iE5MoYN/ovdGYdkiTcF3G7kTJvADhJJblPdUsT+/nzjM/8wn8YXg3lHnIi9w86OwanJLe+cjrlhySEO7FYtz4JCDW7b+2YymHcgcUem5NeKNwLxXuwddGqyO5Vset1sBCTIaPJbFN4CZ1Zt2w+0T8iluwGDY1q1L+B1ZptdhrKlMRKB7+u1GY6iYX8UiX9vrjgbXV2K6+GgP4nEpkUxjiaiCS9OHr81AjE9j0aRqEfSDATVnwAAAP//ST33z1sEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.556545181 -0800 PST m=+4883.047424008", "maxElapsedTime": "591.410027ms", "maxServiceTime": "591.340452ms", "minElapsedTime": "1.418135ms", "minServiceTime": "1.382033ms", "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": 36879 } }, { "prepareds": { "avgElapsedTime": "9.960964ms", "avgServiceTime": "9.882376ms", "encoded_plan": "H4sIAAAAAAAA/6RS0WvbPhj8V8T9CrX5iUC7PgzBHjzHhdF0DXFSKGlIhP01EVMkT5JDuzT724eTdk2d5WHsTZbOd/fdd2uQKWxJ5bTS0kAAHA8kQ+0otSY4qz3E2TmHMiU9JpW6JeeVNRAXHEYuCQLdrPflNhvcTeuqlIHS2ge7JIcdwFeyaFAlPchaB3DYipwM1kGs8d/bB5I6LKxTPwgclVMrpWlOvkH1lA8Q4zWG0s0pvLGJdJQPb66zATj6Tq0gPm4mG46fxULpsi2Q0/eaTNHw7wCOzJZ2H3RFT3khDTi+0ZOHwDiKoijYqQ9OmXl0chGz52d2j849tqe9pw/x8bfzOJ5gw9+L9aWTWpPGP1m+pFAsXgy/pL2Xy5+W0PaRamvo4DanZl2ewjSQW/qtbiXDAgLR7FVh1pml089JL/maZrMYHCup60YrOoZh/7OTsxjNotp6phxtOwQOqZX07yf5i/kmmzZ5V/lCuvJwyOBILnd/wKu52ZYfwtRacwR6bOrWH2T9ZJCxI1Vnl4Obazbqd5Nhxl6tsVGesavsLmfjw/qcdk4PurN33y4Oy7Mh+x0h+7R3bsLE5lcAAAD//ytymAjIAwAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:18:01.107288969 -0800 PST m=+4884.598167790", "maxElapsedTime": "1.332102861s", "maxServiceTime": "1.332037325s", "minElapsedTime": "812.218µs", "minServiceTime": "774.069µ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": 34614 } }, { "prepareds": { "avgElapsedTime": "58.592118ms", "avgServiceTime": "58.513099ms", "encoded_plan": "H4sIAAAAAAAA/6SUUW/aMBSF/4p11geQrGktTGKW9oCaVENiBUFbNE0oePFt8GqczHG6dij77VMSKC2Uh2ovkXL9+frcc2SvQTZOFakoM9JCABy3JH3h6Dy13qUmhzg949BW0UM/0zfkcp1aiC6HlSuCQBAOBzfh5FtUZEp6GjlFbqgtoSHyTMYVpuhWFsaDI83ISZ86iDXe7X7QL/wydfpPtTNz+l4bSiivqKHOPcT3Na6kS8jvuonRJAgn0XBwGYJj7PQ9RK+clxx/46U2av+IKf0qyMbVCQ3gyNaNn0ODatZpLG0Hm8EhMBpGo2gQREH1mUWDYLsWaQWBjzKOP/zodXqfVE/1brtPq5lLf1Lsa8/W1Vgr6R6jO3qE8K6gkuOOHrcevZjmdfPyTNq8lkwPMvZNFw4nbUJ1eamTJQROzmoJsSmavDocJv3dLJR8h3WOYZ0XWPcY1kU5L+ccRa5tAoEk1/XG54aOpZPGkMF/xXJBPl7ibX7tK7nQxpMDR5xapZtU0Gq1Wotdq8X7xSbsRZt9ZidnbSatYq8wwRPTaR+FZk9Qt90+EHRuUksH1SnVUZOPPLlVE3cmfZXEKyq29y9YtMFxL01RWXByWiVz0Niq6/qagkMaLfN9F9/k7rzcPyDQeSydOpzIO5KrZgdyndj6jYGwhTEcnh6qSz2ehOP+JGTHXhR2MRl9ZdfjoH8Vsp06Ng2v2AsjKrdP2exLOAnZJss6Sda/DNgmuDq2bWG2KXRR/gsAAP//cSyc5xMFAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:18:01.070369986 -0800 PST m=+4884.561255726", "maxElapsedTime": "725.353178ms", "maxServiceTime": "725.296906ms", "minElapsedTime": "4.842805ms", "minServiceTime": "4.805289ms", "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": 34614 } }, { "prepareds": { "avgElapsedTime": "10.954408ms", "avgServiceTime": "10.880389ms", "encoded_plan": "H4sIAAAAAAAA/6STUWvbMBSF/4o460MDYqxJoSDYQ6hdZuja4ISlMIqj2jeOWkX2JLlrF7zfPizPbci6h7FH6Ryde+930Q5k8qqgIqu1NBAAx5qkbyydV8bbSjuIkzGHMgU9TWv1haxTlYE45TBySxC4ipfZdRrFaVaSj5TzVuUevexqmXeegtay0d1tVZOVvrIQO7x7PWDa+E1l1Q8CR23Vo9JUkutcl8p5iK87LKQtyb+miSiZL9LkfAGOmVWPEGftbcvxM98oXRwWmNO3hkze5fcGSybE7puSbsx5Ls0Ev2eGQJRkSZQtsyQaLjNVQECOT9f5+MP6Tk4mxdmdfFFrW91T7gOnXTfNVtrn7IGeIbxtqOV4oOcBzd4QbxNztTQudEpPMvd9BoeVpqRwvVHlBgJHJ6GBXDf9hiYcuvreCy1/tY3/ZhujvW1vORqnTAmB0qnwcB/QBfl8g38Z4DBhJq3UmjT+a1EXSnuy4MgrU6geNY6Pj1dDN6v3qyhLotWIfWRHJyMmTcEO5eWLYTwa/dFoYpRXUs/6ZYLDkmu0zzzZ7bCPujMepC6mN6s+7W39Kr5ZZNehdADeHhaee0tyi6DAqdKE/9hh2nsMgXtXGXCEisOx5fD01H2SWRrPpmnM3vye7CK9/szm8WV8vmAhgLO98F4eumbLT3Easw5ngMmmVxHr6QV2aH8FAAD//1JGW6NHBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.446280352 -0800 PST m=+4882.937159155", "maxElapsedTime": "648.066066ms", "maxServiceTime": "648.033064ms", "minElapsedTime": "1.036664ms", "minServiceTime": "1.004585ms", "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": 38462 } }, { "prepareds": { "avgElapsedTime": "4.584031ms", "avgServiceTime": "4.510783ms", "encoded_plan": "H4sIAAAAAAAA/6STb2/aMBDGv4p1m1SQrGptJ03Ku4ikE2oLLHY3IYqCFQ5wG+zMNhUdZJ99csKfDJW92Stzdz+ePH5y2QCqTE9xmha5UBAAUJihcCuDHa2c0bmF4OqaglRTXIeF/I7GSq0g+ExBiSVCAL34R9pPojhJb9I5OuZ09tJVMw01YQuReWyKM7HKHVDQBRrhtIFgAx+OBYQrt9BG/kKgUBj5KnOco/XUvbQOgtEGuDBzdEe1gPF+5w4oDIx8heBLOS4p/M4WMp+eqjP8uUKVefEaMKgqzSZ0h28sEwoovOCbhQBGrZbTqXVGqnnr43WbbLfkCS6foPrVGF2122Mo6d9yt+iyxU5sF8Pe8HvRnP59IIzIc8zhv+7UVdJJkQ+MfsbM52/QrnKXOjRLW9G4LjzYmlTmJpcTln57DHu8y4eTduXqHSIKeXh+OuTR+WG9LZ0eP48k8UOfx/9moi7j6acbD4zLcXmaHnMGxRKqCVg5V9Va+whr8xDAs9X+XR+kmq2DyWZzH0uzd7Ta7A55tC9LCg7XfmsHSTwIk5ic+2TIbdJ/ICy+jzucHJ9GSe3Yn0Me+ePgzhdHBxVZ32Wn5dMijywmd/GQkRHvp4wn3d5Xv8zbLbm4vPCL3Ghf+T3+EwAA//8tNQXqGAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.66116233 -0800 PST m=+4883.152041139", "maxElapsedTime": "667.565716ms", "maxServiceTime": "667.494123ms", "minElapsedTime": "491.147µs", "minServiceTime": "454.976µ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": 37944 } }, { "prepareds": { "avgElapsedTime": "1.84720812s", "avgServiceTime": "1.847148418s", "encoded_plan": "H4sIAAAAAAAA/7RW72/bNhD9V4ibP9iAEMQ/0qYC8sGw1U2dJ3mW2mLoDJmlLjIXmdRIqksWaH/7QMmO5R9d16X7YsB37+4eH99JegQUTKaYJkVOBbgADtwiNaXCiRRGyVyD2x84wEWK9+OCv0OluRTgjhwQdIPgQhSHkx+TmffOmyVUaJ6hiYxkdxNZCgMNTBeUWWyKt7TMbVQWqKiRCtxH+G7/B8alWUvF/0RwoFD8E88xQ21RM64NuB8eIaYqQ7Pv5oaLqbdIZn7ggQNzxT+B+7JyzgBrqi3MsnLgL7bmeXpMI8LfSxTMsmgACkU9vA3yrSgRo2IIDlANLkjYSgUuhLMkTPxpMrU/7xN/usslPAUXrihjlx+vh9ev0uv0+nb0lC2U/A2ZqVV+tBpsqHpI7vABXKNKrBy4w4edoAdHP6+0LqjQNXe8p8w0XRxQVGRYh9c8W4MLnWFNgeVlc8N9B3L5h02MwKq5gw0OYcMn2OAA1v8crA/Vslo6UGouMnAh07wubCv7Gg1bt0X9miMfN5tTRfMcc3jWZQeoDaYzKYs3kgvLLec1PW3dLBKW01JbGt1udyVXF6twVt/6qkduSHelVxeraBvoESpSsof5x7Am0Os9j/GpPXXLnlFcs6ln9Q+t2b+6enk1HPZvh5S9GrEX/82au2U770pRy5nkUhY7R/5box7J+xmfHaNa3jwS/ksNtqivdK2G56hRLauT7jw3qMABJkXKm0uwZjvnt07/2GPTp9TgxH9hk/u1vLwcMtIZ7gCd0TZmnXmA3bdoDPvz23EQ+/EvrS4ver0TgXzBDaf590qWhdUpyxRm1Njn+wdg9n3RTbk2XDBDjuTvwdKBzBZav9mC5RmNfGFQbTDl1OC3mnJyDeLbneB/eVJtVZ43ywoOKNRlbhIrTbNftUEnQZxsyYEDeF/Y2i8doTqnemQU0g3UGdA8E/UHhOXenuGCKDcfUUHlgMF7+16eL7z5eOGRf/yEIK8X4U+ERN7Mm8RkEr4N4u7Uj2I/mMRdebFt3+uRcURa87Zl+7cFkcQPAm9B3oR+0IwkmoQBaZrY3SE3N0RfNI9pMg6m5Km9zdSpehZ5/4O38EirjnT6+4LpNjTYh+za7BfsXBxvSGdUJ+yY3ULt1wmqvwMAAP//+opFf60JAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:18:10.352704731 -0800 PST m=+4893.843583496", "maxElapsedTime": "2.79393919s", "maxServiceTime": "2.793900214s", "minElapsedTime": "336.427839ms", "minServiceTime": "336.370518ms", "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": 3418 } }, { "prepareds": { "avgElapsedTime": "4.539983ms", "avgServiceTime": "4.457831ms", "encoded_plan": "H4sIAAAAAAAA/6STb2/aMBDGv0p0m1SQLDQqpEl5F5F0QrTAYncToihY4QC3wc5sU9FB9tknJ/zJUNmbvjJ39+PJ4yeXHaBM1RznSZ5xCT4AgQVyu9HYVdJqlRnw27cEhJzjNsjFD9RGKAl+h4DkawQfBtHPZBiHUZx0kiVaalX60pMLBRVhcp46bI4LvsksEFA5am6VBn8Hn84FBBu7Ulr8RiCQa/EqMlyicdS9MBb8yQ4Y10u0ZzWfsmG3DwRGWryC/7WYFgT+pCuRzS/VKf7aoEydeAVolKVmHerjG025BAIv+GbAh0mjYVVirBZy2fh82/T2e+8JWk9Q/qqN2s3mFAryr9wd2nR1EDvEcDT8XjSXfx9xzbMMM/jQnXpSWMGzkVbPmLr8NZpNZhOLem1KGre5Axuz0tysNaPJ98dgwHpsPGuWrt4hwoAF16djFl4fVtvSHbDrSBw9DFn0fybsUZZ86ThgWkyLy/So1cjXUE7AiKUs19pFWJkHH56Ncu/6JFVvnUzWm8dY6r2z1Xp3zMJjWRCwuHVbO4qjURBH3rVPxruLhw8eje6jLvPOTyNe5didYxa64+TOFWcHJVnd5aDl0vIeaeT1ozH1JmyYUBb3Bt/cMu/33k3rxi1yrd12e/w3AAD//zpu0/cYBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.166803161 -0800 PST m=+4882.657682035", "maxElapsedTime": "681.654602ms", "maxServiceTime": "681.579046ms", "minElapsedTime": "479.009µs", "minServiceTime": "444.549µ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": 39032 } }, { "prepareds": { "avgElapsedTime": "16.123058ms", "avgServiceTime": "16.050768ms", "encoded_plan": "H4sIAAAAAAAA/6RVbY+jNhD+K2h6HzYSqpqkLyekfmCB1SHlBQHb024VsRZ4E98RQ21z3e2K/vZq7LBxcnukVb8knvHj8TzPjIcXoLxsKloVbU04eAAuPFKiOkGDhivR1BK86cwFxiv65LfsNyokazh4P7rAyZ6CB4l/t4xWebGlKuikavZUyOvnBZFqhQCDky0pEVzRR9LVClxoWiqIagR4L/Dd0QC/U7tGsL/wZCvYF1bTLZWIWjCpwPv9BXIitlQdo3nBbZavl1EKLiSCfQHvl37Tu/B3uWN1dX5BRv/oKC8xvgEIynVYGxQj36wkfA4H8uBBcFt8LOKwCPFn4Wf5sFewCjx4X5XT+eP7+U8/lLOf54S87rai+URLpXV7QVJ7Ip6Lz/QZPCU62rvwmT4PCllc3hZOtoRLnTB9IqUyMVwQhG+pdu/YdgcevJvqBMq6MxWbu1A3f5qN3j3CZt+CzU5g82/B5tBv+o0LnWR8Cx5sJdMHbTlvqCp38F94nkdIiCB1TWv4X2W9YbWiAlwoG14xUxG4urq6ehjSefj+IdBVfpg4vzrvphOH8Mo5B4SvgNnkbQS2h0HMJ5Ov2MScKUbqxDQGuCCo7GpVKCr2Q21bBJ5FxVt1sLe3b+IUbx1BLOMwXESjEJP5CCDL0yjKi+m/Ac1GQUGc312I4ufj2d7Hyeh+8mG9Go+QxatgHBGkURiPa2IgxSJejsLCOAvWt6vxWNf+wr+U0l0eFofBO07/MJyDC7jQz30EbPpNf96sa1HpNyMbcblDX1twcx4mU4KSPegLQLIt158ZfMavlMGDT7Lh4ILpjRNbK/y1BzW3vcjkxD5Ibvt0krYjDm1Lj3bLNo/G9liynrix2WyH7q0TBzb0qcM8pjd8M9tnFdx238fJYPYuKPqEn8UkjRI/jZzxL7Nzk66XThYtoiB3UALXOSiDC8MZV6gG/g+ZWusZrrFQxufn+sB9nOCfFkNvoAgaqQt2XGHp0BpKhOtDJ+DSoqzjHTXXh/zcNxSG/nM+fojSyDHjWw9vx1+FjpnWelYfbGSkJ7OzTsModa7vBubQ/xMAAP//a06a/hIJAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.492735222 -0800 PST m=+4882.983614063", "maxElapsedTime": "472.287831ms", "maxServiceTime": "472.252721ms", "minElapsedTime": "1.229393ms", "minServiceTime": "1.195161ms", "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": 22000 } }, { "prepareds": { "avgElapsedTime": "4.657295ms", "avgServiceTime": "4.580757ms", "encoded_plan": "H4sIAAAAAAAA/6STb2/aMBDGv4p1m1SQrGqtVk3Ku4ikE2oLLHY3IYqCFQ5wG+zMNhUdZJ99csKfDJW92Stzdz+ePH5y2QCqTE9xmha5UBAAUJihcCuDHa2c0bmF4OqaglRTXIeF/I7GSq0g+ExBiSVCAL34R9pPojhJb9I5OuZ09tJVMw01YQuReWyKM7HKHVDQBRrhtIFgAx+OBYQrt9BG/kKgUBj5KnOco/XUvbQOgtEGuDBzdEe1gPF+5w4oDIx8heBLOS4p/M4WMp+eqjP8uUKVefEaMKgqzSZ0h28sEwoovOCbhQBGrZbTqXVGqnnr43WbbLfkCS6foPrVGF2122Mo6d9yt+iyxU5sF8Pe8HvRnP59IIzIc8zhv+7UVdJJkQ+MfsbM52/QrnKXOjRLW9G4LjzYmlTmJpcTln57DHu8y4eTduXqHSIKeXh+OuTR+WG9LZ0eP48k8UOfx/9moi7j6acbD4zLcXmaHnMGxRKqCVg5V9Va+whr8xDAs9X+XR+kmq2DyWZzH0uzd7Ta7A55tC9LCg7XfmsHSTwIk5ic+2TIbdJ/ICy+jzucHJ9GSe3Yn0Me+ePgzhdHBxVZ32Wn5dMijywmd/GQkRHvp4wn3d5Xv8zbLbm4vPCL3Ghf+T3+EwAA//+LxpTzGAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:55.242322524 -0800 PST m=+4878.733201264", "maxElapsedTime": "594.328959ms", "maxServiceTime": "594.284116ms", "minElapsedTime": "494.788µs", "minServiceTime": "439.688µ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": 37093 } }, { "prepareds": { "avgElapsedTime": "4.635017ms", "avgServiceTime": "4.56072ms", "encoded_plan": "H4sIAAAAAAAA/6STX2/aPBTGv4p13lcqSFZVqkmTcheRdEJtgcXuJkRRsMIB3AY7s01FB9lnn5zwJ0NlN7sy55wfTx4/OdkCqkzPcJYWuVAQAFCYo3Brg12tnNG5haBzS0GqGW7CQn5DY6VWEHyioMQKIYB+/D0dJFGcpJ2bdIGOOZ299tRcQ43YQmSem+FcrHMHFHSBRjhtINjCf6cCwrVbaiN/IlAojHyTOS7QeupBWgfBeAtcmAW6k1rA+KB7DxSGRr5B8LmclBR+ZUuZz87VGf5Yo8q8eA0YVJVmE7rHd5YJBRRe8d1CAONWy+nUOiPVovX/bZvsduQZrp+h+tUYddrtCZT0T7k7dNlyL7aP4WD4o2jO/z4URuQ55vBPd+op6aTIh0a/YObzN2jXuUsdmpWtaNwUHmxNK3PT6ylLvz6Ffd7jo2m7cvUBEYU8vDwd8ejysF6Xbp9fRpL4ccDjvzNRj/G0c+OBSTkpz9NjzqBYQTUBKxeq2msfYW0eAnix2r/ro1SzdTTZbB5iafZOVpvdEY8OZUnB4cZv7TCJh2ESk4vfDLlLBo+ExQ9xl5PT4yipLftzxCN/HO354mShIuvL7LV8XOSJxeQ+HjEy5oOU8aTX/+K3ebcjV9dXfpMb7Y5f5N8BAAD//y346KMaBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:58.530801526 -0800 PST m=+4882.021680361", "maxElapsedTime": "666.275565ms", "maxServiceTime": "666.218349ms", "minElapsedTime": "487.428µs", "minServiceTime": "448.21µ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": 39070 } }, { "prepareds": { "avgElapsedTime": "13.18808ms", "avgServiceTime": "13.11913ms", "encoded_plan": "H4sIAAAAAAAA/6RU70/bOhT9V6Lz+ACS9aQW9IosvQ8RBBGJH1Gb9yqYqtRKblND6mS2w2BV9rdPjlcoHRub9i333tNzzzm2uwapvC6oyJpKKHCAYUHCtppOamV1XRnwwZBBqoIew0b+T9rIWoEfMSixInAk4c1ldJVmJdmp0LSsW0PwU9OI3EEKWoi2smCoG9LC1hp8jb9eCoStXdZafna/bLR8kBWVZBzqQhoL/mGNVOiS7Asbn4bj6Pz6v0kEhkTLB/BRN+sYvuRLWRW7Gyb0sSWVuwUeoEn1vNug2Nmc5EId4ptncEzPs/h0U2eyAMfxaLSgoxEtFkf/jI6PB8/TRtd3lNs+orVzshL6KbunJ3CrW+oY7ulpE8u2gbfjMo1QpldJjyK3noRBC1VS317KcgmOPa8gr1p/OocMVf3JD7pZN2NojVQlOEoj0bHXrs/I5kv8lrRdikRoUVVU4Y/iP5OVJQ2GvFaF9Clif3/+rGb+93yaxafzg+DfYG9w8J2MWEkrRZX4UwCDJtNWNrOkV5scGwfc5bwKL6O55/sBYpKOoyjNBr+EGv4cdRKnN+/xhOk7gm7jxAFm3azbjWFiNYkV+gmMLFX/ot2R+N3guDO1AoN3vl33m183vPE3esPt3m2cbMqOwdKje6vJOErCcRS89ScRnI2vL4NJdBGdpIEXwoKXfVvfQ/fthPtemPbA2zjxFM+5BNPzaBwF7or0FwTd1wAAAP//V5Rq6uEEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.535131006 -0800 PST m=+4883.026009793", "maxElapsedTime": "564.043988ms", "maxServiceTime": "564.007833ms", "minElapsedTime": "1.015344ms", "minServiceTime": "954.147µs", "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": 36879 } }, { "prepareds": { "avgElapsedTime": "7.394983ms", "avgServiceTime": "7.323346ms", "encoded_plan": "H4sIAAAAAAAA/6SUUU/bMBSF/0p0xkMjWYg2bKyW9lC1QavE1ipFVBOqUi+5pGapkzkOg6Hst0+OC2WF9mVvsc/na/ucGz+CVFKklMZlLhQ4wHBDwtSahoUyusgr8G6PQaqU7gelvCJdyUKBnzIosSZwjMKL8VUYfYszMsNxCidUpUismtKNqHMDhqIkLUyhwR/xbjvAoDarQsvfBIZSyzuZU0aVpS5kZcCvH3EpdEZmW41PolEYzcAw1fIO/KxZNAx/kpXM093yM/pZk0psdQdoUm3Rl9DYXm+WCBWAISnuSFfg1+7L63SWbr/l8XISj0dL33+idrTRQXV+UB2+UtdkxDPiHy9lavXFJgxwTKLYnqfdtq2OjRbLFBwUnPRPbz72Tz70v5/13z+LpS5uKTFtjLYBjH6If9CDvfEJ67IeC6ybdmaT4bPbbwdblUJVraV0LxIDbnRNDFqojNrplcxW4DjqtkdI8tq1UMCQF7+c0LAt1tuH9f7Bgn1YgGbRLBjqSqoMHFkl24UvA58KLfKccvxX25zL3JBuI1OpdI6i0+ns7Rvvk3fU9T2hUu9NaLTFev4Bbr7lAt9/dbuxkkaKfOqCBoOmqs5NbEivn5IqLXioEa2JzW7lmdEk1mgVVDJT7VthzXMLwXFbFQoNg6F7+8tOo3A6iEJv55nwzqPJF28WXoTDS8+tdVPuJN78cxiFnrWt9cwbfB15zp/WnM14vhkHaP4GAAD//+3EqtTLBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:18:00.99487764 -0800 PST m=+4884.485756543", "maxElapsedTime": "550.488114ms", "maxServiceTime": "550.448197ms", "minElapsedTime": "689.837µs", "minServiceTime": "625.973µ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": 34614 } }, { "prepareds": { "avgElapsedTime": "29.12076ms", "avgServiceTime": "29.033059ms", "encoded_plan": "H4sIAAAAAAAA/6SUYW+bPBDHvwq6py8SyXq0JJ2WIe0FKlRDooEF0qqaIuLBlbglhtmmaxexzz5hQlLaRt20NxE+//K/+9+dvAXkSZFiGpc55WACELhBqiqBZwVXosglmKMxAcZTfLBKdolCsoKDeUqA0w2CCf7cduZxGFnRIowzVL5IUXiMo4SWkSVNGjDFG1rlCggUJQqqCgHmFv47HMCq1LoQ7CcCgVKwe5ZjhrKhPCYVmF+3EFGRoTqomW16z505QCAQ7B7MD/WyJvArWbM8fZ4ixO8V8qTJ0AICuRZ+CrmN2zChfAI7641PL/Zj147t5ucqdu3uLmYpmPCeJsm7b9PJ9GM6Tac3p/vbUhS3mCjdtW1ja0PFY3yHj2AqUWFN4A4fux713LzePFlSLnXJ+EAT1aoQEJRnqMNrlq3BhJO2+CSv2olNCOTFj/aiJgdsfAwb97DRMWwE9bJeEqgk4xmYkEmm//i0oeeokjX8ndPnGgEVNM8xh38a7TnLFQogkBQ8Ze1UYDAYDFaHglb/r3xPj3g1ND4ZJ6OhQXlqvMLYe2Y8PAr5e2gyHL6w5XKmGM2DdkuAgEBZ5SpWKDbdmMsGfCkcLoLAu94VqoWPou4fMF8W1ixyo+u3OOvCX8yityjb8dxLZ34d67zLelk/dx4qgXQD+gYky7h+d5qp7pOACbey4ECgp9gLN9Z6gc5HL/ikV128JqDwoXlLgrkTWHPHOP6UGedz/8IIHc85i4y+HDF2ReiPLrk+tCb056H4VurQLuPqs9PkbjdO75thzWxjt156ubqAvwtMoP4dAAD///0TcPC7BQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.266507327 -0800 PST m=+4882.757386279", "maxElapsedTime": "503.271879ms", "maxServiceTime": "503.231401ms", "minElapsedTime": "2.839525ms", "minServiceTime": "2.800909ms", "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": 3453 } }, { "prepareds": { "avgElapsedTime": "11.308395ms", "avgServiceTime": "11.232055ms", "encoded_plan": "H4sIAAAAAAAA/6SU0U/bMBDG/5XoGw+NZCHaAtIs7aFagobEmiogqglVrYmP1JpxOtsBNpT97VOcQjugQtPekvPv7nzfZ/sRZIpKkpyvtDDgAMMNCV9b+lwZbyvtwPsDBmUkPYxW6pKsU5UBP2Qw4pbAkaRnp5dp/m0uSZOnMd1nVpJFB7iVKFpK0o2otQdDtSIrfGXBH/Fh84NR7ZeVVb8IDCur7pSmklxLnSnnwa8ecSFsSX5TjY/T6TzLkzQHw8SqO/D+QTNrGH4XS6Xlyxbn9KMmU7QdOsCSCYW3odN21PNCmCEYiuqOrAO/6r6iXm/x3HOxvxhn82x+mizi+Il9g0jeJaaviFvyYhuL9xdKtshs7QU41qVDNtbhuZLgOBoeHF3T9bH4KI8Pb0Q773f6+WTFtmhvW+RWwrggDD2IwoN7WxODFaakEF6qcgmOvWHoW+i6OxRDBl3ddwsN22D9XVj/L2ywCxugmTUzhtopU4KjdCokbts2EVZoTRr/Zf6J0j6c3aIyUvmwD/R6vXe8jT5Fe/04EkZGO9HpBh3E77DZhh3G8atZz8nIJNw2MAithHth6z+43cyal+UT5Qph5eu23pK47TLgVGnCQwFuaq0ZPD20V3OSp5NRnkY7noXoJM++tovpRdp9P28wmn5J8zRaqxokjUbjJFprF4R7CmTrwBDNnwAAAP//E1ipLcQEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:18:01.05460961 -0800 PST m=+4884.545488449", "maxElapsedTime": "734.701748ms", "maxServiceTime": "734.63579ms", "minElapsedTime": "668.8µs", "minServiceTime": "627.162µ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": 34614 } }, { "prepareds": { "avgElapsedTime": "4.655218ms", "avgServiceTime": "4.580429ms", "encoded_plan": "H4sIAAAAAAAA/6STb2/aMBDGv0p0m1SQLDSqSUh5F5F0QrTAYncToihY4QC3wc5sU9FB9tknJ/zJUNmbvjJ39+PJ4yeXHaBM1RznSZ5xCT4AgQVyu9HYVdJqlRnw27cEhJzjNsjFD9RGKAn+VwKSrxF8GEQ/k2EcRnHSSZZoqVXpS08uFFSEyXnqsDku+CazQEDlqLlVGvwdfDoXEGzsSmnxG4FArsWryHCJxlH3wljwJztgXC/RntV8yobdPhAYafEKfqeYFgT+pCuRzS/VKf7aoEydeAVolKVmHerjG025BAIv+GbAh0mjYVVirBZy2fh82/T2e+8JWk9Q/qqN2s3mFAryr9wd2nR1EDvEcDT8XjSXfx9xzbMMM/jQnXpSWMGzkVbPmLr8NZpNZhOLem1KGre5Axuz0tysNaPJ98dgwHpsPGuWrt4hwoAF16djFl4fVtvSHbDrSBw9DFn0fybsUZZ86ThgWkyLy/So1cjXUE7AiKUs19pFWJkHH56Ncu/6JFVvnUzWm8dY6r2z1Xp3zMJjWRCwuHVbO4qjURBH3rVPxruLhw8eje6jLvPOTyNe5didYxa64+TOFWcHJVnd5aDl0vIeaeT1ozH1JmyYUBb3Bt/cMu/33k3rxi1yrd12e/w3AAD//+mXG/sYBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:58.888085672 -0800 PST m=+4882.378964420", "maxElapsedTime": "869.173765ms", "maxServiceTime": "869.137496ms", "minElapsedTime": "486.465µs", "minServiceTime": "448.858µ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": 38175 } }, { "prepareds": { "avgElapsedTime": "5.874713ms", "avgServiceTime": "5.689045ms", "encoded_plan": "H4sIAAAAAAAA/6RTYWvbMBD9K+JWqA2i0DSsQ7APruN+adOa2BmENDjCviZiiuxJcmiXZr99yEnWOGnLxj7Zunvv7nTvaQWo8rLAIqskV8AAKDwit7XGsFRWl9IAO+9QEKrAp6AS31AbUSpgXQqKLxAYxMGoH92lWV0V3OJVGNbGlgvUsEGYiucOVuAjr6UFCmWFmttSA1vBp9cDBLWdl1r8RKBQabEUEmdoHOpWGAtsvIKU6xna12osHCbpfT8aAIVYiyWwL+vJmsKvfC5kcdggwR81qtzV3wA0qqbsPugGn5OcK6DwHZ8NMBh7nufZMjNWCzXzTj775OWFPMDZAzR/rdT7uUvfn8CatpvFXHMpUcJ/jXyNNp9vB95ue28vb4lwOEcoS4VH0QSdXAZtZlEvTNO34nYODLzprsP0bBpmV8FtcBdGUx8oLLmsXa+T86bg24RR2su2xmmTOh+Qdk4LD0kXH5B6QRq00V1wHjm8qiqGjYGBApeCm/YS/2G1k/Vh8Z4wOdfF8X6tRr7YMMCImWoeHjBVS0nB4pNzejyI4mAQkfeeGbke3PfJMO4FaUR2s5FhEpGbaJSQ8bF1T89O3Yf8TeLS98mEJFFK/ohMvpKTc0paGrpYx8X2JHKxCxdzCrhDF9a/AwAA///5RWedcAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.538518929 -0800 PST m=+4883.029398294", "maxElapsedTime": "331.946996ms", "maxServiceTime": "331.881852ms", "minElapsedTime": "454.126µs", "minServiceTime": "400.144µ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": 3581 } }, { "prepareds": { "avgElapsedTime": "4.588881ms", "avgServiceTime": "4.50819ms", "encoded_plan": "H4sIAAAAAAAA/6STb2/aMBDGv4p1m1SQrGqtJq3Ku4ikE2oLLHY3IYqCFQ5wG+zMNhUdZJ99csKfDJW92Stzdz+ePH5y2QCqTE9xmha5UBAAUJihcCuDHa2c0bmF4OqaglRTXIeF/I7GSq0g+ExBiSVCAL34R9pPojhJb9I5OuZ09tJVMw01YQuReWyKM7HKHVDQBRrhtIFgAx+OBYQrt9BG/kKgUBj5KnOco/XUvbQOgtEGuDBzdEe1gPF+5w4oDIx8heBLOS4p/M4WMp+eqjP8uUKVefEaMKgqzSZ0h28sEwoovOCbhQBGrZbTqXVGqnnr43WbbLfkCS6foPrVGF2122Mo6d9yt+iyxU5sF8Pe8HvRnP59IIzIc8zhv+7UVdJJkQ+MfsbM52/QrnKXOjRLW9G4LjzYmlTmJpcTln57DHu8y4eTduXqHSIKeXh+OuTR+WG9LZ0eP48k8UOfx/9moi7j6acbD4zLcXmaHnMGxRKqCVg5V9Va+whr8xDAs9X+XR+kmq2DyWZzH0uzd7Ta7A55tC9LCg7XfmsHSTwIk5ic+2TIbdJ/ICy+jzucHJ9GSe3Yn0Me+ePgzhdHBxVZ32Wn5dMijywmd/GQkRHvp4wn3d5Xv8zbLbm4vPCL3Ghf+T3+EwAA//92ifDEGAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.747323212 -0800 PST m=+4883.238202321", "maxElapsedTime": "506.991287ms", "maxServiceTime": "506.892518ms", "minElapsedTime": "479.246µs", "minServiceTime": "443.813µ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": 38168 } }, { "prepareds": { "avgElapsedTime": "4.617849ms", "avgServiceTime": "4.54315ms", "encoded_plan": "H4sIAAAAAAAA/6RTcWvbPhD9KuJ+P6gNItB2MPB/ruOAabIE2xmMNDjCvibqHMmT5JIs9T77kOOsbtZ2g/3lk+7de+9O5wOgyGWBRVaVTIAHQOEemakVBlIYJUsN3uUVBS4K3PkV/4xKcynA+0BBsC2CB9N4GMZZkvrpPMnWaIJaG7lFdbM/RVEBR7SuWG5LCrxndWmAgqxQMSMVeAf47/kAfm02UvHvCBQqxR95iWvUFjXm2oC3OEDK1BrNM5sXzJN0OgljoDBT/BG8j82yofAj3/CyOBdI8FuNIrf8R4BC0dL2Qbe4T3ImgMJX3GvwYOE4jmNkpo3iYu38f+mSpydyB4M7aKNe6sp9O3ftukto6EuxEZp800l1c+p19Nr4zhlmTLGyxBL+qelIcMNZOVPyAXP7Rgp1XZrMoNrqFo27ygKd1cnfarAKsmi4cltLr6dHUZyk7yIm0XA4Dt+FjP0/cNz4Y/9T0JIsm2VzPqHEKGRbaDOg+Vq0q27H9KsUPHjQ0r5557l/EQ37J+umfz42cLppKBjc2QWdxeHMj0PyN38KGcXTCUnCcRikxApS0vmwwVHBRlbbfjvXx7LTKMg8Cclt+CUhi9+39WJwYT8vd/WNxLXrkiU0PwMAAP//OQgvJicEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:57.306685831 -0800 PST m=+4880.797564688", "maxElapsedTime": "252.875876ms", "maxServiceTime": "252.828745ms", "minElapsedTime": "534.506µs", "minServiceTime": "496.697µ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": 1410 } }, { "prepareds": { "avgElapsedTime": "5.329931348s", "avgServiceTime": "5.329866468s", "encoded_plan": "H4sIAAAAAAAA/6RU0U7jOhD9FWsuD4CiClokRCQeuE2Qwu1tqrRiH1ZVauxp6sW1s7YDdKvst6+cbEuhrJZdHj1zND5z5sysARXTHHleSqogBAhgjtRVBvtaOaOlhfC0G4BQHJ+uSnGLxgqtIDwLQNElQgjjSdr/Lx/Et/EgL9ClhqOx/64iYZ0RzEELtCVlHs1xTivpo7pEQ502EK7hn+cHXFVuoY34hhBAacSDkFig9aiBsA7Cz2uYUFOge64WRsl4kiX9CQQwMuIBwvM6eAOWZlGcjXdA0zqA72whJH/NYoxfK1TMk2gBBlXz9y4o8aqMGVU9CIBa/xP81ApCiJI8ifJPeRJtgrngEALtns1Z92R+R3s9fn5Ht9nS6C/IXKPv2ve+pGaV3+MKQmcqrAO4x9VGyJ2W39bXllTZhjI+UebaGgEYqgpswgtRLCCEg9OGAJNVO9leAFI/tol6Wk8DqKxQBYRQWAFe110JrtGxxW7376f4utSIGiolSvjQTIZoHfKB1uWNFsozk6Ihp73nVM4krayncXg447POLMqTaHZELsnhTM86szRvA0cfY7HvDL3jjDRrfnlpi3PGz+YnF/yOXiC7mHf/zhZbi79tCtWok0uty40h3uuTXbl+4ZgXkD/0joYP9VFP673yQjo0EADTiotWv72pH5we7fFKlHCCylGrOwRg0FbS5Q7NcqNU6YEW5dxvmqNmy2Kfx9gZpEtoMmBFoZr76md5DCEcQx2Awyd/p0ZZPLrKYvKbk0qus/R/Mo4HcX9CjtsX2Swb4SQZDuOM3KTJkLQyEk3SIeEd3zW5vCS609qcPC7Q4DZB/Mb/CAAA//98jpO/EwYAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:18:08.227706148 -0800 PST m=+4891.718585079", "maxElapsedTime": "12.013993658s", "maxServiceTime": "12.013891228s", "minElapsedTime": "1.557043768s", "minServiceTime": "1.55699223s", "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": 3418 } }, { "prepareds": { "avgElapsedTime": "4.652095ms", "avgServiceTime": "4.57676ms", "encoded_plan": "H4sIAAAAAAAA/6STb2/aMBDGv4p1m1SQrGqtJk3Nu4ikE2oLLHY3IYqCFQ5wG+zMNhUdZJ99csKfDJW92Stzdz+ePH5y2QCqTE9xmha5UBAAUJihcCuDHa2c0bmF4OqaglRTXIeF/I7GSq0g+ExBiSVCAL34R9pPojhJb9I5OuZ09tJVMw01YQuReWyKM7HKHVDQBRrhtIFgAx+OBYQrt9BG/kKgUBj5KnOco/XUvbQOgtEGuDBzdEe1gPF+5w4oDIx8heBLOS4p/M4WMp+eqjP8uUKVefEaMKgqzSZ0h28sEwoovOCbhQBGrZbTqXVGqnnr43WbbLfkCS6foPrVGF2122Mo6d9yt+iyxU5sF8Pe8HvRnP59IIzIc8zhv+7UVdJJkQ+MfsbM52/QrnKXOjRLW9G4LjzYmlTmJpcTln57DHu8y4eTduXqHSIKeXh+OuTR+WG9LZ0eP48k8UOfx/9moi7j6acbD4zLcXmaHnMGxRKqCVg5V9Va+whr8xDAs9X+XR+kmq2DyWZzH0uzd7Ta7A55tC9LCg7XfmsHSTwIk5ic+2TIbdJ/ICy+jzucHJ9GSe3Yn0Me+ePgzhdHBxVZ32Wn5dMijywmd/GQkRHvp4wn3d5Xv8zbLbm4vPCL3Ghf+T3+EwAA///HIbfAGAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:57.5411995 -0800 PST m=+4881.032078298", "maxElapsedTime": "666.960797ms", "maxServiceTime": "666.914637ms", "minElapsedTime": "473.835µs", "minServiceTime": "440.768µ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": 38091 } }, { "prepareds": { "avgElapsedTime": "4.526934ms", "avgServiceTime": "4.454813ms", "encoded_plan": "H4sIAAAAAAAA/6STb2/aMBDGv4p1m1SQrGpFkyblXUTSCbUFFrubEEXBCge4DXZmm4oOss8+OeFPhsre7JW5ux9PHj+5bAFVpmc4S4tcKAgAKMxRuLXBrlbO6NxCcNOhINUMN2Ehv6OxUisIPlNQYoUQQD/+kQ6SKE7STrpAx5zOXnpqrqEmbCEyj81wLta5Awq6QCOcNhBs4cOpgHDtltrIXwgUCiNfZY4LtJ66l9ZBMN4CF2aB7qQWMD7o3gGFoZGvEHwpJyWF39lS5rNzdYY/16gyL14DBlWl2YTu8I1lQgGFF3yzEMC41XI6tc5ItWh97LTJbkee4PoJql+N0U27PYGS/i13iy5b7sX2MRwMvxfN+d+Hwog8xxz+6049JZ0U+dDoZ8x8/gbtOnepQ7OyFY2bwoOtaWVuej1l6bfHsM97fDRtV67eIaKQh5enIx5dHtbb0u3zy0gSPwx4/G8m6jGefup4YFJOyvP0mDMoVlBNwMqFqtbaR1ibhwCerfbv+ijVbB1NNpuHWJq9k9Vmd8SjQ1lScLjxWztM4mGYxOTSJ0Nuk8EDYfF93OXk9DRKasf+HPHIH0d3vjg5qMj6LnstnxZ5ZDG5i0eMjPkgZTzp9b/6Zd7tyNX1lV/kRvvG7/GfAAAA//+cnULuGAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:57.283277383 -0800 PST m=+4880.774156176", "maxElapsedTime": "401.739153ms", "maxServiceTime": "401.706988ms", "minElapsedTime": "474.337µs", "minServiceTime": "440.829µ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": 39341 } }, { "prepareds": { "avgElapsedTime": "14.21254ms", "avgServiceTime": "14.144698ms", "encoded_plan": "H4sIAAAAAAAA/6STUWvbPhTFv4o4/z40IP6sSWFDsIdQu8ywJcFJl8EIjmrdOFoV2ZPlLl3wPvuw3bRZsg3KHiUdnXvP73J3IJvmilRSGGkhAI4VSV85usqtd7kpIS76HNoq2g4L/ZFcqXMLcclh5YYgMArnyTgOwjjRNnW0IetHtPVjp8hFCp2uLGTaiBWtZGU8OPKCnPS5g9jhv+cDhpVf505/J3AUTt9rQxmVjeq9Lj3E5x1m0mXkn91EEE1ncXQ1A8fE6XuIN/Wi5viRrrVRxwWm9LUimzb+ncCRbW0PRVGTd5pKO8BjeAgEURIFyTyJgv1lohUEZP9ylfZfrW7lYKBe38qn18LlXyj1LbBdk2Yj3UNyRw8Q3lVUc9zRwx7NQYjfEysLacu2U9rK1HceHE7ajNrrtc7WEDjrtw2kpupGNeAw+bfuoebPssGfZAPUi3rBUZXaZhDISt1+PAQ0kU4aQwb/hPmafLrGSzAc93GtjScHjjS3SneocX5+vtz7LP9fBkkULHvsLTvr95i0ih0/z58Eg17vpMSVyS2d3E6pnQn5xJPbdHMppG/IHrmPwk+zZNyWAMe9NFUT6OyioXxiatVNoaRvsEmjZfkrkRdwWtTH5oEuU+nUaRLvSG66Hyh1Ztv9h7CVMRyets2qTeJwMoxD9vdtZ9fx+AO7mQTDWcj2HbJpOGMHGBrOF2z+LoxDFjye+2w4Clg3iXYOqH8GAAD//xTa+TScBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.521901678 -0800 PST m=+4883.012780432", "maxElapsedTime": "548.673109ms", "maxServiceTime": "548.630387ms", "minElapsedTime": "1.691457ms", "minServiceTime": "1.659724ms", "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": 38462 } }, { "prepareds": { "avgElapsedTime": "4.719641ms", "avgServiceTime": "4.62558ms", "encoded_plan": "H4sIAAAAAAAA/6STXW/aMBSG/4p1hlSQrKqh7KO+YyOdoqUJSwIVKiiyklNqzTjMMVU3yH77lJCED7W7GTfYz3mxLc5ztoAqyVJM47XkChgAhUfkZqPxS6aMzmQOzOpTECrFl+FaTFHnIlPABhQUXyEw8Oz72A9GdhAnGrlBX6eoXaEQ9pF8zZMyl+Ij30gDFLI1am4yDWwL7w4bGG7MU6bF7/KXay2ehcQl5mXKFbkB9rCFiOslmsNpbH+z63g2UBhr8QzsplgUFP4kT0Km51eE+HODKilv2Ac0qurg49CUyw2GCVdA4blc58Dg4aFbfUwW50YLtex2rntktyNzuJxDtToq9Xtv16x/1Aa9HiXbOfhuPLzzJ140B0Y6N5RUaGS7ztQOZvGowh8b7IRR7Hi3fkWtqwbHzj7Xr4HTgPc18CZ3n+2gQoMa+U3GqsH3ydCLnGhWwU81DCfjsTuL75vwh5q34LpYLKCgp//rmGsuJUqgsOIvzU7kK2DWfzUsRJU6Kkdd2sWl4GXDTsz4gb8aD0/4a4KeP3sk8oTrFIpFcV4KjUa+2lcgF0tVjQ4wtZGSgsGXUtVxYI+HgU3eHBRyG/h3xPFCO4iI40U+Obyx+82eUTIduhO7t/8Ku5Efh1HgeF9LBXc7cnF5UWp0hPuvY+t1PCidO2l/2/3aoVahusGd63ODWoFqyVrHTlVpTTlRuTX5SLbWtXYODmNw5HvHuip6UPwNAAD//0h1s87JBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.887199164 -0800 PST m=+4883.378078566", "maxElapsedTime": "1.301628154s", "maxServiceTime": "1.301540299s", "minElapsedTime": "460.864µs", "minServiceTime": "416.773µ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": 384531 } }, { "prepareds": { "avgElapsedTime": "15.804869ms", "avgServiceTime": "15.735126ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2/aMBTFv4p11wciuRWBttMs7QGVVEOigEJVNHUouMltcGeczHH6Zyj77JOdQFlbxMPekpvfvTc+58hrQBVnCSZRLrkCBkDhHrkpNV5kyuhMFsD8DgWhEnzu5eIGdSEyBeyUguIrBAb9YDi4CcLvUYpmhE9jnaCG+muR89giCd7zUhqgkOWouck0sDV8en2BXmmWmRa/ESjkWjwKiSkWlhqKwgC7XcM11yma12lsFMyicdgPQqAw0eIR2OdqXlH4Ey+FTN5umOKvElVsF9SARuXm7kIDe8xpzFUXKMTZI+oC2G39RFqtxXbl4mQxGkfjaNBfeN6G/YDoHyRm74gVGr6LeScLkVhk3vgADJrRrhuaciQSYHDWbZ/d4d05/5Kcn95z3H7NdfaAsXHuWd+Nfol+4os9YJv6tGOls++NZ7vqSrESVnl/r69FzlXh5MRnHhtgRpdIQXOVoisLFcuyjk6bgsyegEHr2PegomtYinQJDI5897NbsLsBj/x/sM4+rAPVvJpTKAuhUmCQFsI17lo84ZpLiRL+KyiXQhoX8zhTiahFhVardSAH5Cs58j3CVUL2orNXtOM1rFWK/Cjb7W5MDoTR894deaCEEVxO6gAABY1FKU1kUK82puUWPJRzq271dvrQhYNuZvjv1k+NRr4C1wqFSJW7X6zszWhg8FBkCioKBp9t0CZhMOmFAfnobiGX4fiKTINhcHFNmgl1bfvXZPYtCAPS6O5EJ71RnzTqOmk3BdfupEVy7JPh4GpwTXyo/gYAAP//Be3MXxsFAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:18:00.973886697 -0800 PST m=+4884.464765436", "maxElapsedTime": "664.191168ms", "maxServiceTime": "664.153754ms", "minElapsedTime": "804.871µs", "minServiceTime": "768.739µ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": 34630 } }, { "prepareds": { "avgElapsedTime": "10.967776ms", "avgServiceTime": "10.89503ms", "encoded_plan": "H4sIAAAAAAAA/6RUYW+bSBD9K+hdPsTS6nTGkSKtdB+QITqkJIds1CipLLyBMd4EL3RZ0qQW/e0VbKhd101b9dvOzOPNvDfLbkEqLTPKkqoQChxgWJEwjaZpqYwuixp87DJIldGzV8l3pGtZKvAzBiU2BI7Iu70KruMkJ+PL2miZGthiXYm0Q2S0Ek3RZcuKtDClBt/ir10ArzHrUstPBIZKyydZUE51h7qUtQF/v0UsdE5mx8b9cB7PwmkMhkjLJ/DzdtEyfE7XssgOG8zpQ0Mq7fgtQJPqafdBYSdyngo1waticPhhEvrJTRL6QzKRGTiEe7ZK3X9W92Iyyc7vxddqpcsHSk3v0rZTsxH6JXmkF3CjG2oZHullsGZPxHHH6kqoup+UnkVqLAeDFiqnPr2W+RocJ24/QFo0dj8ThqL8aAst28HGP4KN0S7aBUNTS5WDI69l/+G+QRdk0jV+R8AhQyS0KAoq8EeLupCFIQ2GtFSZtFbj9PR0OUyz/Htpd7YcOf86J+ORI1TmHAKGsjsafTdoqKSRoojsMsGgqW4KkxjSm2EfVQc84Lz2roKlpTsOmMezIIiT8a+A3DdB0zC+/QmLF789zF0YdfVFu2gPDZgbTWKDvoJa5qp/Fbp12c7geKhLBQYrej/uG3+bsKKP5Nz93F0YDWHLYOi5++GjWRB5s8A58tA4F7P/r5x5cBlMY8fOwZxdu72z2527uW3Oi3vgXRhZisEV5+a/YBY49vL0V8fxrn3Hf41ctF8CAAD//3Mw4IkzBQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.544461673 -0800 PST m=+4883.035340416", "maxElapsedTime": "573.809732ms", "maxServiceTime": "573.700875ms", "minElapsedTime": "1.224734ms", "minServiceTime": "1.185063ms", "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": 36879 } }, { "prepareds": { "avgElapsedTime": "16.25272685s", "avgServiceTime": "16.252663865s", "encoded_plan": "H4sIAAAAAAAA/7SVUW/bNhDHvwpxy4MNCEacJvFGIA+ZrG7qXMuQnfahMGSWusjcaFIjqSxZ4H32gZTtuLWKFWj3ZvP+R57u/zvyGVBxXWJZ1JIpoAAR3CNzjcFYK2e0tECHFxEIVeLjbS3eobFCK6CXESi2QaAwX2Txb8UkeZdMigpd3FinN2gyU6KxPz+NhXVGcAdtgq0Z91kl3rNG+lVdo2FOG6DP8MPLH7ht3Fob8TdCBLURD0JihdarJsI6oB+eYcFMhe5lNxrfzRfZ2ySHCGZGPAAdbaMOWZaPk3x+JFpuI/iHr4UsP69ijn82qLgvohUYVOHsY1HquzPnTL2CCJgFChwi4PoBjQX6of1Fer0VXw1WcZGOV/3+XvCyPP5S4P1JYIOO+Wh/sBKlDy13FgGF+K5Ix2GzkAi7SCFKoHB5Prpmo/Pr+6trPuSjq0O0Nvp35C5466lw5qn4A598+efRcBks2LB2EagzDW4j8IKdn0ed77bZ1kzZ0Dl8ZNy1e0RgmKowLAvFZdPCdR6B1H8BBdVICd7CtajWQOFsGAo+CF/thWdD2C63ywgaK1QFFCorQuKxTTNmmJQo4ZvMnqJ1WE60rt9oobzhUgTPtYdZFVyyxvpv73XZTm7IYVmvBqus2AX631bVKYK6G8FPDj1BSncileUh4VOUePnjTxdXH0vE8mp0celROuLhMGLdNKjQxEJqXe9J+E9Adgx8YZi6qOiUdnCy3H6OymshHZrQHlWKdixODB0fLD0b9k9oS5VwgslfjG5q70lVGayYw50djXK9UlgnFHekq9DgQOWz94O47Cg0VQ7NBkvBHH7Xo04aor7zt/wvw7lr+qy9zSACg7aRrvBN2sNVm4DGVxS97er43BlkmxYasKJS4bn01Z4Nw5W1+YgGthE4fPSPzixPZrd5Qr7ynSSv8+wtmSeTJF6QOLubLnrjdL5Ip/Gixwe+tH6/1ZD9nUs4SafTJCdvsnRK2skjmmRT0iaQmxuiB+3Qk/e/JnkSAuMQIv7q/DcAAP//aWf2pwgIAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:58.682786898 -0800 PST m=+4882.173665708", "maxElapsedTime": "19.81660338s", "maxServiceTime": "19.816560998s", "minElapsedTime": "9.451416454s", "minServiceTime": "9.451379101s", "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": 3418 } }, { "prepareds": { "avgElapsedTime": "4.87651ms", "avgServiceTime": "4.785119ms", "encoded_plan": "H4sIAAAAAAAA/6SSXW/aPhjFv4r1/JGaSFYloP2v811UshGtvChJmRCgyEpcas04zHYQHWSffcobAcSudoXPeQ6PHJ/fAZiM04Ql0VZQCQQAwxujJlPsOZVGpUID6fYwcJmwvbPlM6Y0TyWQBwySbhgQmDrzkTsOIy41U2bItUnVB1RjvaVxkUnYG82EAQzplilqUgXkAP+1ApzMvKeK/2KAYav4jgu2ZrpIvXBtgCwOEFK1ZqbdRoZeEE78OWCYKr4D8jlf5Rh+x+9cJNf7A/YzYzIu1lcBxWS59Tw0oyJjQUwlYNgVZw0EFgvLsiyTRtooLtdWp2uj4xEt4X4J5els1LP/PuvbNkaHJQwjZzR5HYdLIKjzCaPCeY4GkTconV7j1Lrb6O+N06+cgRM6pX46abfU/9e6yT9U+vT/x3y1ghxffvqUKioEE4BhQ/eN4noDpPtPbxowmXglGoCBCk6LN22b+8E+Gkha8xY61xcecB1TlUC+yq9HgVGMbqoJaL6WJdBAZCYEBsP2BURT3506votu4ou++JMR8saB64fIG4cTVF/O+ubOMZo5L6+uXf0EyAonURD63vhrwcbxiO7u74ruz+zebbvfEFG33ZZdl9fSULd3Kr+Wl912Hi9QaEg48dbgVqPTecptyP8EAAD//wa27sAEBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.610103077 -0800 PST m=+4883.100981898", "maxElapsedTime": "684.527162ms", "maxServiceTime": "684.47452ms", "minElapsedTime": "506.024µs", "minServiceTime": "465.236µ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": 36879 } }, { "prepareds": { "avgElapsedTime": "5.005883ms", "avgServiceTime": "4.927265ms", "encoded_plan": "H4sIAAAAAAAA/6SSUWvbPhTFv4q4/z/UBhFoOxjoLTgqhKZNsJONkQZHOLeOOkXyJLmkS73PPmQ3JM3SvexJlu9P594jnR2gLswKV3mlhAYGQOERha8tJkZ7a5QDdnlFQeoVbvuV/ILWSaOBfaKgxQaBwT3/mo/TAU/zEn1SO282aKEru0oUgVnho6iVBwqmQiu8scB28N9hA/3ar42VPxEoVFY+S4UlukCNpPPA5juYCluiP6ixZJZNx3c8BQoTK5+BfW4WDYVfxVqq1WmDDH/UqIug3wEWdSt7DN3iS1YIDRS+44sDBvMoiiJvcuet1GX0/2VMXl/JA/QeoP06Kl3FH9eu43gBDX3f7AZ9sX5r9XZPR47OXd+pwkRYoRQq+CfTQy29FGpizRMW4Y0sulr53KPduJbGbRXAaLmfb9lbJvlgmCXj2f10GbeDnYdG/ezvQJLywbBFFs2iOXWYeYtiA20FnCx1m81gc38SGDw5E57sMNHxvzDAft9Q8LgNEZqkfNJPOTkbXnKTju9Ixkc8mZKDKiWdWli73h24t0NmGSe3/FtG5n9G5qJ3EZb3gfmgcB3HZAHN7wAAAP//lwAHn50DAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.517514793 -0800 PST m=+4883.008393640", "maxElapsedTime": "489.72185ms", "maxServiceTime": "489.677222ms", "minElapsedTime": "454.223µs", "minServiceTime": "419.844µ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": 38462 } }, { "prepareds": { "avgElapsedTime": "13.845579ms", "avgServiceTime": "13.774444ms", "encoded_plan": "H4sIAAAAAAAA/6RU4WvbOhz8V8S9fkhAPNok771G8D6E2mWBbglO2zBGcDT7V0erInuS3LUL3t8+bKdp2rRQ2BfDz3c66e6QNiCT5CmlcaGlgQA4bkj60tJZbrzNtYM46XEok9L9qFDXZJ3KDcSAw8g1QSAIL8bXYfQ5LotUeprYlKxDC7tCJjUnpRtZag+OvCArfW4hNvjracCo9Kvcqp8EjsKqO6UpI1ezLpTzEF82uJQ2I/+kJiZREEYzcEytuoM4rRYVx69kpXT6Un5G30sySa3eEiyZRnSfNK5NzhJp+tg6hsAkiifxOIiD+jOPx8EjFqsUAtQ/Hg5uTofH/w6//jf8ZwcWNv9GiW+y2tSO1tI+xLf0AOFtSRXHLT08xrMz8npmrpDGNaele5n4VoHDSpNR83ulshUEjnrN9oku2476HDr/0QIVf6L136L1n9EGb9EGqBbVgqN0ymQQyJxqFu5nOZVWak0af9TIOflkhfdn9fIU50p7suBIcpOqtg10Op3OspVZ/r2sy1122f/sqNdl0qTsORjs4H73NXy+wwfd7sH+Zzo3dPB3Rk2r5GNPdt02W0hfh/5M+2wUReMwanYAx53UZW326KTO/0DTpFfNBQSH1Eq6/azend+ieikcKJdImx6a8Jbkul0BpzLTvBoQptSaw9N9fVOnUTgdRSF79Y1g59HkI7uaBqPLkLXHYrPwku0br4M9YfMPYRSyyXbusdGngLXVNMVs5/l2HqD6HQAA///PCXP32AQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:18:01.061066622 -0800 PST m=+4884.551946330", "maxElapsedTime": "682.680996ms", "maxServiceTime": "682.62923ms", "minElapsedTime": "1.798835ms", "minServiceTime": "1.762684ms", "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": 34614 } }, { "prepareds": { "avgElapsedTime": "28.736648ms", "avgServiceTime": "28.662882ms", "encoded_plan": "H4sIAAAAAAAA/7RUYW/aShD8K9a8fMDS6ekF8lRqqR9QcFokCMgkQVWEzMXemGvss3t3TkmR+9urswmEhKiqmn5BYnd2dmd2fWuQjPKY4rBIuYQHMNwSN6Wi01walaca3nGbQciYVr1CXJHSIpfwThgkzwge+v5wcOUHn0NdZuNhL8tLadBkdcEjC4nplpepjeYFKW5yBW+Nf3Z/0CvNMlfiO4GhUOJepJSQtqih0Abe9RoXXCVkdmzeOOj7QTgcnPtgmChxD+9dNa8YfkRLkcbPW0zpa0kysh0agCJZEz8FDazOacRlBxvR8DAehuNw0A/79mcWDvqPuVDE8PA/j6L/brqd7vu4G3dvT7bZQuVfKDK1X2srK+PqIbyjB3hGlVQx3NHDo0d7ag6bpwsudT0yrXhkGhYGxWVCdXgpkiU8HB3XI0Rp2eyqw5Dm35pExXaw9muw9h6s8xqsg2pezRlKLWQCD4kWdeFTQ8/IREv8ntLnHBOueJpSij9a7ZlIDSkwRLmMRbMVtFqt1mI30OLfxWbZC9f54Bwduw6XsXMA099i2u6roNkW1HHdF7IGUhjB048qLwsw8CRRlHBjz/4auswOEPZG48vzi4XrYs6Q2EJ7TrZgXs2rlw0MqYxiwQ29VZfn6xXy7RT8lbVvXJ403yIYFOkyNaG1pvmYuLZcl6NwOx4YaFXY6l+JqA75PjWKeIY6Ay0SWT+odvr9Lh5kmd2QQsVgaGXftkngT3qB7xx6VJ2zYDxypv7QP71wppej1pbJdXpTZ4+7we7mdmaf/MB3Nsddn7bTO+87m0uu7/gxMNsEOqh+BgAA///WZhQEIAYAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:18:01.000509015 -0800 PST m=+4884.491387757", "maxElapsedTime": "544.290636ms", "maxServiceTime": "544.247571ms", "minElapsedTime": "2.347216ms", "minServiceTime": "2.31307ms", "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": 34614 } }, { "prepareds": { "avgElapsedTime": "321.740023ms", "avgServiceTime": "321.664558ms", "encoded_plan": "H4sIAAAAAAAA/7RVbW/bNhD+K8TNQGVAMOKXbZmAfDBspVPrSZ6ltigSQ2ali8xFJjWS6pKl2m8fKMmR7ToYhnX+YFv3PPfCh3enJ0CeiBTTuMgpBwfAhjukupQ4E1xLkStwhiMbGE/xYVqw9ygVExyciQ2c7hAcCKNg9jZeuO/dRZyhDrVI7mei5BoaiipoYngp3tEyN1ZRoKRaSHCe4LvuAaal3grJ/kSwoZDsM8sxQ2VYC6Y0ODdPEFGZoe6iOcFq7q7ihee7YMNSss/g/FjZZ4h1mQecdWXDX8mW5elpGSH+XiJPTBUNQSKvkx+SPCNImFA+BhuoAgcEtDKBA8EiDmJvHs/N14fYm++xmKXgwPc0SS4+XY4vf0ov08u7yTNaSPEbJrpW+MlosKPyMb7HR3C0LLGy4R4f94IeHf280qqgXNW14wNNdBPFBkl5hrV5y7ItONAb1yUkednc7tCGXPxhgAkYNfe00TFt/EwbHdGGL9GGUK2rtQ2lYjwDBzLFasdDZa9RJ9tDUf/NkU+DvRGM72Op41j7hnihR7mR3bhZlhax0pLxzLI2YjPYBIv6Tjf9PvnyhdzC4Bbqf2d4XsPrf1XYkkqa55jDf+rCa5ZrlGBDInjKmr4Bq/4cV0quSG/YJ5SnpIPmz9Cof4oFDXZbXlyME9Ib7wm9SWu7IifcLoTaDDZh/Ou7qR950ceDKD+cEcLjTDOav5aiLMxNZZnEjGoz9zeQmD1ipUxpxhNNTmWFtQ2ZcWzv6mZdrauvE2iUO0wZ1fitspy2LOPf7gT/S6O0Ki+b/QI2SFRlrmMjTbMg6hGZ+VHcFgc24ENhfP/pCNU51UMtke6gRkCxjNcvFVP7YQ4HeLn7hBIqGzQ+mH29XLnL6colL75WyPUq+IWQ0F24s4jMgnd+ZM29MPL8WWSJQRu63yfTkBzkat26DUIE8XzfXZE3gec36YgigU/euh9DYkVBHEYrz3/dxDRjVA/5q8Er80NO8Dbnh5/dlUuePeqxI1N/3pjmrWnUmczsdFN2zo5XpDepATXopqqbKaj+DgAA//8ZDTWgxgcAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:58.103679372 -0800 PST m=+4881.594558468", "maxElapsedTime": "770.311595ms", "maxServiceTime": "770.260818ms", "minElapsedTime": "62.887676ms", "minServiceTime": "62.847421ms", "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": 3418 } }, { "prepareds": { "avgElapsedTime": "5.221998ms", "avgServiceTime": "5.146395ms", "encoded_plan": "H4sIAAAAAAAA/6RUbW+bQAz+K8ib1CChSk0nTeIbBaqdmhcEdFLaRgQRN72OQHZcqnYt++2TD7IcfSGT9gn78YOxHxs/AxZZucRlssnTAmwAC24xlVuBbllIUeYV2CdDC3ixxEdnw7+jqHhZgP3FgiJdI9gQOLOxP4mTFUp3W8lyjeLsaWexJTTEapNmxF7ibbrNJVhQblCkshRgP8OnvQPOVt6Vgv9CsGAj+APPcYUVsUa8kmBfP0OcihXKfTbbvYzi6dgPwYJA8Aewv9bz2oLf2R3Pl68/EOHPLRYZ5W8IAguVVidd4FOUpQVY8AOfKrDhejAYDGSZVFLwYjX4fGIaLy/GDRzfgLK00ND8OHZqmnOore7HzlFmd+2nWp20jt6T73WGIBVpnmMO/9U0K7jkaR6I8h4zmpHAapvLRKJYV4qNjxsiDha7+hbHCzdh3sJUJb0fPmdhFPcyxszzRn4vZeQcyBHFoe/Hycm/kIa9JJfFswNZnLi/2isW9MaDb9NJf4aITdx+hhv6HuvXpKEkIzbupXkscqeXk/5cZ87IOVTSLPaS9h70t9/eDPcAz3Nihwjzel6/XvlICkzXoCJQ8VWhzhbt/d9awYb7qqSfuBlqx1fSvEVILB2lEjp+q5WOqQXXAebpHq2u7jfbriOaHh2YtkQH1FJ0ANrELtD8Be9gQx3TJqXDVyzYubUFEh/pygahHzihbxy49MZ5OB0bkT/y3dggDSyjlYaMpmmySA567krV7CHZNKkGc2L1whUL6KHUUAFSQTHVxPYWzY683YzIbleBTK1nlW8vunrJiZ2mhd0KGpeRb1z4s8i4fnv5j46P6NG9+x8ETk3TmEP9JwAA///plFV3bgcAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:57.738104204 -0800 PST m=+4881.228984375", "maxElapsedTime": "872.902314ms", "maxServiceTime": "872.841575ms", "minElapsedTime": "627.09µs", "minServiceTime": "587.484µ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": 14889 } }, { "prepareds": { "avgElapsedTime": "4.614773ms", "avgServiceTime": "4.538134ms", "encoded_plan": "H4sIAAAAAAAA/6STb2/aMBDGv4p1m1SQrGqtpk7Ku4ikE2oLLHY3IYqCFQ5wG+zMNhUdZJ99csKfDJW92Stzdz+ePH5y2QCqTE9xmha5UBAAUJihcCuDHa2c0bmF4OqaglRTXIeF/I7GSq0g+ExBiSVCAL34R9pPojhJb9I5OuZ09tJVMw01YQuReWyKM7HKHVDQBRrhtIFgAx+OBYQrt9BG/kKgUBj5KnOco/XUvbQOgtEGuDBzdEe1gPF+5w4oDIx8heBLOS4p/M4WMp+eqjP8uUKVefEaMKgqzSZ0h28sEwoovOCbhQBGrZbTqXVGqnnr43WbbLfkCS6foPrVGF2122Mo6d9yt+iyxU5sF8Pe8HvRnP59IIzIc8zhv+7UVdJJkQ+MfsbM52/QrnKXOjRLW9G4LjzYmlTmJpcTln57DHu8y4eTduXqHSIKeXh+OuTR+WG9LZ0eP48k8UOfx/9moi7j6acbD4zLcXmaHnMGxRKqCVg5V9Va+whr8xDAs9X+XR+kmq2DyWZzH0uzd7Ta7A55tC9LCg7XfmsHSTwIk5ic+2TIbdJ/ICy+jzucHJ9GSe3Yn0Me+ePgzhdHBxVZ32Wn5dMijywmd/GQkRHvp4wn3d5Xv8zbLbm4vPCL3Ghf+T3+EwAA//9YP1z/GAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.116589985 -0800 PST m=+4882.607468726", "maxElapsedTime": "665.022902ms", "maxServiceTime": "664.935041ms", "minElapsedTime": "469.449µs", "minServiceTime": "436.238µ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": 38751 } }, { "prepareds": { "avgElapsedTime": "16.539473ms", "avgServiceTime": "16.458609ms", "encoded_plan": "H4sIAAAAAAAA/6RU72vbOhT9V8R9/ZCAeDRxeeUZ9iGzXWZIm2BnK2UER9i3jlpF9iS5axe8v31Izq+mzRjsi0E+R+fec++x14AyrwosslowCT4AhXtkplEYVNKoSmjwB0MKXBb4PKr5F1SaVxL8CwqSrRB8mCRhlGTpbDT7nGYlmjHTZqIKVNBRdM1yyyvwnjXCAIWqRsVMpcBfwz/7A4was6wU/4FAoVb8iQssUVvWmGsD/tc1zJgq0ezVfFc9BQpTxZ/Av2znLYWf+ZKL4lg+xW8NytyqdwSF0okekmJrNM2Z9GDj2lnMbrM4zEL7CLI43GIZL2wv9x5e/ndx/n9xcX6eD3ZgraoHzI2b19o6WjH1kj3iC/hGNdhSeMSX7Xh2Rt6fma6Z1K5bfGa56RQoKCZLdK+XvFyCD2dd+Vw03Z48CqL63gEt3dOGp2jDVzTvFM2Ddt7OKTSayxJ8KDV3Fw9neYUmX8Kfuzy+P2WKCYEC/mqjV1wYF8a8kgXvtgG9Xq+36JpZ/LuYuPUu+uQDORv0CZMFeQ2HO3jYfw8PdrjX77/xEUtuOBPTLg5AQaFuhMkMqtV2p7UlvtK0ik7qPTAYJUkcJb8nRTez5C5zjHk7b4/b2n6kgq+4/aRscnSlDvsqUOfbqJ3ucX6sPHaKuyuDNxNJjUK2AtcUaF5K98ux6z20Bj486EoChZ2Xw1d7QkvB4LP1ME2i6SiJyMmfErlKJtckjcZRMCNWg5LDkva0KdUxO7Pk9lNkVV1OXErI6CYkXTBcLDbnYHP2uovk450rQsIoDcg4vo5nZADtrwAAAP//wIsIMncFAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.238102483 -0800 PST m=+4882.728981300", "maxElapsedTime": "536.986211ms", "maxServiceTime": "536.951519ms", "minElapsedTime": "1.497582ms", "minServiceTime": "1.420593ms", "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": 3456 } }, { "prepareds": { "avgElapsedTime": "14.865346ms", "avgServiceTime": "14.784808ms", "encoded_plan": "H4sIAAAAAAAA/6RUX2vbPhT9KuL8+tDwE2NNChuCPmS1ywJrFxJ3pYzg3No3jlZF9mS5axe8zz5sN2uWdIOypxDdo6Pzh+s12CZ5ymlcGLJQgMSCyVeOT3PrXW5KqKO+hLYp3w8L/YldqXMLdSxhacVQGA+vz8OLKK6KlDwHuvROJ/4dGbIJo4OVBSUNNuUFVcZDIi/Ykc8d1Br/Pf3BsPLL3Onvzc3C6TttOOOyQX3QpYf6vEZELmP/xKaC0TSajE4jSIydvoN6W89qiR/JUpt094Epf624U9YBHNuWdhs0auxOE7IDPHqHQjCKR0F8FY+CzWGsUyhQ/3iR9F8vbmgwSN/c0K9p4fIvnPg2r3XjZkXuIb7lByjvKq4lbvlhE82WiecTKwuyZauU7ynxHYeEI5txe7zU2RIKB53mxFRdUwMJk3/rBrV8gvX/BOujntUziarUNoNCVur24nZAY3JkDBv8U8xn7JMlXhLDro4zbTw7SCS5TXUXNQ4PD+cbnvmredfZvCdOxEG/J8imYhewGQ96vb0nTk1uee90ym0n7GPPbtX1UpBvkt3hvo6CeQ8Sd2QqbtU9Mxf/i4OjXhP83js2vWw3CxJkNJW/h/SC6Gb1Lnmgy4Rcum/OO6ZVdwOlzmz7RYCylTESnu+b7RtPwvFwEoq/7r84m3w8F5fjYBiFYiNQTMNItMbFyeNvY19cvQ8noejqEm1bYngRiKaethzUPwMAAP//d7yt2rAEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.583462057 -0800 PST m=+4883.074340842", "maxElapsedTime": "733.53466ms", "maxServiceTime": "733.476083ms", "minElapsedTime": "1.718073ms", "minServiceTime": "1.68297ms", "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": 36879 } }, { "prepareds": { "avgElapsedTime": "12.987686ms", "avgServiceTime": "12.916602ms", "encoded_plan": "H4sIAAAAAAAA/6RTUWvbPBT9K+Z8fWhBfJA1LEGwh9A4JNAtwcnmwQiOsG9stYrkSXKXLHi/fdhe0i4bg7FH6R6de865ukeQTk1GWVIqocEBhi0JX1m6M9pboxx47xWD1BntR6X8QNZJo8H7DFrsCBzvwjiZR+MwSnLysbBUmMrRSuwj4QkdzJUibbAZbUWlPBhMSVZ4Y8GP+O/5gFHlC2Pl1+ZlaeWTVJSTa1D30nnwT0eshM3JP7PxeBSF0/n7ZQiGhZVP4IN6XTN8SwupsssOS/pckU6bBh3Akm55X4Jmjd9lKvQtfpgHRzxNZuPTOZEZOIaDwZb6A9pu+68Hw2HvXC2teaDUt1kdGyc7YQ/JIx3Ava2oZnikwymWlwZ+H5crhXatStqL1HckDFbonNrrQuYFOK46BamqujHdMijzpSvU63rNUDmpc3DkTqJmP7uekE8L/JW0S4qFsEIpUvin+CdSebJgSI3OZJcirq83ZzWb/zdxMhtvboI3wVXv5hcZMy29FGrRTQEMllylfOLJ7k45lg3wknM1+ri5aaOqLzmX3pLYoa3AyVy3e9L4a5+B48EZjZrB0775n4soXIyiMPjjhgSTaP42WIb34d0qaIm6m7OsIJ6GURg0dluzqL8HAAD//xHtZb+2AwAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-04 23:17:59.435664833 -0800 PST m=+4882.926543580", "maxElapsedTime": "560.839588ms", "maxServiceTime": "560.779918ms", "minElapsedTime": "1.029527ms", "minServiceTime": "993.816µ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": 38462 } } ]