[ { "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": "8cc6c4d624fe745a", "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": "21.781372ms", "avgServiceTime": "21.711415ms", "encoded_plan": "H4sIAAAAAAAA/6RU72/aMBD9V6JbP4BkTSqwdoq0D2kSNCRaUEJXTRMKVnINboOT2U5XVmV/+2SbAKU/1m1fIM69u/fu7sUPgDwtM8ySqqAcXAAC10hVLdAvuRJlIcE97hFgPMN7r2JfUEhWcnAHBDhdIbgwiYIwSuKZN7uMkxyVX0tVrlDIs/WYSnWhURYsK5rqjAyvaV0oIFBWKKgqBbgP8G53gBi/18hTnfgrXbIiE8jB/fYY5NVqWQr2U6Mqwe5YgTlKXWrMpDLwGRU5qh2l61/Gs8l5GAGBqWB34J4286Yl+ScVbwKN9PjilPI+bGYJLviXyVUyCpJA/4y9eNbGEpaBCx/T9CQdZCe9wTWeDj7QbbQS5Q2myqzhQXe+omKd3OIaXCVqbAjc4rqd9V7Dz69AVpRLIxjvaapsDQKC8hzN6yXLl+DC0bERkBa1NUCfQFH+sIGG7GC9l2C9R7D+S7A+NPNmTqCWjOfgQi6ZSdwf5xBVuoS/6fOwwpQKWhRYwH/tfsgKhQIIpCXPmN0IdDqdzqKVs3i/8M2WF13nk3N03HUoz5xDQLAF9LrPI7Q9LKLf7T7pZsSZYrSYWmMAAYGyLlSiUKza3VYaeFBVs5piz4eHo0izvoI4HwXBOHwVYpW/Ajjzxt6Fb4rMm3mjv8fH3U1EZoYsS/Hnlraan5QZMr4bkSY6iMdKIF2ZRJAs5+YW1LbYSgQXbmTJgcCGZ//FKNg/mc9572wH1b5pCCi81/fSNAqnXhQ6b7hEnWE0OXficBz6M0fzEWcjQz9YAv2kqfX/RrRNa2fkXH0Oo9CxnjSOdLyLwLEWNAbcnHUVYzcrzTn72rJB8zsAAP//prjoADYGAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:37.331784817 -0800 PST m=+4864.955171458", "maxElapsedTime": "578.232798ms", "maxServiceTime": "578.172234ms", "minElapsedTime": "1.614805ms", "minServiceTime": "1.54478ms", "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": 1847 } }, { "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.857626ms", "avgServiceTime": "8.779237ms", "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-05 11:14:38.941805023 -0800 PST m=+4866.565191681", "maxElapsedTime": "997.899637ms", "maxServiceTime": "997.839721ms", "minElapsedTime": "746.932µs", "minServiceTime": "708.046µ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": 338292 } }, { "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": "58e000f3ffe023e7", "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.20443ms", "avgServiceTime": "12.141778ms", "encoded_plan": "H4sIAAAAAAAA/6ST32vbPhTF/xVxvn1oQHzJj40OwR5C4jKzrAmJaQcjOMK+cdQqsifJXbvi/e3Ddr1k6fawDfxi3aOjcz+X+wQySZ5SGhdaGgiAY0vSl5YmufE21w5iMORQJqWHcaGuyTqVG4hXHEbuCQKraD55H8+C62AWZ+TnYYq25gqZ1IKUtrLUHhx5QVb63EI84b/DD1b0uSSTEDi+JTulU0sG4tPPonHpd7lVX2tVYdW90pSRq61myvlGHkmbkT88KabhKlqGkwgcC6vuIS6qddU98lcpwhrEKpFmhGcqEJiGcTiNb+Jw2h3GKoXA6zfU7/e3o+2W+sMRXfyoFja/pcQ3JJ/qbvbSPsZ39AjhbUkVxx09dvyOmvg1VldI45qk9CAT33pwWGkyao53KttB4GzYBEh02c5wxKHzL22h4gfZ4HeyAap1teYonTIZBDKnmovHgC7JJzv8SQOnDgtppdak8U+DulTakwVHkptUtahxfn6+6dJs/t+0M9v02Ft2NugxaVJ2KujKw17vRdDQKK+kXrTDBIclV2ofe7L7bh5FLTzxvAo+RvG8sa6BngJU5uBZrav6O5GsvCW5b+7Cqcw0C1tTOvKGwK3LDSoOTw/1UiyWwWK8DNjLhWWXy/kHtgpmwSRiRx7teZed3bwLlgFroTXI2PhqyqbPf0NU3wMAAP//qg7IzE8EAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:37.651770648 -0800 PST m=+4865.275157830", "maxElapsedTime": "476.179269ms", "maxServiceTime": "476.117255ms", "minElapsedTime": "1.574134ms", "minServiceTime": "1.540248ms", "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": 2995 } }, { "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": "10.057657ms", "avgServiceTime": "9.975446ms", "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-05 11:14:38.914720805 -0800 PST m=+4866.538107722", "maxElapsedTime": "758.465368ms", "maxServiceTime": "758.417334ms", "minElapsedTime": "889.804µs", "minServiceTime": "842.314µ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": 29028 } }, { "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": "5.06263ms", "avgServiceTime": "4.98987ms", "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-05 11:14:38.66624841 -0800 PST m=+4866.289635479", "maxElapsedTime": "845.108819ms", "maxServiceTime": "845.06137ms", "minElapsedTime": "486.181µs", "minServiceTime": "447.669µ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": 33893 } }, { "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": "5.222051ms", "avgServiceTime": "5.146105ms", "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-05 11:14:34.228672475 -0800 PST m=+4861.852059577", "maxElapsedTime": "1.149499519s", "maxServiceTime": "1.149459737s", "minElapsedTime": "542.517µs", "minServiceTime": "509.747µ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": 33408 } }, { "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": "5.296742ms", "avgServiceTime": "5.210496ms", "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-05 11:14:38.66226089 -0800 PST m=+4866.285647815", "maxElapsedTime": "748.532077ms", "maxServiceTime": "748.468856ms", "minElapsedTime": "541.529µs", "minServiceTime": "505.142µ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": 33893 } }, { "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.923278ms", "avgServiceTime": "4.852028ms", "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-05 11:14:38.600539502 -0800 PST m=+4866.223926148", "maxElapsedTime": "1.097260384s", "maxServiceTime": "1.097228702s", "minElapsedTime": "486.233µs", "minServiceTime": "456.584µ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": 338292 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "fd66bc40f4c7d3f5", "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.748442ms", "avgServiceTime": "20.674098ms", "encoded_plan": "H4sIAAAAAAAA/6STbU/bPhTFv4p1/ryg+lvTeBibLPGio0EgjVG1ZRWaqvTOuU09XCezHQZD2WefkvAwCprE9iqyfXLuub+rewN2usg4S0tLDgqQWDDFyvNB4aIvbIDa2pYwLuOrfmk+sQ+mcFC7Eo5WDIVh//wk+ThJqzKjyFPyvCyqwO/JktOMThdK0o044wVVNkKiKNlTLDzUDf57OGDM3yrufvypl8Zmnh3U58eifhWXhTc/GlXpzaWxnHNorD6YEFv5hHzO8aGkmvZHydHp2TiBxNCbS6h39ay+q/JXMY4bKmNNbge3iKAwPUqPB3fn1GRQWGR7e1/07uvFrn6b7Sze3L+WvvjKOrZEb5pOVuSv0wu+hoq+4lrigq/v2P3ewPNMQ0kutCn5inTsTCQ8uZzb66XJl1DY2G4TaFt1w9yRsMX37qGe1TOJKhiXQyEPBrV83PWQPFnLFv/E7pCjXuJFDa4HOTQ2soeELlxmOorY3Jzf+8xfzafp8WDeE/tiY7v3xODAFo6f3I65ZckxjexXHc+SYgNu3ft8Mpj3IHFJtuLnircC8b/Y2Oo1ZJ9UctlZuzaQIGsorFF4CZxZvW4/MEGTz557GkfPtGojIZjctSsP5SprJSJfNYszHCXD/igRf15wcTg6PRFnw0F/koj7kGKcTETbvti//TYQxPQoGSWiGUo7EtS/AgAA//8kVdfwggQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:38.84063831 -0800 PST m=+4866.464026047", "maxElapsedTime": "972.687957ms", "maxServiceTime": "972.638295ms", "minElapsedTime": "1.444763ms", "minServiceTime": "1.383972ms", "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": 32352 } }, { "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": "11.38259ms", "avgServiceTime": "11.300719ms", "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-05 11:14:40.440083138 -0800 PST m=+4868.063469691", "maxElapsedTime": "1.152824203s", "maxServiceTime": "1.147441461s", "minElapsedTime": "929.89µs", "minServiceTime": "887.577µ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": 29639 } }, { "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": "1cfe4541ba795663", "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": "64.139113ms", "avgServiceTime": "64.05701ms", "encoded_plan": "H4sIAAAAAAAA/6SUUWvbMBSF/4o460MCYpDG7TbBHkLtskDWBKdtGCM4mn3raFVkT5a7dsX77cN20ixt8tDtxeCrT1dH53D1CDJxllAS5VoaCIDjhqQrLZ1lxtlMFxC9Yw5lErof5OqabKEyA+FxGLkiCPjBaHgdhF+iMk+ko7FNyI6UIbREkcu4xhK6kaV24MhystJlFuIRb7Y/mNKPkkxcb/wdL5VOLBmIr7vQoHTLzKpfNZVbdac0pVTUrUaqcA1+KW1KbnukGId+EEaj4UUAjolVdxDvq3m1OeafdAxrQ6axNH2s3YHAeBSNo6Ef+fVnFg39zVqkEgj04hvyTrzeN/nuw8np6dPOKLfZd4pdY+xjfa2VtA/RLT1AOFtSxXFLDxsjd26z3+Eil6ZoJNO9jF3bhcNKk1JTXqp0CYGj40ZCrMs21D6Hzn62CxXfYv1DWH8H8w5hHqp5NecoC2VSCKSFajb+behEWqk1afxXLOfk4iVe59dzJedKO7LgiDOTqDYVdDqdzmLbavF2sQ570WUf2dFxl0mTsD2M/8T0uweh2RPkdbsvBJ3pzNCL6pSaqMlFjuyqjTuXrk5ij4rNkPqLLjjupC5rC456dTIvGpvkqpllcEitZPHcxVe5O6+eH+CrIpY22bc0dZbkqhGFQqWmeYogTKk1h6P7eqwnYTAZhAE79PCw83D8mV1N/MFlwLb62DS4ZDtW1H732OxTEAZsnWaTJRtc+GwdXRPcpjBbFzxUfwIAAP//WfCWzToFAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:40.408928597 -0800 PST m=+4868.032315480", "maxElapsedTime": "1.444207275s", "maxServiceTime": "1.444167925s", "minElapsedTime": "7.052052ms", "minServiceTime": "6.993784ms", "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": 29639 } }, { "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": "58e000f3ffe023e7", "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": "12.034112ms", "avgServiceTime": "11.967114ms", "encoded_plan": "H4sIAAAAAAAA/6STUWvbMBSF/4o560MDYqTJRodgD6F2maFrgxOWwgiOsG8ctYrsSXLXrni/fViemyzLHraBX6x7dO6530XPIJ2VOeVppYQGBxjWJFxt6KLUzpTKgp+NGKTO6XFSyU9krCw1+BsGLbYEjutokd4kYZSkBblQWmdk5tCVbSWyVpPTWtSqPS0rMsKVBvwZr3Y/mNGXmnRGYPiebaTKDWnwz7+KJrXblEZ+a1WVkQ9SUUG2tbqS1nn5XJiC3K4lD+PZPIkv5mCYGvkAft4sm77JP6WIWxazTOgxfoIBRxincZgu0jjsD1OZg+PtOxoOh+vxek3D0ZjOX6qVKe8ocx7mczvNVpin9J6ewJ2pqWG4p6ee394Qx7HaSmjrk9KjyFznwWCELsgfb2SxAcfJmQ+Qqbpb45hBlV+7QsN2stGfZCM0y2bJUFupC3AUVvqL+4AuyWUb/M0Ahw5TYYRSpPBfi7qUypEBQ1bqXHaocXp6uurTrF6vwjQOV4PgfXByNgiEzoPD8uJFMBoMfgsaa+mkUNNumWAwZGvlUkdm2++jaoUHrvPJ7apzO16/jm7n6Y1v3QI/BCz1rmezbNrvQDJzhsTW34WVhfZvuqW45w2OO1tqMPhA/W/D4OixfUPTJJpOkig4+sSDy+TmYzCLrqKLeeANWLBn3pX7oYLFhyiJgpa2Zx1MrsOgg+vRovkRAAD//0I3HZ2LBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:38.632239376 -0800 PST m=+4866.255626042", "maxElapsedTime": "1.327614611s", "maxServiceTime": "1.327578795s", "minElapsedTime": "1.068774ms", "minServiceTime": "1.034987ms", "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": 33893 } }, { "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": "5.115859ms", "avgServiceTime": "5.040581ms", "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-05 11:14:38.125245208 -0800 PST m=+4865.748632496", "maxElapsedTime": "437.781227ms", "maxServiceTime": "437.744896ms", "minElapsedTime": "520.946µs", "minServiceTime": "487.331µ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": 33640 } }, { "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": "1cfe4541ba795663", "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": "69baeddda117591e", "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.12812262s", "avgServiceTime": "2.128058718s", "encoded_plan": "H4sIAAAAAAAA/7RWbW+jRhD+K6upP9gSio7YSRSkfLBsruXqgmu4O1VXC29ggrfBu3R3uSaN6G+vFuyAX67Xu9x9seSZZ96eeQZ4AuSJSDGNi5xycAAsuEOqS4kTwbUUuQLHPreA8RQfxgV7h1IxwcEZWcDpBsGBMAomP8cz9507iylXLEMdapHcT0TJNTQwVdDEYFO8o2VurKJASbWQ4DzBD+0fCPHPEnmCYME/yZrlqUQOzod90LjUayHZ3wZVSPaR5ZihMqlmTOkaHlGZoW5LOsFi6i7imee7YMFcso/gXFXWCWA9TwezrHatfFWvnmEuTCgfggVUgQMCtnyCA8EsDmJvGk/Nz/vYm+58MUvBATu5w9HFyL6lV9cXl5fDZ28hxR+Y6HoVT4aDDZWP8T0+gqNliZUF9/i4Y31v9NPrUAXlqu4dH2iimywWSMozrM1rlq3BgV7TQpKXjQxsC3Lxl3GMwLC5g53vw4bPsPM9mP0pmA3VslpaUCrGM3AgU6wO7DL7GnWy7pL6JSMfJptTSfMcc3jRsn1UGtOZEMUbwbjpLWd1e8pInsdJTktl2uj3+yuxOlsFs3rrqwG5If2VWp2twq1hQChPSQvzDmGNYTB4WcfH8lQdeYZR3U1dy96X5uX1LcU0TaltX11c2/h10twd22lV8prOOBei2Cny/wr1gN5P6OwQ1dHmAfGfS7BFfaFqFbyEjWpZHWVnuUYJFiSCp6xZghHbKb317EONTZ9d50f6Cxrf7+WrV8OE9IY7QG+0tRll7mHbFI1gf3079iMv+q2T5XIwOCLI40wzmv8oRVkYnrJMYka1eb5/gMS8VPopU5rxRJMD+gewtCAzgUZvJmB5giOPa5QbTBnV+K2qHK2Bf7sJvsuTasvyvDlWsECiKnMdG2qa+6oFOvGjeNscWIAPhYn93AjVaT52tcxKjrcSaol0U8eCYhmvP0LMaN0WHODl5hYlVBZofDCv7fnCnY8XLvnPzxDyehH8QkjoztxJRCbBWz/qT70w8vxJ1Bdn2/SDARmHpFNvG9a+TIggnu+7C/Im8PymJFEk8EmTxJwWubkh6qx5ipOxPyXP6Y2ndtW1yPuf3IVLOnGkZ7cB063pvDWZq2rv75Qdb0hvVDtMmd29tdcG1b8BAAD//x5ctn3xCQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:52.658118912 -0800 PST m=+4880.281505624", "maxElapsedTime": "3.165542815s", "maxServiceTime": "3.165487289s", "minElapsedTime": "154.880492ms", "minServiceTime": "154.834759ms", "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": 2995 } }, { "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": "5.071844ms", "avgServiceTime": "4.998056ms", "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-05 11:14:38.489177845 -0800 PST m=+4866.112564478", "maxElapsedTime": "583.941711ms", "maxServiceTime": "583.882258ms", "minElapsedTime": "555.217µs", "minServiceTime": "518.234µ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": 33619 } }, { "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": "8cc6c4d624fe745a", "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": "22.792868ms", "avgServiceTime": "22.717041ms", "encoded_plan": "H4sIAAAAAAAA/6RW32+kNhD+V9D0HrISqpTd9K5C6gMBVoe0PxCQnpJqRSxwWN+xhtrmmjSif3s19pKFJEeuvZes5/Pn8cx84yGPQHleF7TImopwcABsuKNEtYJ6NVeiriQ453MbGC/ovduw36mQrObgXNjAyYGCA5F7vQ42aVZS5bVS1Qcq5OXDiki1QYLhyYbkSC7oHWkrBTbUDRVE1QKcR/jpZEBC/2wpz/HgP/meVYWgHJw/xiS3VftasL+R1Qj2lVW0pBJdrZhUmp4SUVJ1utLxrpJ0uw5isCES7Cs4H7pd11/yv6L4LlKIlUtywhdwLCM44F1ln7LQz3z8s3KTtN/LWAEO/Jrn7/OL4v384o5+uPiFPO02ov5Mc6UVeMTMD0Q8ZF/oAzhKtLSz4Qt96Gs9SPh1CWRDuNQB03uSK+PDBkF4STW8Z+UeHHh3rgPIq9Zov7Chqv8yG519os2/RZuPaItv0RbQ7bqdDa1kvAQHSsn0wWE5l1Tle/gveT73EBFBqopW8EPaL1mlqAAb8poXzCgCZ2dnZ7d9OLc/33pa5duZ9Zv17nxmEV5Yzwn+E2E+e52B7WEYi9nsRTYhZ4qRKjKNATYIKttKZYqKQ69tg8RnXvFW7ez17WUY460TjHXo+6tgkmIinyAkaRwEaXb+PaT5JMkL0+s3vLjpdLQ3YTS5H33cbqY9JOHGm2Z4ceCH0zUxlGwVridpfph426vNtK9Ld+W+FdJ16mfHET6d/nHMe2/wfDd1kbDrdh0O2HG7bkWhX42sxds9+tSEL9wsGT/1PF70bD9RgpKDPgiSlVx/0fCdP9UEHPgsaw42mOYZ2VqClwiKMkQx1ZF91GSI6RyGQOgPLT37B7Z5VUNkUPcRjN04BHTzjQDs+DFgXtsr2HyIDTpiCN+EUW92Nih6jx/XKA4iNw6s6X8CrGW8XVtJsAq81MIS2NaxMrgwOeMKq4G/faSD9RzXKJTB3FQfuAkj/NHF0BtYBM3Ugp1WKB1avUS4PnYCLgcpa3+nmutDbuqaFPr2tD59DOLAMvNdT3fL3fiWGed6mB9tzEiPbmsb+0FsXV73mUP3bwAAAP//WH8jRn0JAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:38.786943862 -0800 PST m=+4866.410330338", "maxElapsedTime": "638.640145ms", "maxServiceTime": "638.600718ms", "minElapsedTime": "1.598215ms", "minServiceTime": "1.550088ms", "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": 19528 } }, { "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": "5.10711ms", "avgServiceTime": "5.03117ms", "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-05 11:14:35.641290209 -0800 PST m=+4863.264676767", "maxElapsedTime": "568.0623ms", "maxServiceTime": "568.014142ms", "minElapsedTime": "531.512µs", "minServiceTime": "499.895µ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": 33807 } }, { "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": "5.172809ms", "avgServiceTime": "5.096523ms", "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-05 11:14:36.380125832 -0800 PST m=+4864.003512528", "maxElapsedTime": "727.105998ms", "maxServiceTime": "727.072936ms", "minElapsedTime": "555.551µs", "minServiceTime": "521.983µ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": 34611 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "fd66bc40f4c7d3f5", "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": "15.07942ms", "avgServiceTime": "15.006671ms", "encoded_plan": "H4sIAAAAAAAA/6RUXU/jOBT9K9FZHkCyVtvCgmRpHyIIIhIfUZudCkZV6kluU0PqZGyHgUGZ3z5yPKXlY4b5kPLge3187rnnOn4AqbwuqMiaSihwgGFOwraaDmtldV0Z8MGQQaqC7sJGviNtZK3A9xiUWBI4kvDyLDpPs5LsRGha1K0h+F3TiNxBCpqLtrJgqBvSwtYa/AF/rQOM6WNLKncHv+QLWRWaFPj7p6CwtYtay88O1Wh5KysqyTiqU2lsD0+FLsmuS/JJOIpOLv4fR2BItLwFP+im3arKb8mInRfjXKhdfDMGHJOTLD5axZkswDEv9vc/5Hv/zPfyg2J3/u/jbqPra8pt7+OD62Qp9H12Q/fgVrfUMdzQ/cq7zQZe99Q0QpleJd2J3HoSBi1USX16IcsFOLYGvYK8av0Idxmq+pPf6KbdlKE1UpXgKI1Ex552fUw2X+CXpD2nSIQWVUUV/sj+Y1lZ0mDIa1VI7yK2t2ePamZ/zyZZfDTbCf4LtgY7L2TESlopqsRPAQyaTFvZzJJernxsHPA553l4Fs0833cQ43QURWk2+CnU8Meowzi9fIsnTN8QdBUnDjB9MU2p1g500859zyBjq0ks+7MwslT9q+Am5qWB49rUCgzemM24F/Y04X15JTfczF3FySrsGCzduV85GUVJOIqC1x6a4Hh0cRaMo9PoMA28EBas622sh27thPtcmPbAqzjxFI+2BZOTaBQF7gb19wfd1wAAAP//dKAtoyUFAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:38.799897999 -0800 PST m=+4866.423284740", "maxElapsedTime": "1.071317877s", "maxServiceTime": "1.071284432s", "minElapsedTime": "1.17382ms", "minServiceTime": "1.129314ms", "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": 32352 } }, { "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": "afcce9bb0ff38b8c", "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": "8.25311ms", "avgServiceTime": "8.179304ms", "encoded_plan": "H4sIAAAAAAAA/6SUUWvbMBSF/4q460MMojTxYJ1gDyFxWaBbglMaRgmOat846hTZk+SuXfF++5CU1mva5mGDPEQ6n6Src671AKjyqsAiqyVXwAAorJHbRuOoUlZX0gDrDygIVeDdsBaXqI2oFLD3FBTfIjAYJ+eTyyT9lpVoR5MCgmBqnju1wDVvpAUKVY2a20oDe4B33QDm+KNBlSNQ+J1vhCw0KmBXz6FhYzeVFr8cVWtxKySWaNxW58JYj19wXaLtjmTTdJykc6Aw0+IW2Id22T4e8U81TJwH85yrGCjk1S1qA+wq/CO93iqctzpeTbPJeBVFj9SeNj6oLg6qoxfqFi1/QqLjlSicvtwlBgymaebq8cf63WGnZaIABnyd5/jx+vpkvY5Pr0/zJ7XW1Q3m1oft2sTq++w73rsrn9A+HdDY2elmdkk/2f16/KbmynhP8Y7nFpjVDVLQXJXopzei3ACDo74vIZdNaLSYgqx+BqGlHTZ4Cxs8w+K3sBjaZbuk0BihSmBQGuEX/p34jGsuJUr4r745E9Ki9pmpQgRHodfrvdk45BM56keEq4K8Co07bBAd4BYdF0fRi9tNlLCCy1kIGihoNI20mUW9fUyqduChTnQf1f51Vbdpu2zdbw+ZW41869eCEaXyD47zNuwLDG5MpaClYPHOfdKzNJkN04TsvTXkLJ1+IfPkPBldkLA2TIVCyeJzkibEueotJcOvYxLs897txovdOIb2TwAAAP//HCytiBAFAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:40.359825721 -0800 PST m=+4867.983212421", "maxElapsedTime": "846.286259ms", "maxServiceTime": "846.239024ms", "minElapsedTime": "806.647µs", "minServiceTime": "774.501µ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": 29639 } }, { "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": "1cfe4541ba795663", "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": "30.292301ms", "avgServiceTime": "30.213568ms", "encoded_plan": "H4sIAAAAAAAA/6SUbWujShTHv4qc2xcJDBeS9IEr3BdSLVew0RtNS1mCmdVTM60Z3XHstlvcz77MGGNtG7oPEIIef3PO//zPYZ4BeVKkmMZlTjmYAARukcpa4HnBpSjyCszJlADjKT5aJbtCUbGCg3lMgNMtggn+wnYWcRhZ0TKMM5S+SFF4jGMFLVOVNFFgire0ziUQKEoUVBYCzGf4q3+BEL/UyBMEAt+TDctTgRzMT0PIquWmEOybokrBHliOGVYqlccqqfGIigxlX9JsNXru3AECgWAPYJ41q6Yr81s6XGVJmFA+g50/ygwv9mPXjm31dx27dvctZimYMElu8fjkePKZnv1zcnq6PxmXorjDRGprn1VbWyqe4nt8AlOKGhsC9/jUGTno5n2Hq5LySkvGR5rINgsBQXmGOrxh2QZMOGolJHndjnVGIC++th8a0mPTQ9h0gE0OYRNoVs2KQF0xnoEJWcX0wZeGXqBMNvBrnb7OEVBB8xxz+KPRXrBcogACScFT1k4FRqPRaN0LWv+99j094vXY+Nc4mowNylPjHcbeM9PxQcjfQ7Px+E1bLmeS0TxotwQICKzqXMYSxbYbc6nAt4nDZRB4NzuhOvFB1P0J5v+lNY/c6OYjzrr0l/PoI8p2PPfKWdzEuu7qzUYw3jfdrBr1e4WEUiDd6rNQsYzru0sNfa8BTLirCg4EBgUHYdX5INC1OQi+sLKLNwQkPqqrJlg4gbVwjMPXoXGx8C+N0PGc88gYpiPGToR+6Irrl7YJ/diLb1P1bhrX/zmqdruQeh0Na24bu+3Tu9cF/F1gBs2PAAAA//93iap+/wUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:37.480759546 -0800 PST m=+4865.104146323", "maxElapsedTime": "468.163671ms", "maxServiceTime": "468.12057ms", "minElapsedTime": "4.312831ms", "minServiceTime": "4.27232ms", "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": 3049 } }, { "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": "b9097beb2dad76e5", "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.889232ms", "avgServiceTime": "12.823656ms", "encoded_plan": "H4sIAAAAAAAA/6SUb2vbMBDGv4p51hcxiNIk20oFexFmlxW6ODilYZSQqNbVEVPlTJLbbsX77MNK0vRfKNveyaef7s7Po9M9yBSVJDlbamHAAYYrEr629Lky3lbagXd7DMpIuhss1TlZpyoD/p7BiGsCR5Kenpyn+beZJE2ehnSbWUkWK8AtRdFSkq5ErT0YqiVZ4SsLfo932w+M6UdNpiAw/C4WSktLBvziKTSo/aKy6ldLLa26UZpKcm2qU+V8wM+ELclvS/JhOplleZLmYBhZdQPePWimzabMP/Vx0uoxLoTpg6Gobsg68IvVKup05g815/vzYTbLZifJPI437CtE8iYxeUFckxePsXh/rmSLTNeGgWOdOpzGOjxTEhyXRwdHh5d02ZNCHn6kD2D4Tj83fj0W7XUf3VIYF4ShO1F4cG9rYrDClBTCC1UuwLHXD3ULXa9uTp9BV7erjYZtse4urPsE6+3CemimzZShdsqU4CidCgcf2zYSVmhNGv9l/rHSPlzwojJS+dAHOp3OG95Gn6K9bhwJI6Od6GSL9uI32GzL9uP4xb+OycgkjCQYhFbCPbP1L9xups3z9IlyhbDyta2xtySuEWbMqdKE9wTc1FozeLprh3OUp6NBnkY7Xo/oOM++tpvpWbpaP7QYTb6keRqtdQ2iRoNhEq3VC9JtAtk60EfzJwAA//+Jj8cN6wQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:40.389743342 -0800 PST m=+4868.013129984", "maxElapsedTime": "1.186883323s", "maxServiceTime": "1.186832334s", "minElapsedTime": "815.458µs", "minServiceTime": "768.132µ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": 29639 } }, { "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": "5.25624ms", "avgServiceTime": "5.18144ms", "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-05 11:14:36.091951763 -0800 PST m=+4863.715338870", "maxElapsedTime": "917.521295ms", "maxServiceTime": "917.481882ms", "minElapsedTime": "555.449µs", "minServiceTime": "521.58µ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": 33115 } }, { "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": "6.276329ms", "avgServiceTime": "6.182849ms", "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-05 11:14:38.665348143 -0800 PST m=+4866.288734785", "maxElapsedTime": "349.471016ms", "maxServiceTime": "349.407578ms", "minElapsedTime": "530.73µs", "minServiceTime": "479.821µ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": 3324 } }, { "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": "5.196139ms", "avgServiceTime": "5.128191ms", "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-05 11:14:36.157185608 -0800 PST m=+4863.780572319", "maxElapsedTime": "616.873045ms", "maxServiceTime": "616.837348ms", "minElapsedTime": "562.944µs", "minServiceTime": "518.86µ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": 34059 } }, { "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": "6.065537ms", "avgServiceTime": "5.972415ms", "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-05 11:14:36.892432966 -0800 PST m=+4864.515819660", "maxElapsedTime": "312.807044ms", "maxServiceTime": "312.753626ms", "minElapsedTime": "606.417µs", "minServiceTime": "559.897µ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": 1202 } }, { "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": "58e000f3ffe023e7", "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": "54946a9d13a3791e", "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.372345716s", "avgServiceTime": "5.372278485s", "encoded_plan": "H4sIAAAAAAAA/6SUUU/bMBSF/4p1xwOgqGopG8MSD6wJUljXVGnFHqYqsZLb1MO1M9sBOpT99snJWgplGoNH20fXn889vveAMlM55kkpmAQK4MEcma00DpS0WgkDtHfkAZc53p2X/Aq14UoCPfZAsiUChck0GnxOhsFVMEwKtJHOUZtPK58bq3lmoRWakmVOneOcVcLtqhI1s0oDvYd3DwuY4I8KZYbgwa9swUWuUQL99lh0XtmF0vynU5Wa33CBBRpXasiNbeRTpgu0D1dSP5xM43AwBQ/Gmt8APam9Z2RR7AfxZEs0q9ckr0INnXWTjMk+eMCMuwn+GAoU/DAJ/eRrEvrrzYTnQOH9R+x2u/P+fI7doz6ebE5Lrb5jZpsm3Lu3L5leJde4Amp1hbUH17hau7315OebYEomTYOMdyyzbQ0PNJMFNtsLXiyAwl6vAchE1ba/74FQt+1BPatnHlSGywIoFIaD83Xbggu02WL79S9HfFpqzDQTAgW8qScjNBbzoVLlpeLSkQnewCkXTJlkglXGYezvp3naSf0k9NMDckb2U5V20ihpNw7eRrGbDLWVjChubnkSi+PT4w/sNO/1Wf/ktIevi8Um4s+HQjbuJEKpch2Il+Zk266/JOaR5D+zo+BN76hn9U55Lixq8CBTMuetfztd3+sd7HCFklvOxLj1HTzQaCphE4t6uXaqdEKDYu5+mmV6Q7EDIR8qOchdzonVyJbQDCPDC9nMaNfqQ6BwCLUHFu/cGBvHwfg8Dsg/xjK5iKMvZBIMg8GUHLYrsv6LJCfhaBTE5DIKR6R1mSgSjUjecaaQszOiOu0vILcL1Lg5IG4g/A4AAP//Lek4+FcGAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:49.872502428 -0800 PST m=+4877.495888990", "maxElapsedTime": "11.26027312s", "maxServiceTime": "11.260240402s", "minElapsedTime": "1.706182179s", "minServiceTime": "1.706133598s", "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": 2995 } }, { "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": "5.114008ms", "avgServiceTime": "5.041934ms", "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-05 11:14:38.932871936 -0800 PST m=+4866.556258645", "maxElapsedTime": "771.317159ms", "maxServiceTime": "771.238837ms", "minElapsedTime": "553.558µs", "minServiceTime": "522.928µ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": 33871 } }, { "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": "5.232683ms", "avgServiceTime": "5.161213ms", "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-05 11:14:36.242172439 -0800 PST m=+4863.865559075", "maxElapsedTime": "823.066671ms", "maxServiceTime": "823.010941ms", "minElapsedTime": "518.224µs", "minServiceTime": "485.897µ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": 33535 } }, { "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": "58e000f3ffe023e7", "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.456058ms", "avgServiceTime": "15.374764ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2vbMBTFv4o460MDYqTJxopgD6F2mWFLgpMugxEcYd04WhXZk+UuXfE++7Dd9E/aDbo9Svf43HN/F+sGZNNckUoKIy0EwLEm6StHZ7n1LjclxMmAQ1tFu1GhP5MrdW4h3nBYuSUIjMNFMomDME60TR1tyfox7fzEKXKRQqcrC5k2YkVrWRkPjrwgJ33uIG7w6v6AGX2vyKYEjl/pRhvlyEJ8fSwaVX6TO/2zURVOX2lDGZWN1Udd+lY+ly4jf99SBNFsHkdnc3BMnb6COK2X9b7JP6WIGiizVNohbglBIIiSKEgWSRTsLxOtIPD2lPr9/nq4XlN/MKR3d9XC5d8o9S3Vm2aarXTXySVdQ3hXUc1xSdd7fg+GeB5rWUhbtklpJ1PfeXA4aTNqrzc620DgaNAGSE3V7XPIYfIfXaHm97Lhn2RD1Mt6yVGV2mYQyErdfvgQ0FQ6aQwZ/Bfmc/LpBi/BcJjjXBtPDhxpbpXuUOP4+Hi191m9XgVJFKx67D07GvSYtIodlhd3gmGv96TFmcktPbmdUbsT8oknt+32UkjfkD1wH4df5smkbQGOK2mqZqCjk4byE1OrLgolfYNNGi3Lx0RewGlZH5oHukylU8+VZt6R3LaBUOrMts8EhK2M4fC0a362aRxOR3HI/v4osPN48oldTIPRPGT7jGwWztkDEA3pE7b4EMYhC27PAzYaB6zbRbsJ1L8DAAD//2SwwNrDBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:38.652733356 -0800 PST m=+4866.276120069", "maxElapsedTime": "895.431947ms", "maxServiceTime": "895.389123ms", "minElapsedTime": "1.778477ms", "minServiceTime": "1.737157ms", "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": 33893 } }, { "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": "5.274972ms", "avgServiceTime": "5.181442ms", "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-05 11:14:38.949256473 -0800 PST m=+4866.572643028", "maxElapsedTime": "875.202018ms", "maxServiceTime": "875.156824ms", "minElapsedTime": "500.882µs", "minServiceTime": "459.088µ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": 338292 } }, { "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": "b9097beb2dad76e5", "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": "14.875561ms", "avgServiceTime": "14.802517ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2/aMBTFv4p11wciuRWh26pa2gMqqYZEAYWqaOpQcJPb4M44me30z6rss082AfpXTNtbcvPzvfY5J34EVGmRYZaUkitgABSukdtK40mhrC6kARZ2KAiV4X23FBeojSgUsI8UFF8iMOhFg/5FFH9LcrRDvBvpDDWsvpqSpw7J8JpX0gKFokTNbaGBPcKH7QtM8GeFKkWg8DtdCJlpVMAun0Pdyi4KLX45qtTiVkjM0bhWA2Gsx8+5ztFuR7JhNE1GcS+KgcJYi1tgR/WsXk/5p238FdR3gk1Srg6BQlrcojbALldPpNWab/Y1P5gPR8ko6ffmQbBm3yB6O4npK2KJlj/FgoO5yBwyaxwFBk1rvxqaciIyYHB13D4+usKrTsazo8/4afO11MUNptbnwCXI6ofkBz64A7ZpSDtOX/feuP/UAimWwtkTvpsQU3JlvJx4z1MLzOoKKWiucvRloVJZrULYpiCLO2DQ2g8DqOkjLES+AAZ7od/sBjxcg3vhM6zzHtaBelbPKFRGqBwY5Eb4hU8tHnPNpUQJ/5WmUyGt/2HSQmViJSq0Wq0dOSBfyF4YEK4y8i463aKdoGGdUuR71W4fpmRHGIPg1ZH7SljB5XgVAKCg0VTSJhb1cm1a6cBdOXf/4Esd1LZxPatfEwOfHboeEXrqBTOxGvnStwcjcuWvMudLMxsY3JhCQU3B4r1L4jiOxt04Im9dY+Q0Hp2RSTSITs5J02FV2xyLTL9GcUQaY7wrpDvskUZ+r/264Jd77ZHsh2TQP+ufkxDqPwEAAP//767QsoYFAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:40.319989271 -0800 PST m=+4867.943376337", "maxElapsedTime": "730.220707ms", "maxServiceTime": "730.167865ms", "minElapsedTime": "959.076µs", "minServiceTime": "920.885µ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": 29650 } }, { "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": "58e000f3ffe023e7", "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": "12.290879ms", "avgServiceTime": "12.221464ms", "encoded_plan": "H4sIAAAAAAAA/6RU72vbMBD9V8ytHxoQI3E2OgT7YGKXGdrOJGalHcER9sVRq8ieJHftgve3D1n1kqZZ9wv8wXf3/PTuPaMNoMyrAousFkwCBSCwRGYahZNKGlUJDXTkE+CywPug5p9QaV5JoG8ISLZGoJAEV+fRRZqVaEKujeK5ATfUNcstosAla4TtVjUqZioFdAOvtgXM8EuDMkcg8D1fcVEolEA/PwUFjVlVin+zqFrxOy6wRG2pzrg2HTxlqkSzPZKG8SydxpMUCCSK3wE9aedtf8g/qYitE7OcyTE82gIUwjiLw+wyi8O+mfECKLx9h8PhcDleLnHoj/Hk57RW1Q3mprNyY7dZM/WQ3eIDUKMabAnc4kPv384Sh23VNZO6U4r3LDeOg4BissSuveLlCigc+Z2AXDQuxDEBUX11g5ZsYaNfwUbQzts5gUZzWQKFUvPuw12DTtHkK/ibBfYZEqaYECjgv4I65cKgAgJ5JQvurIbj4+NFr2bxeuEyWwy8997RaOAxWXj7gH7sDwbPhMaSG85E4sIEAgp1I0xmUK37PGoL3OO8CM6jhaM7DJil0yhKs9GfgPwXQZM4vfoNS5C+LOY6Tux8/ixoLre7t/PWPnuQmVHI1t23oHkpu5vFpumEAYUbXUkg4DzZrTtdTxvOkwM9f7d3HSd92RIweG/vg2QaJcE08g5cVt7p9OO5N4vOoknqOR3E2x638+7bd6vb9YK0A17HiaPoTfMuP0TTyHP/VvdnecFF6IWPlQ/tjwAAAP//jzk6e3cFAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:38.829093513 -0800 PST m=+4866.452480148", "maxElapsedTime": "851.464203ms", "maxServiceTime": "851.429143ms", "minElapsedTime": "1.253233ms", "minServiceTime": "1.221169ms", "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": 32352 } }, { "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": "fb453550b2b374b4", "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": "b9b8f9f90c6855db", "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": "19.581653194s", "avgServiceTime": "19.581585051s", "encoded_plan": "H4sIAAAAAAAA/7SVUW/bNhDHvwpxy4MNCEbcxGsjIA+ZrG7qXMuQnfahMGSaOivcaFIjqSxZ4X32gZTlxLOKFWv6ZvP+Rx3v/zvyM6BkqsAirwSVEAIEsEFqa42RklYrYSAcvgqAywIfbir+AbXhSkJ4GYCkW4QQ5os0+jWfxB/iSV6ijWpj1RZ1qgvU5qfHMTdWc2ahSTAVZS6rwA2thVtVFWpqlYbwM/zw9Afm+EeNkiEE8De746LQKCH8dCy6qe2d0vwvp6o0v+cCSzRuqwk31ssXVJdonz4ZRrfzRfo+ziCAmeb3EL7eBR2yNBvH2fyZaLlrK/lfpSauhXNG5QUEQA2EwCAApu5RGwg/Nb9Ir7diq8EqypPxqt9vBU/L4y8FPp4Etmipi/YHK1640HLvI4QQ3ebJ2G/mE2EfyXkBIWzWl6OL0eh8/Wp98fpyfXmIVlr9hsx6ABw6Vj/mv+OjK/88GC69BVvaLEJodY27AJxgb/qzznezYCoqje8cPlBmmz0C0FSW6Je5ZKJuCDwPQKg/IQRZCwHOwjte3kEIZ0Nf8EF40QrPhrBb7pYB1IbLEkIoDfeJz22aUU2FQAHfZPYUjcViolT1TnHpDBfce64c8TJngtbGnb3XZTu5JodltRqs0nwf6H9bVacIqm4Ejz56gpTqRCrNfMIxSuur9ZvN1ebqnP34ZjQq1nDEw2HEummQvom5UKpqSfhPQPYMfGGYuqjolHZwstz9G5W3XFjUvj2y4M1YnBg6Plh6Nuyf0JZIbjkVP2tVV86TstRYUot7O2ppewU3lktmSVeh3oHSZbeDuOwoNJEW9RYLTi2+6KdOGiJf+CzfZTj3TZ81txkEoNHUwuauSS1clfZofEXRu+42tLs7O04dmVuNdOtzwfBS+ifXHeZs6G+07Ro17AKw+ODepFkWz26ymHzlW0veZul7Mo8ncbQgUXo7XfTGyXyRTKNFjw1c5f1+oyHtlUwYSabTOCPv0mRKmsEkiqRT0iSQ62uiBs2dQD7+EmexD4x9iLib9Z8AAAD//2Tm1qNMCAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:38.255921287 -0800 PST m=+4865.879307989", "maxElapsedTime": "23.818923363s", "maxServiceTime": "23.818877367s", "minElapsedTime": "11.614101991s", "minServiceTime": "11.614052676s", "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": 2995 } }, { "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": "5.271409ms", "avgServiceTime": "5.186676ms", "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-05 11:14:38.918945018 -0800 PST m=+4866.542332117", "maxElapsedTime": "757.688153ms", "maxServiceTime": "757.63818ms", "minElapsedTime": "527.951µs", "minServiceTime": "488.414µ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": 32352 } }, { "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.653496ms", "avgServiceTime": "5.585223ms", "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-05 11:14:38.644865433 -0800 PST m=+4866.268252396", "maxElapsedTime": "702.396019ms", "maxServiceTime": "702.359383ms", "minElapsedTime": "509.216µs", "minServiceTime": "478.153µ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": 33893 } }, { "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": "afcce9bb0ff38b8c", "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.796829ms", "avgServiceTime": "15.71838ms", "encoded_plan": "H4sIAAAAAAAA/6RUYWvbMBT8K+LWDwmIsSb50An2IdQuC3RLcNqGMYKjyi+OVkX2ZLlrV7zfPmynadOkULYvhqc733vvDukBZFWWUBLnRloIgGNJ0peOTjPrXWYKiOMeh7YJ3Q1zfUWu0JmFGHBYuSYIBOH56CqMvsVlnkhPY5eQK9DCRS5VzUloKUvjwZHl5KTPHMQD3j0VmNLPkqwicPxRK20SRxbi+y5pWPpV5vTvmpU7fasNpVTUUue68A39QrqU/FNLMY6CMJqCY+L0LcRJNa8eW/zTDKPaiamSto+NLRAYR/E4HgVxUH9m8Sh4xGKdQEAulaKP19cflsv+yfWJ2qK5y36Q8o2jD/VKa+nu4xu6h/CupIrjhu4fTdxuctjZIpe2aMalO6l8q8DhpE2pOV7pdAWBo17TXpmyTbLPYbJfLVDxJ1r/NVp/hzZ4jTZANa/mHGWhbQqBtNDNj8/NnEgnjSGD/4rkjLxa4e1evZziTBtPDhwqs4lu00Cn0+ksWpnF+0Wd7qLLPrGjXpdJm7BdMNjC/e4hfLbFB93uXv9Tk1naO51Skyr52JNbt8nm0tem72ifDqNoFEZNB3DcSlPWyx4d1/7vadrksrmm4JBGy+K5V2/2b169FA50oaRLDkFT70ium2FQ6NQ2rwuELY3h8HRXX9ZJFE6GUcgOviXsLBp/YZeTYHgRsnYwNg0v2PPVa2uP2exzGIVsvKl7bPg1YG04TTSberapB6j+BgAA///nMwxeAAUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:40.39607738 -0800 PST m=+4868.019464070", "maxElapsedTime": "454.340794ms", "maxServiceTime": "454.302795ms", "minElapsedTime": "1.906315ms", "minServiceTime": "1.852272ms", "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": 29639 } }, { "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": "1cfe4541ba795663", "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": "31.055377ms", "avgServiceTime": "30.981957ms", "encoded_plan": "H4sIAAAAAAAA/7RUXWvbSBT9K+JsHiwYFmzngxXsg4mVXYMdGzmJKcHIE+lGnkYaqTOj1GlQf3sZyR914lDapi8C3Tn345xzZ55BMspjisMi5RIewHBP3JSKznNpVJ5qeO0Og5AxrXqFuCGlRS7hHTNInhE89P3h4MYPPoS6zMbDXpaX0qA51QWPLCSme16mNpoXpLjJFbxn/LX7wZQ+lSQjAsPXaCnSWJGEd7sP6pVmmSvxxaIKJR5FSglpW2ootKnhV1wlZHYtvXHQ94NwOLj0wTBR4hHeWTWvNm1+aY6BFWMacdnFWhl4GA/DcTjoh337mYWD/uYsFDE8tKN7Oj45bt/xs39OTk+3mWGh8o8UmVrUZ0sr4+opfKAneEaVVDE80NNGyD02hxXWBZe6HplWPDJNFQbFZUJ1eCmSJTwctesRorRsDO0ypPnn5qBiO1jnLVhnD9Z9C9ZFNa/mDKUWMoGHRIs68XtBL8hES/wc05c1JlzxNKUUv2XthUgNKTBEuYxF4wparVZrsRto8fdibfbCdf51jtquw2XsHMD0t5iO+yZotgV1XfcVrYEURvD0P5WXBRh4kihKuLFrfwtdZgcK9kbj68urhetizpDYRLtONmFezavXDQypjGLBDb1Xl5f2Cvl+DP6I7WuVJ81dBIMiXaYmtNI0l4lrW+t6FG7HAwOtCpv9IxLVYUU23awpr32ZGkU8q3OhRSLrR9mS2x/CgyyzO1KoGAyt7NM3CfxJL/CdQw+zcxGMR87UH/rnV870etTaVnKd3tTZq91gd7Sc2f9+4Dvr3a833+ld9p31otdrvgnM1oEuqm8BAAD//zLkZmNkBgAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:40.369187607 -0800 PST m=+4867.992574238", "maxElapsedTime": "777.951912ms", "maxServiceTime": "777.914377ms", "minElapsedTime": "1.49619ms", "minServiceTime": "1.445375ms", "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": 29639 } }, { "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": "1cfe4541ba795663", "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": "339.570043ms", "avgServiceTime": "339.500604ms", "encoded_plan": "H4sIAAAAAAAA/7RVbY/aRhD+K6spUoxkofCSRLV0HxD4UifUpthJFN0hs7HnzPbMrru7Tu96cX97tbY5A8epapvyAfDMM2/PvPgBkCcixTQucsrBAbDhBqkuJc4E11LkCpzhyAbGU7ybFuwjSsUEB2diA6c7BAfCKJi9jxfuR3cRZ6hDLZLbmSi5hgaiCpoYXIo3tMyNVBQoqRYSnAf4oXuAEH8rkScINvyZbFmeSuTgXB2DpqXeCsn+MKhCsq8sxwyVcbVgStfwiMoMdRfSCVZzdxUvPN8FG5aSfQXnTWWfAda1HGDW1T6Vf5WrZ1gLE8rHYANV4ICAlktwIFjEQezN47n5+hR7870uZik4MExucPJqMvxC3/z46vXr8aO2kOJXTHTdhgfDwY7K+/gW78HRssTKhlu837N+VPr5dqiCclXnjnc00Y0XGyTlGdbiLcu24ECvSSHJy2YEhjbk4nejmIBhcw8bHcPGj7DREWz4HGwI1bpa21AqxjNwIFOsNjxk9hJ1sj0k9Z+UfOrsnWB870sd+9oPxDODzA3txsyytIiVloxnlrURm8EmWNQ93fT75Ns3cg2Da6j/ncF5Da7/JLEllTTPMYf/NIWXLNcowYZE8JQ1cwNW/TnOlFyQ3rBPKE9Jp5o/qkb9U13Q6K7Lly/HCemN94DepJVdkBNs50JtBpsw/uXD1I+86POBl9dniPA404zmb6UoC9OpLJOYUW32/goSc2yslCnNeKLJKa2wtiEzhm2vrtbVunoaQKPcYcqoxu8V5XRkGf9+Ffwvg9KyvGzuC9ggUZW5jg01zYGoV2TmR3GbHNiAd4Wx/bsSqvN87GOZljztSqgl0l1tC4plvH4xmdIOU3CAl7svKKGyQeOdOefLlbucrlzy7KuJXK6CnwkJ3YU7i8gs+OBH1twLI8+fRZYYtK77fTINyUGs1qw7MEQQz/fdFXkXeH4TjigS+OS9+zkkVhTEYbTy/LeNT7Nl9Q14MXhhfsiJvo356Sd35ZJHi3orydSfN6J5Kxp1IrNa3RKek+MF6U1qhRp0S9etHFR/BQAA///XDJFGCggAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:37.659663741 -0800 PST m=+4865.283050388", "maxElapsedTime": "822.619254ms", "maxServiceTime": "822.433122ms", "minElapsedTime": "86.288123ms", "minServiceTime": "86.235822ms", "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": 2995 } }, { "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": "6.045421ms", "avgServiceTime": "5.976462ms", "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-05 11:14:38.695730323 -0800 PST m=+4866.319116957", "maxElapsedTime": "971.519627ms", "maxServiceTime": "971.438255ms", "minElapsedTime": "683.222µs", "minServiceTime": "644.594µ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": 12826 } }, { "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": "5.144931ms", "avgServiceTime": "5.071696ms", "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-05 11:14:38.741719678 -0800 PST m=+4866.365106726", "maxElapsedTime": "670.7952ms", "maxServiceTime": "670.761078ms", "minElapsedTime": "557.123µs", "minServiceTime": "511.187µ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": 34627 } }, { "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": "c303133c7d48fcfa", "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": "17.965871ms", "avgServiceTime": "17.894485ms", "encoded_plan": "H4sIAAAAAAAA/6RU72vbOhT9V8R9/ZCAeLzEhT4M+5AlLjOkTbCzlTKCI+QbR60ie5LctSve3z4k52fbjLJ9CSjn6Nx7zz3yM6DiZY55VkmmIASgsERma43DUlldSgNhr09BqBwfB5X4gtqIUkF4TkGxNUIIk2QUJVk6G8w+p1mBdsyMnegcNbQUUzHueDkuWS0tUCgr1MyWGsJn+Gd/gBS/1ag4AoWffCVkrlFB+PWYNKjtqtTih2NVWjwIiQUaJzUWxnr6jOkC7b5k6FtMgcJUiwcIL5p5sy3xRz28ixQ7y1LOVAAb/7xZ2U0Wj7KR+xlm8WiLZSKHEHjwX9ALAn6Rn/+/5Eu2Qytd3iG33vpnN/ea6afsHp8gtLrGhsI9Pm2d3o37tv2mYsr4dvGRcdsqUNBMFej/XoliBSGc9Xx5Lut25QEFWX5vgYbuaf1TtP4RLThFC6CZN3MKtRGqgBAKI/zFQzMv0fIVvH/Kl/enTDMpUcJf7f1SSOtzzUuVi3Yb0Ol0Oou2mcW/i4nf76JLPpCzXpcwlZNjeLSD+9238OEOD7rdV3PESljB5LSNA1DQaGppM4t6vd1p5YhHmk7RS70FDgdJEkfJ70nR9Sy5zTxj3swb94COG9u+eCnWwj09lx1T6sPOcjR8G7bTXb5SHnvF3ZXe62wItXfENfcCT61GtvbKYESh/OfN7f9wdgjhzpQKKOyGPfxrT2goWHx0I06TaDpIInLyA0guk8kVSaNxNJwRp0HJYUl32pRqma0X5OZT5FR9kHyMyOB6RNrk+NxszsPNOWgvko+3vggZRemQjOOreEZ60PwKAAD//3U0VaDjBQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:37.454743577 -0800 PST m=+4865.078129667", "maxElapsedTime": "679.856445ms", "maxServiceTime": "679.821189ms", "minElapsedTime": "1.657523ms", "minServiceTime": "1.61568ms", "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": 3049 } }, { "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": "58e000f3ffe023e7", "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": "16.129556ms", "avgServiceTime": "16.052211ms", "encoded_plan": "H4sIAAAAAAAA/6SUUU/bPhTFv4p1/jxQ/a2ptJuGLPHQkaBVGqxqwxCaqtRKblMP18lsh8FQ9tmnOHRA6SaxPUXxPb73+Hdk34FMVuaUp5WWBgLgWJL0taXj0nhbagdxMOBQJqebUaU+kXWqNBCvOYxcEwQmo8vT+CxJ6yqXniLlvFWZfye1NBmhk7lKZq02p6WstQdHWZGVvrQQd/jv4Qcz+lpTt/FHtlI6t2QgPj8VjWq/Kq363qoqq66VpoJc2+qDcj7IE2kL8g8jRTSeJdPxcQKOiVXXEIfNvNkM+SsX45bJLJNmiHtAEIjG6ThKL9JxtFlMVQ6BN4fU7/eXw+WS+oMhvf1VrWz5hTIfoN61p1lLe5te0S2EtzU1HFd0u+H36BC7sbpKGhec0o3MfNeDw0pTUFheqWIFgb3Oc6brLs4hhy6/dYWGP8gGv5MN0MybOUftlCkgUDgVNj4GNJFWak0a/4T5hHy2wkswbPs4UdqTBUdWmlx1qLG/v7/Y9Fm8WnSZLXrsiO0NekyanG0LNuVhr/dsxLEuDT1bnVHIhHzqya67XCrpW7JbvS+TaNEDx7XUNQV3O+rsf7Z30GvBP5tj8vNw/cAhtZLuKaQXoJs3280j5TJp812lmbck18EQnCpMeDggTK01h6eb9v5NpvFkNI3ZH58JdjL9eMrOJ9EoidnGIpvFCQtHZ0f33xYAu3gfT2PWBcZCXmx0FrE2oBAPmp8BAAD//wSzvlvXBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:38.877485245 -0800 PST m=+4866.500872462", "maxElapsedTime": "1.021817639s", "maxServiceTime": "1.02176724s", "minElapsedTime": "1.931383ms", "minServiceTime": "1.849669ms", "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": 32352 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "fd66bc40f4c7d3f5", "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": "14.092779ms", "avgServiceTime": "14.025425ms", "encoded_plan": "H4sIAAAAAAAA/6STUW/TMBzEv0p07GGTLMTY2CRLPFRbplUarEoLQUJVapx/E2+uHWxndEzhsyMndGUFIQFSXmyfz3c/xw8gI21JZdFoYcABhiWJ0Do6syY4qz344UsGZUpajxr1npxX1oAfMxixInC8TfPiOjtPs6KikAtHtW09zcQ6E4EwyHwjZNSWtBStDmCwDTkRrAN/wLPtAFP63JKRceM3WStdOjLgH5+KRm2orVNfo6px6k5pqshHqyvlQy+fCVdR2B7J81GWXl6/m6ZgmDh1B37azbvNKf8UYxyhTKUwR/hBCBz5ZTE+34wLVYJjWZ6cfJLHL5bH8rQ8Wr56XG2cvSEZeqAPsclKuPvilu7Bg2upY7il+w27nwv8nqlvhPF9SloLGQYTBidMRf10raoaHHuHfQKp2+Eujxi0/TIsdPNuztB6ZSpwVF6hY09bX1CQNf4q2q7FRDihNWn8F/4LpQM5MEhrSjVQxP7+4jHN4vkiL8bni4PkdbJ3ePBLjLFRQQk9GW4BDI58q0MRyK02HJso3PWcjT4sDiKqXTTKbO26eRe/Hck0OBKrfi+8qkz/1mL93hUcN94adAyB1vH3nWTpZJSlyR9fWXKRXb9JpulVejZLeqNh5jF1kl+mWZpEGj0LdN8DAAD///hFpEH6AwAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-05 11:14:38.614054623 -0800 PST m=+4866.237441327", "maxElapsedTime": "827.309355ms", "maxServiceTime": "827.253681ms", "minElapsedTime": "988.497µs", "minServiceTime": "955.575µs", "name": "NEW_ORDER_getWarehouseTaxRate", "node": "172.23.107.87:8091", "statement": "PREPARE NEW_ORDER_getWarehouseTaxRate FROM SELECT W_TAX FROM WAREHOUSE WHERE W_ID = $1", "uses": 33893 } } ]