Postgresql version 9.4.4. I'm having an issue. The query never ends: delete from bb_gamelist_league;
No WHERE clause used. There are approx. 227000 rows in that table. Here is the table itself: CREATE TABLE bb_gamelist_league ( id SERIAL NOT NULL , bb_league_id INTEGER NOT NULL , day_number INTEGER, date BIGINT , team_id1 INTEGER , team_id2 INTEGER , score1 SMALLINT , score2 SMALLINT , attended_people INTEGER , is_play_off BOOL , play_off_code VARCHAR(5), game_status BOOL , is_finished BOOL , was_taken_by_gameserv BOOL, taken_by_coordinator_status BOOL, seed TIMESTAMP, managerA_watching BOOL, managerB_watching BOOL, day_period VARCHAR(10), group_number VARCHAR(30), PRIMARY KEY(id) , FOREIGN KEY(bb_league_id) REFERENCES bb_league(id), FOREIGN KEY (team_id1) REFERENCES bb_team_info(id), FOREIGN KEY (team_id2) REFERENCES bb_team_info(id)); There are some indexes on that table: public | bb_gamelist_league | bb_gamelist_league_fkindex1 | | CREATE INDEX bb_gamelist_league_fkindex1 ON bb_gamelist_league USING btree (bb_league_id) public | bb_gamelist_league | bb_gamelist_league_pkey | | CREATE UNIQUE INDEX bb_gamelist_league_pkey ON bb_gamelist_league USING btree (id) Also explain gives the following result: explain delete from bb_gamelist_league; QUERY PLAN -------------------------------------------------------------------------------- Delete on bb_gamelist_league (cost=0.00..6954.63 rows=281363 width=6) -> Seq Scan on bb_gamelist_league (cost=0.00..6954.63 rows=281363 width=6) (2 rows) Explain analyze never ends (because the query itself is never ending). I checked the locks: there are no locks on tables. The CPU is fast enough but "top" command on linux shows 100% load for postgres process. Could you help to resolve the issue?