database - PostgreSQL query won't finish on StandBY server

Question

We have a Primary-Stanby setup on PostgreSQL 12.1. A DELETE query is run on the primary server (which takes time but finishes completely) however the same query does not finish (and runs like forever):

DELETE FROM EVENTS
WHERE Event_Type_ID != 2
AND last_update_time <= '2020-11-04'
AND Event_ID NOT IN ( SELECT DISTINCT Event_ID FROM Event_Association )
AND Event_ID NOT IN ( SELECT DISTINCT Event_ID FROM EVENTS WHERE Last_Update_Time > '2020-11-14');

The execution plan is as follows (replacing delete with select query for the same): https://explain.depesz.com/s/GZp7

There is a INDEX created on EVENTS.Event_ID and Event_Association.Event_ID however the delete query still won't finish on the standby server. The EVENTS table has more than 2 million rows and the Event_Association table has more than 300,000 rows.

Can someone help me resolve this issue?

Thanks

Answer 1

等待大神答复