[ { "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": "e5cb99efd46a56d5", "index_projection": { "primary_key": true }, "keyspace": "CUSTOMER", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((`CUSTOMER`.`C_W_ID`) = $1) and ((`CUSTOMER`.`C_D_ID`) = $2)) and ((`CUSTOMER`.`C_LAST`) = $3))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`CUSTOMER`.`C_ID`)" }, { "expr": "(`CUSTOMER`.`C_FIRST`)" }, { "expr": "(`CUSTOMER`.`C_MIDDLE`)" }, { "expr": "(`CUSTOMER`.`C_LAST`)" }, { "expr": "(`CUSTOMER`.`C_BALANCE`)" } ] } ] } } ] }, { "#operator": "Order", "sort_terms": [ { "expr": "(`CUSTOMER`.`C_FIRST`)" } ] }, { "#operator": "FinalProject" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "19.64284ms", "avgServiceTime": "19.581988ms", "encoded_plan": "H4sIAAAAAAAA/6RU72/aMBD9V6JbP4BkTSq0nRppH9IkaEi0oISumiYUvOQa3AYns52urMr+9sk2AUp/rNu+QJx7d+/d3YsfAHlaZpglVUE5uAAErpGqWqBfciXKQoJ72CPAeIb3XsU+o5Cs5OAeEeB0ieDCOArCKImn3vQyTnJUfi1VuUQhz1YjKtWFRlmwrGiqMzK8pnWhgEBZoaCqFOA+wLvtAWL8XiNPdeKvdMGKTCAH9+tjkFerRSnYT42qBLtjBeYodakRk8rAp1TkqLaUrn8ZT8fnYQQEJoLdgfuhmTUtyT+peBNoqMcXp5T3YT1LcMG/TK6SYZAE+mfkxdM2lrAMXMDj9NvpKV5nRyf0+CQ73kQrUd5gqswaHnTnSypWyS2uwFWixobALa7aWe80/PwKZEW5NILxnqbK1iAgKM/RvF6wfAEuHBwaAWlRWwP0CRTlDxtoyBbWewnWewTrvwTrQzNrZgRqyXgOLuSSmcTdcQ5QpQv4mz73K0yooEWBBfzX7gesUCiAQFryjNmNQKfT6cxbOfP3c99sed51PjoHh12H8szZBwQbQK/7PELbwyL63e6TboacKUaLiTUGEBAo60IlCsWy3W2lgXtVNasp9nx4MIw06yuI82EQjMJXIVb5K4Azb+Rd+KbIrJk1+nt83N1YZGbIshR/bmmj+UmZAePbEWmivXisBNKlSQTJcm5uQW2LjURw4UaWHAiseXZfDIPdk/mcd852UO2bhoDCe30vTaJw4kWh84ZL1BlE43MnDkehP3U0H3HWMvSDJdBPmlr/r0XbtHZGztWnMAod60njSMe7CBxrQWPA9VlXMXaz0pyzLy0bNL8DAAD//6DH60g2BgAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:39.871082805 -0800 PST m=+4842.129809424", "maxElapsedTime": "229.555732ms", "maxServiceTime": "229.453204ms", "minElapsedTime": "1.501993ms", "minServiceTime": "1.467388ms", "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": 1856 } }, { "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.307876ms", "avgServiceTime": "8.233582ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBT8KuJWaAKi0DQbw7A/QuLCyJpktrMR0uAI+zURVWRPkkO7NvvsQ267ND8KY/tPfu/83unu9ADSWZFTnpZKaAQAxw0JVxnqFtqZQlkE5y0OqXO665TyGxkrC42gzaHFihBgEH5Ph1EvjNKqzIWj2BXZLZ7athSZx+R0IyrlwFGUZIQrDIIHvNt+IKYfFemMwPErW0qVG9IIprugTuWWhZE/Pao0ci0VLcj6UV+kdTU8EWZBbrsyiJNhtw+OkZFrBB83s83Lhn+i0Kf7OBMaHLd0bxFg2mi4IrXOSL1onHxossdHdo2za9SnV633zeYMG747biSMUIoU/ovUJbls+UzpWfGXax9zYZ9EVxWaDqoxeb8sudSRWdl6aSncEgEa83r8/Gwep1/HnUHyOZnMm+BYC1X5TSfn9bgj8EnS20W23kI+Zao7SHbxF2/ho/BqmISHP7ThPd+/m87HdVrBIZQU9pVkf6vibLM/tidtJkx+rBU7Q2JVU4GVC12/MQS6UorD0Z2P7CgKR50oZEdfFLuMhldsPOp1kpDVvNg4Dlk/nMRsepDA07PTg/jNWBwmbOsY+8ROzjmrPfHnlj//Ud1XLnxlq6svtbH5HQAA//+PZic7NQQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.770547088 -0800 PST m=+4844.029273706", "maxElapsedTime": "674.697551ms", "maxServiceTime": "674.657504ms", "minElapsedTime": "774.92µs", "minServiceTime": "734.527µ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": 352910 } }, { "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": "16851518625e88b4", "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": "11.435368ms", "avgServiceTime": "11.364298ms", "encoded_plan": "H4sIAAAAAAAA/6STX2vbMBTFv4o460MDYuD0z4JgDyFxmVnWhCS0gxEczb511CqyJ8ldu+J99mG7XrJ0e9gGfrHu0dG5v8t9ApkkTymNCy0NBMBxQ9KXlka58TbXDiLocyiT0sOwUFdkncoNxCmHkVuCwGI5Hb2PJ+FVOIkz8tMoRVtzhUxqQUo3stQeHHlBVvrcQjzh1e4HC/pSkkkIHN+TjdKpJQPx6VfRsPSb3Kpvtaqw6l5pysjVVhPlfCNfSpuR3z0pxtFiOY9GS3DMrLqHeFOtqu6Rf0oR1SAWiTQneKYCgXEUR+P4Oo7G3WGsUggE54Oz4CwYnPfPaDD4fPqzWtj8lhLfkHyqu9lK+xjf0SOEtyVVHHf02PHba+L3WF0hjWuS0oNMfOvBYaXJqDneqGwDgaN+EyDRZTvDEw6df20LFd/Jgj/JAlSrasVROmUyCGRONRf3AV2QTzb4mwYOHWbSSq1J478GdaG0JwuOJDepalHj+Ph43aVZv163M1v32Ft2FPSYNCk7FHTlfq/3ImhklFdSz9phgsOSK7WPPdltN4+iFh54XoYfl/G0sa6BHgJUZudZrar6O5AsvCW5be7Cqcw0C1tT2vOGwK3LDSoOTw/1Uszm4Ww4D9nLhWUX8+kHtggn4WjJ9jza8y47u34XzkPWQmuQseHlmI2f//qofgQAAP//X7IbNU8EAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:39.900476401 -0800 PST m=+4842.159202993", "maxElapsedTime": "243.036845ms", "maxServiceTime": "242.989746ms", "minElapsedTime": "1.41633ms", "minServiceTime": "1.379346ms", "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": 3103 } }, { "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": "8.99777ms", "avgServiceTime": "8.918883ms", "encoded_plan": "H4sIAAAAAAAA/6RTYW/aMBD9K9YNqYlkIUG7arK0D1lI96GljUiYhCgKVnIFa8bJbAe1a9lvn5zBSihM2vYJcvfu3tO952dAlZcFFlkluQIGQOEBua01hqWyupQGWK9PQagCH4NKfEFtRKmAXVBQfIXAIA4mw+g2zeqq4BY/h2FtbLlCDb8QpuK5gxX4wGtpgUJZoea21MCe4d3rByT4rUaVI1D4kS+FLDQqYNM2KKjtstTiu0NVWqyFxAUat+pGGNvAU64XaF8pWThO0rthNAIKsRZrYB82s82O5J9UXONTknMFFL7ikwEGU8/zPFtmxmqhFl7nwicvL+QeuvfQ/NtrvfdP9y59fwYb2iaLueZSooT/knyFNl9uBW8t2bvLMacOdYSyVPimmqDz1KDNLOqVaXgrbpfAwJvvGObdeZh9Cm6C2zCa+0BhzWXtuDq9ZuHxgUk6yLbpag/1/zC0i2N4OHQOzvVD8aoYN7kFClwKbtpn+YtjzTaHywfC5FwXx1qJ1chXjSAwYqGaFwdM1VJSsPjo0huPojgYReTU+yJXo7shGceDII3ITh0ZJxG5jiYJmb6N41n3zP20w3iicen7ZEaSKCW/jSMfSadHScsXV+u72t7ZXe0cNj8DAAD//4bGvWtcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.183555882 -0800 PST m=+4843.442282500", "maxElapsedTime": "588.723226ms", "maxServiceTime": "588.62685ms", "minElapsedTime": "895.679µs", "minServiceTime": "851.037µ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": 30169 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 9, "Target": "default:NEW_ORDER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "ValueScan", "values": "[[((((to_string($2) || \".\") || to_string($3)) || \".\") || to_string($1)), {\"NO_D_ID\": $2, \"NO_O_ID\": $1, \"NO_W_ID\": $3}]]" }, { "#operator": "Parallel", "maxParallelism": 1, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "SendInsert", "alias": "NEW_ORDER", "keyspace": "NEW_ORDER", "namespace": "default" }, { "#operator": "Discard" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.773459ms", "avgServiceTime": "4.703094ms", "encoded_plan": "H4sIAAAAAAAA/6SSUWvbPhTFv4o4/0BtEAUn/5fpLSzeCOvsYGctowlG2LepmCJnkpxlS7zPPpw2jVvalw0Mls49+B78O3uQKeuKqmKjpYEAOO5I+sbS+9p4W2sHEQ05lKloN96oa7JO1Qbifw4j1wSBJL4p0mwSZ0VpSXpK6EdqK7J4cLiNLDtbRXey0R4c9Yas9LWF2OO/8wU5fW/IlASO3+W90pUlA3H73DRu/H1t1a/OtbFqqzStyHWfulLOH+1zaVfkzyvFU0JwzKzaQrxrl+1py1/FuJa6obyUBhzb7uwgcHsbBEHg68J5q8wqGAxDdjiwBS4XOJ56o1H49iwKQ872CyRpMSmmkwUEGww5OwrpSYgehZuTMGqXS7T8ec6ZtFJr0uBYy93pptwaIvqnH5CTqabGke2ISq2k61cBHN/o5wl9X36tEi9DT5Qrpa3QLtvueTHNvSW5xpGgUytzbCuEabTm8LTryM+yeDbOYvZWN9mHLP3MpkkeZ3M2Tebp2Rl8ir9ydj2++hKHD688mKdFPs+myccO6eHALi4vOmQ9efS6HD2BfOQ2iHif62DI+xAHozZE+ycAAP//dpBGC5UDAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.346751135 -0800 PST m=+4843.605477712", "maxElapsedTime": "511.649846ms", "maxServiceTime": "511.613909ms", "minElapsedTime": "459.915µs", "minServiceTime": "426.004µ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": 35366 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_01`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.766353ms", "avgServiceTime": "4.694571ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aMBCG/4p1m1SQIjSqSZPyLSLphGiBxe4mRFGwwgFug53ZpqIr2W+fnABJu7IPq4RkfH58997l9TOgTNUCF0mecQk+gAdL5Harsaek1Soz4HcvPRBygbsgF99RG6Ek+J89kHyD4MMw+pGM4jCKk26yQkutSh/6cqmgIkzOU4ctcMm3mQUPVI6aW6XBf4YP9QYo/tyiTBE8+J2uRbbQKMGfvoSCrV0rLX45KtfiUWS4QuNSXQtjS5xxvUJbl/QpG/UG4MFYi0fwvxSz4ljhvyQM8ImmXIIHD/hkwIdpq2VVYqwWctX6eNkm+z25g84dlP8aR912ewaF9zLdFdp0fUh2mNVR8Fvze319zDXPMszgXT31pbCCZ2Ot7jF1H0mj2WY2sag3pqRxlzuwNS/FzTtzmny7DYaszybzdqnqDSIMWHD+dMLC84eVpXpDdh6Jo5sRi/7NhH3Kkk9dB8z+mryQdcvFrHC/Vwi1GvmmvAtGrGT5NNyEq97Ah3ujnBVOlZqhUw/N4HFqzVjdSTM6YeFxW3hgcedMPY6jcRBH5NyzI1fx6IbQ6DrqMVJX80il2K0TFrrlpM5tagUlWfVyyOWGSW5pRAbRhJIpGyWUxf3hV+f1/Z5cdC6czxvhrrP5nwAAAP//SrzJB1wEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:40.881825925 -0800 PST m=+4843.140552523", "maxElapsedTime": "353.407214ms", "maxServiceTime": "353.36437ms", "minElapsedTime": "537.755µs", "minServiceTime": "502.865µ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": 34917 } }, { "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.037174ms", "avgServiceTime": "4.955622ms", "encoded_plan": "H4sIAAAAAAAA/6SSb2vbMBDGv4q4BWqDKCTttk7vTOINM88OttdSmmCEfU3FFDmT5dIt9T77sB3lT2nfbGCQnucO67jntwVURVVimW8kV8AAKNwjN43GaaWMrmQNbDyhIFSJT95GXKOuRaWAXVJQfI3AIPJv8jiZ+UleaOQGY12ihqFcb3jR9ZR4zxtpgEK1Qc1NpYFt4d1BQIo/G1QFAoU/xYOQpUYF7O60yWvMQ6XF765ro8WjkLjCuvtVKGrTt2dcr9AcnmT9aClQmGvxCOxTu2ztE/80wzWXDaYFV0DhsbvXwODuznEcx1R5bbRQK2d04ZLnZ7KA8wX0t6PSxH27NnZdSrYLiHMvDPMwnnrhAhgZXVHSmVMvSQI/yYNZ737YuVZfDnpm9WTQfpQlt/lgvR+sXcN4UHGYT6Osdz4Ozo3tuGiXS2jp6QrmXHMpUQKFNX+yStRrYOP/2m2KqgxUjbojhUvBu93uA/yBvyxPe+81yF6OOxN1wXUJ7bLtvhfV1Gjka+ixqMVK9fADU42UFAw+dSzNE3/uJT55FXXyOYm/kSBK/SQjQZTFZJiOOF/9W0quvfC77w5HSpwsztMsCaIvlpGz87PuIEeFyVuFsaWjT8fGt8vbxr3LbnRxQoeF4wCDZeEEKsvUHglLxDGPo6vWhfZvAAAA//9yT91HPAQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.341979232 -0800 PST m=+4843.600706009", "maxElapsedTime": "662.606303ms", "maxServiceTime": "662.500209ms", "minElapsedTime": "547.878µs", "minServiceTime": "490.952µ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": 35366 } }, { "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.757551ms", "avgServiceTime": "4.689976ms", "encoded_plan": "H4sIAAAAAAAA/6SS0WvbMBDG/xXzbQ8tiEHHYKA3k6pg2rTGzjZGCY6wL446RfIkuaQr3t8+ZKdkbbqXFQxGut/dffruHkGmtg01VaelAQcY1iRD72hmTXBWe/CzjwzKNLRLO/WVnFfWgH9iMHJL4LgW36qb4lwUVUshC7TNzNpiCvtO1pFpaC17HcBgO3IyWAf+iHeHA0r62ZOpCQy/643SjSMDfvscSvuwsU79ilTn1L3S1JKPpa6UDyO+kK6lcGjJs4WYgyF36h7887Acnhr8l4JLeihracDwgx48OG6DrXxwyrQn789OlxjY84QLCvVmj+/N2Ct6zZ+X2bl0UmvSeJPozKigpM6dvaM6DsGR73WoArmtH2nadRE8WUVtqw+rrMqLbCZWp6Oi4+h1Ov938DxdpDG4PPJCmYOKYTnE7wVSBkdyO+bCq9aMqxgfPZUFx5230f5Jw9/nUfHTxcAQaBf3IC9EnhYieXVNk4viZp6U4krMFsm+BEum2vEfe05MfF3ypRTJpfheJkdT/xMAAP//Vp7K60kDAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.235902352 -0800 PST m=+4843.494628926", "maxElapsedTime": "646.967563ms", "maxServiceTime": "646.923068ms", "minElapsedTime": "497.74µs", "minServiceTime": "465.469µ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": 352910 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "367e8ea40f6591dc", "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.177384ms", "avgServiceTime": "20.104384ms", "encoded_plan": "H4sIAAAAAAAA/6STX0/bMBTFv4p1xgPVrGn8GWOWeOhoEEhjVG1ZhaYqvUouqYfrZLbDYCj77FMc/oyCJrE9RbZPzj33d3VvwDYrc87TypCFAiTOmULteL+0wZXGQ21sSmib81W/0l/YeV1aqG0JS0uGwrB/dpx8nqR1lVPgKTlelLXnj2TIZoxO5yvKWnHO51SbAImyYkehdFA3ePVwwJi/19z9+CtbaJM7tlBfH4v6dViUTv9sVZXTl9pwwb61+qR9iPIJuYLDQ0k17Y+Sw5PTcQKJodOXULvNrLmr8k8xjloq44zsFm4RQWF6mB4N7s6pzqGwtfOed5m2357vvPuwkWf3r5Urv3EWItGbtpMluev0gq+hgqu5kbjg6zt2fzbwPFNfkfUxJV9RFjoTCUe24Hi90MUCCmubMUFm6m6YWxKm/NE9NLNmJlF7bQsoFF6jkY+7HpIjY9jgv9gdcMgWeFGDq0EOtAnsIJGVNtcdRayvz+995m/m0/RoMO+JPbG22XtisG9Ky09uxxxZckgDu2XHs6LQglv1PpsM5j1IXJKp+bniUSBei7WNXkv2SSWbn8a1gQQZTX6FwkvgzJpV+4H2Gbn8uadxcEzLGAleFzauPJStjZEIfNUuznCUDPujRPx9wcXB6ORYnA4H/Uki7kOKcTIRsX2xd/ttIYjpYTJKRDuUOBI0vwMAAP//B3IEToIEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.14671818 -0800 PST m=+4843.405445226", "maxElapsedTime": "575.103318ms", "maxServiceTime": "575.063944ms", "minElapsedTime": "1.322155ms", "minServiceTime": "1.280896ms", "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": 33917 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((((to_string($4) || \".\") || to_string($3)) || \".\") || to_string($2))]" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`CUSTOMER`.`C_BALANCE`)", "value": "((`CUSTOMER`.`C_BALANCE`) + $1)" } ] }, { "#operator": "SendUpdate", "alias": "CUSTOMER", "keyspace": "CUSTOMER", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "10.06163ms", "avgServiceTime": "9.982564ms", "encoded_plan": "H4sIAAAAAAAA/6RTXWvbMBT9K+KsUJuJQrs+DMEePMeF0XQNcVIoaUiEfZuIKZInyaFdm/32Ya9Z89E8bHuTdA86595z7hPIFLakclJpaSAAjnuSoXaUWhOc1R7i9IxDmZIekkrdkPPKGohzDiMXBIFO1v1yk/VvJ3VVykBp7YNdkMNvgK9k0aBKupe1DuCwFTkZrIN4wrvXC3L6XpMpCBw/i7nSpSMDMdoGJXWYW6d+NKjKqaXSNCPffNVVPrTwgXQzCq+UIh3mg+urrA+OnlNLiI+r8WpN8k8qLukxL6QBxzd69BAYRVEUBTvxwSkzi47OY/b8zO5wcof2tFH6EB+uncXxGCu+TdaTTmpNGv8l+YJCMX8R/GLJxlzecmpXR6qtob3XnBpPPYVJILfwLW8lwxwC0XTNMD2ZppPPSTf5mmbTGBxLqeuGKzqEYe/Z0WmMxqhdPlMO26CBQ2ol/XYnf9HfeLX7eUf5QrryrVIeHMlFKwhezUy7IxCm1poj0EMTuF4/6yX9jB3YCHbRv75iw14nGWRsLY4N84xdZrc5G+0H6PjkeC89G++70WF5NmB/hsg+bZybcWL1KwAA//9XCZEQ7wMAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:42.170938297 -0800 PST m=+4844.429664865", "maxElapsedTime": "944.665555ms", "maxServiceTime": "944.597289ms", "minElapsedTime": "909.356µs", "minServiceTime": "875.045µ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": 31889 } }, { "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": "a2c5c892d7e94cf4", "index_projection": { "primary_key": true }, "keyspace": "ORDER_LINE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" }, { "high": "$4", "inclusion": 3, "low": "$4" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Filter", "condition": "((((`ORDER_LINE`.`OL_O_ID`) = $2) and ((`ORDER_LINE`.`OL_D_ID`) = $3)) and ((`ORDER_LINE`.`OL_W_ID`) = $4))" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`ORDER_LINE`.`OL_DELIVERY_D`)", "value": "$1" } ] }, { "#operator": "SendUpdate", "alias": "ORDER_LINE", "keyspace": "ORDER_LINE", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "60.653093ms", "avgServiceTime": "60.578942ms", "encoded_plan": "H4sIAAAAAAAA/6SUUWvbMBSF/4q460MCYtDEY61gD6F2WSBrgtM2jBEcId06WhXZk+WuXfF++5CcNEuTPHR7MfjeT1dH5yA9AxpRSJRZqbkBBkDhDrmrLV4UxtlCV8BOexSUkfg4KNUt2koVBlhEwfAVAoM4GQ1vk/RrVpeSOxxbiXakDEJLVCUXHpN4x2vtgEJRouWusMCe4d32B6b4o0Yj/MLfYqm0tGiAfduFBrVbFlb98lRp1YPSmGPlR41U5QJ+zW2ObrslG6dxkmaj4VUCFCZWPQA7a+bNZpt/0jH0hkwFN31YuwMMxqNsnA3jLPafWTaMN71MSWDAe+KDODvvyY94Hom76KVb2uI7CheMffbHWnH7lN3jEzBna2wo3OPTxsid0xx2uCq5qYJkfOTCtVMoWG5yDOWlypfA4KQXJAhdt6H2KejiZ9to6BbrH8P6O1h0DIugmTdzCnWlTA4M8kqFhX8bOuGWa40a/iuWS3RiCW/z67WSS6UdWqAgCiNVmwp0Op3OYjtq8X6xDnvRJZ/ISa9LuJHkABO/MP3uUWj2AkXd7p6gC10Y3KtOMUSNLnNoV23cJXc+iQMqNpc0XnSBwgPXtbfg5NQnszfYyJtwl4EC14pXr118k7vz5vUGsaoEt/JQa+os8lUQBZXKTXiKgJlaawoOH/21nqTJZJAm5NjDQy7T8RdyM4kH1wnZ6iPT5JrsWOH9PiWzz0makHWaIUsyuIrJOroQ3KYwWxciaP4EAAD//5rZ1t86BQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:42.066922988 -0800 PST m=+4844.325649776", "maxElapsedTime": "621.000612ms", "maxServiceTime": "620.838788ms", "minElapsedTime": "7.955351ms", "minServiceTime": "7.915105ms", "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": 31889 } }, { "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": "16851518625e88b4", "index_projection": { "primary_key": true }, "keyspace": "DISTRICT", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "DISTRICT", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "(((`DISTRICT`.`D_ID`) = $1) and ((`DISTRICT`.`D_W_ID`) = $2))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`DISTRICT`.`D_TAX`)" }, { "expr": "(`DISTRICT`.`D_NEXT_O_ID`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "11.586968ms", "avgServiceTime": "11.515304ms", "encoded_plan": "H4sIAAAAAAAA/6ST32vbPhTF/xVzvn1oQHwh6Y8FwR5C7TJD1wYnLIURHM2+ddQqsifJXbvi/e3D8txkWfawDfxi3aNzz/1c9ALSWZlTnlZKaHCA4Y6Eqw1dlNqZUlnw4YhB6pyeJpX8QMbKUoOfMmixIXBcR4v0JgmjJC3IhdI6IzOHrmwrkbWanO5ErdrTsiIjXGnAX/Df9gcz+lyTzggM37K1VLkhDf7xZ9GkduvSyK+tqjLyUSoqyLZWV9I6L58LU5DbtuRhPJsn8cUcDFMjH8HfNMumb/JXKeKWxSwT+gQ/wIAjjNM4TBdpHPaHqczBMTwfnw3PhuPz0RmNx59OX6uVKe8pcx7mSzvNRpjn9IGewZ2pqWF4oOee384Qh7HaSmjrk9KTyFznwWCELsgfr2WxBsfR0AfIVN2t8YRBlV+6QsO2stHvZCM0y2bJUFupC3AUVvqLu4AuyWVr/MkA+w5TYYRSpPBPi7qUypEBQ1bqXHaocXx8vOrTrP5fhWkcrgbB2+BoOAiEzoP98uJVMBoMfgkaa+mkUNNumWAwZGvlUkdm0++jaoV7rvPJ7apzO1y/jm7n6Y1v3QLfByz1tmezbNpvTzJzhsTG34WVhfZvuqW44w2Oe1tqMPhA/W/D4OipfUPTJJpOkig4+MSDy+TmfTCLrqKLeeANWLBj3pX7oYLFuyiJgpa2Zx1MrsOgg+vRovkeAAD//0cp4LiLBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.271847509 -0800 PST m=+4843.530574366", "maxElapsedTime": "596.22546ms", "maxServiceTime": "596.13952ms", "minElapsedTime": "1.134324ms", "minServiceTime": "1.096176ms", "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": 35366 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_03`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.772863ms", "avgServiceTime": "4.703334ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNdtKkvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD//14VRQlcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.626483599 -0800 PST m=+4843.885210183", "maxElapsedTime": "374.967298ms", "maxServiceTime": "374.930588ms", "minElapsedTime": "533.583µs", "minServiceTime": "497.414µ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": 34444 } }, { "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": "a2c5c892d7e94cf4", "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": "5ae2f3a5cf22e225", "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.045212239s", "avgServiceTime": "2.045137255s", "encoded_plan": "H4sIAAAAAAAA/7RWbY/aRhD+K6spH0CyTsFwTWPpPiBwWqfUpthJVKXIbNeD2Z7ZdXfX6V1P7m+v1objNU2Tu35BYuaZt2eesf0AKJjMMEvLggrwABxYITWVwrEURslCg9d3HeAiw7tRyd+h0lwK8IYOCLpB8CBOovGP6dR/509TKjTP0cRGstuxrISBFqZLyiw2wxWtCmuVJSpqpALvAb7Z/4EY/6hQMAQH/mZrXmQKBXgfjkGjyqyl4n9ZVKn4R15gjtqmmnJtGnhCVY5mX9KL5hN/nk6D0AcHZop/BO9l7VwANvMcYBb1rpWv6jWwzMWMigE4QDV4IGHLJ3gQTdMoDSbpxP68T4PJzpfyDDygLrtm371ys5f4ashWw0dvqeTvyEyzigfLwYaq+/QW78EzqsLagVu837F+NPrldeiSCt30jneUmTaLA4qKHBvzmudr8KAzaFpgRdXKoO9AIf+0jiFYNncw9xg2eIS5R7D+p2B9qBf1woFKc5GDB7nmTeAhs6/RsPUhqV8y8mmyGVW0KLCAJy07RG0wm0pZvpFc2N4K3rSnreRFygpaadtGt9tdyuXVMpo2W1/2yA3pLvXyahlvDT1CRUb2sOAU1hp6vad1fC5PfSDPOGm6aWr1j6V5TdFdDeg1W7kuuu7110lzd2yXVSkaOtNCynKnyP8q1BN6P6GzU9SBNk+I/1yCLeoLVavhKWzUi/osOy8MKnCASZHxdglWbJf01umfamzy6HLP9Be1vl+rFy8GjHQGO0BnuLVZZR5h9ylawf78dhQmQfLLQZZve70zggLBDafF90pWpeUpzxXm1Njn+wdg9qXSzbg2XDBDTujvwcKB3AZavdmAxQWOAmFQbTDj1OBzVTlbg3i+Cf6XJ9WW5Vl7rOCAQl0VJrXUtPfVCHQcJum2OXAA70ob+7kR6st87GrZlZxvJTYK6aaJBc1z0XyE2NEOW/BAVJvfUEHtgME7+9qezf3ZaO6Tf/0MIa/n0U+ExP7UHydkHL0Nk+4kiJMgHCddebVN3+uRUUwO6m3D9i8TIkkQhv6cvImCsC1JNIlC0iaxp0Vuboi+ap/iZBROyGN662lcTS3y/gd/7pODONLp7wMmW5O7N9mr2t/fJTvekM6wcdgyu3vbXxvU/wQAAP//WOKQL/EJAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:54.096837476 -0800 PST m=+4856.355564036", "maxElapsedTime": "3.176773748s", "maxServiceTime": "3.176663286s", "minElapsedTime": "179.739673ms", "minServiceTime": "179.683344ms", "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": 3103 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_04`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.845163ms", "avgServiceTime": "4.779716ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aMBCG/4p1m1SQompUSJPyLSLphGiBxe4mRFGwwgFug53ZpqIr2W+fnABJu7IPm4RkfH58997l9QugTNUCF0mecQk+gAdL5Harsaek1Soz4HeuPBBygbsgF99QG6Ek+F0PJN8g+DCMviejOIzipJus0FKr0se+XCqoCJPz1GELXPJtZsEDlaPmVmnwX+BDvQGKP7YoUwQPfqVrkS00SvCnr6Fga9dKi5+OyrV4Ehmu0LhUN8LYEmdcr9DWJX3KRr0BeDDW4gn8z8WsOFb4JwkDfKYpl+DBIz4b8GHaalmVGKuFXLU+XrXJfk/u4fIeyn+No067PYPCe53uGm26PiQ7zOoo+L35vb0+5ppnGWbwXz31pbCCZ2OtHjB1H0mj2WY2sag3pqRxlzuwNS/FzS/nNPl6FwxZn03m7VLVO0QYsOD86YSF5w8rS/WG7DwSR7cjFv2dCfuUJZ+6Dpj9MXkh65aLWeF+bxBqNfJNeReMWMnyabgJV72BDw9GOSucKjVDpx6awePUmrG6k2Z0wsLjtvDA4s6ZehxH4yCOyLlnR67j0S2h0U3UY6Su5pFKsVsnLHTLSZ3b1ApKsurlkMsNk9zRiAyiCSVTNkooi/vDL87r+z25uLxwPm+EO87mvwMAAP//6LqWHVwEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:39.689517002 -0800 PST m=+4841.948243681", "maxElapsedTime": "538.943709ms", "maxServiceTime": "538.887335ms", "minElapsedTime": "535.248µs", "minServiceTime": "502.742µ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": 35811 } }, { "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": "e5cb99efd46a56d5", "index_projection": { "primary_key": true }, "keyspace": "CUSTOMER", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((`CUSTOMER`.`C_W_ID`) = $1) and ((`CUSTOMER`.`C_D_ID`) = $2)) and ((`CUSTOMER`.`C_LAST`) = $3))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`CUSTOMER`.`C_ID`)" }, { "expr": "(`CUSTOMER`.`C_FIRST`)" }, { "expr": "(`CUSTOMER`.`C_MIDDLE`)" }, { "expr": "(`CUSTOMER`.`C_LAST`)" }, { "expr": "(`CUSTOMER`.`C_STREET_1`)" }, { "expr": "(`CUSTOMER`.`C_STREET_2`)" }, { "expr": "(`CUSTOMER`.`C_CITY`)" }, { "expr": "(`CUSTOMER`.`C_STATE`)" }, { "expr": "(`CUSTOMER`.`C_ZIP`)" }, { "expr": "(`CUSTOMER`.`C_PHONE`)" }, { "expr": "(`CUSTOMER`.`C_SINCE`)" }, { "expr": "(`CUSTOMER`.`C_CREDIT`)" }, { "expr": "(`CUSTOMER`.`C_CREDIT_LIM`)" }, { "expr": "(`CUSTOMER`.`C_DISCOUNT`)" }, { "expr": "(`CUSTOMER`.`C_BALANCE`)" }, { "expr": "(`CUSTOMER`.`C_YTD_PAYMENT`)" }, { "expr": "(`CUSTOMER`.`C_PAYMENT_CNT`)" }, { "expr": "(`CUSTOMER`.`C_DATA`)" } ] } ] } } ] }, { "#operator": "Order", "sort_terms": [ { "expr": "(`CUSTOMER`.`C_FIRST`)" } ] }, { "#operator": "FinalProject" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "20.377399ms", "avgServiceTime": "20.301295ms", "encoded_plan": "H4sIAAAAAAAA/6RW32+jRhD+V9D0HmIJVYp9ueqQ+kAA65D8AwHpKakssoWJvXd4cZflmjSif3s1uybGSQ6nvZd459tvZ2fmmx3yCCjyqsAi25VMgANgwx0y1Uj0KqFkVdbgnI9t4KLAe3fHf0NZ80qA894GwbYIDkTu9TxYpNkaldfUqtqirC8fZqxWCyIYXr1jOZELvGNNqcCGaoeSqUqC8wg/HQxI8M8GRU4H/8k3vCwkCnB+Pya5jdpUkv9NrJ3k33iJa6zJ1YzXStNTJteoDlc63lWSLudBDDZEkn8D55d21XaX/K8o3kQKqXJJzsQE9mUEB7yr7HMW+plPf2ZuknZ7GS/AAbzI//j4Ee+K9x/YxYfi4ml3J6svmCutwCNlvmXyIfuKD+Ao2WBrw1d86GrdS/h1CeodE7UOGO9ZrowPGyQTa9Twhq834MC7cx1AXjZG+4kNZfWX2WjtA238Pdr4iDb5Hm0C7apd2dDUXKzBgXXN9cF+Oaeo8g38lzyfe4iYZGWJJfyQ9lNeKpRgQ16JghtF4Ozs7Oy2C+f251tPq3w7sn613p2PLCYK6znBfyKMR68zqD0MYzIavcgmFFxxVkamMcAGiXVTqkyh3Hba7oj4zCvdqp29vj0NY7p1gDEPfX8WDFJM5AOEJI2DIM3O30IaD5K8ML0+4cVNh6O9CaPB/ejTcjHsIQkX3jDDiwM/HK6JoWSzcD5I88PEW14thn1dujP3VEjXqZ/tR/hw+vsx753g+W7qEmHVrloasMftupSFfjV1JU/36FMTvnAz5eLQ83TRs/1ESWRbfRBqvhb6i0bv/Kkm4MCXuhJgg2meI1tL8BIhUfoopXpk7zXpYzqHPhD6fUvP/p5tXlUf6dX9CKZu7AO6+Y4A6vhjwLy2V7BxH+t1RB++CaPObG1QeE8f1ygOIjcOrOF/AqxpvJxbSTALvNSiEtjWvjK0MDnTiqpBv12kvfWY1iSUwdxUH7gJI/rRxdAbVATN1IIdViQdWZ1EtN53Ai17KWt/h5rrQ27qmhS69rQ+fwriwDLzXU93y134lhnnepjvbcpIj25rGftBbF1ed5lD+28AAAD//3pQOIh9CQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.036766842 -0800 PST m=+4843.295493417", "maxElapsedTime": "448.544796ms", "maxServiceTime": "448.481649ms", "minElapsedTime": "1.560567ms", "minServiceTime": "1.522706ms", "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": 20325 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_05`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.843491ms", "avgServiceTime": "4.774302ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNatWkvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD//2Lu0BpcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:39.297493537 -0800 PST m=+4841.556220166", "maxElapsedTime": "352.506607ms", "maxServiceTime": "352.455441ms", "minElapsedTime": "530.15µs", "minServiceTime": "496.055µ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": 35496 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_10`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.80155ms", "avgServiceTime": "4.731358ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aMBCG/4p1m1SQIlSqSZPyLSLphGiBxe4mRFGwwgFug53ZpqIr2W+fnABJu7IPm4RkfH58997l9QugTNUCF0mecQk+gAdL5Harsaek1Soz4HevPBBygbsgF99QG6Ek+J88kHyD4MMw+p6M4jCKk+5lskJLrUof+3KpoEJMzlPHLXDJt5kFD1SOmlulwX+BD/UGKP7YokwRPPiVrkW20CjBn76Ggq1dKy1+OirX4klkuELjUt0IY0uccb1CW5f0KRv1BuDBWIsn8D8Xs+JY4Z8kDPCZplyCB4/4bMCHaatlVWKsFnLV+njVJvs9uYfOPZT/GkfddnsGhfc63TXadH1IdpjVUfB783t7fcw1zzLM4L966kthBc/GWj1g6j6SRrPNbGJRb0xJ4y53YGteipt35jT5ehcMWZ9N5u1S1TtEGLDg/OmEhecPK0/1huw8Eke3Ixb9nQn7lCXdSwfM/pi8kHXLxaxwvzcItRr5prwLRqxk+TbchKvewIcHo5wVTpWaoVMPzeBxas1Y3UkzOmHhcVt4YHHnTD2Oo3EQR+TsuyPX8eiW0Ogm6jFSl/NIJdmtExa65STPbWoJJVk1c8jlpknuaEQG0YSSKRsllMX94Rdn9v2eXHQunNEb4a7z+e8AAAD//1HOq4JeBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.366043926 -0800 PST m=+4843.624770139", "maxElapsedTime": "483.501925ms", "maxServiceTime": "483.408708ms", "minElapsedTime": "540.838µs", "minServiceTime": "504.68µ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": 35468 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "367e8ea40f6591dc", "index_projection": { "primary_key": true }, "keyspace": "WAREHOUSE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "WAREHOUSE", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((`WAREHOUSE`.`W_ID`) = $1)" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`WAREHOUSE`.`W_NAME`)" }, { "expr": "(`WAREHOUSE`.`W_STREET_1`)" }, { "expr": "(`WAREHOUSE`.`W_STREET_2`)" }, { "expr": "(`WAREHOUSE`.`W_CITY`)" }, { "expr": "(`WAREHOUSE`.`W_STATE`)" }, { "expr": "(`WAREHOUSE`.`W_ZIP`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "14.056393ms", "avgServiceTime": "13.983592ms", "encoded_plan": "H4sIAAAAAAAA/6RUXU/cOhD9K9G5PIBkXd1duNBa6kMEQUTiI9pNu4JqlbWSIWvIOqntUChKf3vluMsuHy39kPLgGR+fOXPG8T1I5XVBRdZUQoEDDJckbKtpv1ZW15UBHwwZpCroNmzkB9JG1gp8h0GJBYEjCc9PotM0K8lOhKZ53RqC3zWNyB2koEvRVhYMdUNa2FqD3+OfVYAxfWpJ5e7g13wuq0KTAv/4GBS2dl5r+cWhGi1vZEUlGUd1LI3t4anQJdlVST4JR9HR2ftxBIZEyxvwvW7aLav8kYzYeTHOhdrGd2PAMTnK4oNlnMkCHNu7e/SGxM5/l7v/vx0U+cNuo+srym3v473rZCH0XXZNd+BWt9QxXNPd0rv1Bl721DRCmV4l3YrcehIGLVRJfXouyzk4Nga9grxq/Qi3Gar6s9/opt2UoTVSleAojUTHHnd9SDaf47ekPaVIhBZVRRX+yv5DWVnSYMhrVUjvIjY3Zw9qZv/OJll8MNsK3gUbg61nMmIlrRRV4qcABk2mrWxmSS+WPjYO+JTzNDyJZp7vB4hxOoqiNBv8Emr4c9R+nJ6/xhOmrwi6iBMHmD6bplQrB7pp574nkLHVJBb9WRhZqv5VcBPz0sBxZWoFBm/MetwLe5zwvryQG67nLuJkGXYMlm7dr5yMoiQcRcFLD01wODo7CcbRcbSfBl4IC1b11tZDt3bCfS5Me+BFnHiKB9uCyVE0igJ3g/r7g+5bAAAA//9dpiXwJQUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.073882371 -0800 PST m=+4843.332609052", "maxElapsedTime": "709.397547ms", "maxServiceTime": "709.30279ms", "minElapsedTime": "1.059929ms", "minServiceTime": "1.024357ms", "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": 33917 } }, { "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": "e50bf55ed06f0845", "index_projection": { "entry_keys": [ 0, 1, 2, 3 ] }, "keyspace": "ORDERS", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "(((cover ((`ORDERS`.`O_ID`)) = $1) and (cover ((`ORDERS`.`O_D_ID`)) = $2)) and (cover ((`ORDERS`.`O_W_ID`)) = $3))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "cover ((`ORDERS`.`O_C_ID`))" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "7.629343ms", "avgServiceTime": "7.563024ms", "encoded_plan": "H4sIAAAAAAAA/6SUUW/aPhTFv4p1/30gklUBKf9NlvaAINWQuoFCVTRVKHjJJbgzTmY7Xbsq++yTbVpW2vKwSTxgn5/t63Nu/ACo8qrAIqslV8AAKKyR20bjqFJWV9IA6/UpCFXg3bAWV6iNqBSwMwqKbxEYjJOLyVWSfslKtKNJAUEwNc+dWuCaN9IChapGzW2lgT3Af/sBzPF7gypHoPAr3whZaFTArp9Dw8ZuKi1+OqrW4lZILNG4rS6EsR6/5LpEuz+STdNxks6BwkyLW2Dv2mX7eMRf1TBxHsxzrmKgkFe3qA2w6/CPdDqrcN7qdDXNJuNVFD1SB9r4qLo4qo5eqFu0/AmJTleicPpylxgwmKaZq8cf63eHnZaJAhjgoPt1PRhg0f1/3X1/NnhSa13dYG592K5NrL7PvuG9u3KX9mifxs5ON7NL+snu1+M3NVfGe4p3PLfArG6QguaqRD+9EeUGGJz0fAm5bEKjxRRk9SMILd1j/bew/jMsfguLoV22SwqNEaoEBqURfuGfic+45lKihH/qm3MhLWqfmSpEcBQ6nc6bjUM+kJNeRLgqyKvQeI/1oyPcYs/FUfTidhMlrOByFoIGChpNI21mUW8fk6odeKwT3Ud1eF2137Rdtu53gMytRr71a8GIUvkHx3kb9gUGN6ZS0FKweOc+6VmazIZpQg7eGnKeTj+ReXKRjC5JWBumQqFk8TFJE+Jc9ZaS4ecxCfZ573bjxW4cQ/s7AAD//1ycQDcQBQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:42.033130087 -0800 PST m=+4844.291856652", "maxElapsedTime": "653.566116ms", "maxServiceTime": "653.5231ms", "minElapsedTime": "804.805µs", "minServiceTime": "768.01µ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": 31889 } }, { "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": "a2c5c892d7e94cf4", "index_projection": { "primary_key": true }, "keyspace": "ORDER_LINE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$3", "inclusion": 3, "low": "$3" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((`ORDER_LINE`.`OL_W_ID`) = $1) and ((`ORDER_LINE`.`OL_D_ID`) = $2)) and ((`ORDER_LINE`.`OL_O_ID`) = $3))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`ORDER_LINE`.`OL_SUPPLY_W_ID`)" }, { "expr": "(`ORDER_LINE`.`OL_I_ID`)" }, { "expr": "(`ORDER_LINE`.`OL_QUANTITY`)" }, { "expr": "(`ORDER_LINE`.`OL_AMOUNT`)" }, { "expr": "(`ORDER_LINE`.`OL_DELIVERY_D`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "29.253524ms", "avgServiceTime": "29.195218ms", "encoded_plan": "H4sIAAAAAAAA/6SUb2ujThDH34rMrw8SWH6QpEevwj2QajnBRi+alnIEs+jUbGtWb1177RXvtR+7xljbht4fCEFnP8585zvDPgHypEgxjcuccjABCNwglbXAs4JLUeQVmJMpAcZTfLBKdomiYgUH85gAp1sEE/yF7SziMLKiZRhnKH2RovAYxwpapipposAUb2idSyBQlCioLASYT/Bf/wIhfquRJwgEfiYblqcCOZhfh5BVy00h2A9FlYLdsxwzrFQqj1VS4xEVGcq+pNlq9Ny5AwQCwe7BPGlWTVfmr3S4ypIwoXwGO3+UGV7sx64d2+rvKnbt7ixmKZhAp8mH5OPpND3B0+Pk5nh/WoriFhOprX1SbW2peIzv8BFMKWpsCNzhY2fkoJu3Ha5KyistGR9oItssBATlGerwhmUbMOGoFZ/kdTvWGYG8+N4eNKTHpoew6QCbHMIm0KyaFYG6YjwDE7KK6Q+fG3qOMtnAn3X6MkdABc1zzOGfRnvOcokCCCQFT1k7FRiNRqN1L2j9/9r39IjXY+OTcTQZG5SnxhuMvWem44OQv4dm4/GrtlzOJKN50G4JEBBY1bmMJYptN+ZSga8Th8sg8K53QnXig6j7G8yXpTWP3Oj6Pc668Jfz6D3Kdjz30llcx7ru6tVGMN433awa9XuBhFIg3epvoWIZ13eXGvpeA5hwWxUcCAwKDsKq80Gga3MQfGZlF28ISHxQV02wcAJr4RiHr0PjfOFfGKHjOWeRMUxHjJ0I/dAV1y9tE/qxF9+m6t00rj47qna7kHodDWtuG7vt07vXBfxdYAbNrwAAAP//N6jYJP8FAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:40.516178787 -0800 PST m=+4842.774905570", "maxElapsedTime": "664.712362ms", "maxServiceTime": "664.667914ms", "minElapsedTime": "3.709195ms", "minServiceTime": "3.637501ms", "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": 3155 } }, { "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": "d8ee2060bc192b76", "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": "11.952008ms", "avgServiceTime": "11.881578ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2vbPBTGv4p53l7EIEqTvHSbYBdhdlmhi4NTGkYJiWqdOmKqnEly2614n31YSZr+C2HbnXz00znHz6OjB5ApKklyttTCgAMM1yR8belTZbyttAPv9hiUkXQ/WKoLsk5VBvx/BiNuCBxJenZ6keZfZ5I0eRrSXWYlWawAtxRFS0m6FrX2YKiWZIWvLPgD/tt+YEzfazIFgeFXsVBaWjLgl8+hQe0XlVU/W2pp1a3SVJJrU50p5wN+LmxJfluSD9PJLMuTNAfDyKpb8O5RM202Zf6qj9NWj3EhTB8MRXVL1oFfrlZRpzN/rDk/nA+zWTY7TeZxvGHfIJK9xOQVcUNePMXiw7mSLTJdGwaOdepwGuvwTMlWnvdEvaPjo6ui+6F39e4YDN/ox8avp6K97aNbCuOCMHQvCg/ubU0MVpiSQnihygU4DvqhbqHr1c3pM+jqbrXRsC3W3YV1n2G9XVgPzbSZMtROmRIcpVPh4FPbRsIKrUnjn8w/UdqHC15URiof+kCn09njbfQxOujGkTAy2olOtmgv3sNmW7Yfx6/+dUxGJmEkwSC0Eu6FrX/gdjNtXqZPlCuElW9tjb0lcYMwY06VJrwn4KbWmsHTfTucozwdDfI02vF6RCd59qXdTM/T1fqxxWjyOc3TaK1rEDUaDJNorV6QbhPI1oE+mt8BAAD///ZO+BnrBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:42.05193015 -0800 PST m=+4844.310656709", "maxElapsedTime": "789.108867ms", "maxServiceTime": "789.057021ms", "minElapsedTime": "695.86µs", "minServiceTime": "661.488µ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": 31889 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_07`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.854955ms", "avgServiceTime": "4.787417ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aMBCG/4p1m1SQompUk5DyLSLphGiBxe4mRFGwwgFug53ZpqIr2W+fnABJu7IPm4RkfH58997l9QugTNUCF0mecQk+gAdL5Harsaek1Soz4HeuPBBygbsgF99QG6Ek+J89kHyD4MMw+p6M4jCKk26yQkutSh/7cqmgIkzOU4ctcMm3mQUPVI6aW6XBf4EP9QYo/tiiTBE8+JWuRbbQKMGfvoaCrV0rLX46KtfiSWS4QuNS3QhjS5xxvUJbl/QpG/UG4MFYiyfwu8WsOFb4JwkDfKYpl+DBIz4b8GHaalmVGKuFXLU+XrXJfk/u4fIeyn+No067PYPCe53uGm26PiQ7zOoo+L35vb0+5ppnGWbwXz31pbCCZ2OtHjB1H0mj2WY2sag3pqRxlzuwNS/FzS/nNPl6FwxZn03m7VLVO0QYsOD86YSF5w8rS/WG7DwSR7cjFv2dCfuUJZ+6Dpj9MXkh65aLWeF+bxBqNfJNeReMWMnyabgJV72BDw9GOSucKjVDpx6awePUmrG6k2Z0wsLjtvDA4s6ZehxH4yCOyLlnR67j0S2h0U3UY6Su5pFKsVsnLHTLSZ3b1ApKsurlkMsNk9zRiAyiCSVTNkooi/vDL87r+z25uLxwPm+EO87mvwMAAP//dkdcFFwEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.049006143 -0800 PST m=+4843.307732871", "maxElapsedTime": "467.220631ms", "maxServiceTime": "467.147123ms", "minElapsedTime": "526.702µs", "minServiceTime": "493.99µ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": 35493 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((((to_string($6) || \".\") || to_string($6)) || \".\") || to_string($7))]" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`CUSTOMER`.`C_BALANCE`)", "value": "$1" }, { "path": "(`CUSTOMER`.`C_YTD_PAYMENT`)", "value": "$2" }, { "path": "(`CUSTOMER`.`C_PAYMENT_CNT`)", "value": "$3" }, { "path": "(`CUSTOMER`.`C_DATA`)", "value": "$4" } ] }, { "#operator": "SendUpdate", "alias": "CUSTOMER", "keyspace": "CUSTOMER", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "5.46227ms", "avgServiceTime": "5.353046ms", "encoded_plan": "H4sIAAAAAAAA/6RT72/aMBD9V6wbUhPJQoKidbK0D2lIv7S0EQmTEEXBSq5gzTiZ7aB2LfvbJ2ewNpRW+/EJfPfO7+Xe8yOgyssCi6ySXAEDoHCH3NYaw1JZXUoDrNenIFSB90ElvqA2olTABhQUXyMwiIPpKLpOs7oquMXzMKyNLdeo4RfCVDx3sALveC0tUCgr1NyWGtgjfHg+QILfalQ5AoUf+UrIQqMCNmuDgtquSi2+O1SlxUZIXKJxV10JYxt4yvUS7TMlCydJejOKxkAh1mID7NN2vt2T/JOKS3xIcq6Awld8MMBg5nmeZ8vMWC3U0ut89MnTE7mF7i00/1qtt3tnvj+HLW2TxVxzKVHCf0m+QJuvdoJ3lrzYyzGnDnWEslT4qpqg89SgzSzqtWl4K25XwMBb7BkW3UWYnQdXwXUYLXygsOGydlydXnPh8YFpOsx26WoP9d8Z2scxPBw6fWdoGKRBGz0Al5HDT1XFpEk5UOBScNNe4l+sdr49vHwoTM51cayVWI183QgCI5aqeZ/AVC0lBYv3LuvxOIqDcUTeeo3kYnwzIpN4GKQR2asjkyQil9E0IbPX4T3pnrgf8ieNM98nc5JEKfltM/lMOj1KWi66Wt/VXpjkaqeu5jxwhwFsfwYAAP//mukgYpcEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:40.592721867 -0800 PST m=+4842.851448916", "maxElapsedTime": "422.391138ms", "maxServiceTime": "422.344206ms", "minElapsedTime": "524.025µs", "minServiceTime": "470.139µ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": 3748 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_08`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.766777ms", "avgServiceTime": "4.696451ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNatKqvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD//5BMvTpcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:39.88812655 -0800 PST m=+4842.146853215", "maxElapsedTime": "597.840865ms", "maxServiceTime": "597.792866ms", "minElapsedTime": "528.346µs", "minServiceTime": "495.269µ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": 35608 } }, { "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": "5.09539ms", "avgServiceTime": "5.017586ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBD9KuI2qA0m0HYw8H+u44BpsgTbGYw0OMK+JuoUyZPkkqz1PvuQkyxOf22sYNCd7t29d+fTA6AoZIllXnEqwAfw4BapqRWGUhgluQb//MIDJkrcBBX7ikozKcD/5IGgawQfxkk/SvI0C7Jpmi/RhLU2co3qanuw4hJ2aF3RwqaUeEtrbsADWaGiRirwH+DD0YEUf9QoCgQPfhUrxkuFAvzZKSiozUoq9tOiKsXuGcclaltqyLRp4RlVSzRHSj+cptl4FCXgwUSxe/A/N/PmQPJfKq5xmxZUgAffcavBh5njOI6RuTaKiaXz8dwlj4/kBno30Fqd0IX7euzSdefQeKdkAzTFak+1H2ano5dm/LTChCrKOXJ4V9OxYIZRPlHyDgv7IxXqmpvcoFrrFo2bygKdxUHforcI87i/cFtJL4cHcZJmbyJGcb8/jN6EDIO/1LgKhsGXsC0yfzZgJo5tNfPGfk8gqVFI120uaLYU7XOxU/xTGXy409KuxL6l7kXc73pWbNff9Xe4aTwwuLH7O0miSZBE5F9eGxkk4xFJo2EUZsQSemSvwxo7BmtZbnvuVe/SDpMi0zQi19G3lMyeL/NZ78wep6v8SuDSdckcmt8BAAD//2PwYRtrBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:40.483922917 -0800 PST m=+4842.742649545", "maxElapsedTime": "320.131047ms", "maxServiceTime": "320.073663ms", "minElapsedTime": "583.705µs", "minServiceTime": "549.347µ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": 1300 } }, { "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": "16851518625e88b4", "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": "2da5970d7b85a83b", "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.295078235s", "avgServiceTime": "5.29502036s", "encoded_plan": "H4sIAAAAAAAA/6SUUU/bMBSF/4p1xwOgqFqBQheJB9YEKaxrqrRiD1OVmPiSerh2ZjtAh7LfPjlZS1mZxuDR9tH153OP7wOgzBVDlpaCSvABPLhGaiuNAyWtVsKA3z3wgEuG92clv0RtuJLgH3kg6QLBh8k0HnxKh+FlOEwLtLFmqM3HZcCN1Ty30ApNSXOnZnhNK+F2VYmaWqXBf4B3jwuY4PcKZY7gwc98zgXTKMH/+lR0Vtm50vyHU5Wa33KBBRpXasiNbeRTqgu0j1f6QTSZJtFgCh6MNb8F/6T2npHFSRAmkw3RrF6RvAo1ctZNcioPwQNq3E3w21DwIYjSKEi/pFGw2kw5Ax+6x/1et9ftHx/0sN+/Olqfllp9w9w2TXhwb19QvUxvcAm+1RXWHtzgcuX2xpOfb4IpqTQNMt7T3LY1PNBUFthsz3kxBx92ug1ALqq2/YceCHXXHtSzeuZBZbgswIfCcHC+blpwjjafb77+5Yh/lhpTTYVAAW/qyQiNRTZUqrxQXDoywRs45YIp01zQyjiM3d2MZZ0sSKMg2yOnZDdTWSeL03Zj720U28lQG8mIk+aWp7E4YLT34eQ9O7nq92j/8Op1sVhH/PlQyMadVChVrgLx0pxs2vWXxDyR/Gd2FLzpHfWs3irPhUUNHuRKMt76t9X1ne7eFlckueVUjFvfwQONphI2tagXK6dKJzQort1Ps1SvKbYg5GMlB7nNObEa6QKaYWR4IZsZ7Vq9Dz7sQ+2BxXs3xsZJOD5LQvKPsUzOk/gzmYTDcDAl++2KrP4iYSQajcKEXMTRiLQuE0XiEWEdZwo5PSWq0/4CcjdHjesD4gbCrwAAAP//0WV02FcGAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:51.586345217 -0800 PST m=+4853.845071825", "maxElapsedTime": "11.005255043s", "maxServiceTime": "11.005194989s", "minElapsedTime": "1.604223863s", "minServiceTime": "1.604180334s", "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": 3103 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_09`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.902646ms", "avgServiceTime": "4.828542ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNatLUvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD//xoY+z1cBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:40.50889413 -0800 PST m=+4842.767620819", "maxElapsedTime": "704.207475ms", "maxServiceTime": "704.150149ms", "minElapsedTime": "529.782µs", "minServiceTime": "492.268µ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": 34954 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_02`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.733522ms", "avgServiceTime": "4.665911ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAgNNGlS3kUknRAtsNjdhCgKVjjAbbAz21R0JfvskxMgaVf2YpOQjM8/3/3v8vcLoEzVEpdJnnEJPoAHK+R2p7GvpNUqM+B3ex4IucR9kIuvqI1QEvyPHki+RfBhFH1LxnEYxUkvWaOlVqWPA7lSUBEm56nDlrjiu8yCBypHza3S4L/Af/UGKH7foUwRPPiZbkS21CjBn72Ggp3dKC1+OCrX4klkuEbjUt0IY0uccb1GW5f0KRv3h+DBRIsn8D8V8+JU4a8kDPGZplyCB4/4bMCHWatlVWKsFnLd+r/XJocDuYfOPZT/GkfddnsOhfc63TXadHNMdpzVSfB783t7fcI1zzLM4J96GkhhBc8mWj1g6j6SRrPLbGJRb01J4z53YGtRilt0FjT5cheM2IBNF+1S1TtEGLDg8umUhZcPK0v1R+wyEke3Yxb9mQkHlCUfeg6Y/zZ5IeuWi3nhfm8QajXybXkXjFjL8mm4CVe9gQ8PRjkrnCs1Q+cemsHT1JqxupNmdMrC07bwwOLemXoSR5MgjsilZ0eu4/EtodFN1GekruaRSrFbpyx0y1md29QKSrLq5ZjLDZPc0YgMoyklMzZOKIsHo8/O64cDuepcOZ83wl1n818BAAD//9RBAw5cBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:40.516940286 -0800 PST m=+4842.775666909", "maxElapsedTime": "632.658646ms", "maxServiceTime": "632.600384ms", "minElapsedTime": "523.534µs", "minServiceTime": "483.454µ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": 35418 } }, { "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": "16851518625e88b4", "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.09267ms", "avgServiceTime": "15.022833ms", "encoded_plan": "H4sIAAAAAAAA/6SUb2vbOhTGv4p4bl80IC4kaUsQ3BehdrmGLQlOugxGcDTr1NGqyJ4sd+mK99mH7aZ/0m7Q7aV0Hj/nOb+DdQeyaa5IJYWRFgLguCLpK0fnufUuNyVEf8ChraLduNAfyJU6txAnHFZuCQKTcJlM4yCME21TR1uyfkI7P3WKXKTQ6cpCpo1Y0ZWsjAdHXpCTPncQd/jn8YA5fa3IpgSOH+lGG+XIQnx6LhpXfpM7/b1RFU7faEMZlY3VO136Vr6QLiP/2FIE0XwRR+cLcMycvoEY1at63+SPUkQNlHkq7RD3hCAQREkUJMskCvaXiVYQ6J+NTvun/dHZ4JRGo88nD9XC5V8o9S3Vu2aarXS3yTXdQnhXUc1xTbd7fk+GeB1rWUhbtklpJ1PfeXA4aTNqrzc620DgaNAGSE3V7XPIYfJvXaHmj7Lhr2RD1Kt6xVGV2mYQyErdfvgU0Ew6aQwZ/BXmC/LpBm/BcJjjQhtPDhxpbpXuUOP4+Hi991n/uw6SKFj32H/saNBj0ip2WF4+CIa93osW5ya39OJ2Tu1OyCee3LbbSyF9Q/bAfRJ+XCTTtgU4bqSpmoGO+g3lF6ZWXRZK+gabNFqWz4m8gdOqPjQPdJlKp14rzb0juW0DodSZbZ8JCFsZw+Fp1/xsszicjeOQ/f5RYBfx9D27nAXjRcj2Gdk8XLAnIBrSfbb8P4xDFtyfB2w8CVi3i3YTqH8GAAD//3/fC+zDBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.325180636 -0800 PST m=+4843.583907227", "maxElapsedTime": "539.285549ms", "maxServiceTime": "539.253221ms", "minElapsedTime": "1.752578ms", "minServiceTime": "1.717579ms", "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": 35366 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 9, "Target": "default:ORDER_LINE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "ValueScan", "values": "[[((((((to_string($3) || \".\") || to_string($2)) || \".\") || to_string($1)) || \".\") || to_string($4)), {\"OL_AMOUNT\": $9, \"OL_DELIVERY_D\": $7, \"OL_DIST_INFO\": $10, \"OL_D_ID\": $2, \"OL_I_ID\": $5, \"OL_NUMBER\": $4, \"OL_O_ID\": $1, \"OL_QUANTITY\": $8, \"OL_SUPPLY_W_ID\": $6, \"OL_W_ID\": $3}]]" }, { "#operator": "Parallel", "maxParallelism": 1, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "SendInsert", "alias": "ORDER_LINE", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Discard" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.900181ms", "avgServiceTime": "4.813784ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv0p0D1JBsqqG8myr37GRTtHShCWBChUUWcmVWjMOc0zVrWSffXJIAqnavdgQEvHv/uAT97tnQJnmGWbJVjAJFIDAPTK9U/gpl1rlogBqDwlwmeHTeMvnqAqeS6AjApJtECj4zm0ShBMnTFKFTGOgMlQelwiHSLFlqclleM92QgOBfIuK6VwBfYb/jgeI8PsOZWq++Ct94CJTKIHedUPjnX7IFf9pUlvFH7nANRbmpzxe6CoeM7VGfbySHtrzXN8BAlPFH4Felauyueav+pgzscMoZRIIPJrnAijc3fWrl86TQisu1/3e5cDa760lnC+hejopDQdv1+w/1EaDAbGelxB4yfgmmPnxEqjVuyJWhSaO586dcJFMKvy+wW4UJ65/HVTUvmhw4h5ywxq4Dfi/Bv7s5qMTVmhUo6DJ2DX4Ohv7sRsvKvihhtFsOvUWyW0TflfzFlyWqxWUpPu/TpliQqAAAhv21Jx4sQFq/9PAIpSZKwtURkEmODMD65jxDX80snb4axa/bHvCi5SpDMpVad4vqpFWyDZQOVfwtaw2DKjcCUFA45ORdRo603HoWG/uk3UdBjeW60dOGFuuHwfWscv+F2dBrPnYmzmDw0fUj4MkikPX/2wk3O+ts/MzI9IJHr6O7dfxyFjXEaCdf21RK1E94t7lS4dahWrNWsu6srSudGRuXT7RrbWt3YTjIpwY37MvygGUvwMAAP//roDuK/AEAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.773631979 -0800 PST m=+4844.032358944", "maxElapsedTime": "702.689623ms", "maxServiceTime": "702.624051ms", "minElapsedTime": "520.682µs", "minServiceTime": "478.725µ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": 352910 } }, { "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": "d8ee2060bc192b76", "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": "13.847314ms", "avgServiceTime": "13.776821ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2/aMBTFv4p11wciuRWhU7tZ2gMqqYZEAYWqaOpQcJPb4M44me30z6rss082AfpXTNtbcvPzvfY5J34EVGmRYZaUkitgABSukdtK40mhrC6kARZ2KAiV4X23FBeojSgUsI8UFF8iMOhFg/5FFH9LcrRDvBvpDDWsvpqSpw7J8JpX0gKFokTNbaGBPcKH7QtM8GeFKkWg8DtdCJlpVMAun0Pdyi4KLX45qtTiVkjM0bhWA2Gsx8+5ztFuR7JhNE1GcS+KgcJYi1tgx/WsXk/5p238FdR3gk1Srg6BQlrcojbALldPpNWab/Y1P5gPR8ko6ffmQbBm3yB6O4npK2KJlj/FgoO5yBwyaxwFBk1rvxqaciIyJ+EnxE77qH2Vhp87V8dHm6+lLm4wtT4HLkFWPyQ/8MEdsE1D2nH6uvfG/acWSLEUzp7w3YSYkivj5cR7nlpgVldIQXOVoy8LlcpqFcI2BVncAYPWfhhATR9hIfIFMNgL/WY34OEa3AufYZ33sA7Us3pGoTJC5cAgN8IvfGrxmGsuJUr4rzSdCmn9D5MWKhMrUaHVau3IAflC9sKAcJWRd9HpFu0EDeuUIt+rdvswJTvCGASvjtxXwgoux6sAAAWNppI2saiXa9NKB+7KufsHX+qgto3rWf2aGPjs0PWI0FMvmInVyJe+PRiRK3+VOV+a2cDgxhQKagoW710Sx3E07sYReesaI6fx6IxMokF0ck6aDqva5lhk+jWKI9IY410h3WGPNPJ77dcFv9xrj2Q/JIP+Wf+chFD/CQAA//98b1EMhgUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:42.013079694 -0800 PST m=+4844.271806396", "maxElapsedTime": "571.519817ms", "maxServiceTime": "571.482357ms", "minElapsedTime": "976.052µs", "minServiceTime": "942.931µ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": 31910 } }, { "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": "16851518625e88b4", "index_projection": { "primary_key": true }, "keyspace": "DISTRICT", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "DISTRICT", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "(((`DISTRICT`.`D_W_ID`) = $1) and ((`DISTRICT`.`D_ID`) = $2))" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`DISTRICT`.`D_NAME`)" }, { "expr": "(`DISTRICT`.`D_STREET_1`)" }, { "expr": "(`DISTRICT`.`D_STREET_2`)" }, { "expr": "(`DISTRICT`.`D_CITY`)" }, { "expr": "(`DISTRICT`.`D_STATE`)" }, { "expr": "(`DISTRICT`.`D_ZIP`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "11.613683ms", "avgServiceTime": "11.544821ms", "encoded_plan": "H4sIAAAAAAAA/6RUbW+bPBT9K+g+/dBI1iNBXxZZ2gcUqIbUdihBq9opIh7cEreOYbbp2lXst0/GZUnTrHuT+MC993B87jnIj4CyqEss80YwCRSAwDUy0yqc1NKoWmigfkCAyxLvw4Z/QKV5LYEeEpBshUAhDS/P4vMsr9BEXBvFCwNuqBtWWESJ16wVtls3qJipFdBH+G9dwAw/tygLBALfiiUXpUIJ9ONzUNiaZa34V4tqFL/jAivUluqUa9PDM6YqNOsjaZTMsmkyyYBAqvgd0DfdvBsO+SsViXViVjB5AE+2AIUoyZMov8iTaGjmvAQK/vH4yD/yx8fBEY7Hnw5/TBtV32Bheisf7TYrph7yW3wAalSLHYFbfBj821hit626YVL3SvGeFcZxEFBMVti3l7xaAoW9oBdQiNaFeEBA1F/coCNrmP8zmA/dvJsTaDWXFVCoNO8/3DToBE2xhD9ZYJshZYoJgQL+KagTLgwqIFDUsuTOatjf318Mahb/L1xmi5H31tvzRx6TpbcNGMbBaPRCaCK54UykLkwgoFC3wuQG1WrIo7HALc7z8CxeOLrdgFk2jeMs938HFLwKmiTZ5S9Ywux1MVdJaufzF0Fzud69m3f22YLMjEK26r8FzSvZ3yw2TScMKNzoWgIB58lm3et63nCe7OgFm72rJB3KjoDBe3sfpNM4Daext+Oy8k6m78+8WXwaTzLP6SDe+riN98C+W92uF2Y98CpJHcVgmnfxLp7Gnvu3+j/LC88jL3qqAui+BwAA//+4wzeAdwUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.129601937 -0800 PST m=+4843.388338484", "maxElapsedTime": "504.778703ms", "maxServiceTime": "504.736591ms", "minElapsedTime": "1.230453ms", "minServiceTime": "1.197779ms", "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": 33917 } }, { "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": "7085e5cf4f372ef3", "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": "b9ae8941bc36ee2", "keyspace": "ORDERS", "namespace": "default", "nested_loop": true, "spans": [ { "exact": true, "range": [ { "high": "cover ((`c`.`C_ID`))", "inclusion": 3, "low": "cover ((`c`.`C_ID`))" } ] } ], "using": "gsi" } ] } }, { "#operator": "Filter", "condition": "(cover ((`c`.`C_D_ID`)) = $1)" }, { "#operator": "InitialGroup", "aggregates": [ "count(distinct cover ((`c`.`C_ID`)))" ], "group_keys": [] } ] } }, { "#operator": "IntermediateGroup", "aggregates": [ "count(distinct cover ((`c`.`C_ID`)))" ], "group_keys": [] }, { "#operator": "FinalGroup", "aggregates": [ "count(distinct cover ((`c`.`C_ID`)))" ], "group_keys": [] }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "count(distinct cover ((`c`.`C_ID`)))" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "18.869591156s", "avgServiceTime": "18.869532844s", "encoded_plan": "H4sIAAAAAAAA/7SVUW/bNhDHvwpxy4MNCEYcp0tLIA+ZrG7qXMuQnfahMGSGOivcaFIjqSxZ4X32gZTtJLOKFWv6ZvP+Rx3v/zvyM6DiusSyqCVTQAEiWCNzjcFYK2e0tECHZxEIVeL9VS0+oLFCK6DnESi2QaAwX2Txr8Uk+ZBMigpd3FinN2gyU6KxPz2MhXVGcAdtgq0Z91klrlkj/aqu0TCnDdDP8MPjH5jjHw0qjhDB3/xWyNKgAvrpueiqcbfaiL+8qjbiTkis0PqtJsK6IF8wU6F7/CSNr+eL7H2SQwQzI+6AXmyjDlmWj5N8/kS03O4r+V+lpr6Fc87UCCJgFihwiIDrOzQW6Kf2F+n1Vnw1WMVFOl71+3vB4/L4S4GPR4ENOuaj/cFKlD603PkIFOLrIh2HzUIi7CKFKIHCxenrV/iKr8/Xo4szXI8O0dro35C7AIBHx5mH4nd88OWfRsNlsGDD2kWgzjS4jcALdqY/6Xw3C7ZmyobO4T3jrt0jAsNUhWFZKC6blsDTCKT+EyioRkrwFt6K6hYonAxDwQfhaC88GcJ2uV1G0FihKqBQWRESn9o0Y4ZJiRK+yewpWoflROv6nRbKGy5F8Fx74lXBJWusP3uvy3ZySQ7LejVYZcUu0P+2qo4R1N0IPvvoEVK6E6ksDwnPUbp5w/D1m/PhDR/9iHgGz3A4TFg3DCr0sJBa13sQ/pOPHQJfmKUuKDqlHZgst/8m5a2QDk3ojipFOxVHfo4Pjp4M+0ewpUo4weTPRje1t6SqDFbM4c6NRrleKawTijvSVWgwoPLZ+zlcdhSaKodmg6VgDl/0U0cNUS98lu8ym7umz9rLDCIwaBvpCt+kPVy1CWh8RdHb7jbsd/d2HDsydwbZJuSCFZUKL64/zMkwXGibGzSwjcDhvX+SZnkyu8oT8pVPLXmbZ+/JPJkk8YLE2fV00Run80U6jRc9PvCV9/uthuxvZMJJOp0mOXmXpVPSDibRJJuSNoFcXhI9aK8E8vGXJE9CYBxCxF+s/wQAAP//J82bPksIAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:40.210176629 -0800 PST m=+4842.468907320", "maxElapsedTime": "22.942462349s", "maxServiceTime": "22.942421622s", "minElapsedTime": "11.373923516s", "minServiceTime": "11.373890233s", "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": 3103 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 9, "Target": "default:HISTORY" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "ValueScan", "values": "[[((((to_string($1) || \".\") || to_string($2)) || \".\") || to_string($3)), {\"H_AMOUNT\": $7, \"H_C_D_ID\": $2, \"H_C_ID\": $1, \"H_C_W_ID\": $3, \"H_DATA\": $8, \"H_DATE\": $6, \"H_D_ID\": $4, \"H_W_ID\": $5}]]" }, { "#operator": "Parallel", "maxParallelism": 1, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "SendInsert", "alias": "HISTORY", "keyspace": "HISTORY", "namespace": "default" }, { "#operator": "Discard" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.900426ms", "avgServiceTime": "4.819088ms", "encoded_plan": "H4sIAAAAAAAA/6SScWvbMBDFv4q4BWqDKCRtt07/mcZbzdok2G5HSYIR9jUVU+RMkkO6xPvsw44dNyX7ZwOD9d6drZPebwuo0jzDLFlJroABUHhGbguNN7myOpcGWH9AQagMN95KPKI2IlfALikovkRgMPGe7v1RnAhlUNtbYWyuX2FfNiueVj0ZPvNCWqCQr1Bzm2tgW/jQCYjwZ4EqRaDwO30RMtOogE2Pm7zCvuRa/Kq6VlqshcQFmupXd8LYuj3meoG225LdBlE8Dp+AwkSLNbDP5bxs9/inIR65LDBKuQIK62ptgMF06jiOY/PEWC3Uwun1XbLbkRmcz6BevSkN3L/XLlyXku0MbhPvfvwwimfASO8TJZVzkwyTYFg7g9ZpdL/V31vnYu8Mvdir9fVB+7X+2Oi2/3KvD99flfM5lPT46BOuuZQogcKSb1olzBJY/7/uNEKVBTU/QIFLwas77ZL7ga8tSZ15iq/3Aw+FSbnOoJyX1fOuGlmNfAk1EEYsVM09MFVIScHipsJoEvoTL/TJScrJl3B8T4JR5IcxCUbxmDTjOd/8J0oevbsH392/IuLE4ySKw2D0taJjtyNn52dV+m/swWn7omWiybuLu4mv46HJ7xB/I4/T7V0dwdCycCCuBa6Bp3ddulD+CQAA//+NS/dKKwQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.189828394 -0800 PST m=+4843.448554793", "maxElapsedTime": "445.885072ms", "maxServiceTime": "445.809803ms", "minElapsedTime": "518.415µs", "minServiceTime": "476.689µ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": 33917 } }, { "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.101387ms", "avgServiceTime": "5.032028ms", "encoded_plan": "H4sIAAAAAAAA/6STYWvbPBDHv4q454HaIAJtBwO9C44KoWkT7GRjpMERzjVRp0ieJJd0rffZh5waJ226FxsYZPl+vv//TqdnQF2YFa7yUgkNDIDCPQpfWUyM9tYoB+z8goLUK9z1S/kFrZNGA/tEQYstAoNb/jUfpwOe5mv0SeW82aKFfdiVogjMCu9FpTxQMCVa4Y0F9gz/dRvI8EeFukCg8KvYSLWyqIHNj6F+5TfGyp+BKq18lArX6EKqkXS+wafCrtF3kiyZZdPxDU+BwsTKR2Cf60XdivyVi2t8ygqhgcJ3fHLAYB5FUeRN7ryVeh39fx6TlxdyB707aN4OQhfxx7HLOF5ATY/FrtAXm1ep12YeVHSqx28zTIQVSqGCfyp6qKWXQk2secAiHKRFVymfe7Rb19C4KwMYLVt/y94yyQfDLBnPbqfLuDF2Ghr1sz8DScoHwwZZvGuQ1J2telGH5w2SeYti2/wLTq51M9+hC21iYPDgTDjRzvDht+Cv3dcUPO7ChE1SPumnnJy8AOQqHd+QjI94MiVdVkr22cK6196DbbVklnFyzb9lZP5+os56Z2E5nqcPApdxTBZQ/w4AAP//C8LUdOEDAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.28764138 -0800 PST m=+4843.546368211", "maxElapsedTime": "535.79104ms", "maxServiceTime": "535.749021ms", "minElapsedTime": "520.686µs", "minServiceTime": "483.938µ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": 35366 } }, { "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": "e50bf55ed06f0845", "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": "14.904957ms", "avgServiceTime": "14.84041ms", "encoded_plan": "H4sIAAAAAAAA/6RU72vbOhT9V8R5/ZCAeLT58SiC9yHULgt0S3DahjGCo9k3jlZF9iS5a1e8v33YTtOmTaFsXwxX5/jce89BegCZJE8pjQstDQTAsSLpS0tnufE21w7ipMehTEp3o0Jdk3UqNxADDiM3BIEgvBhfh9HnuCxS6WliU7IOLewKmdSclFay1B4ceUFW+txCPOCfpwIz+l6SSQgcv5K10qklA/FlnzQq/Tq36mfNKqy6VZoycrXUhXK+oV9Km5F/aikmURBGM3BMrbqFOK0W1WOLP5phXDsxS6TpY2sLBCZRPInHQRzUn3k8Dh6xWKUQoOHx19VwSOnxf6vj08FwhxY2/0aJbxx9qFfaSHsf39A9hLclVRw3dP9o4m6Tw866QhrXjEt3MvGtAoeVJqPmeK2yNQSOek37RJdtkn0Onf9ogYo/0fpv0fp7tMFbtAGqRbXgKJ0yGQQyp5ofn5s5lVZqTRp/Fck5+WSN93v1copzpT1ZcCS5SVWbBjqdTmfZyiz/XdbpLrvsf3bU6zJpUrYPBju43z2Ez3f4oNt91f9M54Zenc6oSZV87Mlu2mQL6WvT97TPRlE0DqOmAzhupS7rZY9Oav9faZr0qrmm4JBaSffcq3f7t6heCgfKJdKmh6CZtyQ3zTBwKjPN6wJhSq05PN3Vl3UahdNRFLKDbwk7jyYf2dU0GF2GrB2MzcJL9nz12toTNv8QRiGbbOseG30KWBtOE822nm/rAarfAQAA//8Cv7AtAAUAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:42.060172839 -0800 PST m=+4844.318899469", "maxElapsedTime": "516.941615ms", "maxServiceTime": "516.901789ms", "minElapsedTime": "1.508788ms", "minServiceTime": "1.473736ms", "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": 31889 } }, { "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": "a2c5c892d7e94cf4", "index_projection": { "primary_key": true }, "keyspace": "ORDER_LINE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" }, { "high": "$2", "inclusion": 3, "low": "$2" }, { "high": "$3", "inclusion": 3, "low": "$3" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "ORDER_LINE", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((((`ORDER_LINE`.`OL_O_ID`) = $1) and ((`ORDER_LINE`.`OL_D_ID`) = $2)) and ((`ORDER_LINE`.`OL_W_ID`) = $3))" }, { "#operator": "InitialGroup", "aggregates": [ "sum((`ORDER_LINE`.`OL_AMOUNT`))" ], "group_keys": [] } ] } }, { "#operator": "IntermediateGroup", "aggregates": [ "sum((`ORDER_LINE`.`OL_AMOUNT`))" ], "group_keys": [] }, { "#operator": "FinalGroup", "aggregates": [ "sum((`ORDER_LINE`.`OL_AMOUNT`))" ], "group_keys": [] }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "as": "SUM_OL_AMOUNT", "expr": "sum((`ORDER_LINE`.`OL_AMOUNT`))" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "29.442929ms", "avgServiceTime": "29.374232ms", "encoded_plan": "H4sIAAAAAAAA/7RUXWvbSBT9K+JsHiwYFmJnyWZgH0ysbA12bOwkpgQjT6UbeRpppM6MUqdB/e1lJH/UiUNpm74YfO+5H+ecq3kCqSiPKQ6LVChwgOGOhC01nefK6jw14MdtBqliWnULeUPayFyBnzAokRE4esGgfxNM3oemzEaDbpaXyqLJmkJEDhLTnShTF80L0sLmGvwJf+3+YEqfSlIRgeFrtJRprEmB3+6DuqVd5lp+cahCyweZUkLGtRpIY2v4ldAJ2d1IPpr0gkk46F8GYBhr+QB+Ws2rzZhf2qPvxJhGQnWwVgYco0E4Cvu9sOd+ZmG/t8mFMgaHaEf/RP+eteNTOjuJ7k622ULnHymytahPjlYm9GN4T4/gVpdUMdzT40bIPTaHFTaFUKZemVYisk0XBi1UQnV4KZMlOI6O6xWitGwM7TCk+ecmUbEdrP0arL0H67wG66CaV3OG0kiVgCMxsi78XtALstESP8f0eY+x0CJNKcVvWXshU0saDFGuYtm4glar1VrsFlr8vVibvfC9/7yjY98TKvYOYHpbTNt/FTTbgjq+/4JWX0krRfq/zssCDCJJNCXCurO/hSmzAw27w9H15dXC9zFnSFyhOydXMK/m1csBlnRGsRSW3mrKc3ulejsGf8T2tcrj5lsEgyZTpjZ00jQfkzCu1/Uw3K4HBloVrvpHJKrDimymOVNe+jK1mkRW18LIRNWPsiO3vwSHKrMPpFExWFq5p288CcbdSeAdepi9i8lo6E2DQXB+5U2vh61tJ9/rTr293g12R8ubvQsmgbe+/fryve5lz1sfen3mm8BsHeig+hYAAP//QX8bNWQGAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:42.037836921 -0800 PST m=+4844.296563550", "maxElapsedTime": "389.455861ms", "maxServiceTime": "389.42108ms", "minElapsedTime": "2.100143ms", "minServiceTime": "2.067987ms", "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": 31889 } }, { "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": "a2c5c892d7e94cf4", "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": "324.890998ms", "avgServiceTime": "324.819641ms", "encoded_plan": "H4sIAAAAAAAA/7RVbY/aRhD+K6spUoxkofDSprF0HxD4UifUpthJFN0hs7XnzPbMrru7Tu96cX97tbY5A8epapvwAfDMM2/PvPgBkCcixTQucsrBAbDhBqkuJc4E11LkCpzhyAbGU7ybFuwDSsUEB2diA6c7BAfCKJi9ixfuB3cRZ6hDLZLbmSi5hgaiCpoYXIo3tMyNVBQoqRYSnAf4rnuAEH8vkScINvyVbFmeSuTgXB2DpqXeCsn+NKhCss8sxwyVcbVgStfwiMoMdRfSCVZzdxUvPN8FG5aSfQbnVWWfAda1HGDW1T6V/5SrZ1gLE8rHYANV4ICAlktwIFjEQezN47n5+hh7870uZik4QEfJ98mPr0fpK3w9SW4mj9pCit8w0XUbHgwHOyrv41u8B0fLEisbbvF+z/pR6efboQrKVZ073tFEN15skJRnWIu3LNuCA71xnUKSl80IDG3IxR9GMQHD5h42OoaNH2GjI9jwOdgQqnW1tqFUjGfgQKZYbXjI7CXqZHtI6r8p+dTZW8H43pc69rUfiGcGmRvajZllaRErLRnPLGsjNoNNsKh7uun3yZcv5BoG11D/O4PzGlz/SWJLKmmeYw7/awovWa5Rgg2J4Clr5gas+nOcKbkgvWGfUJ6STjV/VI36p7qg0V2XL1+OE9Ib7wG9SSu7ICfYzoXaDDZh/Mv7qR950acDLz+cIcLjTDOav5GiLEynskxiRrXZ+ytIzLGxUqY044kmp7TC2obMGLa9ulpX6+ppAI1yhymjGr9WlNORZfzrVfBNBqVledncF7BBoipzHRtqmgNRr8jMj+I2ObAB7wpj+08lVOf52McyLXnalVBLpLvaFhTLeP1iMqUdpuAAL3e/ooTKBo135pwvV+5yunLJs68mcrkKfiYkdBfuLCKz4L0fWXMvjDx/Flli0Lru98k0JAexWrPuwBBBPN93V+Rt4PlNOKJI4JN37qeQWFEQh9HK8980Ps2W1TfgxeCF+SEn+jbmx5/clUseLeqtJFN/3ojmrWjUicxqdUt4To4XpDepFWrQLV23clD9HQAA//+24+QCCggAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:39.912055612 -0800 PST m=+4842.170782176", "maxElapsedTime": "779.614183ms", "maxServiceTime": "779.569572ms", "minElapsedTime": "86.269045ms", "minServiceTime": "86.161077ms", "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": 3103 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:CUSTOMER" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((((to_string($1) || \".\") || to_string($2)) || \".\") || to_string($3))]" }, { "#operator": "Fetch", "keyspace": "CUSTOMER", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`CUSTOMER`.`C_ID`)" }, { "expr": "(`CUSTOMER`.`C_FIRST`)" }, { "expr": "(`CUSTOMER`.`C_MIDDLE`)" }, { "expr": "(`CUSTOMER`.`C_LAST`)" }, { "expr": "(`CUSTOMER`.`C_STREET_1`)" }, { "expr": "(`CUSTOMER`.`C_STREET_2`)" }, { "expr": "(`CUSTOMER`.`C_CITY`)" }, { "expr": "(`CUSTOMER`.`C_STATE`)" }, { "expr": "(`CUSTOMER`.`C_ZIP`)" }, { "expr": "(`CUSTOMER`.`C_PHONE`)" }, { "expr": "(`CUSTOMER`.`C_SINCE`)" }, { "expr": "(`CUSTOMER`.`C_CREDIT`)" }, { "expr": "(`CUSTOMER`.`C_CREDIT_LIM`)" }, { "expr": "(`CUSTOMER`.`C_DISCOUNT`)" }, { "expr": "(`CUSTOMER`.`C_BALANCE`)" }, { "expr": "(`CUSTOMER`.`C_YTD_PAYMENT`)" }, { "expr": "(`CUSTOMER`.`C_PAYMENT_CNT`)" }, { "expr": "(`CUSTOMER`.`C_DATA`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "5.314594ms", "avgServiceTime": "5.246009ms", "encoded_plan": "H4sIAAAAAAAA/6RVfWujThD+KjK/HzQBKTQ9OPA/q5ZbmhdRe5C2wYiZptszmls3pb3W++zHrHpZ+2KOOxCcefZxduaZ2fUZME+LFa7ibZbkYAGYcIuJ3Al0ilyKIivBOhmZwPMVPtpb/hVFyYscrE8m5MkGwQLfnk+8aRSvUTq7UhYbFGdPrcVWUBPLbZISe4W3yS6TYEKxRZHIQoD1DP/tHQjx+w7zFMGEn+kdz1YCc7CuuyR7J+8KwX8Qayv4A89wjSWFGvNSKnqUiDXK/ZaWcxlGs4kXgAm+4A9gfa4WVbvJX2VxgU9hmuRgwjd8KsGC68FgMJBFXErB8/Xg/5Oh8fJi3MDxDShLWxoNP147HQ4XUJndzc5RpnfNVo2YWkXvafw6gp+IJMswg38qmuVc8iTzRXGPKTVSYLnLZCxRbErFxsctEQfLNr/l8dKJmbscqpTeXz5nQRj1MibMdcdeL2VsH4gRRoHnRfHJn5BGvSSHRfMDUeyoP9sr5veu+19m0/4IIZs6/Qwn8FzWr0lNicds0ktzWejMLqf9sc7ssX0opXnkxs2l0V9+c7E4B3iuHdlEWLw5MTzfz2m1qOh5RQmlwGSjvoWSr3N19dGx+F0KWHBfFnTG6553fKXcW4S01FHKsOM3UuqYmn8dYK7u0WTrfn0YdESTqwPTEOmAmpkOQIPaBepD8g420jGtkTp8xfzWrUyQ+EiXsB94vh14xoG/hXEezCZG6I09JzJIA9NopCGjLposkoPebaqaPSKbOlVjdqQ+uGI+vZQaaoFUUEzVsb1FvSOv7RHZzSiQqdWs4u1FVx/ZkV2X0E6ocRl6xoU3D43rtz+Go+MjenV/Cx8snA6HxgKqXwEAAP//3c+I5bIHAAA=", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:40.903866544 -0800 PST m=+4843.162593134", "maxElapsedTime": "299.232872ms", "maxServiceTime": "299.183869ms", "minElapsedTime": "656.603µs", "minServiceTime": "604.501µ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": 13592 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:STOCK" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "KeyScan", "keys": "[((to_string($2) || \".\") || to_string($1))]" }, { "#operator": "Fetch", "keyspace": "STOCK", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "InitialProject", "result_terms": [ { "expr": "(`STOCK`.`S_QUANTITY`)" }, { "expr": "(`STOCK`.`S_DATA`)" }, { "expr": "(`STOCK`.`S_YTD`)" }, { "expr": "(`STOCK`.`S_ORDER_CNT`)" }, { "expr": "(`STOCK`.`S_REMOTE_CNT`)" }, { "expr": "(`STOCK`.`S_DIST_06`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "4.905517ms", "avgServiceTime": "4.829886ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/aPBDHv4p1zyMVpAiNauqkvItIOiFaYLG7CVEUrHCA22BntqnoSvbZJydA0q7sxSYhGZ9/vvvf5e8XQJmqBS6SPOMSfAAPlsjtVmNPSatVZsDvXnog5AJ3QS6+ojZCSfA/eiD5BsGHYfQtGcVhFCdXyQottSp97MulgoowOU8dtsAl32YWPFA5am6VBv8F/qs3QPH7FmWK4MHPdC2yhUYJ/vQ1FGztWmnxw1G5Fk8iwxUal+pGGFvijOsV2rqkT9moNwAPxlo8gf+pmBXHCn8lYYDPNOUSPHjEZwM+TFstqxJjtZCr1v+XbbLfk3vo3EP5r3HUbbdnUHiv012jTdeHZIdZHQW/N7+318dc8yzDDP6pp74UVvBsrNUDpu4jaTTbzCYW9caUNO5yB7bmpbh5Z06TL3fBkPXZZN4uVb1DhAELzp9OWHj+sLJUb8jOI3F0O2LRn5mwT1ny4coBs98mL2TdcjEr3O8NQq1GvinvghErWT4NN+GqN/DhwShnhVOlZujUQzN4nFozVnfSjE5YeNwWHljcOVOP42gcxBE59+zIdTy6JTS6iXqM1NU8Uil264SFbjmpc5taQUlWvRxyuWGSOxqRQTShZMpGCWVxf/jZeX2/JxedC+fzRrjrbP4rAAD///wTGhNcBAAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.767835382 -0800 PST m=+4844.026561939", "maxElapsedTime": "590.374816ms", "maxServiceTime": "590.334114ms", "minElapsedTime": "545.073µs", "minServiceTime": "504.019µ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": 35301 } }, { "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": "90d482968443b631", "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.566791ms", "avgServiceTime": "17.485703ms", "encoded_plan": "H4sIAAAAAAAA/6RUXW/bOBD8K8ReHmyAOJwtI5cIuAefpaACnNiQ3AZBYcistJGZ0JRKUmnSQP3tBSl/JnERtC8G6BnO7s4O9QwoszLHPK0Ek+ADULhFZmqFo1IaVQoNfq9PgcscH4cV/4RK81KCP6Ag2QrBh0kchHGazIazj0laoBkzbSYqRwUtRVcss7wcb1ktDFAoK1TMlAr8Z/hrd4AEv9YoMwQKP7IlF7lCCf7nQ9KwNstS8e+WVSn+wAUWqK3UmGvj6DOmCjS7kr5rMQEKU8UfwP+3mTebEr/Vw7tIkbUsyZj0YO2fMyu9TqMgDezPKI2CDZbyHHw4/ycfnPXPT88GA+/LqdfbopUq7zAzzvpnO/eKqaf0Hp/AN6rGhsI9Pm2c3o77tv26YlK7dvGRZaZVoKCYLND9veTFEnw4actnom5X7lEQ5bcWaOiO1j9G6x/QvGM0D5p5M6dQay4L8KHQ3F3cN/MCTbaE90/58v6UKSYECvijvV9wYVyus1LmvN0GdDqdzqJtZvH3YuL2u+iS/8hJr0uYzMkhHGzhfvctfLTFvW731RyR5IYzMW3jABQU6lqY1KBabXZaWeKBplV0Um+Bo2EcR2H8a1J4NYtvUseYN/PGPqDDxjYvXvAVt0/PZkeXar+zHHW2CdvxLl8pj53i9krvdTa43Dlim3uBJ0YhWzll0LyQ7vNm978/O/hwp0sJFLbD7v+1IzQUDD7aEadxOB3GITn6ASQX8eSSJOE4HM2I1aBkv6Q9rUu1zNYLcv0htKouSC5GZHgVkDY5Ljfr82h99tqL5P8bV4QEYTIi4+gympEeND8DAAD//3gD6kvjBQAA", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:40.491765853 -0800 PST m=+4842.750492340", "maxElapsedTime": "476.650724ms", "maxServiceTime": "476.598171ms", "minElapsedTime": "1.935422ms", "minServiceTime": "1.898436ms", "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": 3156 } }, { "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": "16851518625e88b4", "index_projection": { "primary_key": true }, "keyspace": "DISTRICT", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$3", "inclusion": 3, "low": "$3" }, { "high": "$2", "inclusion": 3, "low": "$2" } ] } ], "using": "gsi" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Fetch", "keyspace": "DISTRICT", "namespace": "default" }, { "#operator": "Filter", "condition": "(((`DISTRICT`.`D_W_ID`) = $2) and ((`DISTRICT`.`D_ID`) = $3))" }, { "#operator": "Clone" }, { "#operator": "Set", "set_terms": [ { "path": "(`DISTRICT`.`D_YTD`)", "value": "((`DISTRICT`.`D_YTD`) + $1)" } ] }, { "#operator": "SendUpdate", "alias": "DISTRICT", "keyspace": "DISTRICT", "namespace": "default" } ] } }, { "#operator": "Discard" } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "15.654127ms", "avgServiceTime": "15.579179ms", "encoded_plan": "H4sIAAAAAAAA/6SUb0/bPBTFv4p1Hl5QPdaklj+qLPGiI0GrNFjVhiE0VamXXFIP18lsh8FQ9tmnOHRA6SaxvYrie3zv8e/IvgeZrMwpTystDQTAcUXS15aOS+NtqR1Ef8ChTE63o0p9JOtUaSD2OYxcEQQmo8vT+CxJ6yqXniLlvFWZfyu1NBmhk7lKZq02pytZaw+OsiIrfWkh7vHf4w9m9LWmbuOPbKl0bslAfHouGtV+WVr1vVVVVt0oTQW5ttV75XyQJ9IW5B9Himg8S6bj4wQcE6tuIIbNvFkP+SsX45bJLJNmDw+AIBCN03GUXqTjaL2YqhwC/cPhQf+gPzwcHNBw+Hn/V7Wy5RfKfIB6355mJe1dek13EN7W1HBc092a35NDbMfqKmlccEq3MvNdDw4rTUFheamKJQR2Os+Zrrs49zh0+a0rNPxRNvidbIBm3sw5aqdMAYHCqbDxKaCJtFJr0vgnzCfksyVeg2HTx4nSniw4stLkqkON3d3dxbrP4s2iy2zRY0dsZ9Bj0uRsU7Au7/V6L0Yc69LQi9UZhUzIp57sqsulkr4lu9H7MokWPXDcSF1TcLelzv5nO/1eC/7FHJOfh+sHDqmVdM8hvQLdvNlsHimXSZtvK828JbkKhuBUYcLDAWFqrTk83bb3bzKNJ6NpzP74TLCT6YdTdj6JRknM1hbZLE5YODo7evi2ANjFu3gasy4wFvJio7OItQGFeND8DAAA//+4XVod1wQAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.162538778 -0800 PST m=+4843.421265363", "maxElapsedTime": "545.540125ms", "maxServiceTime": "545.504098ms", "minElapsedTime": "1.710085ms", "minServiceTime": "1.66897ms", "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": 33917 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "367e8ea40f6591dc", "index_projection": { "primary_key": true }, "keyspace": "WAREHOUSE", "namespace": "default", "spans": [ { "exact": true, "range": [ { "high": "$1", "inclusion": 3, "low": "$1" } ] } ], "using": "gsi" }, { "#operator": "Fetch", "keyspace": "WAREHOUSE", "namespace": "default" }, { "#operator": "Parallel", "~child": { "#operator": "Sequence", "~children": [ { "#operator": "Filter", "condition": "((`WAREHOUSE`.`W_ID`) = $1)" }, { "#operator": "InitialProject", "result_terms": [ { "expr": "(`WAREHOUSE`.`W_TAX`)" } ] }, { "#operator": "FinalProject" } ] } } ] } }, { "#operator": "Stream" } ] }, "prepareds": { "avgElapsedTime": "13.655521ms", "avgServiceTime": "13.583926ms", "encoded_plan": "H4sIAAAAAAAA/6STYW/TPBzEv0p0z15skvWIsrGBJV5UW6ZVGqxKC0FCVWol/ybeXDvYzmipwmdHTmjLCkICpLyxfT7f/RxvQDo3BRVZrYQGBxgWJHxj6dJob41y4IPnDFIXtBrW8j1ZJ40GP2PQYkngeBun2V1yFSdZST4VlirTOJqKVSI8oZe5WuRBW9BCNMqDwdRkhTcWfIP/9gNM6FNDOg8bv+aVVIUlDf7xqWjY+MpY+SWoaisfpaKSXLC6lc538qmwJfn9kTwdJvHN3btJDIaxlY/gF+2s3Z7yVzFGAcokF/oU3wmBI73JRlfbcSYLcJyeX9BLEmfPFucvXg2KfLdaW3NPue+AbkKTpbDr7IHW4N421DI80HrL7scCv2bqaqFdl5JWIve9CYMVuqRuupJlBY6jQZcgV01/l6cMynzuF9pZO2NonNQlOEon0bKnra/J5xX+KNqhxVhYoRQp/BP+a6k8WTDkRheyp4jj4/kuzfz/eZqNruYn0evoaHDyU4yRll4KNe5vAQyWXKN85skutxzrIDz0nA4/zE8CqkM0Uu/t2lkbvgPJxFsSy24vnCx199ZC/c4VHPfOaLQMnlbh9x0n8XiYxNFvX1l0ndy9iSbxbXw5jTqjfmaXOkpv4iSOAo2OBdpvAQAA//+7Ssfq+gMAAA==", "featuresControl": 12, "indexApiVersion": 4, "lastUse": "2019-11-08 14:44:41.239619466 -0800 PST m=+4843.498345971", "maxElapsedTime": "522.15351ms", "maxServiceTime": "522.115567ms", "minElapsedTime": "1.052056ms", "minServiceTime": "1.016273ms", "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": 35366 } } ]