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.