Sample Header Ad - 728x90

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