Connected to : http://127.0.0.1:8093/. Type Ctrl-D or \QUIT to exit. Path to history file for the shell : /root/.cbq_history cbq> { "requestID": "e5f69163-4505-4d44-be31-f1b631a47881", "signature": "json", "results": [ { "elapsedTime": "57m26.476359472s", "executionTime": "57m26.476307434s", "node": "172.23.100.121:8091", "phaseOperators": { "authorize": 1 }, "phaseTimes": { "authorize": "300.296029ms", "instantiate": "837.061µs", "parse": "470.139283ms", "plan": "6.532µs" }, "preparedName": "ORDER_STATUS_getLastOrder", "preparedText": "PREPARE ORDER_STATUS_getLastOrder FROM SELECT O_ID, O_CARRIER_ID, O_ENTRY_D FROM default:default.tpcc.ORDERS WHERE O_W_ID = $1 AND O_D_ID = $2 AND O_C_ID = $3 ORDER BY O_ID DESC LIMIT 1", "remoteAddr": "172.23.100.129:35846", "requestId": "e164c8f9-d5e1-4104-8336-babc2b17c228", "requestTime": "2021-01-24T09:59:10.184-08:00", "scanConsistency": "unbounded", "state": "timeout", "statement": "EXECUTE ORDER_STATUS_getLastOrder", "transactionElapsedTime": "57m29.3158286s", "txid": "3d3e387f-4afa-4099-9e3a-26f5ed423492", "useCBO": true, "userAgent": "python-requests/2.24.0", "users": "Administrator" }, { "elapsedTime": "51m21.066388208s", "executionTime": "51m20.932016285s", "node": "172.23.100.121:8091", "phaseOperators": { "authorize": 1 }, "phaseTimes": { "authorize": "437.036467ms", "instantiate": "20.584µs", "parse": "356.874879ms", "plan": "5.13µs" }, "preparedName": "NEW_ORDER_createOrder", "preparedText": "PREPARE NEW_ORDER_createOrder FROM INSERT INTO default:default.tpcc.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})", "remoteAddr": "172.23.100.129:43058", "requestId": "df33193c-91e7-4383-878b-56eb05fd3657", "requestTime": "2021-01-24T10:05:15.594-08:00", "scanConsistency": "unbounded", "state": "timeout", "statement": "EXECUTE NEW_ORDER_createOrder", "transactionElapsedTime": "51m23.504810628s", "txid": "d98bc607-2542-4689-a155-161cf9d8866e", "useCBO": true, "userAgent": "python-requests/2.24.0", "users": "Administrator" }, { "elapsedTime": "7.822976ms", "executionTime": "7.703467ms", "node": "172.23.100.121:8091", "phaseCounts": { "fetch": 16, "primaryScan": 8 }, "phaseOperators": { "authorize": 1, "fetch": 1, "primaryScan": 1 }, "phaseTimes": { "authorize": "25.739µs", "fetch": "16.736µs", "instantiate": "41.346µs", "parse": "778.796µs", "plan": "148.056µs", "primaryScan": "6.482451ms" }, "remoteAddr": "127.0.0.1:59260", "requestId": "e5f69163-4505-4d44-be31-f1b631a47881", "requestTime": "2021-01-24T10:56:36.653-08:00", "scanConsistency": "unbounded", "state": "running", "statement": "select raw s from system:active_requests s;", "useCBO": true, "userAgent": "Go-http-client/1.1 (CBQ/2.0)", "users": "Administrator" }, { "elapsedTime": "58m57.70560609s", "executionTime": "58m57.705190109s", "node": "172.23.100.121:8091", "phaseOperators": { "authorize": 1 }, "phaseTimes": { "authorize": "1.039696043s", "instantiate": "398.962µs", "parse": "109.94µs", "plan": "3.838µs" }, "preparedName": "PAYMENT_getWarehouse", "preparedText": "PREPARE PAYMENT_getWarehouse FROM SELECT W_NAME, W_STREET_1, W_STREET_2, W_CITY, W_STATE, W_ZIP FROM default:default.tpcc.WAREHOUSE WHERE W_ID = $1", "remoteAddr": "172.23.100.129:59528", "requestId": "ae10f8ae-b121-47cd-aa0f-96fc45bd963a", "requestTime": "2021-01-24T09:57:38.955-08:00", "scanConsistency": "unbounded", "state": "timeout", "statement": "EXECUTE PAYMENT_getWarehouse", "transactionElapsedTime": "58m58.150290513s", "txid": "2a8292ba-b139-4ce1-8ca9-b02876932191", "useCBO": true, "userAgent": "python-requests/2.24.0", "users": "Administrator" }, { "elapsedTime": "57m26.680780347s", "executionTime": "57m26.675014896s", "node": "172.23.100.121:8091", "phaseOperators": { "authorize": 1 }, "phaseTimes": { "authorize": "298.105338ms", "instantiate": "16.974µs", "parse": "671.68257ms", "plan": "6.473µs" }, "preparedName": "NEW_ORDER_getItemInfo", "preparedText": "PREPARE NEW_ORDER_getItemInfo FROM SELECT I_PRICE, I_NAME, I_DATA FROM default:default.tpcc.ITEM USE KEYS [to_string($1)]", "remoteAddr": "172.23.100.129:33236", "requestId": "b2e3f89c-235c-42c8-97f5-ca492a00c9ca", "requestTime": "2021-01-24T09:59:09.98-08:00", "scanConsistency": "unbounded", "state": "timeout", "statement": "EXECUTE NEW_ORDER_getItemInfo", "transactionElapsedTime": "57m29.491763666s", "txid": "4f3060c3-1e1a-4000-a5c4-bdc21c3f026e", "useCBO": true, "userAgent": "python-requests/2.24.0", "users": "Administrator" }, { "elapsedTime": "57m26.646241351s", "executionTime": "57m26.646179905s", "node": "172.23.100.121:8091", "phaseOperators": { "authorize": 1 }, "phaseTimes": { "authorize": "299.475894ms", "instantiate": "12.068µs", "parse": "641.38223ms", "plan": "3.783µs" }, "preparedName": "NEW_ORDER_getItemInfo", "preparedText": "PREPARE NEW_ORDER_getItemInfo FROM SELECT I_PRICE, I_NAME, I_DATA FROM default:default.tpcc.ITEM USE KEYS [to_string($1)]", "remoteAddr": "172.23.100.129:35198", "requestId": "0cdef36e-819c-4d2c-bc66-f974a7a8f835", "requestTime": "2021-01-24T09:59:10.015-08:00", "scanConsistency": "unbounded", "state": "timeout", "statement": "EXECUTE NEW_ORDER_getItemInfo", "transactionElapsedTime": "57m29.315546941s", "txid": "5bfbff42-bd0f-49d3-9939-431af11a85fa", "useCBO": true, "userAgent": "python-requests/2.24.0", "users": "Administrator" }, { "elapsedTime": "53m11.909523312s", "executionTime": "53m11.909477766s", "node": "172.23.100.121:8091", "phaseOperators": { "authorize": 1 }, "phaseTimes": { "authorize": "35.465855ms", "instantiate": "54.742µs", "parse": "240.103903ms", "plan": "4.8µs" }, "preparedName": "PAYMENT_getDistrict", "preparedText": "PREPARE PAYMENT_getDistrict FROM SELECT D_NAME, D_STREET_1, D_STREET_2, D_CITY, D_STATE, D_ZIP FROM default:default.tpcc.DISTRICT WHERE D_W_ID = $1 AND D_ID = $2", "remoteAddr": "172.23.100.129:39992", "requestId": "f24965c7-6b23-4538-b650-e34a83478cb8", "requestTime": "2021-01-24T10:03:24.751-08:00", "scanConsistency": "unbounded", "state": "timeout", "statement": "EXECUTE PAYMENT_getDistrict", "transactionElapsedTime": "53m14.691004106s", "txid": "1c9c8659-8e44-44cd-ad40-81bb3c468419", "useCBO": true, "userAgent": "python-requests/2.24.0", "users": "Administrator" }, { "elapsedTime": "51m21.071104393s", "executionTime": "51m21.071072278s", "node": "172.23.100.121:8091", "phaseOperators": { "authorize": 1 }, "phaseTimes": { "authorize": "346.173479ms", "instantiate": "326.033312ms", "parse": "240.879961ms", "plan": "4.396µs" }, "preparedName": "NEW_ORDER_4_getStockInfo", "preparedText": "PREPARE NEW_ORDER_4_getStockInfo FROM SELECT S_QUANTITY, S_DATA, S_YTD, S_ORDER_CNT, S_REMOTE_CNT, S_DIST_04 FROM default:default.tpcc.STOCK USE KEYS [TO_STRING($2)|| '.' || TO_STRING($1)]", "remoteAddr": "172.23.100.129:42972", "requestId": "ada5ea93-45bf-45a6-812c-0cf3117319fd", "requestTime": "2021-01-24T10:05:15.59-08:00", "scanConsistency": "unbounded", "state": "timeout", "statement": "EXECUTE NEW_ORDER_4_getStockInfo", "transactionElapsedTime": "51m23.602636226s", "txid": "90a1445d-1e60-4a5b-b5fb-51c76f15a102", "useCBO": true, "userAgent": "python-requests/2.24.0", "users": "Administrator" } ], "status": "success", "metrics": { "elapsedTime": "8.602048ms", "executionTime": "8.481825ms", "resultCount": 8, "resultSize": 8930, "serviceLoad": 3 } } cbq>