| From: | Murthy Nunna <mnunna(at)fnal(dot)gov> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Query Spins |
| Date: | 2025-09-01 03:52:10 |
| Message-ID: | DM8PR09MB6677D376F84879E730AAB223B807A@DM8PR09MB6677.namprd09.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
Pg16.10
I have a query which runs fine most of the time. When it runs fine, it spawns parallel workers. In pg_stat_activity, wait_event is blank, state is active and backend_type = "client backend" for the main query. For parallel workers of this query I see wait_event = MessageQueueSend, state is active and backend_type = "parallel worker"
But some times, it has no parallel workers. wait_event is blank, state is active and backend_type =client backend. And it never ends. It takes up lot of CPU. The socket on both server and client server are in ESTABLISHED state (netstat -tulpa | grep <client_port>).
I appreciate any help you can provide.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-09-01 07:52:26 | Re: Query Spins |
| Previous Message | w.Elliott malop | 2025-08-31 05:38:42 |