Jira (PDB-5195) Analysis of Estate Reporting Queries
Title: Message Title Dave Woods commented on PDB-5195 Re: Analysis of Estate Reporting Queries Andrei Filipovici can this be closed now? I am hoping to close LIDAR-915. Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.407463.1626788987000.157135.1634565240218%40Atlassian.JIRA.
Jira (PDB-5219) Investigate query performance for "ESTATE - latest corrective change for specific system"
Title: Message Title Dave Woods commented on PDB-5219 Re: Investigate query performance for "ESTATE - latest corrective change for specific system" Andrei Filipovici can this be closed now? I am hoping to close LIDAR-915. Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.409152.1627566005000.157134.1634565240170%40Atlassian.JIRA.
Jira (PDB-5278) Grouping by a fact with a / in the name generates 500
Title: Message Title Dave Woods commented on PDB-5278 Re: Grouping by a fact with a / in the name generates 500 Austin Blatt any idea when this will be merged? We have a Platypus related ticket dependant on this fix. Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.416232.1631899059000.157129.1634565120146%40Atlassian.JIRA.
Jira (PDB-5195) Analysis of Estate Reporting Queries
Title: Message Title Dave Woods commented on PDB-5195 Re: Analysis of Estate Reporting Queries Hi Andrei Filipovici and Bogdan Irimie, has there been any more progress on this? Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.407463.1626788987000.122938.163068250%40Atlassian.JIRA.
Jira (PDB-5226) Dotted fact path group by doesn't group
Title: Message Title Dave Woods commented on PDB-5226 Re: Dotted fact path group by doesn't group Austin Blatt where can we get our hands on a server with this fix? Lynsay Wright has made a fix in the ER Query Service and needs to verify it against the latest fix, before we cut a new release and hand it over to Chris Leicester for a CD4PE release. Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.409525.1627947342000.98826.1628069520102%40Atlassian.JIRA.
Jira (PDB-5214) (Re)allow dotted projections with group_by
Title: Message Title Dave Woods commented on PDB-5214 Re: (Re)allow dotted projections with group_by Rob Browning please let us know if Estate Reporting need to make changes. Platypus has opened LIDAR-942. Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.408826.1627489296000.95684.1627891860032%40Atlassian.JIRA.
Jira (PDB-5195) Analysis of Estate Reporting Queries
Title: Message Title Dave Woods assigned an issue to Andrei Filipovici PuppetDB / PDB-5195 Analysis of Estate Reporting Queries Change By: Dave Woods Assignee: Dave Woods Andrei Filipovici Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.407463.1626788987000.86130.1626856980048%40Atlassian.JIRA.
Jira (PDB-5195) Analysis of Estate Reporting Queries
Title: Message Title Dave Woods commented on PDB-5195 Re: Analysis of Estate Reporting Queries Andrei Filipovici thanks for capturing the Estate Reporting results in PDB-5167. I have added to your spreadsheet at https://docs.google.com/spreadsheets/d/1eaOZhSoTyZ3k_0905_3BSDZpViz3WbTTJGQzGdoTsnI/edit#gid=1055835457 , adding a tab called "Estate Reporting Analysis" to help me understand the response times. I have highlight some extremely high response times and I am wondering if there is any way to optimise the queries for - ESTATE - latest corrective change for specific system - ESTATE - nodes with specific operating system These seem to be taking 7 seconds in the scenario where we have 100,000 nodes Cheers CC Bogdan Irimie / Lynsay Wright Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.407463.1626788987000.85093.1626789420042%40Atlassian.JIRA.
Jira (PDB-5195) Analysis of Estate Reporting Queries
Title: Message Title Dave Woods updated an issue PuppetDB / PDB-5195 Analysis of Estate Reporting Queries Change By: Dave Woods Issue Type: Story Task Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.407463.1626788987000.85088.1626789060031%40Atlassian.JIRA.
Jira (PDB-5195) Analysis of Estate Reporting Queries
Title: Message Title Dave Woods created an issue PuppetDB / PDB-5195 Analysis of Estate Reporting Queries Issue Type: Story Assignee: Dave Woods Created: 2021/07/20 6:49 AM Priority: Normal Reporter: Dave Woods Now that queriers have been executed for 1000, 1 and 10 nodes, we need to check the results and see if any optimisations can be made See results from PDB-5167 at https://docs.google.com/spreadsheets/d/1eaOZhSoTyZ3k_0905_3BSDZpViz3WbTTJGQzGdoTsnI/edit#gid=1055835457 Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)
Jira (PDB-5184) Add Estate Reporting queries to performance test
Title: Message Title Dave Woods moved an issue PuppetDB / PDB-5184 Add Estate Reporting queries to performance test Change By: Dave Woods Key: LIDAR PDB - 923 5184 Team: Ghost Project: LiDAR PuppetDB Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- 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.405177.1625035211000.73641.1625499600091%40Atlassian.JIRA.
