Relationship between query_metrics and sessions system tables?

Hi Rupendra,

I believe both tables show different data.
sessions - SESSIONS Monitors external sessions.
Query_Metrics - Monitors the sessions and queries running on each node.


So Query_metrics table actually shows the sessions opened by Vertica itself to distribute the queries and run on different nodes.

So lets say you execute a query on node 1 (initiator) , Vertica will distribute this query to node 2 and node 3 , so you should see three sessions in total one on each node in query metrics table.

But sessions table records the user sessions
try checking the Client type column in sessions table.
it can JDBC / ODBC / vsql. So it is actually Client connections(sessions) to Vertica.

In short if you want to check the total ACTIVE_SESSION_COUNT , you can check it from  

SELECT node_name, COUNT(distinct(session_id)) FROM sessions GROUP BY node_name;

Hope this helps.

Thanks Navin for the reply. This is helpful.

I was reluctant to use sessions table was because of the fact that the monitoring user needs to be in dbadmin or superuser roles to see other users' session information in this table.