Here is the SQL code I am running:
Code: Select all
DROP LIBRARY RFunctions CASCADE;
CREATE LIBRARY RFunctions AS '/home/dbadmin/vertica-R-functions.R' LANGUAGE 'R';
CREATE TRANSFORM FUNCTION mmult AS LANGUAGE 'R' NAME 'matrixMultiplyFactory' LIBRARY RFunctions;
SELECT mmult(row_num, col_num, vals) OVER() FROM exp_data;
Here is what I get when I run EXPLAIN on the query:
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------
QUERY PLAN DESCRIPTION:
------------------------------
EXPLAIN SELECT mmult(row_num, col_num, vals) OVER() FROM exp_data;
Access Path:
+-ANALYTICAL [Cost: 146K, Rows: 12M] (PATH ID: 1)
| Analytic Group
| Functions: mmult()
| +---> STORAGE ACCESS for exp_data [Cost: 84K, Rows: 12M] (PATH ID: 2)
| | Projection: public.exp_data_super
| | Materialize: exp_data.row_num, exp_data.col_num, exp_data.vals
------------------------------
-----------------------------------------------
PLAN: BASE QUERY PLAN (GraphViz Format)
-----------------------------------------------
digraph G {
graph [rankdir=BT, label = "BASE QUERY PLAN\nQuery: EXPLAIN SELECT mmult(row_num, col_num, vals) OVER() FROM exp_data;\n\nAll Nodes Vector: \n\n node[0]=v_dbadmin_node0001 (initiator) Up\n", labelloc=t, labeljust=l ordering=out]
0[label = "Root \nOutBlk=[UncTuple(3)]", color = "green", shape = "house"];
1[label = "NewEENode \nOutBlk=[UncTuple(3)]", color = "green", shape = "box"];
2[label = "UserDefined:\nPartitionBy:<NONE>\nOrderBy:<NONE>\nAnalytical Functions:\n mmult(exp_data.row_num, exp_data.col_num, exp_data.vals)\nUnc: Integer(8)\nUnc: Integer(8)\nUnc: Float(8)", color = "green", shape = "box"];
3[label = "StorageUnionStep: exp_data_super\nUnc: Integer(8)\nUnc: Integer(8)\nUnc: Float(8)", color = "purple", shape = "box"];
4[label = "ScanStep: exp_data_super\nrow_num\ncol_num\nvals\nUnc: Integer(8)\nUnc: Integer(8)\nUnc: Float(8)", color = "brown", shape = "box"];
1->0 [label = "V[0] C=3",color = "black",style="bold", arrowtail="inv"];
2->1 [label = "0",color = "blue"];
3->2 [label = "0",color = "blue"];
4->3 [label = "0",color = "blue"];
}
(31 rows)
And here is what I get when I run PROFILE and select the appropriate rows from the execution_engine_profiles table:
Code: Select all
node_name | user_id | user_name | session_id | transaction_id | statement_id | operator_name | operator_id | baseplan_id | path_id | localplan_id | counter_name | counter_tag | counter_value | is_executing
--------------------+-------------------+-----------+-----------------------------------+-------------------+--------------+---------------+-------------+-------------+---------+--------------+--------------------------+-------------+---------------+--------------
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Root | 0 | 0 | -1 | 0 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Root | 0 | 0 | -1 | 0 | memory allocated (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Root | 0 | 0 | -1 | 0 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Root | 0 | 0 | -1 | 0 | rows produced | | 885481 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Root | 0 | 0 | -1 | 0 | input queue wait (us) | | 5242936985 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Root | 0 | 0 | -1 | 0 | clock time (us) | | 2459250 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Root | 0 | 0 | -1 | 0 | execution time (us) | | 2413602 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | NewEENode | 1 | 1 | -1 | 1 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | NewEENode | 1 | 1 | -1 | 1 | memory allocated (bytes) | | 524560 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | NewEENode | 1 | 1 | -1 | 1 | memory reserved (bytes) | | -112295936 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | NewEENode | 1 | 1 | -1 | 1 | rle rows produced | | 885481 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | NewEENode | 1 | 1 | -1 | 1 | rows produced | | 885481 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | NewEENode | 1 | 1 | -1 | 1 | output queue wait (us) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | NewEENode | 1 | 1 | -1 | 1 | clock time (us) | | 5767 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | NewEENode | 1 | 1 | -1 | 1 | execution time (us) | | 5315 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Analytical | 2 | 2 | 1 | 2 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Analytical | 2 | 2 | 1 | 2 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Analytical | 2 | 2 | 1 | 2 | memory allocated (bytes) | | 1049792 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Analytical | 2 | 2 | 1 | 2 | memory reserved (bytes) | | 109101056 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Analytical | 2 | 2 | 1 | 2 | rle rows produced | | 885481 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Analytical | 2 | 2 | 1 | 2 | rows produced | | 885481 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Analytical | 2 | 2 | 1 | 2 | clock time (us) | | 5245292542 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Analytical | 2 | 2 | 1 | 2 | execution time (us) | | 5235045774 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | StorageUnion | 3 | 3 | 2 | 3 | request wait (us) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | StorageUnion | 3 | 3 | 2 | 3 | response wait (us) | | 4049 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | StorageUnion | 3 | 3 | 2 | 3 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | StorageUnion | 3 | 3 | 2 | 3 | memory allocated (bytes) | | 705504 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | StorageUnion | 3 | 3 | 2 | 3 | memory reserved (bytes) | | 3588096 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | StorageUnion | 3 | 3 | 2 | 3 | rle rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | StorageUnion | 3 | 3 | 2 | 3 | rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | StorageUnion | 3 | 3 | 2 | 3 | clock time (us) | | 64539 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | StorageUnion | 3 | 3 | 2 | 3 | execution time (us) | | 54717 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | bytes read from disk | | 1868217 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | bytes read from cache | | 5706144 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | rows processed | | 346730 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | memory allocated (bytes) | | 919128 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | rle rows produced | | 346730 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | rows produced | | 346730 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | clock time (us) | | 39912 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 15 | 4 | 2 | 4 | execution time (us) | | 37434 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | bytes read from disk | | 5697208 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | bytes read from cache | | 3473408 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | memory allocated (bytes) | | 1082968 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | clock time (us) | | 105988 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 14 | 4 | 2 | 4 | execution time (us) | | 102360 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | bytes read from disk | | 6796640 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | bytes read from cache | | 1703936 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | memory allocated (bytes) | | 1082968 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | clock time (us) | | 121878 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 13 | 4 | 2 | 4 | execution time (us) | | 119521 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | bytes read from disk | | 6356157 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | bytes read from cache | | 2359296 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | memory allocated (bytes) | | 1082968 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | clock time (us) | | 116006 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 12 | 4 | 2 | 4 | execution time (us) | | 112868 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | bytes read from disk | | 4052471 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | bytes read from cache | | 19267584 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | memory allocated (bytes) | | 1017432 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | clock time (us) | | 92463 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 11 | 4 | 2 | 4 | execution time (us) | | 88464 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | bytes read from disk | | 6736766 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | bytes read from cache | | 1966080 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | memory allocated (bytes) | | 1082968 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | clock time (us) | | 124526 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 10 | 4 | 2 | 4 | execution time (us) | | 119726 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | bytes read from disk | | 5959440 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | bytes read from cache | | 2949120 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | memory allocated (bytes) | | 1082968 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | clock time (us) | | 112291 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 9 | 4 | 2 | 4 | execution time (us) | | 107562 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | bytes read from disk | | 6549553 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | bytes read from cache | | 2031616 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | memory allocated (bytes) | | 1082968 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | clock time (us) | | 120650 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 8 | 4 | 2 | 4 | execution time (us) | | 116774 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | bytes read from disk | | 4707246 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | bytes read from cache | | 18350080 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | memory allocated (bytes) | | 1017432 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | clock time (us) | | 100613 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 7 | 4 | 2 | 4 | execution time (us) | | 96575 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | bytes read from disk | | 5744301 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | bytes read from cache | | 3342336 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | memory allocated (bytes) | | 1082968 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | clock time (us) | | 112658 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 6 | 4 | 2 | 4 | execution time (us) | | 107773 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | bytes read from disk | | 6731657 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | bytes read from cache | | 1769472 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | memory allocated (bytes) | | 1082968 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | clock time (us) | | 124751 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 5 | 4 | 2 | 4 | execution time (us) | | 120267 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | bytes read from disk | | 6784965 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | bytes read from cache | | 1572864 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | rows pruned by valindex | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | rows processed | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | estimated rows produced | | 11881066 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | file handles | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | memory allocated (bytes) | | 1074776 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | memory reserved (bytes) | | 0 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | rle rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | rows produced | | 1048576 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | clock time (us) | | 125606 | f
v_dbadmin_node0001 | 45035996273704962 | dbadmin | vise3.csail.mit.edu-17090:0x28fb4 | 45035996273788846 | 2 | Scan | 4 | 4 | 2 | 4 | execution time (us) | | 121846 | f
(176 rows)
Any help would be much appreciated!