Jira (PDB-4892) Summary query for catalog_inputs unecessarily slow

[Austin Blatt (Jira)]

Title: Message Title

Austin Blatt created an issue   PuppetDB / PDB-4892 Summary query for catalog_inputs unecessarily slow Issue Type: Improvement Affects Versions: PDB 6.9.1 Assignee: Unassigned Created: 2020/09/14 4:34 PM Priority: Normal Reporter: Austin Blatt The summary query for catalog_inputs unecessarily queries the catalog_inputs table when all of its data is in the certnames table. This results in a summary query that is much more slow than the other groups. 2020-09-11T06:22:53.500Z INFO [sync] --> transferred catalogs (0) from https://uklvasapp715.gdc.standardchartered.com:8081/pdb/query/v4/catalogs in 2,960 ms 2020-09-11T06:23:02.803Z INFO [sync] --> transferred factsets (2) from https://uklvasapp715.gdc.standardchartered.com:8081/pdb/query/v4/factsets in 9,303 ms 2020-09-11T06:23:06.081Z INFO [sync] --> transferred reports (0) from https://uklvasapp715.gdc.standardchartered.com:8081/pdb/query/v4/reports in 3,277 ms 2020-09-11T06:24:09.596Z INFO [sync] --> transferred catalog-inputs (0) from https://uklvasapp715.gdc.standardchartered.com:8081/pdb/query/v4/catalog-inputs in 63,515 ms 2020-09-11T06:24:11.400Z INFO [sync] --> transferred nodes (0) from https://uklvasapp715.gdc.standardchartered.com:8081/pdb/query/v4/nodes in 1,803 ms Add Comment   This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935) -- 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.371815.1600126491000.35966.1600126500035%40Atlassian.JIRA.