[ { "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": "4ef14732c2c27767", "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": "12.770862ms", "avgServiceTime": "12.641379ms", "encoded_plan": "H4sIAAAAAAAA/6RU72/aMBD9V6xbP4BkTStUQ7K0DykJGhItKKGrpgkFK7kGt8HJbKcrq7K/fbJDKKU/1m1fIPY933v37ux7QJkUKaZxmXMJDIDCFXJTKRwW0qgi18A+UBAyxTuvFF9QaVFIYH0Kkq8RGExDPwjjaO7NL6I4QzOstCnWqPTpZsK1ObcoCkWJiptCAbuHdw8LiPB7hTKxkF/JSuSpQgns22OQV5lVocRPiyqVuBU5ZqhtqonQxsHnXGVogEGKV7zKDRteRPPpWRAChZkSt8AG9aJuSf5JxZtAY2tUlHDZh61rwGB4EV/GYz/27c/Ei+ZtLBYpMDjBq+OTQb+X9JLeYPBxsIuWqrjGxDjD723la6428Q1ugBlVYU3hBje65Ak6kl3BtjPt9tYPoKBLLrUTjHc8MU0OCorLDN32SmQrYHB07AQkebVrdV78aAI1fYD1XoL1HsH6L8H6UC/qBYVKC5kBg0wLd3DfzhGaZAV/U+dhhhlXPM8xh//q/UjkBhVQSAqZiqYj0Ol0OstWzvL9cui6vOyST+TouEu4TMkhwN8Bet3nEXY8GkS/231SzVgKI3g+awYDKCjUVW5ig2rd9ra0wIOsltUlez48GoeW9RXE2dj3J8GrkEb5K4BTb+KdD12SRb2o7X18XN1Upc5kXag/l7TT/CTNSMgHiyzRQTwyCvnaHQQtMumeOzsWO4nA4FoXEihsefY3xv7+yl3nvXVjVLtTUzB4Z9+lWRjMvDAgb3guySicnpEomATDObF8lGxl2I+GwH5Zavu/Fd0caz0il5+DMCDNTLqJJN65T5oRdAO4XdssbtwaaeT0a8sG9e8AAAD//0OFRIofBgAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:40.196599209 -0800 PST", "maxElapsedTime": "72.37119ms", "maxServiceTime": "72.312645ms", "minElapsedTime": "1.763514ms", "minServiceTime": "1.711514ms", "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": 2225 } }, { "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": "5.845523ms", "avgServiceTime": "5.709961ms", "encoded_plan": "H4sIAAAAAAAA/6RTYW/aMBT8K9atUkGy0Fq6abK0DwhSaWIFloRNiKJgJa9g1TiZ46B2Lfvtk7MySqHStH17eb7cO987P4BMmmeUJYWWBgLguCHpKkvd3Dib6xLiLYcyGd11CvWVbKlyA9HmMHJFEBgE35Jh2AvCpCoy6ShyeXoLjrwgK11uIR7wZveBiL5XZFICx890qXRmyUBM90Gdyi1zq354VGHVWmlaUOmpPqvS1fBY2gU5CGR0IyvtRBQPu31wjKxaQ3zYzDbbCf8koU/3USoNOG7pvoTAtNFweVI6q8yicfK+yR4f2TVa16irZ0fvms0ZNnyfbiSt1Jo0/kvUJbl0+SSpkKn3f3ttv45t78mSAxFdnRs66EbkwFGSSxzZVVkPLaRbQqAxr+nnrXmUfBl3BvGneDJvgmMtdeUnnZzVdEfgk7i3jzx/Dfk7Pd1BvI9vv4YPg6thHBz+cAG/85d3M9m4ziU4pFayfGbZ37o427yk7akylTY7dhQ5S3JVS0GpFqZ+TBCm0prD0Z2P7CgMRp0wYEffDrsMh1dsPOp14oDVutg4Clg/mERsepDA09bpQfxmLApittsY+8hOzjird+Lrc1//cd132r6z89W3LrD5FQAA///WZbVHHgQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:49.251422246 -0800 PST", "maxElapsedTime": "102.440308ms", "maxServiceTime": "102.385659ms", "minElapsedTime": "682.242µs", "minServiceTime": "628.259µ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": 410691 } }, { "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": "ca8666238d5eb92", "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": "9.188736ms", "avgServiceTime": "9.02769ms", "encoded_plan": "H4sIAAAAAAAA/6RTX2vbPhT9KuL8+tCA+LGmrOsEewixy8yyJsSmHYzgaPato1aRPUnu2hXvsw/bdZul7GEb+EVXR8fnD/cBZLIypzyttDQQAMcVSV9bmpbG21I7iFccyuR0N6nUBVmnSgNxzGHkliAQJ/Pph3QWXoSztCA/j3JwlBVZ6UsL8YD/ng+I6WtNJiNw/Mg2SueWDMTnX0GT2m9Kq763qMqqW6WpINdSzZTzHTyRtiAPgZyuZK29CKI4WUbTBBwLq24h3jSrZvjJX6mIWstxJs0xHv1DIIjSKEgv0ygYhqnKIZDJ05OTk/Hxaf6avrwdP11WtrymzHeRPbRmttLepzd0D+FtTQ3HDd27SmbUkT95aLMdxo8WweEqaVwnlO5k5nsODitNQd14o4oNBA56AZmun8rS5bf+ouHPsKPfwY7QrJoVR+2UKSBQONU93M3njHy2wZ8Y2GdYSCu1Jo1/6ulMaU8WHFlpctVHjcPDw/WgZv3/uq9sPWLv2MHRiEmTs33AcD0ejV4IjYzySupFXyY4LLla+9ST3Q59VC1wj/M8/JSk8466DXQ/QGWeOZtV0357kNhbktvuLZwqTLeYbUo73BC4dqVBw+Hprt2JxTJcTJYhe7mZ7Gw5/8jicBZOE7bD0c8H7ezyfbgMWR9aFxmbnAcseDyN0fwMAAD//zvTyew3BAAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:45.038068074 -0800 PST", "maxElapsedTime": "107.840136ms", "maxServiceTime": "107.783977ms", "minElapsedTime": "1.208012ms", "minServiceTime": "1.126054ms", "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": 3712 } }, { "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": "6.044096ms", "avgServiceTime": "5.902507ms", "encoded_plan": "H4sIAAAAAAAA/6RTXWvbMBT9K+IuUBtEWJutDMEePMfdQ5vWxM4gpMER9m0ipsieJId2bfbbh0y8xUkz2PaU+H6dwzlHz4AqLwssskpyBQyAwgNyW2sMS2V1KQ2wtxSEKvAxqMQX1EaUCtiAguJrBAZxMB1Ft2lWVwW3+DkMa2PLNWqgUFaouS01sGd48/sDEvxWo8oRKPzIV0IWGhWwWXcoqO2q1OK7m6q02AiJSzTu1I0wthlPuV6iBQYFPvBaWhZOkvRuFI2BQqzFBtiH7XzbgvwTi2t8SnKugMJXfDLAYOZ5nmfLzFgt1NLrvfPJywu5h/49NP/2Wu/9071L35/DlnbBYq65lCjhvyhfoc1XO8IVz51He7o419ryTrYjHqEsFR5VE7RAwaDNLOq1aXArblfAwFu0CIv+Isw+BTfBbRgtfKCw4bJ2WL3z5uDrC9N0mO1y1F26+MNSG7zwcGkAzvVD8qqYNAkFClwKbrqy/IVY8+3h8aEwOdfFa63EauTrhhAYsVTN0wKmaikpWHx06Y3HURyMI3LqJZGr8d2ITOJhkEakZUcmSUSuo2lCZsdxPOufuZ9uGE80Ln2fzEkSpeSXceQj6Z1T0vHF1S5cbU92VxvA9mcAAAD//7udfthFBAAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.917788162 -0800 PST", "maxElapsedTime": "80.825664ms", "maxServiceTime": "80.751977ms", "minElapsedTime": "899.416µs", "minServiceTime": "844.537µ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": 35830 } }, { "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": "3.327401ms", "avgServiceTime": "3.191684ms", "encoded_plan": "H4sIAAAAAAAA/6SSYYvaQBCG/8ryVrgElqPqp+43qWmRXhNJrEdRCUsy5y1dN3Z3Y201/e0lVu9y196XFgLZeWZIXvaZA8gUVUllvtXSQAAcdyR9beltZbyttIN4zaFMSfvRVs3JOlUZiCGHkRuCQBzd5kk6jtK8sCQ9xfQtsSVZcFRbstJXFuKAV48FMvpakykIHD+Le6VLSwZi8XRoVPv7yqof7dTWqp3StCbXfupGOX8an0m7Jg+Bku5krb14yAKOqVU7iDfNqrn85Z9izKWuKSukAceuPTsILBZBEAS+yp23yqyD3iBkxyNb4nqJ06nTGoYv9/phyNlhiTjJx/lkvIRgvQFnJ5BcQP8Mbi9g2KxWaPjTnFNppdakwbGR+0ul3Aai/18XkJEpJ8aR9eCQWknXlQ6OL/TdbWVBz3C7Hhd+9vNH6LFyhbQlmlXTPs+6mbckNzgZdGptTmsJYWqtOTztW/PTNJqO0oi9tIXsXZp8ZJM4i9IZm8Sz5HEy+BB95mw+uvkUhb9fWTBL8myWTuL3rdLjkV1dX7XKOnj4d9x/EHn21uvzrtfegHcl9oZNiOZXAAAA//83D1BEfgMAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.931243032 -0800 PST", "maxElapsedTime": "78.662742ms", "maxServiceTime": "78.598259ms", "minElapsedTime": "485.805µs", "minServiceTime": "420.882µ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": 41065 } }, { "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": "3.385886ms", "avgServiceTime": "3.25551ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkVWV7mOS3iKQTogUWu5sQRcEKF3Ab7MwxFV3Jfvvk8JF0HXvYpEiOr4/vPefo+AVQp2aO8yTPpAYGQGGB0m0sdo121mQFsCsKSs9xG+TqK9pCGQ3sIwUt1wgMBtG3ZBiHUZx0kiU67kz62NMLAxRMjlY6Y4G9wLt6Axy/b1CnCBR+piuVzS1qYJPXoGDjVsaqHx6VW/WkMlxi4VvdqMJVcCHtEh0wmONCbjLHuBh2+0BhZNUTsE/ltDxO+CcKfXzmqdRA4RGfC2AwabWcSQpnlV623n9ok92O3MPlPVR/jaNOuz2Fkr5ud40uXR2a5TL15h0Jey+PtYOYN9dH0soswwz+S1NPK6dkNrLmAVMHFCwWm8wlDu26qNC4zT2wNavIzS5nPPlyFwxET4xn7YrVHxBhIILzp2MRnj/ch6c7EOchcXQ7FNHfMWGPi+Sq4wHTN84rXUsup6X/foNwZ1Guq7tQqKWu3oB3eK8NGDwUxkfhNKlZOmloFo+uNWu1kmZ1LMLjtqTgcOtDPYqjURBH5NwDI9fx8Jbw6CbqClJPo2TP2K9jEfrlxM5vagYVcq/l0MubSe54RPrRmJOJGCZcxL3BZ5/13Y5cXF74nDfKHR/zXwEAAP//i/Iq7kUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:46.474187815 -0800 PST", "maxElapsedTime": "88.037404ms", "maxServiceTime": "78.52009ms", "minElapsedTime": "503.878µs", "minServiceTime": "453.209µ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": 41291 } }, { "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": "3.405818ms", "avgServiceTime": "3.260418ms", "encoded_plan": "H4sIAAAAAAAA/6SSb2vbPBTFv4q4T6A2iPKk2Z9O70ziDTPPDrbXUpJghH2biilyJsshW+p99mE7apNtfbOBQTrnXqzLPb8DoCqqEst8K7kCBkDhHrlpNE4rZXQla2D/UxCqxL23FTeoa1EpYBMKim8QGET+bR4nMz/JC43cYKxL1ECh2qLmptLADvDfs4AUvzaoCgQKP4oHIUuNCtjivMlrzEOlxfeua6vFTkhcY939KhS16dszrtdogEGJ97yRhvVDpEBhrsUO2Lt21don/mqGGy4bTAuugMKuu9fAYLFwHMcxVV4bLdTaGU1c8vhIlnC5hP52UrpyX66NXZeSwxLi3AvDPIynXrgERkbXlHTm1EuSwE/yYNa7b46u1a8GPbP6atB+lCV3+WC9Hqxjw3hQcZhPo6x33g7Ore2YtKsVtPR8BXOuuZQogcKG760S9QbY+J92m6IqA1WjNkCBS8G73T4F+AW/1Vte4KnX0WbNY+K/jTsTdcF1Ce2q7b5fqqnRyDfQY1GLteopB6YaKSkY3HcszRN/7iU++SPU5H0SfyJBlPpJRoIoi8kwHXE++neU3HjhZ98djpQ4WZynWRJEHywjF5cX3UFOClcvFcaWjj4dG98xbxv3MbvR5IwOC8czDJaFM6gsU09IWCJOeRxdty60PwMAAP//cl6W3SUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.926656867 -0800 PST", "maxElapsedTime": "74.563629ms", "maxServiceTime": "74.506668ms", "minElapsedTime": "494.107µs", "minServiceTime": "441.685µ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": 41065 } }, { "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": "3.268751ms", "avgServiceTime": "3.144558ms", "encoded_plan": "H4sIAAAAAAAA/6SSUWvbMBDHv4r5bw8tiLGxh4HeTKqCadMaO9sYJTjCuSTqFMmTziVd8T77kJPQddleNjAY6X53+ul0TyDX+iUtm85qBwkIrEhzH2jiHQdvI+RbAeOWtMs784lCNN5BvhdwekuQuFGfm9vqQlXNmrhg2hZu5SHgOwqafYB8wqvnBWr61pNrCQI/2o2xy0AO8u4llPe88cF8T1QXzIOxtKaYSl2byCM+02FNDIklrXRvWRYzNYVAGcwD5IdhPhwP+CeDK3qsW+0g8JUeIyTu2DeRg3Hrs9fvzucYxMuES+J2c8A73abWHIxSo45bB9mT7FIHbS1Z/Jd04Qwbbcvg76llCASKveWGKWzjSNOuS+DZIrkt3iyKpqyKiVqcj0an0Zt8+vfgRT7LU3B+0gvjni2G+ZC+35CaA+ntmIto1m6cuXTpfVlI3Eef2r93+HU9Gh83BgGmXZqDslJlXqnsjwOZXVa306xW12oyyw4lRLavnf7pzD2Tbpd9rFV2pb7U2cmr/wwAAP//XZmkYjIDAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.889814424 -0800 PST", "maxElapsedTime": "83.912187ms", "maxServiceTime": "79.332599ms", "minElapsedTime": "461.906µs", "minServiceTime": "416.953µ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": 410691 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 8, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "bed9e03b97436f27", "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": "14.746068ms", "avgServiceTime": "14.616549ms", "encoded_plan": "H4sIAAAAAAAA/6ST0U7bTBCFX2V1fi6I/lVFSVXKSlykxAikUqIkNEJV5Az24GzZrN3dNYUi99krbyAtCapEe2V5Z3TmnG8092CblTnnaWXIQgESV0yhdnxY2uBK46F2JLTN+bZX6U/svC4tVFfC0oKhMOhdnCYfx2ld5RR4Qo7nZe35PRmyGUOirNhRKB3UPf779YMRf6152fIjm2uTO7ZQn5829eowL53+3nZVTt9owwX7VuqD9iG2j8kVHKCQ8xXVJqhJb5gcn52PEkgMnL6BetdMm8cpf2XjpM0/ysh28QADCpPj9KT/+J/qHAqXnO/zTvdyf+9N9+3V7t6qWrnyC2chsrtvkyzI3aXXfAcVXM2NxDXf+YqyFunvAVrKj+8PASHhK7I+uuRbysJSRMKRLTg+z3Uxh8LWbnSQmXq1NlN+WxaaaTOVqL22BRQKr9HIp6kH5MgYNvgndkccsjleFHDdyJE2gR0kstLmekkR29uzlc7s1WySnvRnHXEgtnY7GwKHprS88TriyJJDGtgtljwrCi24de2LcX/WgcQNmZqfGx4bxP9i63WnJbsxyebn8UAgQUaTX6PwEjjTZl2+r31GLn+uNAqOaREtwevCxtuGsrUxEoFv28MZDJNBb5iIP5+yOBqenYrzQb83TsTKpBglYxHji4OHbwtBTI6TYSLapcSVoPkZAAD//9LXqERrBAAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.890981114 -0800 PST", "maxElapsedTime": "89.823509ms", "maxServiceTime": "89.725712ms", "minElapsedTime": "1.733285ms", "minServiceTime": "1.681385ms", "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": 39513 } }, { "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": "6.172174ms", "avgServiceTime": "6.040515ms", "encoded_plan": "H4sIAAAAAAAA/6RTXWvbMBT9K+KsUJuJsq17GII9eI4Lo+ka4qRQ0pAI+zYRUyRPkkO71vvtw6bZ8rE8bHuT7z3cc+65x08gU9iSylmlpYEAOO5JhtpRak1wVnuINxzKlPSQVOqGnFfWQJxzGLkiCPSy/uebbHg7q6tSBkprH+yKHDhsRU4G6yCe8Or3B3L6VpMpCBw/iqXSpSMDMdkFJXVYWqe+t6jKqbXStCDfjuorHzr4SLoFBQiUdC9rHUQ6zkfXV9kQHAOn1hAfmmmzIfknFZf0mBfSgOMrPXoITKIoioKd+eCUWUQn72P2/MzucHaH7rXVOo+P997F8RQN3yUbSCe1Jo3/knxBoVi+CK5k0Z5oy5f2aJvyi20HOlJtDR1Ucwrg8BRmgdzKd7yVDEsIRPMNw/xsns4+Jf3kS5rNY3Cspa5brugYhr1mJ29jtIfa5zPluIsUOKRW0u9u8hf7TZv94T3lC+nKP7Xy4EiuOkHwamG6nwHC1FpzBHpoAzcYZoNkmLEj2WcXw+srNh70klHGNuLYOM/YZXabs8lhgE7PTg/Ss1Xfjw7LsxH7ZSL7uPVu7UTzMwAA///7tGMH2AMAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:50.304311344 -0800 PST", "maxElapsedTime": "70.892079ms", "maxServiceTime": "70.823899ms", "minElapsedTime": "916.76µs", "minServiceTime": "864.698µ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": 36763 } }, { "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": "56ef11152b8786bb", "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": "43.781587ms", "avgServiceTime": "43.640395ms", "encoded_plan": "H4sIAAAAAAAA/6SUX0/bPBTGv4r1vFy0kvXqLS28yNIuKhK0Sh2tUqCapio1ySH1cJ3McRgMZZ99cvpvBXrBdlOp5zw5fs7zk/0MMkmeUhoXWhoIgOOOpKssnefG2VyXEP9xKJPSY79QN2RLlRuILoeRS4JAEA4HN2H0Oa6KVDoa2ZTsUBkCR16QlS63EM/4Z/cHE/pWkUm85GeyUDq1ZCC+7Iv6lVvkVv3wqsKqB6Upo9KPGqrSNfIraTNyEEjpTlbaiVEUhFE8HFyG4Bhb9QBxVs/qzTF/5GPgV58k0nSxzgECo2E8igdBHPifaTwINr1YpRA4OaW7Tqdzcnx79v/Z6e3ttlvY/Cslronw2a+1lPYpvqcnCGcrqjnu6aksZOKT3dvGp71prNcFR1lIUzaW6VEmbjWFw0qTUVNeqGwBgaPjxkKiqy0+nX9fNWq+k3UPybp7st4hWQ/1rJ5xVKUyGQSyUjUf/h7oWFqpNWn8FZYLcskC78vrpZMLpR1ZcCS5SdWKClqtVmu+GzX/d76GPW+zD+zouM2kSdkbmmCr6bYPiqZbUa/dfmXoXOeGXlUn1KAmFzuyyxXuQjpP4g0Xm+sYzNvgeJC68hEcdTyZV4NNet3cWnBIrWT5MsV3pTurXx4QqDKRNn2rNXGW5LIxhVJlpnlzIEylNYejR3+tx1E47kchO/TEsIto9Ildj4P+Vch2/tgkvGJ7Ufi8O2z6MYxCtqbZsGT9y4Ct0TXgNoXputBD/SsAAP//WBA1ySMFAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:50.264656248 -0800 PST", "maxElapsedTime": "150.31047ms", "maxServiceTime": "150.254758ms", "minElapsedTime": "3.005222ms", "minServiceTime": "2.950018ms", "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": 36763 } }, { "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": "56ef11152b8786bb", "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": "c84a4e81f8fa0a82", "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": "1.645203251s", "avgServiceTime": "1.645028699s", "encoded_plan": "H4sIAAAAAAAA/7RWb4+bxhP+Kqv5+YUtodNhOxcL6V5YNvmV1AXXkERVauE9GOPt4V26u6R3PdHPXi3g8980TS59Y8kzz/x75hngCZAnIsU0LnLKwQGwYI1UlxIngmspcgXOtQWMp/gwLth7lIoJDs7AAk63CA6EUTD5MZ65791ZTLliGepQi+R+IkquwQJRoKRaSHCe4H/7PxDi7yXyBMGCv5INy1OJHJyPx6BxqTdCsj8NqpDsE8sxQ2VSzZjSNTyiMkMNDqS4pmWunWAxdRfxzPNdsGAu2SdwXlfWBWDd+QFmWe1a+aZePcNRmFA+AAuoAgcEtMyBA8EsDmJvGk/Nz4fYm+58MUvBgVc3uLZt+1X/bvR6dHN39+wtpPgNE12T/mQ42FL5GN/jIzhallhZcI+PqqCJ2cXR6GY/O0c7MligCspV3Ts+0EQ3WSyQlGdYmzcs24ADnUHdQpKXzcJtC3Lxh3EMwbC5g/WPYYNnWP8IZn8OZkO1rJYWlIrxDBzIFKsDD5l9gzrZHJL6NSOfJptTSfMcc3jRsn1UGtOZEMVbwbjpLWd1e8pInsdJTktl2uh2uyuxuloFs3rrqx65Jd2VWl2twtbQI5SnZA/zTmGNodd7Wcfn8lQH8gyjupu6ln0szWQ0pEMc2evRml7TUf/bpLk7tsuq5DWdcS5EsVPkvxXqCb2f0dkp6kCbJ8R/KUGL+krVKngJG9WyOsvOco0SLEgET1mzBCO2S3rr2Kcamz67+mf6Cxrfr+X19SAhncEO0Bm2NqPMI+w+RSPYn9+N/ciLfjnIctPrnRHkcaYZzf8vRVkYnrJMYka1eb5/hMS8PropU5rxRJMT+nuwtCAzgUZvJmB5gSOPa5RbTBnV+L2qnK2Bf78J/pMnVcvyvDlWsECiKnMdG2qa+6oFOvGjuG0OLMCHwsR+aYTqMh+7WmYl51sJtUS6rWNBsYzXXxtmtMMWHODl9g4lVBZofDCv7fnCnY8XLvnHDw7yZhH8REjoztxJRCbBOz/qTr0w8vxJ1BVXbfpej4xDclCvDdu/TIggnu+7C/I28PymJFEk8EmTxJwWub0l6qp5ipOxPyXP6Y2ndtW1yIcf3IVLDuJIx94HTFtTf28yV7W/v0t2vCWdYe0wZXb3tr82qP4OAAD//w9YnQDaCQAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:57.641047088 -0800 PST", "maxElapsedTime": "2.431735512s", "maxServiceTime": "2.43166995s", "minElapsedTime": "215.211967ms", "minServiceTime": "215.132626ms", "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": 3712 } }, { "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": "ca8666238d5eb92", "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": "8.886672ms", "avgServiceTime": "8.750494ms", "encoded_plan": "H4sIAAAAAAAA/6STUU/bPhTFv4p1/jxQyfprFI0xS3uoSNAiMajSakWaqtRLLqnBdTLbYTCUffYpDimsYw/bpLzE9/j4nt/VfQCZvCqoyGotDQTAcUXSN5ZOKuNtpR3EKw5lCrqb1OojWacqA3HIYeSGIHAeL7KLNIrTrCQfKeetyj04qpqs9JWFeMB/Tz+Y0ZeGTE7g+J6vlS4sGYhPP4smjV9XVn3rVLVVt0pTSa6zOlPOB/lc2pI8BAq6ko32Ikpm8zQ5mYNjatUtxJt22Q6P/FUXSZd6lktziEcEEIiSLImyRZZEw2GmCgjk8vjo6Gh8eFy8ps9vx9tibatryn2g9tCF2Uh7n93QPYS3DbUcN3TvaplTMN9m6PAOx48RweFqaVxolO5k7nsPDitNSeF4rco1BPYOQgO5brbz0tXXvtDyJ9n4d7Ix2mW75GicMiUESqfCxed8Tsnna/xJgF2HqbRSa9L4pzmdKu3JgiOvTKF61Njf318N3az+X0VZEq1G7B3bOxgxaQq2W15sBePR6JdGE6O8knraDxMcllyjfebJboZ51J1wx3U+uVz1bi/Xz+PLeXYRnu6A7wJW5unNdtl2345k5i3JTbgLp0oTdrej+MwbAteuMuAIDQ2/LYenu26Fpmk8naQxe3GX2Wl68YHN4rP4ZM6CAWfPzPvyEIot3sdpzDragTWbnEeshxvQov0RAAD//8ibMwBzBAAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.904666384 -0800 PST", "maxElapsedTime": "75.539523ms", "maxServiceTime": "75.472893ms", "minElapsedTime": "1.056879ms", "minServiceTime": "1.006013ms", "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": 41065 } }, { "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": "3.388743ms", "avgServiceTime": "3.252935ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkoXY8TPJbRNIJ0QKL3U2IomCFC7gNduaYiq5kv31y+ErXsYdViuT4+vjec46OXwB1amY4S/JMamAAFOYo3dpix2hnTVYAu6Sg9Aw3Qa6+oS2U0cDaFLRcITDoR9+TQRxGcdJOFui4M+ljV88NUDA5WumMBfYCH04b4PhjjTpFoPArXapsZlEDG78GBWu3NFb99KjcqieV4QIL3+pGFa6CC2kX6IDBDOdynTnGxaDTAwpDq56AfS4n5WHCf1Ho4TNPpQYKj/hcAINxo+FMUjir9KLx8VOTbLfkHlr3UP3Vjq6azQmU9HW7a3Tpct8sl6k370DYe3mo7cW8uT6UVmYZZvAuTV2tnJLZ0JoHTB1QsFisM5c4tKuiQuMm98DGtCI3bU158vUu6IuuGE2bFau/IMJABOdPRyI8f7gLT6cvzkPi6HYgon9jwi4XyWXbAyZvnFf6JLmclP77A8KdRbmq7kKhFrp6A97hnTZg8FAYH4XjpHrpqKFePLhWr52U1KsjER62JQWHGx/qYRwNgzgi5x4YuY4Ht4RHN1FHkNM0SnaM/ToSoV+O7PzmxKBC7rTse3kzyR2PSC8acTIWg4SLuNv/4rO+3ZKL1oXPea185WP+OwAA//8VUTQlRQQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:46.127195732 -0800 PST", "maxElapsedTime": "68.27256ms", "maxServiceTime": "68.179053ms", "minElapsedTime": "515.26µs", "minServiceTime": "466.366µ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": 40449 } }, { "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": "3.411545ms", "avgServiceTime": "3.281388ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBD9KuI2aAKitFthoP9M7I6QNsksdSOkwRHOJVHrSJ6slHSN99mHnB9212V/bGCQdXq6e+/x9AKoUzPDWZJnUgMDoDBH6dYWO0Y7a7IC2AUFpWe4CXL1FW2hjAb2kYKWKwQG/ehbMojDKE6ukgU67kz62NVzAxRMjlY6Y4G9wLt6Axy/r1GnCBR+pkuVzSxqYOPXoGDtlsaqHx6VW/WkMlxg4VvdqMJVcCHtAh0wmOFcrjPHuBh0ekBhaNUTsE/lpDxM+CcKPXzmqdRA4RGfC2AwbrWcSQpnlV603n9ok+2W3MP5PVR/jaPLdnsCJX3d7hpdutw3y2XqzTsQ9l4eansxb64PpZVZhhn8l6auVk7JbGjNA6YOKFgs1plLHNpVUaFxk3tga1qRm55PefLlLuiLrhhN2xWrPyDCQASnT0ciPH24C0+nL05D4uh2IKK/Y8IuF8nFlQdM3jivdC25nJT++w3CnUW5qu5CoRa6egPe4Z02YPBQGB+F46Rm6aihWTy41qzVSprVkQgP25KCw40P9TCOhkEckVMPjFzHg1vCo5uoI0g9jZIdY7+OROiXIzu/qRlUyJ2WfS9vJrnjEelFI07GYpBwEXf7n33Wt1tydn7mc94oX/qY/woAAP//OeLpxkUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:45.006319372 -0800 PST", "maxElapsedTime": "79.88219ms", "maxServiceTime": "79.829477ms", "minElapsedTime": "533.702µs", "minServiceTime": "483.185µ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": 40332 } }, { "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": "4ef14732c2c27767", "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": "13.380348ms", "avgServiceTime": "13.247643ms", "encoded_plan": "H4sIAAAAAAAA/6RV32+jRhD+V9D0HmIJVQ0+1RJSHwhgHZJ/ICA9JZVFVjCx9w4v7rJck0b0b69mMTYkOZL2Xuydb7+dnflmdngCFFmZY54eCibABjDhHpmqJbqlULIsKrB/MYGLHB+cA/8dZcVLAfbUBMH2CDaEzs3SXyXpFpVbV6rco6yuHhesUisimFAeUDJVSrCf4KezATH+WaPIiPJPtuNFLlGA/ceQ5NRqV0r+N7EOkn/jBW6xIlcLXilNT5jcogIbcrxndaFs9zpO1ks/AhNCyb+BPWs2TXfJ/4riXaSANIozJqZwFAxscK/Tz2ngpR79LJw46fZSnoMNH/H+8uNsamVWZs1mv85OuwdZfsFMaa2fKPM9k4/pV3wEW8kaGxO+4mN1YBnqS04JU1E6+KgHmFAdmKh0wPjAMtX6MEEysUUN7/h2BzZ8uNQBZEV9qnJR/tVuNOaZZn2PZg1o0+/RptBsmo0JdcXFFmzYVlwf7Ms5R5Xt4L/k+dxDyCQrCizgh2o/54VCCSZkpch5WxG4uLi4uOvCufv5ztVVvpsYvxkfLicGE7nxnOCdCNbkdQa1R8uYTiYvsgkEV5wVYdsYYILEqi5UqlDuu9oeiPjMK92qnb2+PQ8iunWEsQw8b+GPUtrIRwhxEvl+kl6+h2SNktwguXnDi5OMR3sbhKP74af1atxDHKzccYYb+V4wrklLSRfBcpTmBbG7vl6N+7pyFs5bId0kXnoc1uPpHwe6+wbPcxKHCJtm09CAHbbrWub61VSlfLtHT034ws2ci3PP00XP9mMlke31Qaj4VuhPF73zkyZgw5eqFGBC2zwDW5fgJUJF6aOU6sA+1qSP6Rz6QOD1LT37e3b7qvpIT/cBTN3YB3TzDQDq+CHQvrZXMKuP9TqiD98GYWc2Jih8oI9rGPmhE/nG+OfemEfrpRH7C99NDJLANI7K0KLNmVakBv13kfbWFq2pUC3mJPrAbRDSnxZDb5AImqkLdl5R6cjqSkTrYyfQspey9nfWXB9yEqdNoWtP4/MnP/KNdr7r6W44K89ox7ke5kebMtKj21hHnh8ZVzdd5tD8GwAA//9PzbicZgkAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.853801848 -0800 PST", "maxElapsedTime": "132.980458ms", "maxServiceTime": "132.893766ms", "minElapsedTime": "1.455638ms", "minServiceTime": "1.405415ms", "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": 23764 } }, { "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": "3.398377ms", "avgServiceTime": "3.261156ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBD9KuI2aAKitBtloP9M7I6QNsksdSOkwRHOJVHrSJ6slHSN99mHnB9212V/bGCQdXq6e+/x9AKoUzPDWZJnUgMDoDBH6dYWO0Y7a7IC2AUFpWe4CXL1FW2hjAb2kYKWKwQG/ehbMojDKE6ukgU67kz62NVzAxRMjlY6Y4G9wLt6Axy/r1GnCBR+pkuVzSxqYOPXoGDtlsaqHx6VW/WkMlxg4VvdqMJVcCHtAh0wmOFcrjPHuBh0ekBhaNUTsE/lpDxM+CcKPXzmqdRA4RGfC2AwbrWcSQpnlV603n9ok+2W3MP5PVR/jaPLdnsCJX3d7hpdutw3y2XqzTsQ9l4eansxb64PpZVZhhn8l6auVk7JbGjNA6YOKFgs1plLHNpVUaFxk3tga1qRm55PefLlLuiLrhhN2xWrPyDCQASnT0ciPH24C0+nL05D4uh2IKK/Y8IuF8nFlQdM3jivdC25nJT++w3CnUW5qu5CoRa6egPe4Z02YPBQGB+F46Rm6aihWTy41qzVSprVkQgP25KCw40P9TCOhkEckVMPjFzHg1vCo5uoI0g9jZIdY7+OROiXIzu/qRlUyJ2WfS9vJrnjEelFI07GYpBwEXf7n33Wt1tydn7mc94oX/qY/woAAP//9rNmo0UEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:40.799898919 -0800 PST", "maxElapsedTime": "68.362432ms", "maxServiceTime": "68.303932ms", "minElapsedTime": "520.889µs", "minServiceTime": "468.289µ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": 42252 } }, { "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": "3.353444ms", "avgServiceTime": "3.223842ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkIdgeJvktIumEaIHF7iZEUbDCBdwGO3NMRVey3z45fKXr2MMmRXJ8fXzvOUfHL4A6NXOcJ3kmNTAACguUbmOxa7SzJiuAtSkoPcdtkKuvaAtlNLCPFLRcIzAYRN+SYRxGcdJpJ0t03Jn0sacXBiiYHK10xgJ7gXfnDXD8vkGdIlD4ma5UNreogU1eg4KNWxmrfnhUbtWTynCJhW91owpXwYW0S3TAYI4Luckc42LY7QOFkVVPwD6V0/I44Z8o9PGZp1IDhUd8LoDBpNFwJimcVXrZeP+hSXY7cg+te6j+akedZnMKJX3d7hpdujo0y2Xq3TsS9mYeawcxb66PpJVZhhn8l6aeVk7JbGTNA6YOKFgsNplLHNp1UaFxm3tgY1aRm7VmPPlyFwxET4xnzYrVHxBhIILLp2MRXj7cp6c7EJchcXQ7FNHfMWGPi6TT9oDpG+eVPksup6X/foNwZ1Guq7tQqKWuHoF3eK8NGDwUxkfhNKleOmmoF4+u1WtnJfXqWITHbUnB4daHehRHoyCOyMUXRq7j4S3h0U3UFeQ8jpI9Zb+OReiXEz2/OVOokHsxh17eTXLHI9KPxpxMxDDhIu4NPvuw73bkqnXlg14rd3zOfwUAAP//mNv6pUcEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:44.382243363 -0800 PST", "maxElapsedTime": "88.812039ms", "maxServiceTime": "88.708673ms", "minElapsedTime": "527.823µs", "minServiceTime": "475.982µ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": 40964 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "bed9e03b97436f27", "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": "10.644156ms", "avgServiceTime": "10.524553ms", "encoded_plan": "H4sIAAAAAAAA/6RUXU/jOBT9K9FZHkCyVtCuFmFpHyIIIhIfUZudCkZVapJLanCdjO0wMCjz20dOaCkfM8yH1Aff49Pjc8+18wDSeVVQkdVKaHCA4YqEawztV9qZSlnwbQapC7oLa/mBjJWVBh8yaLEgcCTh+Ul0mmYluYkwNK8aS2CoajLCVQb8AX89FRjTp4Z07ilf87lUhSEN/vE5KWzcvDLyi2fVRt5KRSVZL3UsrevoqTAlOXAUdCUa5fgkHEVHZ/+PIzAkRt6C77bTdnnKb9mIfdfjXOghHiMAx+Qoiw+WdSYLcFxSsUfbw8u93X+G/14Ndle7tamuKXddYg++k4Uw99kN3YM701DLcEP3tha5D3K9AZ/tEn9sEAy2Ftp2LulO5K4XYTBCl9TBc1nOwbGx0znIVbMalqo+9xvttJ0yNFbqEhyllWjZ864PyeVz/JK1lxKJMEIpUvij+A+lcmTAkFe6kH2K2NycrdzM/p5NsvhgthX8F2zsbL2yEWvppFBJPwUwGLKNcpkjs1jmWHviS83T8CSa9XrfYYzTURSl2c5PsQY/Zu3H6fl7OmH6jqGLOPGE6atpSv2UQDtt/e8FZewMiUX3X1hZ6u75+4n11sBxbSsNhj6Y9boz9hzoc3kDG6xjF3GyLFsGR3f+KSejKAlHUfDWJyU4HJ2dBOPoONpPg94IC57OW1sP/Nob77Ew7YgXcdJLrGILJkfRKAr8DeruD9pvAQAA//9i/4pMDgUAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.869653922 -0800 PST", "maxElapsedTime": "78.717215ms", "maxServiceTime": "78.652792ms", "minElapsedTime": "1.051524ms", "minServiceTime": "1.014556ms", "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": 39513 } }, { "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": "8c64c440952bb8f1", "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": "6.250562ms", "avgServiceTime": "6.10367ms", "encoded_plan": "H4sIAAAAAAAA/6SU0U/bMBDG/5XoGw+tZCFo2MYs7aFqg1aJrVWKqCZUpSY5UjPXyRyHwVD2t092WjrK6MMm9aH297Pv7ruLH0E6LTLKklIJDQ4w3JCwtaFBoa0pVAV+xCB1Rvf9Ul6SqWShwUMGLVYEjmF0PrqM4q9JTnYwysBQlGSELQz4I95sF5jS95p0SmD4lS6lygxp8KvnUL+2y8LIn44qjbyTinKq3FXnsrIevxAmJwuOjG5ErSwfx8MonoJhYuQd+Ptm3mxC/FMOI1ftNBU6BENa3JGpwK/af0Gns2jjLQ4X42Q0XHS7G2pHG+5VZ3vVwQt1RVY8Id3DhcycPl/3BhzjOHH5+LD+dqy1RGbgOE3fnaQnJ0cf3vaur09vjp/U0hS3lFrfVjcP1jwk3+jBlXzEjlmPhc5Ot1OKlHygtd1uAjab616AoSqFrryndC9SC25NTQxG6Jz89lLmS3ActCmkqn4aKVX8aIWGbbHea1jvGRa+hoVo5s2coa6kzsGRV9If/LPjE2GEUqTwX3NzJpUl43umM9k6ik6n8+rgBB+Dg+NuIHQW/BUabrFedw8323Jht/uiupGWVgo1aRsNBkNVrWxiyaw2nSoduG8S3Ue1W67eXtrMG/fbQabWkFj5s6hkrv3L4rxt7wXHbVVoNAyW7t0nPYmjST+Ogp1XJTiLx5+DaXQeDS6C9my71SYazD5FcRQ4V72lQf/LMGjt896t17P1OkTzOwAA//9KDxmb+QQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:50.217073729 -0800 PST", "maxElapsedTime": "75.421246ms", "maxServiceTime": "75.314765ms", "minElapsedTime": "718.719µs", "minServiceTime": "664.905µ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": 36763 } }, { "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": "56ef11152b8786bb", "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": "19.375437ms", "avgServiceTime": "19.24711ms", "encoded_plan": "H4sIAAAAAAAA/6SUbWujShTHv4qc2xcJDJebhD4wcF+EarmCjd5oWsoSzFRPzbRmdMex225xP/viqLG2G7oPEIKe+XnO/3/OYV4ARZTFGId5ygRQAAJ3yFQp8TwTSmZpAfQfAlzE+DTP+RXKgmcC6IyAYDsECu7StJahH8yDlR8mqFwZo3S4wAIIZDlKpjIJ9AX+6l/Ax88ligiBwLdoy9NYogD6aQjNS7XNJP9aU7nkjzzFBIs6lcMLpfGAyQQVUIjxjpWpoo0ax15YQMCT/BHoabWuujK/pcOuzfsREzNoO1HbdkI3tM3QrP+uQ9vszkIeA4XjE7ybTCbH09uz07OT29v9aS6ze4yUbuJLbWvH5HP4gM9AlSyxIvCAz0XOor63rZu6391BaxcIFDkThZaMTyxSTRYCkokEdXjLky1QOGrER2m5H2CafWkOKtJj00PYdIBNDmETqNbVmkBZcJEAhaTg+sPXDb1AFW3h15y+zeExydIUU/ij0V7wVKEEAlEmYt5MBUaj0WjTC9r8vXEdPeLN2PjXOJqMDSZi4weMuWem44OQu4dm4/E7W7bgirPUa7YECEgsylSFCuWuG3Neg+8T+yvPc25aoTrxQdT+Ceb/1XwR2MHNR9z80l0tgo8o03LsK2t5E+q663cbwUVvulpX9e8N4iuJbKe/hYInQl9S9dD3GoDCfZEJIDAoOAjXzgeBzuYg+KqVXbwioPCpvmq8peXNl5Zx+OIzLpbupeFbjnUeGMN0xGhF6IeuuH5pTOjHXnyTqu+mcf2fVdduFlKvozFfmEa7fXr3uoDbBmZQfQ8AAP//ZyhfEegFAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.295034826 -0800 PST", "maxElapsedTime": "98.773451ms", "maxServiceTime": "98.693131ms", "minElapsedTime": "3.222899ms", "minServiceTime": "3.171996ms", "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": 3652 } }, { "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": "502cab3738aba810", "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": "8.896332ms", "avgServiceTime": "8.769566ms", "encoded_plan": "H4sIAAAAAAAA/6SUX2vbPBTGv4p53l4kIEoS87Ii2EWYXVbo4uCUhlFColqnjpgqZ5LcdiveZx9Wnab/Qtl2Zx/9dM7R8+joHmSKSpJcbrQw4ADDFQlfW/pUGW8r7cAHDMpIuhtv1DlZpyoDHjMYcU3gSNLTk/M0/7qUpMnThG4zK8mCodqQFb6y4Pf4b/eDGX2vyRQEhl/FWmlpyYBfPIfGtV9XVv1sqY1VN0pTSa5NdaqcD/iZsCV5cEi6ErX2fJLOl1mepDkYplbdgA8HzaLZlvmrPk7ak88KYWIwFNUNWQd+8fAV9Xqrx5qrw9UkW2bLk2TV72/ZN4jkXWL+irgmL55i/cOVki2y6KwBR5c67EYXXioJjv8Ho0Jcxh/iI3EpjoYDMHyjH24jita/p6K1lm7jnahgcBthXBCG7kThwb2ticEKU1IIr1W5BsdBHOoWun68I7q6fVho2A4b7sOGz7DRPmyEZtEsGGqnTAmO0qmw8altU2GF1qTxT+YfK+3DVS4qI5UPfaDX673jbfQxOhj2I2FktBed79BR/x0227Fxv//qrDMyMgnDBwahlXAvbP0Dt5tF8zJ9olwhrHxraeYtiWuEGXOqNOHhADe11gye7trhnObpdJyn0Z53IjrOsy/tYnqWPnw/thjNP6d5GnW6BlGj8SSJOvWCdNtA1gViNL8DAAD//2a/qPfUBAAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:50.243629243 -0800 PST", "maxElapsedTime": "73.280471ms", "maxServiceTime": "73.231979ms", "minElapsedTime": "636.973µs", "minServiceTime": "587.757µ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": 36763 } }, { "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": "3.402601ms", "avgServiceTime": "3.277452ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkoXZ7QPJbRNIJ0QKL3U2IomCFC7gNduaYiq5kv31y+ErXsYdViuT4+vjec46OXwB1amY4S/JMamAAFOYo3dpix2hnTVYAu6Sg9Aw3Qa6+oS2U0cA+U9ByhcCgH31PBnEYxUk7WaDjzqSPXT03QMHkaKUzFtgLfDhtgOOPNeoUgcKvdKmymUUNbPwaFKzd0lj106Nyq55UhgssfKsbVbgKLqRdoAMGM5zLdeYYF4NODygMrXoC1i4n5WHCf1Ho4TNPpQYKj/hcAINxo+FMUjir9KLx8VOTbLfkHlr3UP3Vjq6azQmU9HW7a3Tpct8sl6k370DYe3mo7cW8uT6UVmYZZvAuTV2tnJLZ0JoHTB1QsFisM5c4tKuiQuMm98DGtCI3bU158vUu6IuuGE2bFau/IMJABOdPRyI8f7gLT6cvzkPi6HYgon9jwi4XyWXbAyZvnFf6JLmclP77A8KdRbmq7kKhFrp6A97hnTZg8FAYH4XjpHrpqKFePLhWr52U1KsjER62JQWHGx/qYRwNgzgi5x4YuY4Ht4RHN1FHkNM0SnaM/ToSoV+O7PzmxKBC7rTse3kzyR2PSC8acTIWg4SLuNv/4rO+3ZKL1oXPea185WP+OwAA//9oEHhoRQQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:47.406368362 -0800 PST", "maxElapsedTime": "70.016947ms", "maxServiceTime": "69.961698ms", "minElapsedTime": "543.239µs", "minServiceTime": "486.851µ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": 40583 } }, { "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": "3.490339ms", "avgServiceTime": "3.289329ms", "encoded_plan": "H4sIAAAAAAAA/6RTXU/bMBT9K9ZdJRLJqgZFY7K0h5CGFyhETTqpKlVqJZfWmutktlPBoPvtk6NmIy2gbTwlPvfr+J7jR0CVlwUWWSW5AgZA4Q65rTWGpbK6lAbYRwpCFXgfVOIraiNKBWxAQfE1AoM4mI6i6zSrq4JbPA/D2thyjRoolBVqbksN7BE+/DlAgt9rVDkChZ/5SshCowI26yYFtV2VWvxwWZUWGyFxica1uhLGNukp10u0wKDAO15Ly8JJkt6MojFQiLXYAPu8nW/bIf/F4hIfkpwroPANHwwwmHme59kyM1YLtfR6n3zy9ERuoX8LzV8n9HrszPfnsKXdYTHXXEqU8C7KF2jz1Y5wxXOn0bO9ONVaeLe2Ax6hLBUeoAlaoGDQZhb12jRzK25XwMBbtBMW/UWYnQdXwXUYLXygsOGydrN6x03Dlwum6TDb+ahbdPJGUWu8cL9o8EbRMEiDbvYpOI/sX1UVk8bPQIFLwU13if+w2vl2v/lQmJzr4qVQYjXydUMIjFiq5iECU7WUFCzeO6/H4ygOxhF57d2Ri/HNiEziYZBGpGVHJklELqNpQmaH5j3qH7kP+ZvAme+TOUmilPyWmXwhvWNKOio67MRhz0Ry2MBhTgN3OIXtrwAAAP//FR7g24AEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:47.336242825 -0800 PST", "maxElapsedTime": "59.138886ms", "maxServiceTime": "36.868807ms", "minElapsedTime": "490.01µs", "minServiceTime": "421.557µ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": 3683 } }, { "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": "3.399387ms", "avgServiceTime": "3.263753ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkVe32sMpvEUknRAssdjchioIVLuA22JljKrqS/fbJ4SPpOvawSZEcXx/fe87R8QugTs0MZ0meSQ0MgMIcpVtb7BjtrMkKYBcUlJ7hJsjVV7SFMhrYRwparhAY9KNvySAOozi5ShbouDPpY1fPDVAwOVrpjAX2Au/qDXD8vkadIlD4mS5VNrOogY1fg4K1WxqrfnhUbtWTynCBhW91owpXwYW0C3TAYIZzuc4c42LQ6QGFoVVPwD6Vk/Iw4Z8o9PCZp1IDhUd8LoDBuNVyJimcVXrRev+hTbZbcg/n91D9NY4u2+0JlPR1u2t06XLfLJepN+9A2Ht5qO3FvLk+lFZmGWbwX5q6Wjkls6E1D5g6oGCxWGcucWhXRYXGTe6BrWlFbno+5cmXu6AvumI0bVes/oAIAxGcPh2J8PThLjydvjgNiaPbgYj+jgm7XCQXVx4weeO80rXkclL67zcIdxblqroLhVro6g14h3fagMFDYXwUjpOapaOGZvHgWrNWK2lWRyI8bEsKDjc+1MM4GgZxRE49MHIdD24Jj26ijiD1NEp2jP06EqFfjuz8pmZQIXda9r28meSOR6QXjTgZi0HCRdztf/ZZ327J2fmZz3mjfOlj/isAAP//viE9EUUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:49.244808268 -0800 PST", "maxElapsedTime": "63.387533ms", "maxServiceTime": "63.3308ms", "minElapsedTime": "522.358µs", "minServiceTime": "472.948µ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": 41031 } }, { "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": "3.49211ms", "avgServiceTime": "3.349271ms", "encoded_plan": "H4sIAAAAAAAA/6RTcWvbPhD9KuJ+P6gNomzrHwP95zoOmCZLsJ3BSIMj7GuizpE8SS7JWu+zDznxmixrNzYw+HT3dO+94/QIKAtVYpnXFZfAACjcIbeNxlBJq1VlgL2hIGSJ26AWH1EboSSwKwqSbxAYTJJBlORpFmSzNF+hDRtj1Qb19a6P4hIoqBo1t0oDe4T/ng+Q4pcGZYFA4VuxFlWpUQKbn4KCxq6VFl8dqtbiQVS4QuNajYSxHTzjeoUWGJR4x5vKsnCWZpNxlACFqRYPwN63i7Yn+SsVN7hLCy6BwmfcGWAw9zzPsyo3Vgu58v5/65OnJ3ILl7fQRUeld/7LtSvfX0BLT8mGaIv1garmhZv0kSM3+z59MHzWYco1ryqs4J9Mx1JYwaupVvdYWKCg0TSVzS3qjenQuK0d0Fv2+paXyzCPB0u/k/Tr8jBO0uxVxDgeDEbRq5BR8Jse18Eo+BB2TRZnAxby2Va7aN33EyS1GvmmuwtGrGT3LtwUf3QGBvdGuZU4WDpOxIPjkxN7fN776zMtBYtbt7/TJJoGSUT+5F2RYTIZkzQaRWFGHCElBx0u2DO4yHG7/0H1/lo/KTJLI3ITfUrJ/HyZLy4v3O90lV8oXPk+WUD7PQAA//8qXXMrVAQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.252289185 -0800 PST", "maxElapsedTime": "65.987185ms", "maxServiceTime": "65.929449ms", "minElapsedTime": "574.04µs", "minServiceTime": "522.896µ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": 1427 } }, { "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": "ca8666238d5eb92", "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": "ed27864c33f5cc26", "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": "3.890782798s", "avgServiceTime": "3.89066806s", "encoded_plan": "H4sIAAAAAAAA/6SUUU/jOBDHv4o1xwOgqDrao3CWeOCaIIXrNVVacQ+nKvU509SLa2dtB+ii7GdfOaGlbFktC48ej8a/+c/f8wiouM4xz0rJFFCAABbIXGVwoJUzWlqgvwcgVI4Pl6W4QWOFVkB7ASi2QqAwmSaDv7NhdBMNswJdYnI09q91KKwzgjsIQJdomNMG6CP89nyACX6uUHGEAL7ypZC5QQX0v5dJl5VbaiO++KzSiDshsUDrSw2FdU36lJkCHVDIccEq6WgYT6ZpPJhCAGMj7oCe1cEraUkaRulkJ2lWb0jehRp7kSacqR4EwKx/CZ6kAwphnMVh9m8Wh5tgJnKgwNl5v9/v9s7zU/z/z+72sjT6E3LXqP3oW18xs85ucQ3UmQrrAG5xbUvGsSm+7diPZRN+6hQCsCVTtiHGB8ZdWyMAw1SBTXgpiiVQODhpAListnOW+r69qGf1LIDKClUAhcIK8LLuKnCFji93m3874velxswwKVHCh0YyQuswH2pdXmuhPJkUDZz2vlQZl6yyHuPwcJ7PO/Mwi8P5Ebkgh3M978yTrA0cfYxi3xh6xxhJ2rzy0hWYd8/O+3/wXm9xynm3/z5bbB3+uilUo04mtS43hnirT3bl+oFjXqT8onc0fKiPelbvlRfSoYEAuFa5aPXbm/rBydEeV6yEE0yOW90hAIO2ki5zaFYbpUqfaFEu/E9zzGwp9iDUcyUPuc85cQbZCppdZEWhml3sR30MFI6hDsDhg99i4zQaX6YR+cn+JVdp8g+ZRMNoMCXH7Yls/iLJSTwaRSm5TuIRaVUmmiQjkne8KOTiguhO+wvI/RINbi+IXwjfAgAA//8JR5d3PwYAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:56.601702071 -0800 PST", "maxElapsedTime": "9.409958548s", "maxServiceTime": "9.409868741s", "minElapsedTime": "907.111154ms", "minServiceTime": "907.013306ms", "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": 3712 } }, { "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": "3.396334ms", "avgServiceTime": "3.259871ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkVe32MNVvEUknRAssdjchioIVLuA22JljKrqS/fbJ4SPpOvawSZEcXx/fe87R8QugTs0MZ0meSQ0MgMIcpVtb7BjtrMkKYBcUlJ7hJsjVV7SFMhrYRwparhAY9KNvySAOozi5ShbouDPpY1fPDVAwOVrpjAX2Au/qDXD8vkadIlD4mS5VNrOogY1fg4K1WxqrfnhUbtWTynCBhW91owpXwYW0C3TAYIZzuc4c42LQ6QGFoVVPwD6Vk/Iw4Z8o9PCZp1IDhUd8LoDBuNVyJimcVXrRev+hTbZbcg/n91D9NY4u2+0JlPR1u2t06XLfLJepN+9A2Ht5qO3FvLk+lFZmGWbwX5q6Wjkls6E1D5g6oGCxWGcucWhXRYXGTe6BrWlFbno+5cmXu6AvumI0bVes/oAIAxGcPh2J8PThLjydvjgNiaPbgYj+jgm7XCQXVx4weeO80rXkclL67zcIdxblqroLhVro6g14h3fagMFDYXwUjpOapaOGZvHgWrNWK2lWRyI8bEsKDjc+1MM4GgZxRE49MHIdD24Jj26ijiD1NEp2jP06EqFfjuz8pmZQIXda9r28meSOR6QXjTgZi0HCRdztf/ZZ327J2fmZz3mjfOlj/isAAP//cXCydEUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.786575944 -0800 PST", "maxElapsedTime": "70.113133ms", "maxServiceTime": "70.044078ms", "minElapsedTime": "537.002µs", "minServiceTime": "487.44µ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": 40527 } }, { "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": "3.409368ms", "avgServiceTime": "3.274087ms", "encoded_plan": "H4sIAAAAAAAA/6RTXW/aMBT9K9bdpIJkoZY9TPJbRNIJ0QKL3U2IomCFC7gNduaYiq5kv31y+ErXsYdViuT4+vjec46OXwB1amY4S/JMamAAFOYo3dpix2hnTVYAu6Sg9Aw3Qa6+oS2U0cA+UdByhcCgH31PBnEYxUk7WaDjzqSPXT03QMHkaKUzFtgLfDhtgOOPNeoUgcKvdKmymUUNbPwaFKzd0lj106Nyq55UhgssfKsbVbgKLqRdoAMGM5zLdeYYF4NODygMrXoC9rmclIcJ/0Whh888lRooPOJzAQzGjYYzSeGs0ovGx3aTbLfkHlr3UP3Vjq6azQmU9HW7a3Tpct8sl6k370DYe3mo7cW8uT6UVmYZZvAuTV2tnJLZ0JoHTB1QsFisM5c4tKuiQuMm98DGtCI3bU158vUu6IuuGE2bFau/IMJABOdPRyI8f7gLT6cvzkPi6HYgon9jwi4XyWXbAyZvnFf6JLmclP77A8KdRbmq7kKhFrp6A97hnTZg8FAYH4XjpHrpqKFePLhWr52U1KsjER62JQWHGx/qYRwNgzgi5x4YuY4Ht4RHN1FHkNM0SnaM/ToSoV+O7PzmxKBC7rTse3kzyR2PSC8acTIWg4SLuNv/4rO+3ZKL1oXPea185WP+OwAA///aALtARQQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:46.973321112 -0800 PST", "maxElapsedTime": "60.302464ms", "maxServiceTime": "58.279489ms", "minElapsedTime": "514.83µs", "minServiceTime": "451.262µ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": 41058 } }, { "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": "ca8666238d5eb92", "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": "11.605409ms", "avgServiceTime": "11.474331ms", "encoded_plan": "H4sIAAAAAAAA/6SU4WvbOhTF/xVxXj80IB6vCa90gn0ItcsMWxKcdBmM4GjSraNVkT1Z7tIV728fdpq0TbdBt4+69/jo3N9FvgM5VWjSWWmlgwA4rkiG2tN54YIvbAXxH4dxmjbD0rwnX5nCQQw4nFwTBEbxPBunUZxmxilPa3JhRJsw9pp8osFRlORlKDzEHf55OGBKX2pyisDxXa2M1Z4cxMenomEdVoU331pV6c2NsZRT1Vq9NVXo5DPpcwoQ0HQlaxtElExnaXI+A8fEmxuIs2bR7C75oxRJO/5USTfAPQsIREmWRNk8S6JdMTMaAkqenZ6e9gdn+n/69Kq/b5a++EwqdPju2mHW0t9m13QLEXxNDcc13ValVNSZ72doOe/K9yOCoyqlq7qgtJEqbD04vHQ5deWVyVcQONoGULbeL84WX7eNhj/IBr+SDdAsmgVHXRmXQyCvTPfhYz4T6aW1ZPFXlC8oqBVeguEwx4WxgTw4VOG02aLG8fHxcuez/HcZZUm07LHX7KjfY9Jpdtie7wWDXu/ZFee2cPSsOqVuJxSyQH693UspQ0v2wH0Uf5hl4+4KcNxIW7cDHZ20lJ+ZOn1ZahlabNIaWT0l8gJOi+bQPDKVkl7/rDUNnuS6C4TK5K77HUC42lqOQJv2rU3SeDJMY/b7188u0vE7djmJhrOY7TKyaTxjj0C0pE/Y/E2cxiy6P/fZcBSx7S66TaD5EQAA//+uDaTKqwQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.917703442 -0800 PST", "maxElapsedTime": "101.581125ms", "maxServiceTime": "101.487771ms", "minElapsedTime": "1.735133ms", "minServiceTime": "1.683383ms", "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": 41065 } }, { "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": "3.396116ms", "avgServiceTime": "3.248484ms", "encoded_plan": "H4sIAAAAAAAA/6STb2+bMBCHv4p1i9REsqqm6f7U77KFTmgUGJBUURMhC66pNcdkxlTdGvbZJyjQ0LV7sUWRYj/3Uzhxzz0AqiRLMY13kitgABRukJtC46dMGZ3JHNgJBaFSvJ/uxAJ1LjIFbEJB8S0CA9e6ir1gZgVxopEb9HSK2hEKgUK2Q81NpoE9wJunC4T4vUCVVJFfya2QqUYF7LofmhbmNtPiZ5XaaXEnJG4wr/7KEbmp4xHXGzTAIMUbXkjDHhtxbNcCCr4Wd8DOy3XZPuaf+lhwWWCYcAUU7qpzDgyur4f1x2RxbrRQm+FgMiL7PVnB8Qrq00HpdPR6bfyX2tloRMnDCjwnnl56czdaASODc0pqNLMce2EFy3hW4/cttsMott0Lr6bjkxbH9mPutAF2C942wJ1ffrSCGp01yGsz4wZ8nU/dyI6WNfzQwHDu+84yvmrD7xregUm5XkNJ++/V55pLiRIobPl9exP5Ftj4vwYWokptlaM2QIFLwauB9cz4hj/yHU/wOa+UbguNUn+0PRN5wnUK5bqsvs+qodHIt1A7l4uNqlcJmCqkpGDwvpLVDyx/Gljk1c0hF4F3SWw3tIKI2G7kkacuh1+sJSWLqTO3Ro8/4TDy4jAKbPdzJeF+T46OjyqRDvDpy3j8Mj6rrOsJ0M2/saiTqBnxYPLcoU6hRrPOsr4snSs9mTuXD3TrbOs24WkRDowfjE/KEZS/AwAA//+S12Dx2QQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:49.260502052 -0800 PST", "maxElapsedTime": "80.923828ms", "maxServiceTime": "80.861681ms", "minElapsedTime": "475.043µs", "minServiceTime": "415.307µ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": 410691 } }, { "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": "502cab3738aba810", "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.510373ms", "avgServiceTime": "13.381127ms", "encoded_plan": "H4sIAAAAAAAA/6SU3W7iOhSFX8VapxdEcisCOmpl6VygkuogUUBQFY06KLjJbnAnOBnH6c9UmWcfxQT6L0Yzd/HO5217rWU/gXSUxRSHeSo1BMBxQ9KWhk4zbU2WFhBtDqVjeujl6pJMoTIN0eXQck0Q6AfDwWUw/RImZEd0PzYxGXBkORlpMwPxhH+eB5jR95J0ROD4Ga1UGhvSEFevoV5pV5lRP2oqN+pOpZRQUbcaqsI6/EKahCwEYrqRZWrFKJiH42k/mIJjYtQdxHG1qLar/NE2fgsa1NLMIqm74IiyOzIFxNXmi7Vay92+lkfL0Tgch4P+0vO27AdEfy8xf0esycqXmHe0VHGNLBrvINC0drPRlEMVQ+DfdieS193j7om8lid+e/c3N9ktRdY5XkfFmsfwGz3WB2xzn3dqfetxLqM6Ci8tSNVa1fb42CRlyzR2gaPIpS6cnPQgIwthTUkcRuqEXFnpKC03cWtzpNk9BFqHvoeKP2GlkhUEDny32R3Y3YIH/ius8xnWQbWoFhxloXQCgaRQbuJLiyfSyDSlFH+VpjOVWnc1okzHaiMqWq3Wnhyw/9iB7zGpY/YpOn9GO17D1kqxr2W73Y3YnjB63rsjD7SySqaTTQDAYagoUxtaMuutaXkN7st5fQff6qCfG1eL6j0xdNnh2yV8R71hZtaQXLv2KFSi3ZtV+9KsDYHbItOoOCw91EmcTINJbxqwjx4sdjYdn7NZMAxOL1jTYVPbHYvN/w+mAWuMca6w3qjPGvmd9tuCm+60J3bos+HgfHDBfFS/AgAA///XE02ubwUAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:50.17245927 -0800 PST", "maxElapsedTime": "124.88631ms", "maxServiceTime": "124.823122ms", "minElapsedTime": "785.811µs", "minServiceTime": "737.712µ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": 36770 } }, { "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": "ca8666238d5eb92", "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": "9.010979ms", "avgServiceTime": "8.876321ms", "encoded_plan": "H4sIAAAAAAAA/6RUX0+cThT9KuT8fHCTyS9dTK2dpA9kwZRELdklNdps2Clc2VF2oMNgtYZ+9gZG3HW19l/CA/few+HccyZzB1JpmVGWVIVQ4ADDBQnTaJqUyuiyqMFfMUiV0Y1XyY+ka1kq8D0GJVYEjsg7Ow5O4iQn48vaaJkaMJQVaWFKDX6H/9YFZvSlIZUSGL6nS1lkmhT4p8cgrzHLUstvHarS8loWlFPdUR3J2vTwWOicDDgyuhBNYbgfzuJpOInBEGl5Df6mnbfDT/5KRdjtPEuF2sO9AeDwwyT0k9Mk9IdmIjNwpOJgf3/f3TvIXtPnt+7DsNLlJaWm9+yuW2Yl9G1yRbfgRjfUMlzRbV2JlHryhx06c4f2/YpgqCuh6l4o3YjUWA4GLVROfXsp8yU4dqyAtGge0irKr3bQsjVs/DPYGO28nTM0tVQ5OPJa9h9u+nNIJl3iTxbYZoiEFkVBBf4pp0NZGNJgSEuVSWs1dnd3F4Oaxf8LG9li5LxzdsYjR6jM2QYMY3c0eiI0VNJIUUQ2TDBoqpvCJIb0asij6oBbnCfecbCwdM8DZvE0COJk/Dsg90XQJIzPfsHixS+LOQ+jbj5/ErRU693beds9W5CZ0SRW/beoZa76G6RL0woDx2VdKjBYTzbrXtfjhvXkmZ672TsPo6FsGQzddNdBNA0ibxo4z9xKzuH0w7EzC46CSexYHcxZ/27j3e3eO92258U98DyMLMVgmnP6PpgGjj1b/clyvBPf8e8rF+2PAAAA//+7wlPJXwUAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.881636134 -0800 PST", "maxElapsedTime": "83.546278ms", "maxServiceTime": "83.486517ms", "minElapsedTime": "1.211505ms", "minServiceTime": "1.092806ms", "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": 39513 } }, { "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": "c81774a83a06c9b5", "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": "adc5be3b743ce0e8", "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": "16.959596139s", "avgServiceTime": "16.959484267s", "encoded_plan": "H4sIAAAAAAAA/7SVUW/bNhDHvwpxy4MNEIYNt0smIA+ZrG7qXMuQnfahMGSGuircaFIjqSxZ4X32gZTl1rOKFWv2ZvP+Rx3v/zvyI6DiusSyqCVTEAFQ+IDMNQZjrZzR0kI0piBUiY83tXiLxgqtIJpSUGyHEMFqncW/FPPkbTIvKnRxY53eoclMicb++DQT1hnBHVDQNRrmtIHoI3z36Q+s8PcGFUeg8Be/F7I0qCB6fyq6ady9NuJPr6qNeBASK7R+q7mwLsjXzFToIIISP7BGuii+Xa2zN0kOFJZGPEB0uac9siyfJfnqM9Fm31Xyn0pNfbNWnKkpUGAWIuBAgesHNBai9+0vMhhs+Xa0jYt0th0OO8Gn5dmXAu/OAjt0zEeHo60ofWhzcAwiiG+LdBY2C4lwiBSi9HVdTS4vX7CrKRt/z3+4e3mM1kb/itwFqz0jzjwVv+GTL39MJ5tgwY61ixA50+CeghfUjGP46rHzHpNu+dBxoGBrpmzoHD4y7to9KBimKgzLQnHZtKyNKUj9B0SgGinBW3gvqnuI4GISCj4Kp53wYgL7zX5DobFCVRBBZUVI/NymJTNMSpTwTWYv0Dos51rXr7VQ3nApgufaE68KLllj/dkHfbaTa3Jc1tvRNisOgeG3VXWOoO5H8OSjZ0jpXqSyPCScosRK/vIOp3eXL6Ycx3gFJzwcR6yfBhWaWEit646EfwXkwMAXhqmPil5pDyeb/T9ReSWkQxPao0rRjsWZobOjpReT4RltqRJOMPmT0U3tPakqgxVzeLCjUW5QCuuE4o70FRocqHx2N4ibnkJT5dDssBTM4bN+6qwh6pnP8r8M56Hpy/Y2AwoGbSNd4ZvUwVWbgMZXFL3vb0O3u7fj3JGVM8h2IResqFR4W/1hLibhRtvdoYE9BYeP/k1a5snyJk/IV76q5FWevSGrZJ7EaxJnt4v1YJau1ukiXg/4yFc+HLYa0l3JhJN0sUhy8jpLF6QdTKJJtiBtArm+JnrU3gnk3c9JnoTALISIv1n/DgAA//+MB1HANQgAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:45.433219752 -0800 PST", "maxElapsedTime": "21.082197701s", "maxServiceTime": "21.082142107s", "minElapsedTime": "11.122996513s", "minServiceTime": "11.122934625s", "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": 3712 } }, { "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": "3.40967ms", "avgServiceTime": "3.269399ms", "encoded_plan": "H4sIAAAAAAAA/6SSb2+bMBDGv4p1i1SQrGpt1q3zO9SwBa35I6CZoiRCFlxTa47JbBOlS9hnnyCQNFv3ZpOQ8PPcAcc9vx2gSvMMs2QtuQIGQOERuS003uXK6lwaYG8pCJXh1luLCWojcgWsS0HxFQKDsTcd+MM4Ecqgtn1hbK6fgUK+Rs1troHt4M1JQITfC1QpAoWf6ZOQmUYFbHbe5BX2KdfiR9W11mIjJC7RVK+6F8bW7THXS7TAIMNHXkjL+kEUj8IpUBhrsQH2sVyU7Tf+aYgJlwVGKVdAYVOdDTCYzRzHcWyeGKuFWjqdK5fs92QOl3OoTy9K1+7fa13XpWQ3h37iDUYPw3gOjHQ+UFI5d0kvCXq1c906jb5q9dfW6R6cnhd7tb49ar/W7xvd9r876OPzN+ViASU9//Ux11xKlEBhxbetEmYF7Oq/dhqhyoKaFKDApeDVTk/JfcNns+YpnpkVaK3bhP3HwD1hUq4zKBdldf1WjaxGvoIaCCOWqgYcmCqkpGBxW2E0Dv2xF/rkVZ7Jp3A0IMEw8sOYBMN4RJrxnC/+lJKJd//gu4dbRJx4lERxGAw/V3Ts9+Ti8qJK/4V9/brdbZlo8j7F3cR34qHJ7xh/I8/T7dycwdCycCSuBa6Bp3NbulD+CgAA//95EMxMFAQAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.922526094 -0800 PST", "maxElapsedTime": "68.353948ms", "maxServiceTime": "68.299125ms", "minElapsedTime": "499.548µs", "minServiceTime": "447.297µ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": 39513 } }, { "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": "3.300695ms", "avgServiceTime": "3.17105ms", "encoded_plan": "H4sIAAAAAAAA/6SSUWvbMBSF/4q4G9QGEbblYaC34KgQmjbBTjZGGhzh3DrqFMmT5JKu9X77kFOTZGn3sIFBlvT53HOvzxOgLswa13mlhAYGQOEOha8tJkZ7a5QD9oGC1GvcDSr5Ba2TRgPrU9Bii8Dghn/NJ+mQp3mJPqmdN1u0QMFUaIU3FtgTvDtsIMMfNeoCgcKvYiPV2qIGtjiFBrXfGCt/Bqqy8kEqLNEFqbF0vsVnwpbogcEa70StPEvm2WxyzVOgMLXyAdjnZtl0Rf7JxRU+ZoXQQOE7PjpgsIiiKPImd95KXUbvP8bk+ZncQu8W2rejq0/x23f9OF5CQ0+LXaIvNi+lKlGE0R51FIbdHb80fKYwFVYohQr+q+mRll4KNbXmHgsPFCy6Wvnco926lsZdFcBo1flb9VZJPhxlyWR+M1vFrbHXofEg+zuQpHw4apHl2YCkPthqlk14/kAyb1Fs22/ByVK3QQ5T6ISBwb0z4Y8eDB+fBX/dvqHgcRcSNk35dJBy8mrUyWU6uSYZH/NkRg6qlOzVwrqvvQe7bsk84+SKf8vI4jxRF72LsJzm6Y2LfhyTJTS/AwAA//+AT8SDygMAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.915232207 -0800 PST", "maxElapsedTime": "70.609636ms", "maxServiceTime": "70.523629ms", "minElapsedTime": "510.774µs", "minServiceTime": "459.542µ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": 41065 } }, { "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": "8c64c440952bb8f1", "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": "11.771515ms", "avgServiceTime": "11.635051ms", "encoded_plan": "H4sIAAAAAAAA/6RUX2vbPhT9KuL8+pCA+NEm3ugEewi1ywLdEpy2YYzgqPato1WRPVnu2hXvsw/Ladr0D5TtxXB1ju+95xykO5BJi4yypNTSQAAclyRdbemoMM4WuoLY51Amo5tRqc7JVqowEEMOI9cEgTA6GZ9H8dekLjPpaGIzshU4ipKsdIWFuMN/DwVm9KMmkxI4fqcrpTNLBuLbLmlUu1Vh1a+WVVp1rTTlVLWtTlTlPP1U2pwcBDK6lLV2YhKHUTwDx9Sqa4jDZtHcj/irHcat5lkqzRAbAyAwiZNJMg6TsP3Mk3F4jyUqg8Bh+j5Ig2D/w7vBxcXh5cEWLW3xnVLnvbtrJa2lvU2u6BbC2Zoajiu6rUqZkh+yUdJafH+4kQmOqpSm8uvSjUxd14HDSpOTP16pfAWBvYEfn+p6m5kufnZAwx9ow9dowx1a8BotQLNoFhx1pUwOgbxS/sfHZk6llVqTxj9FckwuXeHtXj3d4lhpRxYcaWEy1aWBXq/XW3Ztlv8v23SXffaR7Q36TJqM7YLhFh72X8LnWzzo95/NP9KFoWenM/Kpkksc2XWXbClda/pO76NRHI+j2E8Ax7XUdSt276D1/1lPk535CwkOqZWsHnv1Zv8WzdPGoapSabOXoJmzJNd+GVQqN/4ZgTC11hyObtrLOo2j6SiO2IuvBjuOJ5/Z2TQcnUasW4zNolP2WHpr7QGbf4riiE029YCNvoSsC8dHs6nnmzpA8ycAAP//zksUAukEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:50.254607437 -0800 PST", "maxElapsedTime": "94.812314ms", "maxServiceTime": "94.756933ms", "minElapsedTime": "1.681408ms", "minServiceTime": "1.624541ms", "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": 36763 } }, { "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": "56ef11152b8786bb", "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": "18.60881ms", "avgServiceTime": "18.482442ms", "encoded_plan": "H4sIAAAAAAAA/7RUbW/aPBT9K9F5+oFI1qMB6oss7QMq6YYEBUFbNFUomOQ2eE2czHE6uir77ZNDgNFSTdu6L5Hie+7LOefaTyAVpCGFfhYLBQ4w3JEwhabzVBmdxjn4OwapQlp1MnlDOpepAm8zKJEQOLpev3fjjT/5eZEM+50kLZQBQ5qRFibV4E/4b/eDCX0pSAUEhu/BUsahJgV+uw/qFGaZavnNojItH2RMEeW2VF/mpoJfCR2RAUdId6KIDR+Ou97Y7/cuPTCMtHwAPy1n5abNH83Rs7QngVBt1BqAY9j3h36v63ftZ+r3upuYL0NwHJ/QXbPZPG4tzk7PThaLbTTT6WcKTCXfk6WVCP3o39MjuNEFlQz39JhnIrCq7rGxSm8CNV0w5JlQeTUyrURg1lUYtFARVcdLGS3BcdSsRgjiYmtdnH5dB0q2g7Veg7X2YO3XYG2Us3LGUORSReCIclkl/izoBZlgid9j+rzGSGgRxxTjr6y9kLEhDYYgVaFcu4JGo9GY7waa/z+vzZ67znvnqOk6QoXOAUx3i2m5r4KmW1DbdV/Q6ilppIg/6LTIwCCiSFMkjF37W+RFcqBgZzC8vryauy5mDJFNtOtkE2blrHzZwJBOKJTC0Ft1eW6vVG/H4J/YXqs8Wt9FMGjKi9j4Vpr1ZRK5rXU98LfjgYFWmc3+FYnysCKbbtaUl75MjCaRVLnIZaSq19eS2x+CQxXJgjRKBkMr+/SNxt6oM/acQ0+wczEeDpyJ1/fOr5zJ9aCxreQ6nYmzV3uN3dFyph+9sefUu19tvtO57Dr1oldrvjmY1gdtlD8CAAD//2kqEbVNBgAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:50.228903268 -0800 PST", "maxElapsedTime": "129.716941ms", "maxServiceTime": "129.599595ms", "minElapsedTime": "2.254945ms", "minServiceTime": "2.205207ms", "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": 36763 } }, { "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": "56ef11152b8786bb", "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": "213.656935ms", "avgServiceTime": "213.504866ms", "encoded_plan": "H4sIAAAAAAAA/7RVa2/aSBf+K6PzIhWkEQqQppWlfEDg9HXL2ix2W1UJMhP7xMzGzHhnxt1kU+9vX41twiVUq93t8gHwOc+5PefiJ0CRyBTTuMiZAAeAwh0yUyqcSGGUzDU4ZxS4SPFhXPBPqDSXApwRBcE2CA6EUTD5EM/cT+4sztCERib3E1kKAxRkgYoZqcB5gv/tHiDEX0sUCQKFP5I1z1OFApzrQ9C4NGup+O8WVSj+leeYobauZlybGh4xlaEBB1K8Y2VunGAxdRfxzPNdoDBX/Cs4byp6AlhnvYdZVttU/lGunuUnTJgYAQWmwQEJLWvgQDCLg9ibxlP79Tn2pltdzFNw4PUF3g0Gg9fD27dv3l7c3j5rCyV/wcTUhD9ZDjZMPcb3+AiOUSVWFO7xURcssX04KN32ZqtoSwYKumBC17njA0tM44WCYiLDWrzm2Roc6IzqFJK8bJo9oJDL36ziHCybW9jwEDZ6hg0PYIPvwQZQLaslhVJzkYEDmea14T6zV2iS9T6pf6fkY2fvJRdbX/rQ13YgTjMnhaXdmnW7RsbaKC6ybnclV/1VMKt7uur1yLdv5Ab6N1D/O4HzGlzvRWJzplieYw7/agqveG5QAYVEipQ3cwPd+nOYKbkknUGPMJGSnWr6rBr2jnVBo7spz85GCemMtoDOeSu7JEfYnQu96q/C+OePYz/yoi97Xi5OEOEJbjjL3ylZFrZTWaYwY8bu/TUk9qx0U64NF4khx7TCkkJmDdteXS+rZfUygEG1wZQzgz8qyvHIcvHjKvhPBqVled7cF6CgUJe5iS01zYGoV2TiR3GbHFDAh8La/lUJ1Wk+trFsS152JTQK2aa2Bc0zUb+BbGn7KTggys0tKqgoGHyw53y+cOfjhUu++xIiV4vgJ0JCd+ZOIjIJPvpRd+qFkedPoq7st657PTIOyV6s1mx3YIgknu+7C/I+8PwmHNEk8MkH90tIulEQh9HC8981Pu2W1TfgVf+V/SFH+jbm5/+7C5c8W9RbScb+tBFNW9FwJ7KrtVvCU3K8JJ3zWqH7u6XbrRxUfwYAAP//JoKlU/MHAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:45.045448331 -0800 PST", "maxElapsedTime": "471.38062ms", "maxServiceTime": "471.299913ms", "minElapsedTime": "71.778924ms", "minServiceTime": "71.723564ms", "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": 3712 } }, { "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": "3.730034ms", "avgServiceTime": "3.6003ms", "encoded_plan": "H4sIAAAAAAAA/6RV7W6bShB9FTT3SrElFN04P67EPwJEXcUfCEglJ7EwwhNnUwzuso6SJvTZq1mgXuoEV62ExMzZwzBzZnb3FTBPixWu4m2W5GABmHCPidwJdIpciiIrwfrPBJ6v8Nne8s8oSl7kYJ2bkCcbBAt8ez7xplG8RunsSllsUFy8tBZbgQnFFkUiCwHWK/yzdyDErzvMUwQTvqcPPFsJzMG67ZLsnXwoBP9GrK3gTzzDNZYUasxLqehRItYowYIV3ie7TFrOdRjNJl4AJviCP4H1f7Wo2p/8URZX+BKmSQ4mfMGXEiy4HQwGA1nEpRQ8Xw/+PRsab2/GHZzegbK0pdHw47Xz4XABldn92SXK9KH51TZJSWStIpK9hZuCDyL4iUiyDDP4q6JZziVPMl8Uj5hKMEFguctkLFFsSsXG5y0RB8s2v+Xp0omZuxyqlN5fvmRBGPUyJsx1x14vZWwfiRFGgedF8dnvkEa9JIdF8yNR7Kg/2xvm9677n2bT/gghmzr9DCfwXNavSU2Jx2zSS3NZ6Myup/2xLuyxfSyleeTGzfHQX35zhDhHeK4d2URYHOwYnu/ntFpU9PxCCaXAZKO+hZKvc3XG0bb4WQpY8FgWtMfrnnd8pdwhQlrqKGXY8RspdUzNvw4wV/dosnW/3gw6osnVgWmIdEDNTAegQe0C9SZ5BxvpmNZIHb5hfutWJkh8pkPYDzzfDjzjyL1gXAaziRF6Y8+JDNLANBppyKiLJovkoHebqmaPyKZO1ZgdqQ9umE8vpYZaIBUUU3Vsb1HvyGt7RHYzCmRqNat4e9HVR3Zk1yW0E2pch55x5c1D4/bwYjg5PaFX91r4YOF8ODQWUP0IAAD//xWSRPqbBwAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.664783882 -0800 PST", "maxElapsedTime": "56.398283ms", "maxServiceTime": "56.343749ms", "minElapsedTime": "651.986µs", "minServiceTime": "595.848µ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": 15750 } }, { "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": "3.410425ms", "avgServiceTime": "3.274624ms", "encoded_plan": "H4sIAAAAAAAA/6RTf2vbMBD9KuI2aAKitBt0oP9M7I6QNsksdSOkwRHOJVHrSJ6slHSN99mHnB9212V/bGCQdXq6e+/x9AKoUzPDWZJnUgMDoDBH6dYWO0Y7a7IC2AUFpWe4CXL1FW2hjAb2kYKWKwQG/ehbMojDKE6ukgU67kz62NVzAxRMjlY6Y4G9wLt6Axy/r1GnCBR+pkuVzSxqYOPXoGDtlsaqHx6VW/WkMlxg4VvdqMJVcCHtAh0wmOFcrjPHuBh0ekBhaNUTsE/lpDxM+CcKPXzmqdRA4RGfC2AwbrWcSQpnlV603n9ok+2W3MP5PVR/jaPLdnsCJX3d7hpdutw3y2XqzTsQ9l4eansxb64PpZVZhhn8l6auVk7JbGjNA6YOKFgs1plLHNpVUaFxk3tga1qRm55PefLlLuiLrhhN2xWrPyDCQASnT0ciPH24C0+nL05D4uh2IKK/Y8IuF8nFlQdM3jivdC25nJT++w3CnUW5qu5CoRa6egPe4Z02YPBQGB+F46Rm6aihWTy41qzVSprVkQgP25KCw40P9TCOhkEckVMPjFzHg1vCo5uoI0g9jZIdY7+OROiXIzu/qRlUyJ2WfS9vJrnjEelFI07GYpBwEXf7n33Wt1tydn7mc94oX/qY/woAAP//p0H3DUUEAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:46.86460837 -0800 PST", "maxElapsedTime": "74.270186ms", "maxServiceTime": "74.21888ms", "minElapsedTime": "530.842µs", "minServiceTime": "478.461µ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": 42204 } }, { "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": "d51bc71d375861f6", "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": "13.268598ms", "avgServiceTime": "13.132228ms", "encoded_plan": "H4sIAAAAAAAA/6RUUWvbPBT9K+J+fUhAfCwNbYdhD5ntMkPaBDtbKSM4mn3rqFVkT5K7dsX77UNy4iRtM8r2YpDu0dG55x75CVBmZY55WgkmwQOgcIPM1Ar9UhpVCg3eOwpc5vgwqvgXVJqXErwhBclWCB5M4iCM02Q2mn1O0gLNmGkzUTkqoFBWqJgpFXhP8N92AQl+r1FmCBR+ZUsucoUSvK/7oFFtlqXiPy2qUvyeCyxQW6ox18bBZ0wVaMCDHG9YLYznxCRAYar4PXhnzbzZXPFXGt4Eiqw5ScbkENZOOVvSqzQK0sB+/DQKNrWU51bwyeBbdjbIh2cn708HN6ddtVLlLWbGmfxk+14x9Zje4SN4RtXYULjDR12xrPPetmtnsdlcewEUdMWkdnLxgWWmZaCgmCzQbS95sQQPjgbu+kzU3XBF+aMtNHQLOz4EO96DDQ/BhtDMmzmFWnNZgAeF5u7grpnnaLIlvL3L5+enTDEhUMA/zf2cC+MSnJUy5+00oNfr9RatmMX/i4mb76JPPpCjQZ8wmZP9ctCVj/uv1f2uPuz3X/QRSW44E9M2DkBBoa6FSQ2q1WamlQXucVpGR/Va0R/FcRTGfwaFl7P4OnWIeTNv7APaF7Z524KvuH16Nju6VLvKctTZJmyHVb5gHjvG7sjgZTa43DpixT2rJ0YhWzlm0LyQ7j9m57/bO3hwq0sJFLpmd7e2gIaCwQfb4jQOp6M4JAd/deQ8nlyQJByH/oxYDkp2r7Sr9VUtsvWCXH0KLasLkosRGV0GpE2Oy8167a/Xw/Yg+XjtLiFBmPhkHF1EMzKA5ncAAAD//4n+3OXMBQAA", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.257736902 -0800 PST", "maxElapsedTime": "190.239017ms", "maxServiceTime": "190.152702ms", "minElapsedTime": "1.609249ms", "minServiceTime": "1.552182ms", "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": 3652 } }, { "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": "ca8666238d5eb92", "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": "11.753248ms", "avgServiceTime": "11.599939ms", "encoded_plan": "H4sIAAAAAAAA/6SU4U/bOhTF/xXrPD5QPevpvVYPMUt86EjQKg1WtWEITVXqOZfUw3Uy22EwlP3tUxwKo7BJbJ+q3ntyfe7vyL4FWVUVVOS1kRYC4LggGRpHh5UNrjIe4l8ObQu6Htf6PTmvKwsx4rByTRCYjs+P05Msb+pCBkq0D06r8FoaaRWBo6rJyVA5iFv89fAHc/rcUC/5plbaFI4sxIfHonETVpXTXztV7fSVNlSS70a91T5EeSZdSQECBV3IxgSRTObZbHKYgWPq9BXEfrtoN4f8lotJt/1cSTvCHQoIJJN8kuRn+STZFHNdQEDJ/b29veFov/ifPr4a3jdrV30iFSK9226ZtXQ3+SXdQATXUMtxSTe+lori8PsdOsyb8t2K4PC1tD4apWupQj+Dw0lbUiyvdLmCwE5vWZnmPjdTfekbLX+QDX8mG6JdtAuOxmtbQqD0On74I5+pdNIYMvgjykcU1AovwbDt40ibQA4cqrKF7lFjd3d3uZmz/GfZR7YcsAO2MxwwaQu2Ldi0R4PBkyMOTWXpSXVOMRMKeSC37nOpZejIbs0+z5LlABxX0jQU3T3TZ3+znf8GHfgn59jiNN4zcEijpX8M6QXoFu328ER7JV3xXGseHMl1NASvSxsfCAjbGMMR6Lq7ftNZOh3PUvbL94Adzd4ds9NpMs5StrHI5mnG4urs4O63A8DO3qSzlPWBsZgXG58krAsoxoP2ewAAAP//WoeCX78EAAA=", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.902855264 -0800 PST", "maxElapsedTime": "86.953942ms", "maxServiceTime": "86.869042ms", "minElapsedTime": "1.762301ms", "minServiceTime": "1.685011ms", "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": 39513 } }, { "plan": { "#operator": "Sequence", "~children": [ { "#operator": "Authorize", "privileges": { "List": [ { "Priv": 7, "Target": "default:WAREHOUSE" } ] }, "~child": { "#operator": "Sequence", "~children": [ { "#operator": "IndexScan3", "index": "WH_ID", "index_id": "bed9e03b97436f27", "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": "10.56848ms", "avgServiceTime": "10.440059ms", "encoded_plan": "H4sIAAAAAAAA/6STUWvbPBiF/4o5Xy9aEB/tMlYq2EVoHRLoluBk82AER7Xf2GoVyZPkLlnwfvuQ06RrBoNt4Bu9Oj4+55G1BencFFRktRIaHGBYkvCNpWujvTXKgZ8zSF3Qul/Lj2SdNBq8x6DFisDxPk6zcXITJ1lJPhWWKtM4mol1IjyBwdRkhTcWfIv/nheY0peGdB4k3/NKqsKSBv/8UtRvfGWs/BZUtZWPUlFJLljdSuc7+UzYkjw4ClqKRnme9pN4OP4wjcEwsfIR/LKdt/uv/FWMUag/zYXu4YkFONJhNrrZrzNZgOOOiis6791dXb7uvVm+ujzs1tbcU+47dNvQZCXsJnugDbi3DbUMD7RxtcgD0Z8LBMj7+VNBMLhaaNelpLXI/c6EwQpdUjeuZFmB4+SiS5Cr5nBqynzdbbTzds7QOKlLcJROomUvWw/I5xX+KNqxxURYoRQp/BP+gVSeLBhyowu5o4jT08UhzeL/RZqNbhZn0dvo5OLslxgjLb0UarI7BTBYco3ymSe72nOsg/DYc9b/tDgLqI7RSP1s187b8BxJpt6SWHXvwslSd5cq1O9cwXHvjEbL4Gkdft9JEk/6SRz99j5Fg2T8LprGt/H1LOqMdpND6igdxkkcBRodC7Q/AgAA///yiVFX4wMAAA==", "featuresControl": 0, "indexApiVersion": 3, "lastUse": "2019-11-08 17:17:48.892913756 -0800 PST", "maxElapsedTime": "102.611737ms", "maxServiceTime": "102.563574ms", "minElapsedTime": "1.240199ms", "minServiceTime": "1.170103ms", "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": 41065 } } ]