|
|
|
|
|
|
VT_QUERY_METRICS monitors the sessions and queries executing 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 |
|
ACTIVE_USER_SESSIONS |
an INTEGER value containing the number of active user sessions (connections). |
|
ACTIVE_SYS_SESSIONS |
an INTEGER value containing the number of active system sessions (connections). What is a system session? |
|
TOTAL_USER_SESSIONS |
an INTEGER value containing the total number of user sessions |
|
TOTAL_SYS_SESSIONS |
an INTEGER value containing the total number of system sessions. |
|
TOTAL_ACTIVE_SESSIONS |
an INTEGER value containing the total number of active user and system sessions. |
|
TOTAL_SESSIONS |
an INTEGER value containing the total number of user and system sessions. |
|
QUERIES_CURRENTLY_RUNNING |
an INTEGER value containing the number of queries currently running |
|
TOTAL_QUERIES_EXECUTED |
an INTEGER value containing the total number of queries executed |
|
When do the totals get reset? Startup? Never?
Example
=> \pset expanded
=> SELECT * FROM VT_QUERY_METRICS;
-[ RECORD 1 ]-------------+--------------------
timestamp | 2007-12-05 23:45:48
node | site01
active_user_sessions | 1
active_sys_sessions | 2
total_user_sessions | 20
total_sys_sessions | 81
total_active_sessions | 3
total_sessions | 3
queries_currently_running | 0
total_queries_executed | 132
-[ RECORD 2 ]-------------+--------------------
timestamp | 2007-12-05 23:45:48
node | site02
active_user_sessions | 0
active_sys_sessions | 3
total_user_sessions | 0
total_sys_sessions | 327
total_active_sessions | 3
total_sessions | 3
queries_currently_running | 0
total_queries_executed | 0
-[ RECORD 3 ]-------------+--------------------
timestamp | 2007-12-05 23:45:48
node | site03
active_user_sessions | 0
active_sys_sessions | 3
total_user_sessions | 0
total_sys_sessions | 327
total_active_sessions | 3
total_sessions | 3
queries_currently_running | 0
total_queries_executed | 0
-[ RECORD 4 ]-------------+--------------------
timestamp | 2007-12-05 23:45:48
node | site04
active_user_sessions | 0
active_sys_sessions | 3
total_user_sessions | 0
total_sys_sessions | 327
total_active_sessions | 3
total_sessions | 3
queries_currently_running | 0
total_queries_executed | 0
node