|
|
|
|
|
|
VT_COLUMN_STORAGE monitors the amount of disk storage used by each column of 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 |
COLUMN |
a VARCHAR value containing a projection column name |
NUM_ROWS |
an INTEGER value containing the number of rows in the column (cardinality) |
NUM_BYTES |
an INTEGER value containing the disk storage allocation of the column in bytes |
PROJECTION_NAME |
a VARCHAR value containing the projection name |
TABLE |
a VARCHAR value containing the associated table name |
Example
=> \pset expanded
=> SELECT * FROM VT_COLUMN_STORAGE;
-[ RECORD 1 ]---+------------------------------------------------
timestamp | 2007-12-05 23:40:11
node | site01
column_name | c0_cdr_summary_partition_id
num_rows | 124437
num_bytes | 182910
projection_name | p_12_cdr_summary
table | cdr_summary
-[ RECORD 2 ]---+------------------------------------------------
timestamp | 2007-12-05 23:40:11
node | site01
column_name | c100_cdr_summary_redirect_line
num_rows | 124437
num_bytes | 8070
projection_name | p_12_cdr_summary
table | cdr_summary
-[ RECORD 3 ]---+------------------------------------------------
timestamp | 2007-12-05 23:40:11
node | site01
column_name | c101_cdr_summary_redirect_int_num
num_rows | 124437
num_bytes | 17611
projection_name | p_12_cdr_summary
table | cdr_summary
-[ RECORD 4 ]---+------------------------------------------------
timestamp | 2007-12-05 23:40:11
node | site01
column_name | c102_cdr_summary_redirect_natr_addr_ind
num_rows | 124437
num_bytes | 124514
projection_name | p_12_cdr_summary
table | cdr_summary
-[ RECORD 5 ]---+------------------------------------------------
timestamp | 2007-12-05 23:40:11
node | site01
column_name | c103_cdr_summary_orig_redirect_reason_cd
num_rows | 124437
num_bytes | 16753
projection_name | p_12_cdr_summary
table | cdr_summary
node