On Wed, 2021-10-06 at 18:00 +0000, Dirschel, Steve wrote: > Are there other statistics in Postgres I may have looked at to methodically > come to the conclusion that the problem was the missing index on the parent > FK column?
You could use the query from my article to find the missing indexes: https://www.cybertec-postgresql.com/en/index-your-foreign-key/ Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com