Jira (PDB-3053) Create Index on certname latest_report_id

[Nick Walker (JIRA)]

Title: Message Title

Nick Walker created an issue   PuppetDB / PDB-3053 Create Index on certname latest_report_id Issue Type: Improvement Affects Versions: PDB 4.1.4 Assignee: Unassigned Components: PuppetDB Created: 2016/09/14 3:05 PM Priority: Normal Reporter: Nick Walker The Problem Event Inspector is incredibly slow with large amounts of nodes. The Solution CREATE UNIQUE INDEX certnames_latest_report_id ON certnames(latest_report_id); Query Plans Before Index ( 5+ mins ) : https://explain.depesz.com/s/1Ev After index ( ~ 8 seconds ): https://explain.depesz.com/s/btLS Add Comment   This message was sent by Atlassian JIRA (v6.4.14#64029-sha1:ae256fe) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.