On Tue, 18 May 2021 at 08:42, <rstan...@exa.co.za> wrote: > Running delete from table1 where id = 48938 the trigger for constraint runs > for 20 seconds > > Event when doing a simple select from table2 where table1_id = 48938 takes > about 8 seconds
Does EXPLAIN show it uses a seq scan for this 8-second SELECT? If so, does it use the index if you SET enable_seqscan TO off; ? If so, how do the costs compare to the seqscan costs? Is random_page_cost set to something sane? Are all the indexes valid? (psql's \d table2 would show you INVALID if they're not.) does: SHOW enable_indexscan; show that index scanning is switched on? David
