Re: slow delete

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Tue, Aug 15, 2023 at 4:23 PM Les <nagylzs@xxxxxxxxx> 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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux