Jira (PDB-5495) Investigate observed slow/expensive environment gc query

[Rob Browning (Jira)]

Rob Browning created an issue

PuppetDB / PDB-5495 Investigate observed slow/expensive environment gc query Issue Type: Task Assignee: Unassigned Components: PuppetDB Created: 2022/05/10 9:20 AM Priority: Normal Reporter: Rob Browning Add Comment

This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d)

[Rob Browning (Jira)]

Rob Browning updated an issue

PuppetDB / PDB-5495 Investigate observed slow/expensive environment gc query

Change By: Rob Browning While evaluating an escalation, this was noticed in the logs: {code} LOG:  duration: 37777.734 ms  execute <unnamed>: DELETE FROM environments WHERE ID NOT IN          (SELECT environment_id FROM catalogs WHERE environment_id IS NOT NULL             UNION SELECT environment_id FROM reports                     WHERE environment_id IS NOT NULL             UNION SELECT environment_id FROM factsets                     WHERE environment_id IS NOT NULL) LOG:  temporary file: path "pg_tblspc/16400/PG_11_...", size 127286260 {code} This ticket's a reminder to evaluate whether that's actually the query we want, e.g. union vs union all, etc.

Add Comment

[Rob Browning (Jira)]

Rob Browning updated an issue

PuppetDB / PDB-5495 Investigate observed slow/expensive environment gc query Change By: Rob Browning

While evaluating an escalation, this was noticed in the logs: {code} LOG:  duration: 37777.734 ms  execute <unnamed>: DELETE FROM environments WHERE ID NOT IN          (SELECT environment_id FROM catalogs WHERE environment_id IS NOT NULL             UNION SELECT environment_id FROM reports                     WHERE environment_id IS NOT NULL             UNION SELECT environment_id FROM factsets                     WHERE environment_id IS NOT NULL) LOG:  temporary file: path "pg_tblspc/16400/PG_11_...", size 127286260 {code}

This ticket's a reminder to evaluate whether that's actually the query we want, e.g. {{ union }} vs {{ union all }} , etc.

Add Comment