Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
concurrent sessions (check active or inactive)
How to check if a session is active or not ?
I'm new to vertica and I'm using this sql statement, but I'm not sure if I'm doing it right ?
any suggestion or sample query ?
select count(*) from sessions where transaction_id > 0 => for active sessions
select count(*) from sessions where transaction_id <= 0 or current_statement =' '
=> for active sessions
regards,
Patrick
I'm new to vertica and I'm using this sql statement, but I'm not sure if I'm doing it right ?
any suggestion or sample query ?
select count(*) from sessions where transaction_id > 0 => for active sessions
select count(*) from sessions where transaction_id <= 0 or current_statement =' '
=> for active sessions
regards,
Patrick
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
select session_id,transaction_id,query from query_profiles where transaction_id in(select transaction_id from sessions)and is_executing='t'
Regards'
Abhishek
The currently executing statement, if any. NULL indicates that no statement is currently being processed.
NULL if the user has just logged in; otherwise the currently running statement or the most recently completed statement.
PS: It's so hard to read documentation
GetSatisfaction - die!