Re: Extremely Slow Cascade Delete Operation - Mailing list pgsql-general

try checking if it is waiting perhaps for something (is locked).

Peek at: (using different connection)
SELECT * FROM pg_stat_activity;
SELECT * FROM pg_locks;

Did you used prepared transactions ?
Try:
SELECT * FROM pg_prepared_xacts ;

Maybe some other transaction is blocking it.


HTH