Jira (PDB-4892) Summary query for catalog_inputs unecessarily slow
Title: Message Title Zachary Kent commented on PDB-4892 Re: Summary query for catalog_inputs unecessarily slow Once PDB-4943 is merged and released we should double check a support script to make sure the sync summary queries have improved. 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.82283.1605727980024%40Atlassian.JIRA.
Jira (PDB-4892) Summary query for catalog_inputs unecessarily slow
Title: Message Title Rob Browning updated an issue PuppetDB / PDB-4892 Summary query for catalog_inputs unecessarily slow Change By: Rob Browning Story Points: 2 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.80080.1605554700558%40Atlassian.JIRA.
Jira (PDB-4892) Summary query for catalog_inputs unecessarily slow
Title: Message Title Zachary Kent assigned an issue to Unassigned PuppetDB / PDB-4892 Summary query for catalog_inputs unecessarily slow Change By: Zachary Kent Assignee: Zachary Kent 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.67569.1604005140035%40Atlassian.JIRA.
Jira (PDB-4892) Summary query for catalog_inputs unecessarily slow
Title: Message Title
Austin Blatt updated an issue
PuppetDB / PDB-4892
Summary query for catalog_inputs unecessarily slow
Change By:
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.{code}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 ms2020-09-11T06:23:02.803Z INFO [sync] --> transferred factsets (2) from https:// uklvasapp715.gdc.standardchartered.com :8081/pdb/query/v4/factsets in 9,303 ms2020-09-11T06:23:06.081Z INFO [sync] --> transferred reports (0) from https:// uklvasapp715.gdc.standardchartered.com :8081/pdb/query/v4/reports in 3,277 ms2020-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 ms2020-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{code}
Add Comment
This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935)
Jira (PDB-4892) Summary query for catalog_inputs unecessarily slow
Title: Message Title
Austin Blatt updated an issue
PuppetDB / PDB-4892
Summary query for catalog_inputs unecessarily slow
Change By:
Austin Blatt
Acceptance Criteria:
- Summary query for catalog inputs uses drop joins to only query the {{certnames}} table
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.36553.1600195620083%40Atlassian.JIRA.
Jira (PDB-4892) Summary query for catalog_inputs unecessarily slow
Title: Message Title Austin Blatt assigned an issue to Zachary Kent PuppetDB / PDB-4892 Summary query for catalog_inputs unecessarily slow Change By: Austin Blatt Assignee: Zachary Kent 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.36525.1600194360123%40Atlassian.JIRA.
Jira (PDB-4892) Summary query for catalog_inputs unecessarily slow
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-4892 Summary query for catalog_inputs unecessarily slow Change By: Austin Blatt Epic Link: PDB-4894 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.36521.1600194300037%40Atlassian.JIRA.
Jira (PDB-4892) Summary query for catalog_inputs unecessarily slow
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)
