0037420: [BUT Issue 3556] Delete in C_import_entry_archive query too long

Description

The following executed query took more than 10 hours in BUT production environment (see attached images of Munin and pg_badger):

DELETE FROM C_Import_Entry_Archive WHERE Created & lt; now () - 30;

Steps To Reproduce

1) Analyze previous query.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0037404

closed

marvintm

[BUT Issue 3556] Delete in C_import_entry_archive query too long

Notes
(0101147) hgbot (developer) 2017-12-19 18:46	Repository: erp/backports/3.0PR17Q4 Changeset: d429c9745916627433e54a1146c2072aa4e5382d Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Tue Dec 19 18:46:40 2017 +0100 URL: http://code.openbravo.com/erp/backports/3.0PR17Q4/rev/d429c9745916627433e54a1146c2072aa4e5382d [^] Fixed issue 37420. Added index to improve performance of C_IMPORT_ENTRY_ARCHIVE deletion. --- M src-db/database/model/tables/C_IMPORT_ENTRY_ARCHIVE.xml ---

(0101238) migueldejuana (developer) 2017-12-22 13:51	Reviewed

Issue History
Date Modified	Username	Field	Change
2017-11-30 10:19	marvintm	Type	defect => backport
2017-11-30 10:19	marvintm	Target Version	=> RR17Q4
2017-12-19 18:46	hgbot	Checkin
2017-12-19 18:46	hgbot	Note Added: 0101147
2017-12-19 18:46	hgbot	Status	scheduled => resolved
2017-12-19 18:46	hgbot	Resolution	open => fixed
2017-12-19 18:46	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/backports/3.0PR17Q4/rev/d429c9745916627433e54a1146c2072aa4e5382d [^]
2017-12-22 13:51	migueldejuana	Review Assigned To	=> migueldejuana
2017-12-22 13:51	migueldejuana	Note Added: 0101238
2017-12-22 13:51	migueldejuana	Status	resolved => closed
2017-12-22 13:51	migueldejuana	Fixed in Version	=> RR17Q4