|
|
|
|
|
|
VT_PROJECTION_STORAGE monitors the amount of disk storage used by each projection on each node.
Column Name |
Description |
TIMESTAMP |
a VARCHAR value containing the Linux system time of query execution in a format that can be used as a Date/Time Expression. |
NODE |
a VARCHAR value containing the name of the |
PROJECTION_NAME |
a VARCHAR value containing the name of the projection |
NUM_COLUMNS |
an INTEGER value containing the number of columns in the projection |
NUM_ROWS |
an INTEGER value containing the number of rows in the projection |
NUM_BYTES |
an INTEGER value containing the number of bytes of disk storage used by the projection |
TABLE_NAME |
a VARCHAR value containing associated table name |
Example
=> \pset expanded
=> SELECT * FROM VT_PROJECTION_STORAGE;
-[ RECORD 1 ]---+-----------------------------
timestamp | 2007-12-05 23:44:00
node | site01
projection_name | p_12_cdr_summary
num_columns | 195
num_rows | 124437
num_bytes | 22715067
table_name | cdr_summary
-[ RECORD 2 ]---+-----------------------------
timestamp | 2007-12-05 23:44:00
node | site01
projection_name | p_13_cdr_summary
num_columns | 195
num_rows | 115357
num_bytes | 20107846
table_name | cdr_summary
-[ RECORD 3 ]---+-----------------------------
timestamp | 2007-12-05 23:44:00
node | site01
projection_name | p_1_lerg6_called
num_columns | 12
num_rows | 27000
num_bytes | 329214
table_name | lerg6_called
-[ RECORD 4 ]---+-----------------------------
timestamp | 2007-12-05 23:44:00
node | site01
projection_name | p_0_lerg6_calling
num_columns | 12
num_rows | 27000
num_bytes | 329146
table_name | lerg6_calling
-[ RECORD 5 ]---+-----------------------------
timestamp | 2007-12-05 23:44:00
node | site01
projection_name | p_2_lerg6_charge
num_columns | 12
num_rows | 27000
num_bytes | 329188
table_name | lerg6_charge
node