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

[Rob Browning (Jira)]

Title: Message Title

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   This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.447164.1652199619000.26046.1652200140115%40Atlassian.JIRA.