Re: Troubleshooting a long running delete statement

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "Dirschel, Steve" <steve(dot)dirschel(at)thomsonreuters(dot)com>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Troubleshooting a long running delete statement
Date: 2021-10-06 19:48:45
Message-ID: c73a8eb00330ce5aa0d35e36d99e73fa5f1b6fc9.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dirschel, Steve 2021-10-06 20:26:49 RE: [EXT] Re: Troubleshooting a long running delete statement
Previous Message Justin Pryzby 2021-10-06 19:20:00 Re: Troubleshooting a long running delete statement