Yes, it appeared to be in a transaction. The pg_stat_activity.xact_start was before the query_start. Unfortunately, I don’t have the other queries. (I snapshot pg_stat_activity every minute, so it missed any prior queries to the blocker).
Thanks,
Chris Hoover Senior DBA AWeber.com Cell: (803) 528-2269 Email: chrish@xxxxxxxxxx
On Jun 14, 2024, at 2:16 PM, Ozgur Kulu <kuluozgur@xxxxxxxxx> wrote:
Hi chris,
Is this query in transaction block ? Forgot to mention, this is on PG 16.1
Thanks,
Chris Hoover Senior DBA AWeber.com Cell: (803) 528-2269
All,
We had an outage today that appears to have been caused by a query in "IPC:MessageQueueReceive” wait state blocking another query from completing a truncate.
Is there anyway to figure out what exactly it was waiting on other than an IPC message? I’m trying to get to the true root cause of our outage.
Thanks,
Chris Hoover Senior DBA AWeber.com Cell: (803) 528-2269
|