Re: Tips on troubleshooting slow DELETE (suspect cascades) - Mailing list pgsql-general

From Tom Lane
Subject Re: Tips on troubleshooting slow DELETE (suspect cascades)
Date
Msg-id 2279939.1705597280@sss.pgh.pa.us
Whole thread Raw
In response to Re: Tips on troubleshooting slow DELETE (suspect cascades)  (Jim Vanns <jvanns@ilm.com>)
List pgsql-general
Jim Vanns <jvanns@ilm.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



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Tips on troubleshooting slow DELETE (suspect cascades)
Next
From: Jim Vanns
Date:
Subject: Re: Tips on troubleshooting slow DELETE (suspect cascades)