|
|
|
|
|
|
VT_TABLE_STORAGE monitors the amount of disk storage used by each table 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 |
TABLE_NAME |
a VARCHAR value containing the table name |
NUM_PROJECTIONS |
an INTEGER value containing the number of projections using columns of the table |
NUM_COLUMNS |
an INTEGER value containing the number of columns in the table |
NUM_ROWS |
an INTEGER value containing the number of rows in the table (cardinality) |
NUM_BYTES |
an INTEGER value containing the number of bytes used to store the projections |
Example
=> \pset expanded
=> SELECT * FROM VT_TABLE_STORAGE;
-[ RECORD 1 ]---+----------------------
timestamp | 2007-12-05 23:47:36
node | site01
table_name | cdr_summary
num_projections | 2
num_columns | 195
num_rows | 124437
num_bytes | 42822913
-[ RECORD 2 ]---+----------------------
timestamp | 2007-12-05 23:47:36
node | site01
table_name | lerg6_called
num_projections | 4
num_columns | 12
num_rows | 27000
num_bytes | 329214
-[ RECORD 3 ]---+----------------------
timestamp | 2007-12-05 23:47:36
node | site01
table_name | lerg6_calling
num_projections | 4
num_columns | 12
num_rows | 27000
num_bytes | 329146
-[ RECORD 4 ]---+----------------------
timestamp | 2007-12-05 23:47:36
node | site01
table_name | lerg6_charge
num_projections | 4
num_columns | 12
num_rows | 27000
num_bytes | 329188
-[ RECORD 5 ]---+----------------------
timestamp | 2007-12-05 23:47:36
node | site01
table_name | lerg6_enriched_called
num_projections | 4
num_columns | 12
num_rows | 27000
num_bytes | 329173
node