Jira (PDB-3611) Fact filter from overview page uses nested loops and times out

[Erik Hansen (JIRA)]

Title: Message Title

Erik Hansen created an issue   PuppetDB / PDB-3611 Fact filter from overview page uses nested loops and times out Issue Type: Bug Affects Versions: PDB 4.4.1 Assignee: Unassigned Created: 2017/07/05 1:18 PM Priority: Normal Reporter: Erik Hansen Attempting to filter the console overview page based on two fact filters causes a timeout in the console. The attempted query was: 2017-07-03 13:49:03.676 UTC [db:pe-puppetdb,sess:595a3ced.c711,pid:50961,vtid:22/490887,tid:0] LOG: duration: 503820.138 ms execute S_826/C_827: WITH inactive_nodes AS (SELECT certname FROM certnames WHERE (deactivated IS NOT NULL OR expired IS NOT NULL)) SELECT certnames.certname AS certname FROM factsets fs LEFT JOIN environments ON fs.environment_id = environments.id LEFT JOIN producers ON fs.producer_id = producers.id LEFT JOIN certnames ON fs.certname = certnames.certname WHERE (((certnames.certname) in ( (SELECT fs.certname AS certname FROM factsets fs INNER JOIN facts f ON fs.id = f.factset_id INNER JOIN fact_paths fp ON f.fact_path_id = fp.id INNER JOIN value_types vt ON f.value_type_id = vt.id LEFT JOIN environments env ON fs.environment_id = env.id WHERE (vt.id <> 5 AND ((fp.path ~ $1 AND fp.path IS NOT NULL) AND (f.value_string = $2)))) ) ) AND ((certnames.certname) in ( (SELECT fs.certname AS certname FROM factsets fs INNER JOIN facts f ON fs.id = f.factset_id INNER JOIN fact_paths fp ON f.fact_path_id = fp.id INNER JOIN value_types vt ON f.value_type_id = vt.id LEFT JOIN environments env ON fs.environment_id = env.id WHERE (vt.id <> 5 AND ((fp.path ~ $3 AND fp.path IS NOT NULL) AND (f.value_string = $4)))) ) )) 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.