|
|
|
|
|
|
VT_RESOURCE_USAGE monitors system resource management 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 |
NUM_REQUESTS |
an INTEGER value containing the cumulative number of requests for threads, file handles, and memory (in kilobytes). |
NUM_LOCAL_REQUESTS |
an INTEGER value containing the cumulative number of local requests |
CURRENT_REQ_QUE_DEPTH |
an INTEGER value containing the current request queue depth |
CURRENT_NUM_ACTIVE_THREADS |
an INTEGER value containing the current number of active threads |
CURRENT_NUM_OPEN_FILE_HANDLES |
an INTEGER value containing the current number of open file handles |
Example
=> \pset expanded
=> SELECT * FROM VT_RESOURCE_USAGE;
-[ RECORD 1 ]-----------------+--------------------
timestamp | 2007-12-26 18:42:55
node | site01
num_requests | 1
num_local_requests | 0
current_req_que_depth | 0
current_num_active_threads | 12
current_num_open_file_handles | 8
-[ RECORD 2 ]-----------------+--------------------
timestamp | 2007-12-26 18:42:55
node | site02
num_requests | 1
num_local_requests | 1
current_req_que_depth | 0
current_num_active_threads | 28
current_num_open_file_handles | 325
-[ RECORD 3 ]-----------------+--------------------
timestamp | 2007-12-26 18:42:55
node | site03
num_requests | 1
num_local_requests | 0
current_req_que_depth | 0
current_num_active_threads | 12
current_num_open_file_handles | 8
-[ RECORD 4 ]-----------------+--------------------
timestamp | 2007-12-26 18:42:55
node | site04
num_requests | 0
num_local_requests | 0
current_req_que_depth | 0
current_num_active_threads | 0
current_num_open_file_handles | 0
node