From: | Hotmail <crajac66(at)hotmail(dot)com> |
---|---|
To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | pg_stat_activity with null wait events and null wait_event_types |
Date: | 2021-04-01 17:28:55 |
Message-ID: | SN6PR06MB4030890994815AFD3D01E2CFD77B9@SN6PR06MB4030.namprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All,
We have a testing scenario where we see large number of active sessions in pg_stat_activity ( >100) and the wait_event and wait_event_type columns for these active sessions in pg_stat_activity are all null.
Is it safe to assume that if a session is active in pg_stat_activity and has NULL a wait_event and a NULL wait_event_type that the session is on the CPU?
I’m asking because in our testing we are observing a significant number of active sessions in pg_stat_activity with NULL wait_events and NULL wait_event_types and when we look at the corresponding OS process for these active sessions we observe that they are in a sleep state.
Is there anything we can do to understand what is happening when sessions are active with null wait_events in pg_stat_activity but the corresponding OS processes are sleeping?
Regards,
Craig Jackson
From | Date | Subject | |
---|---|---|---|
Next Message | SASIKUMAR Devaraj | 2021-04-02 12:37:43 | Re: work_mem |
Previous Message | David G. Johnston | 2021-04-01 14:06:24 | Re: FATEL Role error! |