Re: Tips on troubleshooting slow DELETE (suspect cascades)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jim Vanns <jvanns(at)ilm(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Tips on troubleshooting slow DELETE (suspect cascades)
Date: 2024-01-18 17:01:20
Message-ID: 2279939.1705597280@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jim Vanns <jvanns(at)ilm(dot)com> writes:
> I should have already stated I did begin with EXPLAIN but given they
> don't easily work with (the internals) stored/procedures, it wasn't
> useful in this case.

auto_explain with nested statements enabled might help?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Vanns 2024-01-18 17:03:51 Re: Tips on troubleshooting slow DELETE (suspect cascades)
Previous Message Rob Sargent 2024-01-18 16:53:52 Re: Tips on troubleshooting slow DELETE (suspect cascades)