How we can check idle session in vertica?
In my environment there are too many connections are building. because of that CPU,Disk IO are going on high usage and linux killing the vertica process. Can we some solution so that we can clean the idle session or is it good for us to make grace period?
NOTE: We are using Vertica for reporting purposes.
0
Answers
++ Try the below query to check idle sessions.
select * from sessions where statement_id is null;
++ Check for IDLESESSIONTIMEOUT. If it's not set you can set it by running below command.
SHOW IDLESESSIONTIMEOUT;
SET SESSION IDLESESSIONTIMEOUT '300s';