Jira (PDB-3518) idx_certnames_latest_report_id slows filter performance in console overview

[Thomas Kishel (JIRA)]

Title: Message Title

Thomas Kishel created an issue   PuppetDB / PDB-3518 idx_certnames_latest_report_id slows filter performance in console overview Issue Type: Bug Assignee: Unassigned Components: PuppetDB Created: 2017/05/17 12:57 PM Environment: PE 2016.4.3 with index from PDB-3053 : CREATE UNIQUE INDEX CONCURRENTLY idx_certnames_latest_report_id ON certnames(latest_report_id) Priority: Normal Reporter: Thomas Kishel Potential regression ... User with the following amount of data: public | reports | table | pe-puppetdb | 42 GB | public | reports_id_seq | sequence | pe-puppetdb | 8192 bytes | public | resource_events | table | pe-puppetdb | 3736 MB | public | resource_params | table | pe-puppetdb | 31 MB | pe-puppetdb=# select count(*) from resource_events ; count ---------- 10039459 (1 row) Adding the index from PDB-3053 resolved slow/timeout issues in the Console Overview, but created slow/timeout issues when using the "Unresponsive for N+ hours" Filter in the Console Overview. I will post queries, and ask user for EXPLAIN ANALYZE output: with and without the index. 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.