Re: slow delete

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Les <nagylzs(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: slow delete
Date: 2023-08-16 14:03:49
Message-ID: CAMkU=1yt74r+DM3eHMq=EUUVc03GDgnH013OHLFSUigxSwobEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Aug 15, 2023 at 4:23 PM Les <nagylzs(at)gmail(dot)com> wrote:

{
>
> "Trigger Name": "RI_ConstraintTrigger_a_75463",
>
> "Constraint Name": "fk_pfq_src_product_file",
>
> "Relation": "product_file",
>
> "Time": 11179.429,
>
> "Calls": 90
>
> },
>
...

> The one with fk_pfft_product looks like this, it has about 5000 records in
> it:
>

That constraint took essentially no time. You need to look into the one
that took all of the time,
which is fk_pfq_src_product_file.

Cheers,

Jeff

>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Martin Querleu 2023-08-23 09:19:02 Question regarding writes when locking rows
Previous Message Les 2023-08-16 04:43:05 Re: slow delete