The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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.

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';

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.