Postgres drop table (which has no rows) has taken > 20 minutes and isn't finished yet
0
votes
1
answer
135
views
Before executing the
drop table MY_TABLE
, I checked count(*) from MY_TABLE
and verified that the row count is 0.
There exist no foreign key constraints on other tables which reference MY_TABLE. Yet the drop table query has been running for 23 minutes now.
Can someone suggest possible causes?
Asked by Ben R.
(101 rep)
Jun 6, 2024, 09:15 AM
Last activity: Jun 6, 2024, 12:06 PM
Last activity: Jun 6, 2024, 12:06 PM