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.
Question
How we can check idle session in vertica?
+1
++ 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';
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
