pg_stat_activity with null wait events and null wait_event_types

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

Browse pgsql-admin by date

  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!