[ { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "CU_W_ID_D_ID_LAST", "index_id": "99b84dc2764c325c", "index_projection": { "primary_key": true }, "keyspace": "CUSTOMER", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((`CUSTOMER`.`C_W_ID`) = $1) and ((`CUSTOMER`.`C_D_ID`) = $2)) and ((`CUSTOMER`.`C_LAST`) = $3))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`CUSTOMER`.`C_ID`)" }, { "expr": "(`CUSTOMER`.`C_FIRST`)" }, { "expr": "(`CUSTOMER`.`C_MIDDLE`)" }, { "expr": "(`CUSTOMER`.`C_LAST`)" }, { "expr": "(`CUSTOMER`.`C_BALANCE`)" } ] } ] } } ] }, { "#operator": "Order", "sort_terms": [ { "expr": "(`CUSTOMER`.`C_FIRST`)" } ] }, { "#operator": "FinalProject" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "19.107873ms", "avgServiceTime": "19.034202ms", "encoded_plan": "H4sIAAAAAAAA/6RU72/aMBD9V6JbP4BkTSp06xppH9IkaEi0oISumiYUvOQa3AYns52urMr+9sk2AUp/rNu+QJx7d+/d3YvvAXlaZpglVUE5uAAErpCqWqBfciXKQoJ72CPAeIZ3XsU+o5Cs5OAeEeB0ieDCOArCKImn3vQiTnJUfi1VuUQhT1cjKtW5RlmwrGiqMzK8onWhgEBZoaCqFODew5vtAWL8XiNPdeKvdMGKTCAH9+tDkFerRSnYT42qBLtlBeYodakRk8rAp1TkqLaUrn8RT8dnYQQEJoLdgnvczJqW5J9UvAo01OOLU8r7sJ4luOBfJJfJMEgC/TPy4mkbS1gGLpycfPtwlKW94/dHab/3Lt1EK1FeY6rMGu5150sqVskNrsBVosaGwA2u2lnvNPz0CmRFuTSC8Y6mytYgICjP0bxesHwBLhwcGgFpUVsD9AkU5Q8baMgW1nsO1nsA6z8H60Mza2YEasl4Di7kkpnE3XEOUKUL+Js+9ytMqKBFgQX81+4HrFAogEBa8ozZjUCn0+nMWznzt3PfbHnedT46B4ddh/LM2QcEG0Cv+zRC28Mi+t3uo26GnClGi4k1BhAQKOtCJQrFst1tpYF7VTWrKfZ0eDCMNOsLiLNhEIzCFyFW+QuAU2/knfumyKyZNfp7fNjdWGRmyLIUf25po/lRmQHj2xFpor14rATSpUkEyXJubkFti41EcOFalhwIrHl2XwyD3ZP5nHfOdlDtm4aAwjt9L02icOJFofOKS9QZROMzJw5HoT91NB9x1jL0gyXQT5pa/69F27R2Rs7lpzAKHetJ40jHOw8ca0FjwPVZVzF2s9Kc0y8tGzS/AwAA///azo1JNgYAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.782134627 -0800 PST m=+4846.021198479", "maxElapsedTime": "181.530547ms", "maxServiceTime": "181.49561ms", "minElapsedTime": "1.639398ms", "minServiceTime": "1.596783ms", "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": 1772 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($6) || \".\") || to_string($5))]" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`STOCK`.`S_QUANTITY`)", "value": "$1" }, { "path": "(`STOCK`.`S_YTD`)", "value": "$2" }, { "path": "(`STOCK`.`S_ORDER_CNT`)", "value": "$3" }, { "path": "(`STOCK`.`S_REMOTE_CNT`)", "value": "$4" } ] }, { "#operator": "SendUpdate", "alias": "STOCK", "keyspace": "STOCK", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "8.365443ms", "avgServiceTime": "8.290778ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBT8KuJWaAKi0DQbw7A/QuLCyJpktrMR0uAI+zURVWRPkkO7NvvsQ267ND8KY/tPfu/83unu9ADSWZFTnpZKaAQAxw0JVxnqFtqZQlkE5y0OqXO665TyGxkrC42gzaHFihBgEH5Ph1EvjNKqzIWj2BXZLZ7athSZx+R0IyrlwFGUZIQrDIIHvNt+IKYfFemMwPErW0qVG9IIprugTuWWhZE/Pao0ci0VLcj6UV+kdTU8EWZBbrsyiJNhtw+OkZFrBB83s83Lhn+i0Kf7OBMaHLd0bxFg2mi4IrXOSL1onHxossdHdo2za9SnV633zeYMG747biSMUIoU/ovUJbls+UzpWfGXax9zYZ9EVxWaDqoxeb8sudSRWdl6aSncEgEa83r8/Gwep1/HnUHyOZnMm+BYC1X5TSfn9bgj8EnS20W23kI+Zao7SHbxF2/ho/BqmISHP7ThPd+/m87HdVrBIZQU9pVkf6vibLM/tidtJkx+rBU7Q2JVU4GVC12/MQS6UorD0Z2P7CgKR50oZEdfFLuMhldsPOp1kpDVvNg4Dlk/nMRsepDA07PTg/jNWBwmbOsY+8ROzjmrPfHnlj//Ud1XLnxlq6svtbH5HQAA//+PZic7NQQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.676632784 -0800 PST m=+4846.915696422", "maxElapsedTime": "1.131069503s", "maxServiceTime": "1.131028203s", "minElapsedTime": "790.751µs", "minServiceTime": "754.669µ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": 344287 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:DISTRICT" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "DI_ID_W_ID", "index_id": "8028a074b733c78a", "index_projection": { "primary_key": true }, "keyspace": "DISTRICT", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "DISTRICT", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "(((`DISTRICT`.`D_W_ID`) = $1) and ((`DISTRICT`.`D_ID`) = $2))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`DISTRICT`.`D_NEXT_O_ID`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "12.1788ms", "avgServiceTime": "12.118455ms", "encoded_plan": "H4sIAAAAAAAA/6STUWvbPhTFv4o4/z40IP40SSFFsIeQuMwsa0Ji2sEIjmbfOmoV2ZPkrl3xPvuwXS9Zuj1sA79Y9+jo3N/lPoNMkqeUxoWWBgLguCXpS0uT3HibawfRH3Aok9LjuFDXZJ3KDcQ5h5E7gsAqmk/exbPgOpjFGfl5mKKtuUImtSClW1lqD468ICt9biGe8d/+Byv6XJJJCBzfkq3SqSUD8fFn0bj029yqr7WqsOpBacrI1VYz5Xwjj6TNyO+fFNNwFS3DSQSOhVUPEKNqXXWP/FWKsAaxSqQZ4oUKBKZhHE7jmzicdoexSiFwcTa4kGej80+j4TAZXcgf1cLmd5T4huRz3c1O2qf4np4gvC2p4rinp47fQRO/xuoKaVyTlB5l4lsPDitNRs3xVmVbCJwMmgCJLtsZDjl0/qUtVHwv6/9O1ke1rtYcpVMmg0DmVHPxENAl+WSLP2ng2GEhrdSaNP5pUJdKe7LgSHKTqhY1Tk9PN12azf+bdmabHnvDTvo9Jk3KjgVdedDrvQoaGuWV1It2mOCw5ErtY092182jqIVHnlfBhyieN9Y10GOAyuw9q3VVf0eSlbckd81dOJWZZmFrSgfeELhzuUHF4emxXorFMliMlwF7vbDscjl/z1bBLJhE7MCjPe+ys5u3wTJgLbQGGRtfTdn05W+A6nsAAAD//wyzettPBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.950351098 -0800 PST m=+4846.189414697", "maxElapsedTime": "648.359771ms", "maxServiceTime": "648.313438ms", "minElapsedTime": "1.453177ms", "minServiceTime": "1.420171ms", "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": 3148 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((((to_string($4) || \".\") || to_string($5)) || \".\") || to_string($6))]" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`CUSTOMER`.`C_BALANCE`)", "value": "$1" }, { "path": "(`CUSTOMER`.`C_YTD_PAYMENT`)", "value": "$2" }, { "path": "(`CUSTOMER`.`C_PAYMENT_CNT`)", "value": "$3" } ] }, { "#operator": "SendUpdate", "alias": "CUSTOMER", "keyspace": "CUSTOMER", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "9.018364ms", "avgServiceTime": "8.934867ms", "encoded_plan": "H4sIAAAAAAAA/6RTYW/aMBD9K9YNqYlkIUG7arK0D1lI96GljUiYhCgKVnIFa8bJbAe1a9lvn5zBSihM2vYJcvfu3tO952dAlZcFFlkluQIGQOEBua01hqWyupQGWK9PQagCH4NKfEFtRKmAXVBQfIXAIA4mw+g2zeqq4BY/h2FtbLlCDb8QpuK5gxX4wGtpgUJZoea21MCe4d3rByT4rUaVI1D4kS+FLDQqYNM2KKjtstTiu0NVWqyFxAUat+pGGNvAU64XaF8pWThO0rthNAIKsRZrYB82s82O5J9UXONTknMFFL7ikwEGU8/zPFtmxmqhFl7nwicvL+QeuvfQ/NtrvfdP9y59fwYb2iaLueZSooT/knyFNl9uBW8t2bvLMacOdYSyVPimmqDz1KDNLOqVaXgrbpfAwJvvGObdeZh9Cm6C2zCa+0BhzWXtuDq9ZuHxgUk6yLbpag/1/zC0i2N4OHQOzvVD8aoYN7kFClwKbtpn+YtjzTaHywfC5FwXx1qJ1chXjSAwYqGaFwdM1VJSsPjo0huPojgYReTU+yJXo7shGceDII3ITh0ZJxG5jiYJmb6N41n3zP20w3iicen7ZEaSKCW/jSMfSadHScsXV+u72t7ZXe0cNj8DAAD//4bGvWtcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.928787842 -0800 PST m=+4846.167851582", "maxElapsedTime": "564.308052ms", "maxServiceTime": "564.249782ms", "minElapsedTime": "941.919µs", "minServiceTime": "895.555µ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": 29692 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 9, "Target": "default:NEW_ORDER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "ValueScan", "values": "[[((((to_string($2) || \".\") || to_string($3)) || \".\") || to_string($1)), {\"NO_D_ID\": $2, \"NO_O_ID\": $1, \"NO_W_ID\": $3}]]" }, { "#operator": "Parallel", "maxParallelism": 1, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "SendInsert", "alias": "NEW_ORDER", "keyspace": "NEW_ORDER", "namespace": "default" }, { "#operator": "Discard" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.91174ms", "avgServiceTime": "4.846357ms", "encoded_plan": "H4sIAAAAAAAA/6SSUWvbPhTFv4o4/0BtEAUn/5fpLSzeCOvsYGctowlG2LepmCJnkpxlS7zPPpw2jVvalw0Mls49+B78O3uQKeuKqmKjpYEAOO5I+sbS+9p4W2sHEQ05lKloN96oa7JO1Qbifw4j1wSBJL4p0mwSZ0VpSXpK6EdqK7J4cLiNLDtbRXey0R4c9Yas9LWF2OO/8wU5fW/IlASO3+W90pUlA3H73DRu/H1t1a/OtbFqqzStyHWfulLOH+1zaVfkzyvFU0JwzKzaQrxrl+1py1/FuJa6obyUBhzb7uwgcHsbBEHg68J5q8wqGAxDdjiwBS4XOJ56o1H49iwKQ872CyRpMSmmkwUEGww5OwrpSYgehZuTMGqXS7T8ec6ZtFJr0uBYy93pptwaIvqnH5CTqabGke2ISq2k61cBHN/o5wl9X36tEi9DT5Qrpa3QLtvueTHNvSW5xpGgUytzbCuEabTm8LTryM+yeDbOYvZWN9mHLP3MpkkeZ3M2Tebp2Rl8ir9ydj2++hKHD688mKdFPs+myccO6eHALi4vOmQ9efS6HD2BfOQ2iHif62DI+xAHozZE+ycAAP//dpBGC5UDAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.372885069 -0800 PST m=+4846.611948645", "maxElapsedTime": "607.845834ms", "maxServiceTime": "607.794518ms", "minElapsedTime": "503.571µs", "minServiceTime": "467.336µ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": 34462 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_01`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.889033ms", "avgServiceTime": "4.819437ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aMBCG/4p1m1SQIjSqSZPyLSLphGiBxe4mRFGwwgFug53ZpqIr2W+fnABJu7IPq4RkfH58997l9TOgTNUCF0mecQk+gAdL5Harsaek1Soz4HcvPRBygbsgF99RG6Ek+J89kHyD4MMw+pGM4jCKk26yQkutSh/6cqmgIkzOU4ctcMm3mQUPVI6aW6XBf4YP9QYo/tyiTBE8+J2uRbbQKMGfvoSCrV0rLX45KtfiUWS4QuNSXQtjS5xxvUJbl/QpG/UG4MFYi0fwvxSz4ljhvyQM8ImmXIIHD/hkwIdpq2VVYqwWctX6eNkm+z25g84dlP8aR912ewaF9zLdFdp0fUh2mNVR8Fvze319zDXPMszgXT31pbCCZ2Ot7jF1H0mj2WY2sag3pqRxlzuwNS/FzTtzmny7DYaszybzdqnqDSIMWHD+dMLC84eVpXpDdh6Jo5sRi/7NhH3Kkk9dB8z+mryQdcvFrHC/Vwi1GvmmvAtGrGT5NNyEq97Ah3ujnBVOlZqhUw/N4HFqzVjdSTM6YeFxW3hgcedMPY6jcRBH5NyzI1fx6IbQ6DrqMVJX80il2K0TFrrlpM5tagUlWfVyyOWGSW5pRAbRhJIpGyWUxf3hV+f1/Z5cdC6czxvhrrP5nwAAAP//SrzJB1wEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:28.779157447 -0800 PST m=+4844.018221003", "maxElapsedTime": "472.406272ms", "maxServiceTime": "472.349802ms", "minElapsedTime": "538.118µs", "minServiceTime": "506.919µ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": 34587 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 9, "Target": "default:ORDERS" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "ValueScan", "values": "[[((((to_string($3) || \".\") || to_string($2)) || \".\") || to_string($1)), {\"O_ALL_LOCAL\": $8, \"O_CARRIER_ID\": $6, \"O_C_ID\": $4, \"O_D_ID\": $2, \"O_ENTRY_D\": $5, \"O_ID\": $1, \"O_OL_CNT\": $7, \"O_W_ID\": $3}]]" }, { "#operator": "Parallel", "maxParallelism": 1, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "SendInsert", "alias": "ORDERS", "keyspace": "ORDERS", "namespace": "default" }, { "#operator": "Discard" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.999297ms", "avgServiceTime": "4.914469ms", "encoded_plan": "H4sIAAAAAAAA/6SSb2vbMBDGv4q4BWqDKCTttk7vTOINM88OttdSmmCEfU3FFDmT5dIt9T77sB3lT2nfbGCQnucO67jntwVURVVimW8kV8AAKNwjN43GaaWMrmQNbDyhIFSJT95GXKOuRaWAXVJQfI3AIPJv8jiZ+UleaOQGY12ihqFcb3jR9ZR4zxtpgEK1Qc1NpYFt4d1BQIo/G1QFAoU/xYOQpUYF7O60yWvMQ6XF765ro8WjkLjCuvtVKGrTt2dcr9AcnmT9aClQmGvxCOxTu2ztE/80wzWXDaYFV0DhsbvXwODuznEcx1R5bbRQK2d04ZLnZ7KA8wX0t6PSxH27NnZdSrYLiHMvDPMwnnrhAhgZXVHSmVMvSQI/yYNZ737YuVZfDnpm9WTQfpQlt/lgvR+sXcN4UHGYT6Osdz4Ozo3tuGiXS2jp6QrmXHMpUQKFNX+yStRrYOP/2m2KqgxUjbojhUvBu93uA/yBvyxPe+81yF6OOxN1wXUJ7bLtvhfV1Gjka+ixqMVK9fADU42UFAw+dSzNE3/uJT55FXXyOYm/kSBK/SQjQZTFZJiOOF/9W0quvfC77w5HSpwsztMsCaIvlpGz87PuIEeFyVuFsaWjT8fGt8vbxr3LbnRxQoeF4wCDZeEEKsvUHglLxDGPo6vWhfZvAAAA//9yT91HPAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.370455812 -0800 PST m=+4846.609519380", "maxElapsedTime": "469.355533ms", "maxServiceTime": "469.302463ms", "minElapsedTime": "559.643µs", "minServiceTime": "514.33µ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": 34462 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:ITEM" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[to_string($1)]" }, { "#operator": "Fetch", "keyspace": "ITEM", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`ITEM`.`I_PRICE`)" }, { "expr": "(`ITEM`.`I_NAME`)" }, { "expr": "(`ITEM`.`I_DATA`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.63523ms", "avgServiceTime": "4.567962ms", "encoded_plan": "H4sIAAAAAAAA/6SS0WvbMBDG/xXzbQ8tiEHHYKA3k6pg2rTGzjZGCY6wL446RfIkuaQr3t8+ZKdkbbqXFQxGut/dffruHkGmtg01VaelAQcY1iRD72hmTXBWe/CzjwzKNLRLO/WVnFfWgH9iMHJL4LgW36qb4lwUVUshC7TNzNpiCvtO1pFpaC17HcBgO3IyWAf+iHeHA0r62ZOpCQy/643SjSMDfvscSvuwsU79ilTn1L3S1JKPpa6UDyO+kK6lcGjJs4WYgyF36h7887Acnhr8l4JLeihracDwgx48OG6DrXxwyrQn789OlxjY84QLCvVmj+/N2Ct6zZ+X2bl0UmvSeJPozKigpM6dvaM6DsGR73WoArmtH2nadRE8WUVtqw+rrMqLbCZWp6Oi4+h1Ov938DxdpDG4PPJCmYOKYTnE7wVSBkdyO+bCq9aMqxgfPZUFx5230f5Jw9/nUfHTxcAQaBf3IC9EnhYieXVNk4viZp6U4krMFsm+BEum2vEfe05MfF3ypRTJpfheJkdT/xMAAP//Vp7K60kDAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.324430918 -0800 PST m=+4846.563494996", "maxElapsedTime": "925.760348ms", "maxServiceTime": "925.72246ms", "minElapsedTime": "496.868µs", "minServiceTime": "462.662µ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": 344287 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "971d1851a58665a9", "index_projection": { "primary_key": true }, "keyspace": "WAREHOUSE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$2", "inclusion": 3, "low": "$2" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "WAREHOUSE", "namespace": "default" }, { "#operator": "Filter", "condition": "((`WAREHOUSE`.`W_ID`) = $2)" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`WAREHOUSE`.`W_YTD`)", "value": "((`WAREHOUSE`.`W_YTD`) + $1)" } ] }, { "#operator": "SendUpdate", "alias": "WAREHOUSE", "keyspace": "WAREHOUSE", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "20.158053ms", "avgServiceTime": "20.08352ms", "encoded_plan": "H4sIAAAAAAAA/6STX0/bMBTFv4p1xgPVrEmFwcASDx0NAmmMqi2r0FSlV8kl8XCdzHYYDGWffUrCn1GqSWxPke2Tc8/9Xd07sE2KlNO4NGShAIlLplA5PixscIXxUP0tCW1TvhmU+gs7rwsL9V7C0pKhMBpcnEafp3FVphR4Ro7zovL8kQzZhNHpfElJI075kioTIFGU7CgUDuoOb54OmPD3irsffyW5NqljC/X1uWhQhbxw+mejKp2+1oYz9o3VJ+1DK5+Syzg8lVSzwTg6PjufRJAYOX0NtVfP64cq/xTjpKEySchu4x4RFGbH8cnw4RzrFAr7H/ppf2+nTzt7u7s7tP/4WrriGyehJXrXdLIkdxtf8S1UcBXXEld8+8DuzwbWM/UlWd+m5BtKQmci4chm3F7nOsuhsLHVJkhM1Q1zW8IUP7qHel7PJSqvbQaFzGvU8nnXI3JkDBv8F7sjDkmOVzW4GuRIm8AOEklhU91RxObm4tFn8W4xi0+Gi544EBtbvRcGh6aw/OJ2wi1LDnFgt+x4lhQacKveF9PhogeJazIVryveCsRbsdHvNWRfVLLpebs2kCCjya9QeA2ceb1qP9Q+IZeue5oEx7RsI8HrzLYrD2UrYyQC3zSLMxpHo8E4En9fcHE0PjsV56PhYBqJx5BiEk1F2744uP82EMTsOBpHohlKOxLUvwMAAP//firJu4IEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.877420769 -0800 PST m=+4846.116484330", "maxElapsedTime": "858.318274ms", "maxServiceTime": "858.264264ms", "minElapsedTime": "1.492175ms", "minServiceTime": "1.45734ms", "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": 32920 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((((to_string($4) || \".\") || to_string($3)) || \".\") || to_string($2))]" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`CUSTOMER`.`C_BALANCE`)", "value": "((`CUSTOMER`.`C_BALANCE`) + $1)" } ] }, { "#operator": "SendUpdate", "alias": "CUSTOMER", "keyspace": "CUSTOMER", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "10.430408ms", "avgServiceTime": "10.348289ms", "encoded_plan": "H4sIAAAAAAAA/6RTXWvbMBT9K+KsUJuJQrs+DMEePMeF0XQNcVIoaUiEfZuIKZInyaFdm/32Ya9Z89E8bHuTdA86595z7hPIFLakclJpaSAAjnuSoXaUWhOc1R7i9IxDmZIekkrdkPPKGohzDiMXBIFO1v1yk/VvJ3VVykBp7YNdkMNvgK9k0aBKupe1DuCwFTkZrIN4wrvXC3L6XpMpCBw/i7nSpSMDMdoGJXWYW6d+NKjKqaXSNCPffNVVPrTwgXQzCq+UIh3mg+urrA+OnlNLiI+r8WpN8k8qLukxL6QBxzd69BAYRVEUBTvxwSkzi47OY/b8zO5wcof2tFH6EB+uncXxGCu+TdaTTmpNGv8l+YJCMX8R/GLJxlzecmpXR6qtob3XnBpPPYVJILfwLW8lwxwC0XTNMD2ZppPPSTf5mmbTGBxLqeuGKzqEYe/Z0WmMxqhdPlMO26CBQ2ol/XYnf9HfeLX7eUf5QrryrVIeHMlFKwhezUy7IxCm1poj0EMTuF4/6yX9jB3YCHbRv75iw14nGWRsLY4N84xdZrc5G+0H6PjkeC89G++70WF5NmB/hsg+bZybcWL1KwAA//9XCZEQ7wMAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.62204184 -0800 PST m=+4846.861105434", "maxElapsedTime": "967.846731ms", "maxServiceTime": "967.793597ms", "minElapsedTime": "840.743µs", "minServiceTime": "803.234µ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": 31327 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:ORDER_LINE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "OL_O_ID_D_ID_W_ID", "index_id": "2e91eeb4be448a2e", "index_projection": { "primary_key": true }, "keyspace": "ORDER_LINE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" }, { "high": "$4", "inclusion": 3, "low": "$4" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Filter", "condition": "((((`ORDER_LINE`.`OL_O_ID`) = $2) and ((`ORDER_LINE`.`OL_D_ID`) = $3)) and ((`ORDER_LINE`.`OL_W_ID`) = $4))" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`ORDER_LINE`.`OL_DELIVERY_D`)", "value": "$1" } ] }, { "#operator": "SendUpdate", "alias": "ORDER_LINE", "keyspace": "ORDER_LINE", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "60.352317ms", "avgServiceTime": "60.280034ms", "encoded_plan": "H4sIAAAAAAAA/6SUUW/aPhTFv4p1/n0AyfpLQB46S3tATaohsYJCWzRNKLjJbfBqnMxxunZV9tmnJFBGgYduL5Fy78/Xx+fIfgGZOEsoiXItDQTAcU/SlZYuMuNspguIXp9DmYSehrm6JVuozEB4HEauCQJ+MB7dBuGXqMwT6WhiE7JjZQgtUeQyrrGE7mWpHTiynKx0mYV4wX+7H8zoe0kmrhf+ildKJ5YMxNd9aFi6VWbVz5rKrXpUmlIq6lFjVbgGv5Y2JbfbUkxCPwij8egqAMfUqkeI82pRbbf5Kx2j2pBZLM0AG3cgMBlHk2jkR379mUcjf9uLVAKBPn3oEd15d+R557JPr93cZt8odo2xL/Wx1tI+Rw/0DOFsSRXHAz1vjdw7zXGHi1yaopFMTzJ27RQOK01KTXml0hUEzvqNhFiXbagDDp39aBsV32GDU9hgD/NOYR6qRbXgKAtlUgikhWoW/mnoVFqpNWn8UyyX5OIV3ufXWyWXSjuy4Igzk6g2FXQ6nc5yN2r5/3IT9rLLPrKzfpdJk7AjjP/KDLonofkr5HW7B4IudGbooDqjJmpykSO7buPOpauTOKJie0n9ZRccj1KXtQVnvTqZg8EmuWnuMjikVrJ46+K73F1UbzfwVRFLmxxrzZwluW5EoVCpaZ4iCFNqzeHoqb7W0zCYDsOAnXp42GU4+cxupv7wOmA7fWwWXLM9K2q/e2z+KQgDtkmzyZINr3y2ia4JbluYbwoeqt8BAAD//5TkTFQ6BQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.578370586 -0800 PST m=+4846.817434155", "maxElapsedTime": "1.095737678s", "maxServiceTime": "1.095698436s", "minElapsedTime": "8.780228ms", "minServiceTime": "8.736236ms", "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": 31327 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:DISTRICT" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "DI_ID_W_ID", "index_id": "8028a074b733c78a", "index_projection": { "primary_key": true }, "keyspace": "DISTRICT", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "DISTRICT", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "(((`DISTRICT`.`D_ID`) = $1) and ((`DISTRICT`.`D_W_ID`) = $2))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`DISTRICT`.`D_TAX`)" }, { "expr": "(`DISTRICT`.`D_NEXT_O_ID`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "11.652597ms", "avgServiceTime": "11.584898ms", "encoded_plan": "H4sIAAAAAAAA/6STUWvbMBSF/4o560MDYrRJIUWwh1C7zNC1wQlLYQRHs28dtYrsSXLXrni/fViemyzLHraBX6x7dO6530UvIJ2VOeVppYQGBxjuSLja0EWpnSmVBT8dMkid09Okkh/JWFlq8DMGLTYEjutokd4kYZSkBblQWmdk5tCVbSWyVpPTnahVe1pWZIQrDfgL3mx/MKMvNemMwPA9W0uVG9Lgn34VTWq3Lo381qoqIx+looJsa3UlrfPyuTAFuW1LHsazeRJfzMEwNfIRfNwsm77JP6WIWxazTOgRfoIBRxincZgu0jjsD1OZg+P8ZHguTsZnn8ejUTY+F6/VypT3lDkP86WdZiPMc/pAz+DO1NQwPNBzz29niMNYbSW09UnpSWSu82AwQhfkj9eyWIPj6NQHyFTdrXHEoMqvXaFhW9nwT7IhmmWzZKit1AU4Civ9xV1Al+SyNf5mgH2HqTBCKVL4r0VdSuXIgCErdS471Dg+Pl71aVZvV2Eah6tB8C44Oh0EQufBfnnxKhgOBr8FjbV0Uqhpt0wwGLK1cqkjs+n3UbXCPdf55HbVuR2uX0e38/TGt26B7wOWetuzWTbttyeZOUNi4+/CykL7N91S3PEGx70tNRh8oP63YXD01L6haRJNJ0kUHHziwWVy8yGYRVfRxTzwBizYMe/K/VDB4n2UREFL27MOJtdh0MH1aNH8CAAA///n/y6SiwQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.336780866 -0800 PST m=+4846.575844452", "maxElapsedTime": "539.395296ms", "maxServiceTime": "539.357592ms", "minElapsedTime": "1.118288ms", "minServiceTime": "1.084902ms", "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": 34462 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_03`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.779149ms", "avgServiceTime": "4.707668ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNdtKkvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD//14VRQlcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.751027184 -0800 PST m=+4845.990090916", "maxElapsedTime": "414.654789ms", "maxServiceTime": "414.618313ms", "minElapsedTime": "553.311µs", "minServiceTime": "508.619µ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": 34548 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:ORDER_LINE" }, { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "as": "o", "index": "OL_O_ID_D_ID_W_ID", "index_id": "2e91eeb4be448a2e", "index_projection": { "primary_key": true }, "keyspace": "ORDER_LINE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$3", "inclusion": 1, "low": "$4" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "as": "o", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "NestedLoopJoin", "alias": "s", "on_clause": "(((`o`.`OL_W_ID`) = (`s`.`S_W_ID`)) and ((`o`.`OL_I_ID`) = (`s`.`S_I_ID`)))", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "as": "s", "index": "ST_W_ID_I_ID1", "index_id": "19508d065f75cbfd", "index_projection": { "primary_key": true }, "keyspace": "STOCK", "namespace": "default", "nested_loop": true, "spans": [ { "exact": true, "range": [ { "high": "(`o`.`OL_W_ID`)", "inclusion": 3, "low": "(`o`.`OL_W_ID`)" }, { "high": "(`o`.`OL_I_ID`)", "inclusion": 3, "low": "(`o`.`OL_I_ID`)" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "as": "s", "keyspace": "STOCK", "namespace": "default", "nested_loop": true } ] } }, { "#operator": "Filter", "condition": "((((((`o`.`OL_W_ID`) = $1) and ((`o`.`OL_D_ID`) = $2)) and ((`o`.`OL_O_ID`) < $3)) and ($4 <= (`o`.`OL_O_ID`))) and ((`s`.`S_QUANTITY`) < $6))" }, { "#operator": "InitialGroup", "aggregates": [ "count(distinct (`o`.`OL_I_ID`))" ], "group_keys": [] } ] } }, { "#operator": "IntermediateGroup", "aggregates": [ "count(distinct (`o`.`OL_I_ID`))" ], "group_keys": [] }, { "#operator": "FinalGroup", "aggregates": [ "count(distinct (`o`.`OL_I_ID`))" ], "group_keys": [] }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "as": "CNT_OL_I_ID", "expr": "count(distinct (`o`.`OL_I_ID`))" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "2.032666189s", "avgServiceTime": "2.032592024s", "encoded_plan": "H4sIAAAAAAAA/7RWW2/bRhP9K4v59CABhGFdnAsBPwgS85WpSqoik6BIBWpNjqmtqV12d5naNdjfXuxSsqhLmiZOXwRo5sztzBmSj4A8FRlmSVlQDi6AA7dIdSVxIriWolDg9gcOMJ7h/bhk71EqJji4Iwc43SC4EMXh5Mdk5r33ZgnliuWoIy3Su4mouIYGpkqaGmyGt7QqjFWUKKkWEtxH+N/+D0T4e4U8RXDgr3TNikwiB/fjIWhc6bWQ7E+DKiX7xArMUZlUM6a0hcdU5qj3Jd1wMfUWycwPPHBgLtkncF/WzhmgnaeFWda7Vr6pV98wF6WUD8EBqsAFAVs+wYVwloSJP02m5udD4k93voRl4MIAX/cRb0Y3OBq9ogN88pZS/Iaptqt4NBxsqHxI7vABXC0rrB24w4cd6wejn1+HKilXtne8p6lusjggKc/RmtcsX4MLnaFtIS2qRgZ9Bwrxh3GMwLC5gw0OYcMn2OAA1v8crA/1sl46UCnGc3AhV8wGtpl9gzpdt0n9mpGPk82ppEWBBTxr2QEqjdlMiPKtYNz0VjDbnjKS50la0EqZNrrd7kqsLlbhzG591SPXpLtSq4tVtDX0COUZ2cP8Y1hj6PWe1/GpPFVLnlFsu7G1+ofS7L++unyVXb64un15ld7cZt8mzd2xnVclt3QmhRDlTpH/VqhH9H5GZ8eoljaPiP9Sgi3qK1Wr4Dls1Mv6JDsrNEpwIBU8Y80SjNjO6a3TP9bY9Mk1ONFf2Ph+rS4vhynpDHeAzmhrM8o8wO5TNIL9+d04iP34l1aWF73eCUE+Z5rR4v9SVKXhKc8l5lSb5/tHSM1LpZsxpRlPNTmivwdLB3ITaPRmApZnOPK5RrnBjFGN36vKyRr495vgP3lSbVmeN8cKDkhUVaETQ01zX1agkyBOts2BA3hfmtgvjVCf52NXy6zkdCuRlkg3NhYUy7n9CDGjtVtwgVebG5RQO6Dx3ry25wtvPl545B8/Q8ibRfgTIZE38yYxmYTvgrg79aPYDyZxV1xs0/d6ZByRVr1t2P5lQgTxg8BbkLehHzQliSJhQJok5rTI9TVRF81TnIyDKXlKbzzWZWuRDz94C4+04kinvw+Ybk2Dvclc1f7+ztnxmnRG1mHK7O5tf21Q/x0AAP//7KaO8/EJAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:47.251965679 -0800 PST m=+4862.491029144", "maxElapsedTime": "3.126443234s", "maxServiceTime": "3.126403966s", "minElapsedTime": "342.28854ms", "minServiceTime": "342.235397ms", "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": 3148 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_04`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.765324ms", "avgServiceTime": "4.692108ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aMBCG/4p1m1SQompUSJPyLSLphGiBxe4mRFGwwgFug53ZpqIr2W+fnABJu7IPm4RkfH58997l9QugTNUCF0mecQk+gAdL5Harsaek1Soz4HeuPBBygbsgF99QG6Ek+F0PJN8g+DCMviejOIzipJus0FKr0se+XCqoCJPz1GELXPJtZsEDlaPmVmnwX+BDvQGKP7YoUwQPfqVrkS00SvCnr6Fga9dKi5+OyrV4Ehmu0LhUN8LYEmdcr9DWJX3KRr0BeDDW4gn8z8WsOFb4JwkDfKYpl+DBIz4b8GHaalmVGKuFXLU+XrXJfk/u4fIeyn+No067PYPCe53uGm26PiQ7zOoo+L35vb0+5ppnGWbwXz31pbCCZ2OtHjB1H0mj2WY2sag3pqRxlzuwNS/FzS/nNPl6FwxZn03m7VLVO0QYsOD86YSF5w8rS/WG7DwSR7cjFv2dCfuUJZ+6Dpj9MXkh65aLWeF+bxBqNfJNeReMWMnyabgJV72BDw9GOSucKjVDpx6awePUmrG6k2Z0wsLjtvDA4s6ZehxH4yCOyLlnR67j0S2h0U3UY6Su5pFKsVsnLHTLSZ3b1ApKsurlkMsNk9zRiAyiCSVTNkooi/vDL87r+z25uLxwPm+EO87mvwMAAP//6LqWHVwEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.82220769 -0800 PST m=+4846.061271231", "maxElapsedTime": "1.153344932s", "maxServiceTime": "1.153231962s", "minElapsedTime": "525.642µs", "minServiceTime": "494.196µ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": 34322 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "CU_W_ID_D_ID_LAST", "index_id": "99b84dc2764c325c", "index_projection": { "primary_key": true }, "keyspace": "CUSTOMER", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((`CUSTOMER`.`C_W_ID`) = $1) and ((`CUSTOMER`.`C_D_ID`) = $2)) and ((`CUSTOMER`.`C_LAST`) = $3))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`CUSTOMER`.`C_ID`)" }, { "expr": "(`CUSTOMER`.`C_FIRST`)" }, { "expr": "(`CUSTOMER`.`C_MIDDLE`)" }, { "expr": "(`CUSTOMER`.`C_LAST`)" }, { "expr": "(`CUSTOMER`.`C_STREET_1`)" }, { "expr": "(`CUSTOMER`.`C_STREET_2`)" }, { "expr": "(`CUSTOMER`.`C_CITY`)" }, { "expr": "(`CUSTOMER`.`C_STATE`)" }, { "expr": "(`CUSTOMER`.`C_ZIP`)" }, { "expr": "(`CUSTOMER`.`C_PHONE`)" }, { "expr": "(`CUSTOMER`.`C_SINCE`)" }, { "expr": "(`CUSTOMER`.`C_CREDIT`)" }, { "expr": "(`CUSTOMER`.`C_CREDIT_LIM`)" }, { "expr": "(`CUSTOMER`.`C_DISCOUNT`)" }, { "expr": "(`CUSTOMER`.`C_BALANCE`)" }, { "expr": "(`CUSTOMER`.`C_YTD_PAYMENT`)" }, { "expr": "(`CUSTOMER`.`C_PAYMENT_CNT`)" }, { "expr": "(`CUSTOMER`.`C_DATA`)" } ] } ] } } ] }, { "#operator": "Order", "sort_terms": [ { "expr": "(`CUSTOMER`.`C_FIRST`)" } ] }, { "#operator": "FinalProject" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "20.162467ms", "avgServiceTime": "20.087984ms", "encoded_plan": "H4sIAAAAAAAA/6RW32+kNhD+V9D0HrISqhQ27fWQ+kCA1SHtDwSkp6RaERd8u75jDbXNNWlE//Zq7CULSY5cey9Zz+fP45n5xkMegPKiLmmZNxXh4ALY8JES1Qrq11yJupLgnjs2MF7SO69hv1EhWc3BvbCBkwMFF2LvehWus3xHld9KVR+okJf3SyLVGgmGJxtSILmkH0lbKbChbqggqhbgPsAPJwNS+mdLeYEH/yn2rCoF5eD+PiZ5rdrXgv2NrEawL6yiOyrR1ZJJpekZETuqTle6/lWabVZhAjbEgn0B92237fpL/lcU30SKsHJpQfgcjmUEF/yr/EMeBXmAf5ZemvV7OSvBhXfv/vjloiyctz9fFHPnp+JxtxH1J1oorcADZn4g4j7/TO/BVaKlnQ2f6X1f60HCL0sgG8KlDpjekUIZHzYIwndUw3u224MLb851AEXVGu3nNlT1X2ajs08052s0Z0Sbf402h27bbW1oJeM7cGEnmT44LOeCqmIP/yXPpx5iIkhV0Qq+S/sFqxQVYENR85IZReDs7Ozstg/n9sdbX6t8O7N+td6czyzCS+spIXgkOLOXGdgehjGfzZ5lE3GmGKli0xhgg6CyrVSuqDj02jZIfOIVb9XOXt5eRAneOsFYRUGwDCcpJvIJQpolYZjl599CciZJfpRdv+LFy6ajvYniyf34/WY97SGN1v40w0/CIJquiaHky2g1SQui1N9crad9XXpL77WQrrMgP47w6fSPY95/hRd4mYeEbbftcMCO23UjSv1qZC1e79HHJnzmZsH4qefxoif7qRKUHPRBkGzH9RcN3/ljTcCFT7LmYINpnpGtJXiOoChDFFMd2UdNhpjOYQhEwdDSs39gm1c1RAZ1H8HYjUNAN98IwI4fA+a1vYA5Q2zQEUP4Jop7s7NB0Tv8uMZJGHtJaE3/E2Atks3KSsNl6GcWlsC2jpXBhckZV1gN/O0jHawdXKNQBvMyfeAmivFHF0NvYBE0Uwt2WqF0aPUS4frYCbgcpKz9nWquD3mZZ1Lo29P68D5MQsvMdz3dLW8dWGac62F+tDEjPbqtTRKEiXV53WcO3b8BAAD//12sjs99CQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.827133487 -0800 PST m=+4846.066197119", "maxElapsedTime": "885.818367ms", "maxServiceTime": "885.78205ms", "minElapsedTime": "1.644724ms", "minServiceTime": "1.612342ms", "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": 19860 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_05`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.823368ms", "avgServiceTime": "4.754983ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNatWkvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD//2Lu0BpcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:29.819856921 -0800 PST m=+4845.058920479", "maxElapsedTime": "411.259969ms", "maxServiceTime": "411.19344ms", "minElapsedTime": "535.489µs", "minServiceTime": "503.537µ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": 34009 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_10`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.808214ms", "avgServiceTime": "4.737963ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aMBCG/4p1m1SQIlSqSZPyLSLphGiBxe4mRFGwwgFug53ZpqIr2W+fnABJu7IPm4RkfH58997l9QugTNUCF0mecQk+gAdL5Harsaek1Soz4HevPBBygbsgF99QG6Ek+J88kHyD4MMw+p6M4jCKk+5lskJLrUof+3KpoEJMzlPHLXDJt5kFD1SOmlulwX+BD/UGKP7YokwRPPiVrkW20CjBn76Ggq1dKy1+OirX4klkuELjUt0IY0uccb1CW5f0KRv1BuDBWIsn8D8Xs+JY4Z8kDPCZplyCB4/4bMCHaatlVWKsFnLV+njVJvs9uYfOPZT/GkfddnsGhfc63TXadH1IdpjVUfB783t7fcw1zzLM4L966kthBc/GWj1g6j6SRrPNbGJRb0xJ4y53YGteipt35jT5ehcMWZ9N5u1S1TtEGLDg/OmEhecPK0/1huw8Eke3Ixb9nQn7lCXdSwfM/pi8kHXLxaxwvzcItRr5prwLRqxk+TbchKvewIcHo5wVTpWaoVMPzeBxas1Y3UkzOmHhcVt4YHHnTD2Oo3EQR+TsuyPX8eiW0Ogm6jFSl/NIJdmtExa65STPbWoJJVk1c8jlpknuaEQG0YSSKRsllMX94Rdn9v2eXHQunNEb4a7z+e8AAAD//1HOq4JeBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.097280111 -0800 PST m=+4845.336343801", "maxElapsedTime": "560.41426ms", "maxServiceTime": "560.377588ms", "minElapsedTime": "541.448µs", "minServiceTime": "508.509µ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": 34852 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "971d1851a58665a9", "index_projection": { "primary_key": true }, "keyspace": "WAREHOUSE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "WAREHOUSE", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((`WAREHOUSE`.`W_ID`) = $1)" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`WAREHOUSE`.`W_NAME`)" }, { "expr": "(`WAREHOUSE`.`W_STREET_1`)" }, { "expr": "(`WAREHOUSE`.`W_STREET_2`)" }, { "expr": "(`WAREHOUSE`.`W_CITY`)" }, { "expr": "(`WAREHOUSE`.`W_STATE`)" }, { "expr": "(`WAREHOUSE`.`W_ZIP`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "14.034312ms", "avgServiceTime": "13.968825ms", "encoded_plan": "H4sIAAAAAAAA/6RUbU/bPBT9K9F5+ACS9Ugp483SPkQQRCReojZbBVOVWsklNaRO5jgMhrLfPjleaYFu7EXKB9/r43PPPdfxI0hlVU55WpdCgQMM1yRMq+mwUkZXZQPuDxikyuk+qOVH0o2sFPg7BiXmBI44uDwLz5O0IDMWmmZV2xDcblOLzEJyuhZtacBQ1aSFqTT4I/5bBhjR55ZUZg9+y2ayzDUp8E/PQUFrZpWWXy2q1vJOllRQY6lOZWN6eCJ0QWZZko+DYXhy8WEUgiHW8g58r5t0iyp/JSOyXowyobbxwxhwjE/S6GgRpzIHx8Gen/v7O77Y2d/d3REHT7u1rm4oM72Pj7aTudAP6S09gBvdUsdwSw8L71YbWO9pUwvV9CrpXmTGkTBooQrq0zNZzMCx4fcKsrJ1I9xmKKsvbqObdBOGtpGqAEfRSHTsedfHZLIZ/kjaS4pYaFGWVOKf7D+WpSENhqxSuXQuYnNz+qRm+v90nEZH0y3vvbfhb72SESlppChjNwUwaGra0qSG9HzhY22BLznPg7Nw6vh+ghglwzBMUv+3UINfow6j5PItniB5Q9BVFFvA5NU0pVo60E06+72AjIwmMe/PopGF6l8FOzEnDRw3TaXA4IxZjXthzxPOlzW5wWruKooXYcdg6N7+yvEwjINh6K17aLzj4cWZNwpPw8PEc0KYt6y3sh7YtRXuckHSA6+i2FE82eaNT8Jh6Nkb1N8fdN8DAAD//4uX7colBQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.854510522 -0800 PST m=+4846.093574139", "maxElapsedTime": "1.071139139s", "maxServiceTime": "1.071083633s", "minElapsedTime": "1.137423ms", "minServiceTime": "1.069341ms", "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": 32920 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:ORDERS" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "covers": [ "cover ((`ORDERS`.`O_ID`))", "cover ((`ORDERS`.`O_D_ID`))", "cover ((`ORDERS`.`O_W_ID`))", "cover ((`ORDERS`.`O_C_ID`))", "cover ((meta(`ORDERS`).`id`))" ], "index": "OR_O_ID_D_ID_W_ID", "index_id": "753a694b68619fea", "index_projection": { "entry_keys": [ 0, 1, 2, 3 ] }, "keyspace": "ORDERS", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "(((cover ((`ORDERS`.`O_ID`)) = $1) and (cover ((`ORDERS`.`O_D_ID`)) = $2)) and (cover ((`ORDERS`.`O_W_ID`)) = $3))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "cover ((`ORDERS`.`O_C_ID`))" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "7.595072ms", "avgServiceTime": "7.528326ms", "encoded_plan": "H4sIAAAAAAAA/6SUUU/bPhTFv4p1/zw0koX+bRgMS3uo2qBVYmuVIqoJVamXXFIz18lsh8FQ9tkn24WMAn3YpD7UPj/b1+fc+AFQ5VWBRVZLroABULhGbhuNo0pZXUkDrD+gIFSBd8NaXKI2olLAjigovkFgME7OJ5dJ+iUr0Y4mBQTB1Dx3aoHXvJEWKFQ1am4rDewB/usGMMfvDaocgcKvfC1koVEBu3oODRu7rrT46ahai1shsUTjtjoXxnr8gusSbXckm6bjJJ0DhZkWt8BO2mX7eMRf1TBxHsxzrmKgkFe3qA2wq/CP9HqrcN7qcDXNJuNVFD1SO9p4r7rYq45eqBu0/AmJDleicPpymxgwmKaZq8cf63eHrZaJAhicvIv58enR1+P3x/3Ta+RPaq2rG8ytD9u1idX32Te8d1f+n/bpgMbOTjezTfrJ7tfjNzVXxnuKdzy3wKxukILmqkQ/vRblGhgc9H0JuWxCo8UUZPUjCC3tsMFb2OAZFr+FxdAu2yWFxghVAoPSCL/wz8RnXHMpUcI/9c2ZkBa1z0wVIjgKvV7vzcYhH8hBPyJcFeRVaNxhg2gPt+i4OIpe3G6ihBVczkLQQEGjaaTNLOrNY1K1A/d1ovuodq+ruk3bZet+O8jcauQbvxaMKJV/cJy3YV9gcGMqBS0Fi3fuk56lyWyYJmTnrSFn6fQTmSfnyeiChLVhKhRKFh+TNCHOVW8pGX4ek2Cf9247XmzHMbS/AwAA////FMLJEAUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.494236657 -0800 PST m=+4846.733300528", "maxElapsedTime": "809.214452ms", "maxServiceTime": "809.177215ms", "minElapsedTime": "807.655µs", "minServiceTime": "771.284µ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": 31327 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:ORDER_LINE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "OL_O_ID_D_ID_W_ID", "index_id": "2e91eeb4be448a2e", "index_projection": { "primary_key": true }, "keyspace": "ORDER_LINE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$3", "inclusion": 3, "low": "$3" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((`ORDER_LINE`.`OL_W_ID`) = $1) and ((`ORDER_LINE`.`OL_D_ID`) = $2)) and ((`ORDER_LINE`.`OL_O_ID`) = $3))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`ORDER_LINE`.`OL_SUPPLY_W_ID`)" }, { "expr": "(`ORDER_LINE`.`OL_I_ID`)" }, { "expr": "(`ORDER_LINE`.`OL_QUANTITY`)" }, { "expr": "(`ORDER_LINE`.`OL_AMOUNT`)" }, { "expr": "(`ORDER_LINE`.`OL_DELIVERY_D`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "29.271047ms", "avgServiceTime": "29.211711ms", "encoded_plan": "H4sIAAAAAAAA/6SUf2ujTBDH34rM0z8SWB7ID3ieE+4PqZYTbPSiaSlHMFudmm3N6q1rr73ivfZj1xhr29D7ASHo7MeZ73xn2CdAnhQppnGZUw4mAIEbpLIWeFpwKYq8AnMyJcB4ig9WyS5QVKzgYM4JcLpDMMFf2s4yDiMrWoVxhtIXKQqPcaygZaqSJgpM8YbWuQQCRYmCykKA+QT/9C8Q4tcaeYJA4EeyZXkqkIP5ZQhZtdwWgn1XVCnYPcsxw0ql8lglNR5RkaHsS5qtRs9dOEAgEOwezP+addOV+SMdrrIkTCifwd4fZYYX+7Frx7b6u4xduzuLWQomTPHDBPF6fo3z+f90iofTUhS3mEht7ZNqa0fFY3yHj2BKUWND4A4fOyMH3bztcFVSXmnJ+EAT2WYhICjPUIe3LNuCCSet+CSv27HOCOTFt/agIT02PYZNB9jkGDaBZt2sCdQV4xmYkFVMf/jc0DOUyRZ+r9OXOQIqaJ5jDn812jOWSxRAICl4ytqpwGg0Gm16QZt/N76nR7wZGx+Nk8nYoDw13mDsAzMdH4X8AzQbj1+15XImGc2DdkuAgMCqzmUsUey6MZcKfJ04XAWBd7UXqhMfRd1fYD6vrEXkRlfvcda5v1pE71G247kXzvIq1nXXrzaC8b7pZt2o3wsklALpTn8LFcu4vrvU0A8awITbquBAYFBwEFadDwJdm4PgMyu7eENA4oO6aoKlE1hLxzh+HRpnS//cCB3POY2MYTpi7EXoh664fmmb0I+9+DZV76Zx+clRtduF1OtoWAvb2G+f3r0u4O8DM2h+BgAA//+8JTpE/wUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.81321053 -0800 PST m=+4846.052274124", "maxElapsedTime": "283.795999ms", "maxServiceTime": "283.709032ms", "minElapsedTime": "4.128543ms", "minServiceTime": "4.092596ms", "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": 3072 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 10, "Target": "default:NEW_ORDER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "covers": [ "cover ((`NEW_ORDER`.`NO_O_ID`))", "cover ((`NEW_ORDER`.`NO_D_ID`))", "cover ((`NEW_ORDER`.`NO_W_ID`))", "cover ((meta(`NEW_ORDER`).`id`))" ], "index": "NO_D_ID_W_ID", "index_id": "71d1e05da49d1b12", "keyspace": "NEW_ORDER", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$3", "inclusion": 3, "low": "$3" }, { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "(((cover ((`NEW_ORDER`.`NO_D_ID`)) = $1) and (cover ((`NEW_ORDER`.`NO_W_ID`)) = $2)) and (cover ((`NEW_ORDER`.`NO_O_ID`)) = $3))" }, { "#operator": "SendDelete", "alias": "NEW_ORDER", "keyspace": "NEW_ORDER", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "12.012304ms", "avgServiceTime": "11.940531ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2vbPBTGv4p53l7EIEqd9GVMsIswu6zQxcEpDaOERLNOHTFVziS57Va8zz6sJE3/hbLtTj766Zzj59HRPciUtSQ5X2lhwAGGKxK+sfSxNt7W2oEnfQZlJN0NV+qCrFO1AT9mMOKawJFmZ6cXWfFlLkmTpxHd5laSxRpwK1F2lKQr0WgPhnpFVvjagt/jv90HJvS9IVMSGH6VS6WlJQN++RQaNn5ZW/Wzo1ZW3ShNFbku1ZlyPuDnwlbkdyX5KJvO8yLNCjCMrboBT47aWbst81d9nHZ6TEphBmAo6xuyDvxyvYp6vcVDzcXhYpTP8/lpuojjLfsKkb5JTF8Q1+TFYyw+XCjZIbONYeDYpA6nsQnPlQTHu0QmdPS/FMfvZfI16YPhG/3Y+vVYtNd9dCthXBCG7kTpwb1tiMEKU1EIL1W1BMfBINQtdbO+OQMGXd+uN1q2w5J9WPIE6+/D+mhn7YyhccpU4KicCgcf2zYWVmhNGv9k/onSPlzwsjZS+dAHer3eG95GH6KDJI6EkdFedLpD+/EbbL5jB3H84l8nZGQaRhIMQivhntn6B263s/Z5+lS5Ulj52tbEWxLXCDPmVGXCewJuGq0ZPN11wzkusvGwyKI9r0d0UuSfu83sPFuvH1qMpp+yIos2ugZRo+EojTbqBem2gXwTGKD9HQAA//89R9uB6wQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.527069044 -0800 PST m=+4846.766132758", "maxElapsedTime": "548.579887ms", "maxServiceTime": "548.54462ms", "minElapsedTime": "811.242µs", "minServiceTime": "770.355µ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": 31327 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_07`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.871981ms", "avgServiceTime": "4.804717ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aMBCG/4p1m1SQompUk5DyLSLphGiBxe4mRFGwwgFug53ZpqIr2W+fnABJu7IPm4RkfH58997l9QugTNUCF0mecQk+gAdL5Harsaek1Soz4HeuPBBygbsgF99QG6Ek+J89kHyD4MMw+p6M4jCKk26yQkutSh/7cqmgIkzOU4ctcMm3mQUPVI6aW6XBf4EP9QYo/tiiTBE8+JWuRbbQKMGfvoaCrV0rLX46KtfiSWS4QuNS3QhjS5xxvUJbl/QpG/UG4MFYiyfwu8WsOFb4JwkDfKYpl+DBIz4b8GHaalmVGKuFXLU+XrXJfk/u4fIeyn+No067PYPCe53uGm26PiQ7zOoo+L35vb0+5ppnGWbwXz31pbCCZ2OtHjB1H0mj2WY2sag3pqRxlzuwNS/FzS/nNPl6FwxZn03m7VLVO0QYsOD86YSF5w8rS/WG7DwSR7cjFv2dCfuUJZ+6Dpj9MXkh65aLWeF+bxBqNfJNeReMWMnyabgJV72BDw9GOSucKjVDpx6awePUmrG6k2Z0wsLjtvDA4s6ZehxH4yCOyLlnR67j0S2h0U3UY6Su5pFKsVsnLHTLSZ3b1ApKsurlkMsNk9zRiAyiCSVTNkooi/vDL87r+z25uLxwPm+EO87mvwMAAP//dkdcFFwEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:27.990591303 -0800 PST m=+4843.229654911", "maxElapsedTime": "863.442151ms", "maxServiceTime": "863.399495ms", "minElapsedTime": "536.039µs", "minServiceTime": "498.4µ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": 34710 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((((to_string($6) || \".\") || to_string($6)) || \".\") || to_string($7))]" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`CUSTOMER`.`C_BALANCE`)", "value": "$1" }, { "path": "(`CUSTOMER`.`C_YTD_PAYMENT`)", "value": "$2" }, { "path": "(`CUSTOMER`.`C_PAYMENT_CNT`)", "value": "$3" }, { "path": "(`CUSTOMER`.`C_DATA`)", "value": "$4" } ] }, { "#operator": "SendUpdate", "alias": "CUSTOMER", "keyspace": "CUSTOMER", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "5.678395ms", "avgServiceTime": "5.577603ms", "encoded_plan": "H4sIAAAAAAAA/6RT72/aMBD9V6wbUhPJQoKidbK0D2lIv7S0EQmTEEXBSq5gzTiZ7aB2LfvbJ2ewNpRW+/EJfPfO7+Xe8yOgyssCi6ySXAEDoHCH3NYaw1JZXUoDrNenIFSB90ElvqA2olTABhQUXyMwiIPpKLpOs7oquMXzMKyNLdeo4RfCVDx3sALveC0tUCgr1NyWGtgjfHg+QILfalQ5AoUf+UrIQqMCNmuDgtquSi2+O1SlxUZIXKJxV10JYxt4yvUS7TMlCydJejOKxkAh1mID7NN2vt2T/JOKS3xIcq6Awld8MMBg5nmeZ8vMWC3U0ut89MnTE7mF7i00/1qtt3tnvj+HLW2TxVxzKVHCf0m+QJuvdoJ3lrzYyzGnDnWEslT4qpqg89SgzSzqtWl4K25XwMBb7BkW3UWYnQdXwXUYLXygsOGydlydXnPh8YFpOsx26WoP9d8Z2scxPBw6fWdoGKRBGz0Al5HDT1XFpEk5UOBScNNe4l+sdr49vHwoTM51cayVWI183QgCI5aqeZ/AVC0lBYv3LuvxOIqDcUTeeo3kYnwzIpN4GKQR2asjkyQil9E0IbPX4T3pnrgf8ieNM98nc5JEKfltM/lMOj1KWi66Wt/VXpjkaqeu5jxwhwFsfwYAAP//mukgYpcEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:28.780292089 -0800 PST m=+4844.019355718", "maxElapsedTime": "513.965326ms", "maxServiceTime": "476.046639ms", "minElapsedTime": "509.394µs", "minServiceTime": "459.828µ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": 3228 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_08`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.760026ms", "avgServiceTime": "4.688823ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNatKqvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD//5BMvTpcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.620757421 -0800 PST m=+4846.859821094", "maxElapsedTime": "1.022966559s", "maxServiceTime": "1.022930934s", "minElapsedTime": "543.353µs", "minServiceTime": "503.55µ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": 34793 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((((to_string($1) || \".\") || to_string($2)) || \".\") || to_string($3))]" }, { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`CUSTOMER`.`C_ID`)" }, { "expr": "(`CUSTOMER`.`C_FIRST`)" }, { "expr": "(`CUSTOMER`.`C_MIDDLE`)" }, { "expr": "(`CUSTOMER`.`C_LAST`)" }, { "expr": "(`CUSTOMER`.`C_BALANCE`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.80372ms", "avgServiceTime": "4.69763ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBD9KuI2qA0m0HYw8H+u44BpsgTbGYw0OMK+JuoUyZPkkqz1PvuQkyxOf22sYNCd7t29d+fTA6AoZIllXnEqwAfw4BapqRWGUhgluQb//MIDJkrcBBX7ikozKcD/5IGgawQfxkk/SvI0C7Jpmi/RhLU2co3qanuw4hJ2aF3RwqaUeEtrbsADWaGiRirwH+DD0YEUf9QoCgQPfhUrxkuFAvzZKSiozUoq9tOiKsXuGcclaltqyLRp4RlVSzRHSj+cptl4FCXgwUSxe/A/N/PmQPJfKq5xmxZUgAffcavBh5njOI6RuTaKiaXz8dwlj4/kBno30Fqd0IX7euzSdefQeKdkAzTFak+1H2ano5dm/LTChCrKOXJ4V9OxYIZRPlHyDgv7IxXqmpvcoFrrFo2bygKdxUHforcI87i/cFtJL4cHcZJmbyJGcb8/jN6EDIO/1LgKhsGXsC0yfzZgJo5tNfPGfk8gqVFI120uaLYU7XOxU/xTGXy409KuxL6l7kXc73pWbNff9Xe4aTwwuLH7O0miSZBE5F9eGxkk4xFJo2EUZsQSemSvwxo7BmtZbnvuVe/SDpMi0zQi19G3lMyeL/NZ78wep6v8SuDSdckcmt8BAAD//2PwYRtrBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:28.795905709 -0800 PST m=+4844.034970034", "maxElapsedTime": "268.855405ms", "maxServiceTime": "268.782293ms", "minElapsedTime": "674.489µs", "minServiceTime": "615.352µ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": 1301 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:DISTRICT" }, { "Priv": 7, "Target": "default:ORDERS" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "as": "d", "index": "DI_ID_W_ID", "index_id": "8028a074b733c78a", "index_projection": { "primary_key": true }, "keyspace": "DISTRICT", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "as": "d", "keyspace": "DISTRICT", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "NestedLoopJoin", "alias": "o", "on_clause": "((`d`.`D_ID`) = (`o`.`O_D_ID`))", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "as": "o", "index": "OR_D_ID", "index_id": "fa289e60810a7a44", "index_projection": { "primary_key": true }, "keyspace": "ORDERS", "namespace": "default", "nested_loop": true, "spans": [ { "exact": true, "range": [ { "high": "(`d`.`D_ID`)", "inclusion": 3, "low": "(`d`.`D_ID`)" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "as": "o", "keyspace": "ORDERS", "namespace": "default", "nested_loop": true } ] } }, { "#operator": "Filter", "condition": "((`d`.`D_ID`) = $1)" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "self", "star": true } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "5.15788874s", "avgServiceTime": "5.157816416s", "encoded_plan": "H4sIAAAAAAAA/6SUUW/aPhTFv4p1/31oqwhBQX+YpT50JJXSMYIC6h4mFLzkErwaO7OdtqzKPvvkZFA6Oq1rH20fXf987vF9AJSpyjBLCsEkUAAPlshsqXGopNVKGKCdMw+4zPD+ouDXqA1XEmjPA8nWCBSms2j4IRkF18EoydFGOkNt3m98bqzmqYVGaAqWOnWGS1YKt6sK1MwqDfQB/ntcwBS/lShTBA9+pCsuMo0S6OenoovSrpTm352q0PyWC8zRuFIjbmwtnzGdo328kvrhdBaHwxl4MNH8Fmi/8p6RRbEfxNM90bzakrwKNXTWTVMmu+ABM+4m+GUoUPDDJPSTT0nobzcTngGFQftswNr93pd+t5v2B2x3Wmj1FVNbN+HBvX3N9Ca5wQ1Qq0usPLjBzdbtvSc/3wRTMGlqZLxnqW1qeKCZzLHeXvF8BRSOOjVAKsqm/V0PhLprDqp5NfegNFzmQCE3HJyv+xZcok1X+69/OeLvpSZMMyFQwJt6MkZjMRspVVwpLh2Z4DWccsGUSSpYaRzG8fEiW7QWfhL6ixNyTo4XatFaREmzcfI2isNkqL1kRHF9y9NYLNnZ4B3+3x502qzPer3XxWIX8edDIWt3EqFUsQ3ES3Oyb9cfEvNE8o/ZUfCmd1Tz6qA8FxY1eJAqmfHGv4OuH3VODrhCyS1nYtL4Dh5oNKWwiUW93jpVOKFBsXQ/zTK9oziAkI+VHOQh59RqZGuoh5HhuaxntGv1KVA4hcoDi/dujE3iYHIRB+QvY5lcxtFHMg1GwXBGTpsV2f5FkpFwPA5ichWFY9K4TBSJxiRrOVPI+TlRreYXkLsVatwdEDcQfgYAAP//jix+2FcGAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:44.872537699 -0800 PST m=+4860.111601344", "maxElapsedTime": "10.793746893s", "maxServiceTime": "10.793654251s", "minElapsedTime": "1.462542676s", "minServiceTime": "1.462507334s", "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": 3148 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_09`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.794575ms", "avgServiceTime": "4.73142ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNatLUvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD//xoY+z1cBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:28.388827237 -0800 PST m=+4843.627891768", "maxElapsedTime": "581.361939ms", "maxServiceTime": "581.293288ms", "minElapsedTime": "556.203µs", "minServiceTime": "520.313µ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": 33685 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_02`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.889673ms", "avgServiceTime": "4.81509ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAgNNGlS3kUknRAtsNjdhCgKVjjAbbAz21R0JfvskxMgaVf2YpOQjM8/3/3v8vcLoEzVEpdJnnEJPoAHK+R2p7GvpNUqM+B3ex4IucR9kIuvqI1QEvyPHki+RfBhFH1LxnEYxUkvWaOlVqWPA7lSUBEm56nDlrjiu8yCBypHza3S4L/Af/UGKH7foUwRPPiZbkS21CjBn72Ggp3dKC1+OCrX4klkuEbjUt0IY0uccb1GW5f0KRv3h+DBRIsn8D8V8+JU4a8kDPGZplyCB4/4bMCHWatlVWKsFnLd+r/XJocDuYfOPZT/GkfddnsOhfc63TXadHNMdpzVSfB783t7fcI1zzLM4J96GkhhBc8mWj1g6j6SRrPLbGJRb01J4z53YGtRilt0FjT5cheM2IBNF+1S1TtEGLDg8umUhZcPK0v1R+wyEke3Yxb9mQkHlCUfeg6Y/zZ5IeuWi3nhfm8QajXybXkXjFjL8mm4CVe9gQ8PRjkrnCs1Q+cemsHT1JqxupNmdMrC07bwwOLemXoSR5MgjsilZ0eu4/EtodFN1GekruaRSrFbpyx0y1md29QKSrLq5ZjLDZPc0YgMoyklMzZOKIsHo8/O64cDuepcOZ83wl1n818BAAD//9RBAw5cBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.661762555 -0800 PST m=+4846.900826121", "maxElapsedTime": "589.906023ms", "maxServiceTime": "589.805774ms", "minElapsedTime": "543.462µs", "minServiceTime": "507.303µ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": 35116 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:DISTRICT" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "DI_ID_W_ID", "index_id": "8028a074b733c78a", "index_projection": { "primary_key": true }, "keyspace": "DISTRICT", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "DISTRICT", "namespace": "default" }, { "#operator": "Filter", "condition": "(((`DISTRICT`.`D_ID`) = $2) and ((`DISTRICT`.`D_W_ID`) = $3))" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`DISTRICT`.`D_NEXT_O_ID`)", "value": "$1" } ] }, { "#operator": "SendUpdate", "alias": "DISTRICT", "keyspace": "DISTRICT", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "15.225759ms", "avgServiceTime": "15.156421ms", "encoded_plan": "H4sIAAAAAAAA/6SUb2vbMBDGv4q49UUDYrRxoUGwF6F2mWFLguMugxGcm3R1tCqyJ8tduuJ99mG76Z+0G3R7Kd3j5577HdYtkJWFIpWVBi0IAA6XhL52dFZY7wpTgTgectBW0XZc6k/kKl1YECccLG4IBEyiRTZNwijJtJWONmT9hLZ+6hS5WEGvq0qUrVjRJdbGA4eiJIe+cCBu4c3DAeb0vSYrCTj8kmttlCML4stT0bj268Lpn62qdPpaG8qpaq0+6Mp38hRdTv6hpQjjeZrEZylwmDl9DWLULJtdk39KEbdQ5hJtAHeEQEAYZ3GYLbI43F1mWoGA0dFwhEenJ19Pg0CejvC+WrriG0nfUb1tp9mgu8mu6AaEdzU1HK7oZsfv0RAvY61KtFWXlLYofe/BwaHNqbte63wNAg6GXQBp6n6fAQdT/OgLDX+QBX+SBdAsmyWHutI2BwF5pbsPHwOaoUNjyMB/YT4nL9fwGgz7Oc618eSAgyys0j1qODw8XO18Vm9XYRaHqwF7xw6GA4ZWsf3y4l4QDAbPWpyZwtKz2zl1OyGfeXKbfi8l+pbsnvsk+pxm064FcLhGU7cDHRy3lJ+ZWnVRKvQtNjQaq6dEXsFp2eybh7qS6NRLpbl3hJsuEFQ6t90zAcLWxnDwtG1/tlkSzcZJxP7+KLDzZPqRXczCcRqxXUY2j1L2CERL+pgt3kdJxMK785CNJyHrd9FtAprfAQAA//8ANc1FwwQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.358749764 -0800 PST m=+4846.597813614", "maxElapsedTime": "463.796298ms", "maxServiceTime": "463.725527ms", "minElapsedTime": "1.920425ms", "minServiceTime": "1.864307ms", "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": 34462 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 9, "Target": "default:ORDER_LINE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "ValueScan", "values": "[[((((((to_string($3) || \".\") || to_string($2)) || \".\") || to_string($1)) || \".\") || to_string($4)), {\"OL_AMOUNT\": $9, \"OL_DELIVERY_D\": $7, \"OL_DIST_INFO\": $10, \"OL_D_ID\": $2, \"OL_I_ID\": $5, \"OL_NUMBER\": $4, \"OL_O_ID\": $1, \"OL_QUANTITY\": $8, \"OL_SUPPLY_W_ID\": $6, \"OL_W_ID\": $3}]]" }, { "#operator": "Parallel", "maxParallelism": 1, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "SendInsert", "alias": "ORDER_LINE", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Discard" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.962597ms", "avgServiceTime": "4.873271ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv0p0D1JBsqqG8myr37GRTtHShCWBChUUWcmVWjMOc0zVrWSffXJIAqnavdgQEvHv/uAT97tnQJnmGWbJVjAJFIDAPTK9U/gpl1rlogBqDwlwmeHTeMvnqAqeS6AjApJtECj4zm0ShBMnTFKFTGOgMlQelwiHSLFlqclleM92QgOBfIuK6VwBfYb/jgeI8PsOZWq++Ct94CJTKIHedUPjnX7IFf9pUlvFH7nANRbmpzxe6CoeM7VGfbySHtrzXN8BAlPFH4Felauyueav+pgzscMoZRIIPJrnAijc3fWrl86TQisu1/3e5cDa760lnC+hejopDQdv1+w/1EaDAbGelxB4yfgmmPnxEqjVuyJWhSaO586dcJFMKvy+wW4UJ65/HVTUvmhw4h5ywxq4Dfi/Bv7s5qMTVmhUo6DJ2DX4Ohv7sRsvKvihhtFsOvUWyW0TflfzFlyWqxWUpPu/TpliQqAAAhv21Jx4sQFq/9PAIpSZKwtURkEmODMD65jxDX80snb4axa/bHvCi5SpDMpVad4vqpFWyDZQOVfwtaw2DKjcCUFA45ORdRo603HoWG/uk3UdBjeW60dOGFuuHwfWscv+F2dBrPnYmzmDw0fUj4MkikPX/2wk3O+ts/MzI9IJHr6O7dfxyFjXEaCdf21RK1E94t7lS4dahWrNWsu6srSudGRuXT7RrbWt3YTjIpwY37MvygGUvwMAAP//roDuK/AEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.691589285 -0800 PST m=+4846.930652845", "maxElapsedTime": "1.165644232s", "maxServiceTime": "1.165583831s", "minElapsedTime": "506.444µs", "minServiceTime": "452.381µ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": 344287 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:NEW_ORDER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "covers": [ "cover ((`NEW_ORDER`.`NO_O_ID`))", "cover ((`NEW_ORDER`.`NO_D_ID`))", "cover ((`NEW_ORDER`.`NO_W_ID`))", "cover ((meta(`NEW_ORDER`).`id`))" ], "index": "NO_D_ID_W_ID", "index_id": "71d1e05da49d1b12", "index_projection": { "entry_keys": [ 0, 1, 2 ] }, "keyspace": "NEW_ORDER", "limit": "1", "namespace": "default", "spans": [ { "exact": true, "range": [ { "inclusion": 0, "low": "(-1)" }, { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "(((cover ((`NEW_ORDER`.`NO_D_ID`)) = $1) and (cover ((`NEW_ORDER`.`NO_W_ID`)) = $2)) and ((-1) < cover ((`NEW_ORDER`.`NO_O_ID`))))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "cover ((`NEW_ORDER`.`NO_O_ID`))" } ] }, { "#operator": "FinalProject" } ] } } ] }, { "#operator": "Limit", "expr": "1" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "16.441157ms", "avgServiceTime": "16.368328ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2/aMBTFv4p11wciuRWmnapZ2gMqqYZEAYWqaOpQ8JLb4M44meP0z6rss082AfoPMW1vyc3P99rnnPgJUCd5imlcKKGBA1C4QWErg2e5tiZXJXDWoSB1ig/dQl6hKWWugZ9Q0GKJwKEXDvpXYfQ1ztAO8X5kUjSw+loWInFIijeiUhYo5AUaYXMD/Ak+bF9ggj8r1AkChd/JQqrUoAZ+/RLqVnaRG/nLUYWRd1JhhqVrNZCl9filMBna7Ug+DKfxKOqFEVAYG3kH/LSe1esp/7SNv4L6TrBJIvQxUEjyOzQl8OvVE2m15pt9zY/mw1E8ivu9eRCs2XeI3l5i+oZYohXPseBoLlOHzBpHgUPT2q+GphzLFDicspRh+2MqTj6l7DvrbL4WJr/FxPocuARZ8xj/wEd3wDZltOP0de+N+88tUHIpnT1sZ0LKQujSy4kPIrHAramQghE6Q1+WOlHVKoRtCiq/Bw6tQxZATZ9gIbMFcDhgfrMb8HgNHrAXWGcX1oF6Vs8oVKXUGXDISukXPrd4LIxQChX8V5rOpbL+h0lyncqVqNBqtfbkgHwmBywgQqdkJzrdop2gYZ1S5FvVbh8nZE8Yg+DNkftaWinUeBUAoGCwrJSNLZrl2rTCgfty7v7B1zrobeN6Vr8lBj47dD2CeeoVM7EGxdK3h1Jm2l9lzpdmNnC4LXMNNQWLDy6J4ygcd6OQvHeNkfNodEEm4SA8uyRNh1Vtcywy/RJGIWmM8a6Q7rBHGvm99uuCX+61R3LIyKB/0b8kDOo/AQAA//8XED5EhgUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.476870929 -0800 PST m=+4846.715934535", "maxElapsedTime": "576.700448ms", "maxServiceTime": "576.667141ms", "minElapsedTime": "924.142µs", "minServiceTime": "889.851µ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": 31360 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:DISTRICT" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "DI_ID_W_ID", "index_id": "8028a074b733c78a", "index_projection": { "primary_key": true }, "keyspace": "DISTRICT", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "DISTRICT", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "(((`DISTRICT`.`D_W_ID`) = $1) and ((`DISTRICT`.`D_ID`) = $2))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`DISTRICT`.`D_NAME`)" }, { "expr": "(`DISTRICT`.`D_STREET_1`)" }, { "expr": "(`DISTRICT`.`D_STREET_2`)" }, { "expr": "(`DISTRICT`.`D_CITY`)" }, { "expr": "(`DISTRICT`.`D_STATE`)" }, { "expr": "(`DISTRICT`.`D_ZIP`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "11.723969ms", "avgServiceTime": "11.651308ms", "encoded_plan": "H4sIAAAAAAAA/6RU72vbMBD9V8ytHxoQo3EKKYJ9MLHLDG1nErPSjuBo9tVRq8ieJHftgve3D1n1kqZZ9wv8wXf3/PTuPaM1oMyrAousFkwCBSBwg8w0CieVNKoSGujQJ8BlgQ9BzT+i0rySQI8JSLZCoJAEV+fRRZqVaEKujeK5ATfUNcstosAb1gjbrWpUzFQK6BrebAqY4ZcGZY5A4Hu+5KJQKIF+eg4KGrOsFP9mUbXi91xgidpSnXFtOnjKVIlmcyQN41k6jScpEEgUvwc6budtf8g/qYitE7OcyRE82QIUwjiLw+wyi8O+mfECKJwc+SfsaHz8eTwa5eMT9nNaq+oWc9NZubbbrJh6zO7wEahRDbYE7vCx929rif226ppJ3SnFB5Ybx0FAMVli117ycgkUDvxOQC4aF+KIgKi+ukFLNrDhr2BDaOftnECjuSyBQql59+G2Qado8iX8zQK7DAlTTAgU8F9BnXJhUAGBvJIFd1bD4eHholezeLtwmS0G3jvvYDjwmCy8XUA/9geDF0JjyQ1nInFhAgGFuhEmM6hWfR61Be5wXgTn0cLR7QfM0mkUpdnwT0D+q6BJnF79hiVIXxdzHSd2Pn8RNJeb3dt5a58dyMwoZKvuW9C8lN3NYtN0woDCra4kEHCebNedrucN58menr/du46TvmwJGHyw90EyjZJgGnl7LivvdPrh3JtFZ9Ek9ZwO4m2O23r37bvV7XpB2gGv48RR9KZ5l++jaeS5f6v7s7zgIvTCp8qH9kcAAAD///WEuyV3BQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.869903622 -0800 PST m=+4846.108967438", "maxElapsedTime": "572.345785ms", "maxServiceTime": "572.280769ms", "minElapsedTime": "1.356047ms", "minServiceTime": "1.319384ms", "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": 32920 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:CUSTOMER" }, { "Priv": 7, "Target": "default:ORDERS" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "as": "c", "covers": [ "cover ((`c`.`C_ID`))", "cover ((`c`.`C_D_ID`))", "cover ((`c`.`C_W_ID`))", "cover ((meta(`c`).`id`))" ], "index": "CU_ID_D_ID_W_ID", "index_id": "6baa07e40bf12da5", "index_projection": { "entry_keys": [ 0, 1 ], "primary_key": true }, "keyspace": "CUSTOMER", "namespace": "default", "spans": [ { "exact": true, "range": [ { "inclusion": 0, "low": "null" }, { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "NestedLoopJoin", "alias": "o", "on_clause": "(cover ((`c`.`C_ID`)) = cover ((`o`.`O_C_ID`)))", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "as": "o", "covers": [ "cover ((`o`.`O_C_ID`))", "cover ((meta(`o`).`id`))" ], "index": "OR_C_ID", "index_id": "9d80f50758026313", "keyspace": "ORDERS", "namespace": "default", "nested_loop": true, "spans": [ { "exact": true, "range": [ { "high": "cover ((`c`.`C_ID`))", "inclusion": 3, "low": "cover ((`c`.`C_ID`))" } ] } ], "using": "gsi" } ] } }, { "#operator": "Filter", "condition": "(cover ((`c`.`C_D_ID`)) = $1)" }, { "#operator": "InitialGroup", "aggregates": [ "count(distinct cover ((`c`.`C_ID`)))" ], "group_keys": [] } ] } }, { "#operator": "IntermediateGroup", "aggregates": [ "count(distinct cover ((`c`.`C_ID`)))" ], "group_keys": [] }, { "#operator": "FinalGroup", "aggregates": [ "count(distinct cover ((`c`.`C_ID`)))" ], "group_keys": [] }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "count(distinct cover ((`c`.`C_ID`)))" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "18.700105272s", "avgServiceTime": "18.700045411s", "encoded_plan": "H4sIAAAAAAAA/7SVUW/bNhDHvwpxy4MNCIadNE1HIA+ZrG7qXMuQnfahMGSGuijcaFIjqSxZ4X32gZTtOLOKFWv6ZvP+R57u/zvyM6DiusSyqCVTQAEiuEXmGoOxVs5oaYGOTiMQqsSHq1p8QGOFVkBfRaDYGoHCfJHFvxaT5EMyKSp0cWOdXqPJTInG/vQ4FtYZwR20CbZm3GeVeMsa6Vd1jYY5bYB+hh+e/sAc/2hQcYQI/uZ3QpYGFdBPz0VXjbvTRvzlVbUR90JihdZvNRHWBfmCmQrd05E0vp4vsvdJDhHMjLgHerGJOmRZPk7y+YFoudlV8r9KTX0L55ypM4iAWaDAIQKu79FYoJ/aX6TXW/HVYBUX6XjV7+8ET8vjLwU+HgXW6JiP9gcrUfrQcusjUIivi3QcNguJsI0UogQKr28YG17gq+HN7ei0ZOf7aG30b8hdAMCj48xj8Ts++vKH0WgZLFizdhGoMw1uIvCCrekHne9mwdZM2dA5fGDctXtEYJiqMCwLxWXTEjiMQOo/gYJqpARv4Z2o7oDCySgUvBee7YQnI9gsN8sIGitUBRQqK0LioU0zZpiUKOGbzJ6idVhOtK7faaG84VIEz7UnXhVcssb6b+912U4uyX5ZrwarrNgG+t9W1TGCuhvBZ4ceIaU7kcrykPAcpR/LN8Pb8+HF+Zvh6euzkT/3gIf9iHXToEITC6l1vSPhPwHZMvCFYeqiolPawcly829U3grp0IT2qFK0Y3Fk6Hhv6cmof0RbqoQTTP5sdFN7T6rKYMUcbu1olOuVwjqhuCNdhQYHKp+9G8RlR6GpcmjWWArm8EWPOmqIeuFv+S7DuW36rL3NIAKDtpGu8E3awVWbgMZXFL3pbsNud2/HsSNzZ5CtQy5YUanw5PqPORmFG219gwY2ETh88G/SLE9mV3lCvvKtJW/z7D2ZJ5MkXpA4u54ueuN0vkin8aLHB77yfr/VkN2VTDhJp9MkJ++ydErawSSaZFPSJpDLS6IH7Z1APv6S5EkIjEOI+Jv1nwAAAP//g28vuEwIAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.402449679 -0800 PST m=+4846.641513240", "maxElapsedTime": "23.336625939s", "maxServiceTime": "23.336560501s", "minElapsedTime": "13.467688759s", "minServiceTime": "13.467651705s", "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": 3148 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 9, "Target": "default:HISTORY" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "ValueScan", "values": "[[((((to_string($1) || \".\") || to_string($2)) || \".\") || to_string($3)), {\"H_AMOUNT\": $7, \"H_C_D_ID\": $2, \"H_C_ID\": $1, \"H_C_W_ID\": $3, \"H_DATA\": $8, \"H_DATE\": $6, \"H_D_ID\": $4, \"H_W_ID\": $5}]]" }, { "#operator": "Parallel", "maxParallelism": 1, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "SendInsert", "alias": "HISTORY", "keyspace": "HISTORY", "namespace": "default" }, { "#operator": "Discard" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.878691ms", "avgServiceTime": "4.795055ms", "encoded_plan": "H4sIAAAAAAAA/6SScWvbMBDFv4q4BWqDKCRtt07/mcZbzdok2G5HSYIR9jUVU+RMkkO6xPvsw44dNyX7ZwOD9d6drZPebwuo0jzDLFlJroABUHhGbguNN7myOpcGWH9AQagMN95KPKI2IlfALikovkRgMPGe7v1RnAhlUNtbYWyuX2FfNiueVj0ZPvNCWqCQr1Bzm2tgW/jQCYjwZ4EqRaDwO30RMtOogE2Pm7zCvuRa/Kq6VlqshcQFmupXd8LYuj3meoG225LdBlE8Dp+AwkSLNbDP5bxs9/inIR65LDBKuQIK62ptgMF06jiOY/PEWC3Uwun1XbLbkRmcz6BevSkN3L/XLlyXku0MbhPvfvwwimfASO8TJZVzkwyTYFg7g9ZpdL/V31vnYu8Mvdir9fVB+7X+2Oi2/3KvD99flfM5lPT46BOuuZQogcKSb1olzBJY/7/uNEKVBTU/QIFLwas77ZL7ga8tSZ15iq/3Aw+FSbnOoJyX1fOuGlmNfAk1EEYsVM09MFVIScHipsJoEvoTL/TJScrJl3B8T4JR5IcxCUbxmDTjOd/8J0oevbsH392/IuLE4ySKw2D0taJjtyNn52dV+m/swWn7omWiybuLu4mv46HJ7xB/I4/T7V0dwdCycCCuBa6Bp3ddulD+CQAA//+NS/dKKwQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.941921259 -0800 PST m=+4846.180984852", "maxElapsedTime": "724.479676ms", "maxServiceTime": "724.432114ms", "minElapsedTime": "561.863µs", "minServiceTime": "516.535µ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": 32920 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((((to_string($1) || \".\") || to_string($2)) || \".\") || to_string($3))]" }, { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`CUSTOMER`.`C_DISCOUNT`)" }, { "expr": "(`CUSTOMER`.`C_LAST`)" }, { "expr": "(`CUSTOMER`.`C_CREDIT`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "5.205144ms", "avgServiceTime": "5.130611ms", "encoded_plan": "H4sIAAAAAAAA/6STYWvbPBDHv4q454HaIAJtBwO9C44KoWkT7GRjpMERzjVRp0ieJJd0rffZh5waJ226FxsYZPl+vv//TqdnQF2YFa7yUgkNDIDCPQpfWUyM9tYoB+z8goLUK9z1S/kFrZNGA/tEQYstAoNb/jUfpwOe5mv0SeW82aKFfdiVogjMCu9FpTxQMCVa4Y0F9gz/dRvI8EeFukCg8KvYSLWyqIHNj6F+5TfGyp+BKq18lArX6EKqkXS+wafCrtF3kiyZZdPxDU+BwsTKR2Cf60XdivyVi2t8ygqhgcJ3fHLAYB5FUeRN7ryVeh39fx6TlxdyB707aN4OQhfxx7HLOF5ATY/FrtAXm1ep12YeVHSqx28zTIQVSqGCfyp6qKWXQk2secAiHKRFVymfe7Rb19C4KwMYLVt/y94yyQfDLBnPbqfLuDF2Ghr1sz8DScoHwwZZvGuQ1J2telGH5w2SeYti2/wLTq51M9+hC21iYPDgTDjRzvDht+Cv3dcUPO7ChE1SPumnnJy8AOQqHd+QjI94MiVdVkr22cK6196DbbVklnFyzb9lZP5+os56Z2E5nqcPApdxTBZQ/w4AAP//C8LUdOEDAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.354162271 -0800 PST m=+4846.593225869", "maxElapsedTime": "525.311601ms", "maxServiceTime": "525.265961ms", "minElapsedTime": "528.449µs", "minServiceTime": "492.915µ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": 34462 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:ORDERS" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "OR_O_ID_D_ID_W_ID", "index_id": "753a694b68619fea", "index_projection": { "primary_key": true }, "keyspace": "ORDERS", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" }, { "high": "$4", "inclusion": 3, "low": "$4" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "ORDERS", "namespace": "default" }, { "#operator": "Filter", "condition": "((((`ORDERS`.`O_ID`) = $2) and ((`ORDERS`.`O_D_ID`) = $3)) and ((`ORDERS`.`O_W_ID`) = $4))" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`ORDERS`.`O_CARRIER_ID`)", "value": "$1" } ] }, { "#operator": "SendUpdate", "alias": "ORDERS", "keyspace": "ORDERS", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "15.025661ms", "avgServiceTime": "14.954913ms", "encoded_plan": "H4sIAAAAAAAA/6RUX2vbPhT9KuL8+pCA+EH+rGsFewi1ywLdEpy2YYzgaPato1WRPUnu2hXvsw/badq0KZTtxXB1js+99xyke5BJ8pTSuNDSQAAcVyR9aekkN97m2kH0+hzKpHQ7KtQlWadyAzHkMHJNEAjCs/FlGH2JyyKVniY2JevQwq6QSc1J6UqW2oMjL8hKn1uIe/z3WGBGP0oyCYHjd7JSOrVkIL7ukkalX+VW/apZhVU3SlNGrpY6U8439HNpM/KPLcUkCsJoBo6pVTcQR9WiemjxVzOMaydmiTQDbGyBwCSKJ/E4iIP6M4/HwQMWqxQC798N5OHx8Nvh0WHv+IrkFi1s/p0S3zh6X6+0lvYuvqY7CG9Lqjiu6e7BxO0m+511hTSuGZduZeJbBQ4rTUbN8UplKwgc9Jv2iS7bJAccOv/ZAhV/pA1eow12aMPXaENUi2rBUTplMghkTjU/PjVzKq3UmjT+KZJT8skKb/fq+RSnSnuy4Ehyk6o2DXQ6nc6ylVn+v6zTXXbZB3bQ7zJpUrYLBlt40N2Hz7f4sNt90f9E54ZenM6oSZV87Mmu22QL6WvTd7RPRlE0DqOmAzhupC7rZQ96tf8vNE160VxTcEitpHvq1Zv9W1TPhQPlEmnTfdDMW5LrZhg4lZnmdYEwpdYcnm7ryzqNwukoCtnet4SdRpNP7GIajM5D1g7GZuE5e7p6bW2PzT+GUcgmm7rPRp8D1obTRLOp55t6iOpPAAAA///+GMJeAAUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.533730681 -0800 PST m=+4846.772794304", "maxElapsedTime": "843.590964ms", "maxServiceTime": "843.536499ms", "minElapsedTime": "1.936888ms", "minServiceTime": "1.898368ms", "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": 31327 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:ORDER_LINE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "OL_O_ID_D_ID_W_ID", "index_id": "2e91eeb4be448a2e", "index_projection": { "primary_key": true }, "keyspace": "ORDER_LINE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((`ORDER_LINE`.`OL_O_ID`) = $1) and ((`ORDER_LINE`.`OL_D_ID`) = $2)) and ((`ORDER_LINE`.`OL_W_ID`) = $3))" }, { "#operator": "InitialGroup", "aggregates": [ "sum((`ORDER_LINE`.`OL_AMOUNT`))" ], "group_keys": [] } ] } }, { "#operator": "IntermediateGroup", "aggregates": [ "sum((`ORDER_LINE`.`OL_AMOUNT`))" ], "group_keys": [] }, { "#operator": "FinalGroup", "aggregates": [ "sum((`ORDER_LINE`.`OL_AMOUNT`))" ], "group_keys": [] }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "as": "SUM_OL_AMOUNT", "expr": "sum((`ORDER_LINE`.`OL_AMOUNT`))" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "29.215042ms", "avgServiceTime": "29.140008ms", "encoded_plan": "H4sIAAAAAAAA/7RUW2vbTBD9K+J8ebBg+cAXaCvog4mV1mDHRk5iSjDyRprI20grdXeVOg3qby8r+VInDqVt+mLwzJnLOWe0jyAZ5THFYZFyCQ9guCVuSkWnuTQqTzW8dodByJjW/UJckdIil/B6DJJnBA8DfzS88oNPoS6zyaif5aU0aLK64JGFxHTLy9RG84IUN7mC94j/9n8woy8lyYjA8D1aiTRWJOFdH4L6pVnlSnyzqEKJe5FSQtq2GgltavgFVwmZ/UhvEgz8IBwNz30wTJW4h/emWlTbMX+0x9CKMYu47GKjDDxMRuEkHA7Cgf2Zh8PBNheKGB469K5NdNO7oV7vLe/QLluo/DNFphb10dLKuHoI7+gBnlElVQx39LAV8oDNcYV1waWuV6Y1j0zThUFxmVAdXolkBQ8n7XqFKC0bQ7sMaf61SVRsD+u8BOscwLovwbqoFtWCodRCJvCQaFEX/izoGZlohd9j+rTHlCueppTir6w9E6khBYYol7FoXEGr1Wot9wst/19uzF66znvnpO06XMbOEcxgh+m4L4LmO1DXdZ/RGkphBE8/qLwswMCTRFHCjT37a+gyO9KwP55cnl8sXRcLhsQW2nOyBYtqUT0fYEhlFAtu6LWmPLVXyNdj8E9s36g8bb5FMCjSZWpCK03zMXFte12Ow916YKB1Yat/RaI6rsh2mjXluS8zo4hndS20SGT9KFtyh0t4kGV2QwoVg6G1ffqmgT/tB75z7GF2zoLJ2Jn5I//0wpldjlu7Tq7TnzkHvRvsnpYz/+gHvrO5/frynf75wNkcen3m28B8E+ii+hEAAP//AdKPVWQGAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.506064426 -0800 PST m=+4846.745128213", "maxElapsedTime": "623.069539ms", "maxServiceTime": "623.019787ms", "minElapsedTime": "2.605045ms", "minServiceTime": "2.562177ms", "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": 31327 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:ORDER_LINE" }, { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "as": "o", "index": "OL_O_ID_D_ID_W_ID", "index_id": "2e91eeb4be448a2e", "index_projection": { "primary_key": true }, "keyspace": "ORDER_LINE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$3", "inclusion": 1, "low": "$4" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "as": "o", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Join", "as": "s", "keyspace": "STOCK", "namespace": "default", "on_keys": "((to_string((`o`.`OL_W_ID`)) || \".\") || to_string((`o`.`OL_I_ID`)))" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((((`o`.`OL_W_ID`) = $1) and ((`o`.`OL_D_ID`) = $2)) and ((`o`.`OL_O_ID`) < $3)) and ($4 <= (`o`.`OL_O_ID`))) and ((`s`.`S_QUANTITY`) < $6))" }, { "#operator": "InitialGroup", "aggregates": [ "count(distinct (`o`.`OL_I_ID`))" ], "group_keys": [] } ] } }, { "#operator": "IntermediateGroup", "aggregates": [ "count(distinct (`o`.`OL_I_ID`))" ], "group_keys": [] }, { "#operator": "FinalGroup", "aggregates": [ "count(distinct (`o`.`OL_I_ID`))" ], "group_keys": [] }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "as": "CNT_OL_I_ID", "expr": "count(distinct (`o`.`OL_I_ID`))" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "321.409179ms", "avgServiceTime": "321.335366ms", "encoded_plan": "H4sIAAAAAAAA/7RVe4/aRhD/KqspUoxkofBQH5buDwS+1Am1KXYSRXfI7NkTsz2z6+6u07te3M9erW3OwHGq2l74A/DMb16/efgBkCcixTQucsrBAbDhM1JdSpwJrqXIFTjDkQ2Mp3g3LdgHlIoJDs7EBk53CA6EUTB7Fy/cD+4izlCHWiS3M1FyDQ1EFTQxuBQ/0zI3UlGgpFpIcB7gu+4BQvy9RJ4g2PBXsmV5KpGDc3UMmpZ6KyT706AKyb6wHDNUxtWCKV3DIyoz1F1IJ1jN3VW88HwXbFhK9gWcHyr7DLCu5QCzrvap/KdcPcNamFA+BhuoAgcEtFyCA8EiDmJvHs/N18fYm+91MUvBgRH+NES8mdzgZPIjHeGjtpDiN0x03YYHw8GOyvv4Fu/B0bLEyoZbvN+zflT6+XaognJV5453NNGNFxsk5RnW4i3LtuBAb1ynkORlMwJDG3Lxh1FMwLC5h42OYeNH2OgINnwONoRqXa1tKBXjGTiQKVYbHjJ7iTrZHpL6b0o+dfZWML73pY597QfimUHmhnZjZllaxEpLxjPL2ojNYBMs6p5u+n3y9Su5hsE11P/O4LwG13+S2JJKmueYw/+awkuWa5RgQyJ4ypq5Aav+HGdKLkhv2CeUp6RTzR9Vo/6pLmh01+Xr1+OE9MZ7QG/Syi7ICbZzoTaDTRj/+n7qR1706cDL92eI8DjTjOZvpCgL06ksk5hRbfb+ChJzbKyUKc14oskprbC2ITOGba+u1tW6ehpAo9xhyqjGl4pyOrKMv1wF32RQWpaXzX0BGySqMtexoaY5EPWKzPwobpMDG/CuMLb/VEJ1no99LNOSp10JtUS6q21BsYzXLyZT2mEKDvByd4MSKhs03plzvly5y+nKJc++msjlKviFkNBduLOIzIL3fmTNvTDy/FlkiUHrut8n05AcxGrNugNDBPF8312Rt4HnN+GIIoFP3rmfQmJFQRxGK89/0/g0W1bfgFeDV+aHnOjbmB9/dlcuebSot5JM/XkjmreiUScyq9Ut4Tk5XpDepFaoQbd03cpB9XcAAAD//zEzJo4KCAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.15915585 -0800 PST m=+4846.398220135", "maxElapsedTime": "846.743508ms", "maxServiceTime": "846.672947ms", "minElapsedTime": "85.832091ms", "minServiceTime": "85.776564ms", "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": 3148 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((((to_string($1) || \".\") || to_string($2)) || \".\") || to_string($3))]" }, { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`CUSTOMER`.`C_ID`)" }, { "expr": "(`CUSTOMER`.`C_FIRST`)" }, { "expr": "(`CUSTOMER`.`C_MIDDLE`)" }, { "expr": "(`CUSTOMER`.`C_LAST`)" }, { "expr": "(`CUSTOMER`.`C_STREET_1`)" }, { "expr": "(`CUSTOMER`.`C_STREET_2`)" }, { "expr": "(`CUSTOMER`.`C_CITY`)" }, { "expr": "(`CUSTOMER`.`C_STATE`)" }, { "expr": "(`CUSTOMER`.`C_ZIP`)" }, { "expr": "(`CUSTOMER`.`C_PHONE`)" }, { "expr": "(`CUSTOMER`.`C_SINCE`)" }, { "expr": "(`CUSTOMER`.`C_CREDIT`)" }, { "expr": "(`CUSTOMER`.`C_CREDIT_LIM`)" }, { "expr": "(`CUSTOMER`.`C_DISCOUNT`)" }, { "expr": "(`CUSTOMER`.`C_BALANCE`)" }, { "expr": "(`CUSTOMER`.`C_YTD_PAYMENT`)" }, { "expr": "(`CUSTOMER`.`C_PAYMENT_CNT`)" }, { "expr": "(`CUSTOMER`.`C_DATA`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "5.360275ms", "avgServiceTime": "5.282116ms", "encoded_plan": "H4sIAAAAAAAA/6RVfWujThD+KjK/HzQBKTQ9OPA/q5ZbmhdRe5C2wYiZptszmls3pb3W++zHrHpZ+2KOOxCcefZxduaZ2fUZME+LFa7ibZbkYAGYcIuJ3Al0ilyKIivBOhmZwPMVPtpb/hVFyYscrE8m5MkGwQLfnk+8aRSvUTq7UhYbFGdPrcVWUBPLbZISe4W3yS6TYEKxRZHIQoD1DP/tHQjx+w7zFMGEn+kdz1YCc7CuuyR7J+8KwX8Qayv4A89wjSWFGvNSKnqUiDXK/ZaWcxlGs4kXgAm+4A9gfa4WVbvJX2VxgU9hmuRgwjd8KsGC68FgMJBFXErB8/Xg/5Oh8fJi3MDxDShLWxoNP147HQ4XUJndzc5RpnfNVo2YWkXvafw6gp+IJMswg38qmuVc8iTzRXGPKTVSYLnLZCxRbErFxsctEQfLNr/l8dKJmbscqpTeXz5nQRj1MibMdcdeL2VsH4gRRoHnRfHJn5BGvSSHRfMDUeyoP9sr5veu+19m0/4IIZs6/Qwn8FzWr0lNicds0ktzWejMLqf9sc7ssX0opXnkxs2l0V9+c7E4B3iuHdlEWLw5MTzfz2m1qOh5RQmlwGSjvoWSr3N19dGx+F0KWHBfFnTG6553fKXcW4S01FHKsOM3UuqYmn8dYK7u0WTrfn0YdESTqwPTEOmAmpkOQIPaBepD8g420jGtkTp8xfzWrUyQ+EiXsB94vh14xoG/hXEezCZG6I09JzJIA9NopCGjLposkoPebaqaPSKbOlVjdqQ+uGI+vZQaaoFUUEzVsb1FvSOv7RHZzSiQqdWs4u1FVx/ZkV2X0E6ocRl6xoU3D43rtz+Go+MjenV/Cx8snA6HxgKqXwEAAP//3c+I5bIHAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.840088968 -0800 PST m=+4846.079152535", "maxElapsedTime": "662.278334ms", "maxServiceTime": "662.226003ms", "minElapsedTime": "676.374µs", "minServiceTime": "638.23µ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": 13060 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_06`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.850082ms", "avgServiceTime": "4.782581ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNauqkvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD///wTGhNcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.16071247 -0800 PST m=+4845.399776078", "maxElapsedTime": "478.112601ms", "maxServiceTime": "478.04488ms", "minElapsedTime": "543.322µs", "minServiceTime": "509.06µ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": 33665 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:ORDERS" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "OR_W_ID_D_ID_C_ID", "index_id": "6b5338064a1c4699", "index_projection": { "primary_key": true }, "keyspace": "ORDERS", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "ORDERS", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((`ORDERS`.`O_W_ID`) = $1) and ((`ORDERS`.`O_D_ID`) = $2)) and ((`ORDERS`.`O_C_ID`) = $3))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`ORDERS`.`O_ID`)" }, { "expr": "(`ORDERS`.`O_CARRIER_ID`)" }, { "expr": "(`ORDERS`.`O_ENTRY_D`)" } ] } ] } } ] }, { "#operator": "Order", "limit": "1", "sort_terms": [ { "desc": true, "expr": "(`ORDERS`.`O_ID`)" } ] }, { "#operator": "Limit", "expr": "1" }, { "#operator": "FinalProject" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "16.820469ms", "avgServiceTime": "16.760125ms", "encoded_plan": "H4sIAAAAAAAA/6RUX2vbPhT9KuL++pCA+LHEXbca9pDFLjOkTbCzlTKCo9m3jlpF9iS5a1e8zz4k52/bjLK9BJRzdO695x75EVBmZY55WgkmwQegcI3M1AqHpTSqFBr8Xp8ClzneDyr+BZXmpQT/mIJkSwQfxnEQxmkyHUw/J2mBZsS0GascFbQUXbHM8nK8ZrUwQKGsUDFTKvAf4b/tARL8XqPMECj8yhZc5Aol+F/3SYPaLErFf1pWpfgdF1igtlIjro2jT5kq0GxL+q7FBChMFL8D/10za9Yl/qqHV5Eia1mSMenByj9nVnqZRkEa2J9hGgVrLOU5+HDy7a3nvX9zcsx62fHJ6ekGrVR5g5lx1j/auZdMPaS3+AC+UTU2FG7xYe30ZtyX7dcVk9q1i/csM60CBcVkge7vBS8W4MNRz5XPRN2u3KMgyh8t0NAtrX+I1t+jeYdoHjSzZkah1lwW4EOhubu4a+YZmmwBr5/y6f0JU0wIFPBPez/jwrhcZ6XMebsN6HQ6nXnbzPz/+djtd94lH8hRr0uYzMk+HGzgfvclfLjBvW732RyR5IYzMWnjABQU6lqY1KBarndaWeKeplV0Ui+Bw0EcR2H8Z1J4MY2vUseYNbPGPqD9xtYvXvAlt0/PZkeXarezHHW2DtvhLp8pj5zi5krveTa43Dpim3uCJ0YhWzpl0LyQ7vNm9787O/hwo0sJFDbD7v61JTQUDN7bESdxOBnEITn4ASRn8ficJOEoHE6J1aBkt6Q9rUq1zNYLcvkptKouSC5GZHARkDY5Ljer83B19tqL5OOVK0KCMBmSUXQeTUkPmt8BAAD///800u/jBQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.79887991 -0800 PST m=+4846.037943837", "maxElapsedTime": "292.185594ms", "maxServiceTime": "292.147674ms", "minElapsedTime": "1.567043ms", "minServiceTime": "1.528212ms", "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": 3073 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:DISTRICT" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "DI_ID_W_ID", "index_id": "8028a074b733c78a", "index_projection": { "primary_key": true }, "keyspace": "DISTRICT", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$3", "inclusion": 3, "low": "$3" }, { "high": "$2", "inclusion": 3, "low": "$2" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "DISTRICT", "namespace": "default" }, { "#operator": "Filter", "condition": "(((`DISTRICT`.`D_W_ID`) = $2) and ((`DISTRICT`.`D_ID`) = $3))" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`DISTRICT`.`D_YTD`)", "value": "((`DISTRICT`.`D_YTD`) + $1)" } ] }, { "#operator": "SendUpdate", "alias": "DISTRICT", "keyspace": "DISTRICT", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "15.909885ms", "avgServiceTime": "15.834831ms", "encoded_plan": "H4sIAAAAAAAA/6SUYU/bPhDGv4p1f15Q/a0JWiQqS7zoSNAqDVY1YQhNVXpzjtTDdTLbYTCUffYpDhlQuklsr6L4Ht89/j2y74GMLHPKs0qjAQHA4YrQ15aOS+NtqR2I/SEHZXK6nVTqI1mnSgPigIPBNYGA2eTyND5Ls7rK0VOknLdK+reo0UiCTuYqlK02pyustQcOZUUWfWlB3MN/jz+Q0Neauo0/5Erp3JIB8em5aFL7VWnV91ZVWXWjNBXk2lbvlfNBnqItyD+OFNE0SefT4xQ4zKy6ATFuFk0/5K9cTFsmiUQzggdAICCaZtMou8imUb+YqRwEjPeGY9w7PPh8OBrJwzH+qla2/ELSB6j37WnWaO+ya7oD4W1NDYdruuv5PTnEdqyuQuOCU7pF6bseHCyagsLyShUrELDTeZa67uIccdDlt67Q8EfZ8HeyITSLZsGhdsoUIKBwKmx8CmiGFrUmDf+E+YS8XMFrMGz6OFHakwUOsjS56lDD7u7usu+zfLPsMlsO2BHbGQ4YmpxtCvryaDB4MeJYl4ZerCYUMiGfebLrLpcKfUt2o/dlGi0HwOEGdU3B3ZY6+5/t7A9a8C/mmPw8XD/ggFqhew7pFegWzWbzSDmJNt9WSrwlXAdD4FRhwsMBwtRac/B0296/2TyeTeYx++MzwU7mH07Z+SyapDHrLbIkTlk4Ojt6+LYA2MW7eB6zLjAW8mKTs4i1AYV4oPkZAAD//2vBiSvXBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:30.895815529 -0800 PST m=+4846.134879317", "maxElapsedTime": "964.642881ms", "maxServiceTime": "964.593028ms", "minElapsedTime": "1.799012ms", "minServiceTime": "1.761566ms", "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": 32920 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "971d1851a58665a9", "index_projection": { "primary_key": true }, "keyspace": "WAREHOUSE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "WAREHOUSE", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((`WAREHOUSE`.`W_ID`) = $1)" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`WAREHOUSE`.`W_TAX`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "13.705979ms", "avgServiceTime": "13.64052ms", "encoded_plan": "H4sIAAAAAAAA/6ST32vbMBzE/xVz60MLYuB1/SXYQ2hdGujW4GTzYARH2N/aahXJk+QuXfH+9iF7SdZsDLaBXySdTncfWU8gXZiSyrxRQoMDDLckfGvp3GhvjXLg8SsGqUtajRr5gayTRoO/ZtBiSeB4l2T5TXqRpHlFPhOWatM6molVKjxhkLlGFEFb0q1olQeDacgKbyz4E15sB5jS55Z0ETZ+K2qpSksa/NNz0aj1tbHya1A1Vj5IRRW5YHUtne/lM2Er8tsjeTZKk6ub99MEDBMrH8BPunm3PuWfYowDlGkh9CF+EAJHdpWPL9bjXJbgODuJy/j0KBZHp8fHR+Jss9pYc0eF74E+hSZLYR/ze3oE97aljuGeHtfsfi7we6auEdr1KWklCj+YMFihK+qna1nV4NiL+wSFaoe7PGRQ5suw0M27OUPrpK7AUTmJjj1vfUm+qPFX0XYtJsIKpUjhv/BfSuXJgqEwupQDRezvLzZpFi8XWT6+WBxEb6K9+OCXGGMtvRRqMtwCGCy5Vvnck12uOTZBuOs5G31cHARUu2ik3tp18y58O5KptySW/V44Wen+rYX6vSs47pzR6Bg8rcLvO0mTyShNoj++sugyvXkbTZPr5HwW9UbDzCZ1lF0laRIFGj0LdN8DAAD///o4ykH6AwAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 11:52:31.32987535 -0800 PST m=+4846.568939368", "maxElapsedTime": "459.740504ms", "maxServiceTime": "459.697047ms", "minElapsedTime": "1.10723ms", "minServiceTime": "1.067958ms", "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": 34462 } } ]