Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title Eric Thompson updated an issue PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints Change By: Eric Thompson Labels: 2021-o1-kr2 jira_escalated 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.399840.1621382472000.76050.1625678760349%40Atlassian.JIRA.
Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title Eric Thompson updated an issue PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints Change By: Eric Thompson Sprint: HA 2021-06-02 HAHA/Grooming , HA 2021-06- 16 02 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.399840.1621382472000.46412.1622658180233%40Atlassian.JIRA.
Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title Eric Thompson updated an issue PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints Change By: Eric Thompson Sprint: HA 2021-06-02 , HA 2021-06-16 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.399840.1621382472000.46390.1622658000530%40Atlassian.JIRA.
Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title Austin Boyd updated an issue PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints Change By: Austin Boyd Zendesk Ticket Count: 1 Zendesk Ticket IDs: 44407 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.399840.1621382472000.40040.1621889760538%40Atlassian.JIRA.
Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title Austin Boyd updated an issue PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints Change By: Austin Boyd Labels: jira_escalated 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.399840.1621382472000.40041.1621889760591%40Atlassian.JIRA.
Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title Austin Blatt assigned an issue to Austin Blatt PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints Change By: Austin Blatt Assignee: Austin Blatt 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.399840.1621382472000.37646.1621529700162%40Atlassian.JIRA.
Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title Zachary Kent updated an issue PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints Change By: Zachary Kent Story Points: 5 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.399840.1621382472000.36772.1621449180054%40Atlassian.JIRA.
Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title Zachary Kent updated an issue PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints Change By: Zachary Kent Sprint: HAHA/Grooming HA 2021-06-02 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.399840.1621382472000.36773.1621449180116%40Atlassian.JIRA.
Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints Change By: Austin Blatt Epic Link: PE-31891 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.399840.1621382472000.36758.1621448400480%40Atlassian.JIRA.
Jira (PDB-5133) Use grouping sets for event-counts endpoints
Title: Message Title
Austin Blatt created an issue
PuppetDB / PDB-5133
Use grouping sets for event-counts endpoints
Issue Type:
Improvement
Assignee:
Unassigned
Created:
2021/05/18 5:01 PM
Priority:
Normal
Reporter:
Austin Blatt
Currently, when the PE console queries the aggregate event counts endpoint and requests summarize_by="containing_class,certname,resource"}}l, the event-counts query performs the three queries in separate queries joined by {{UNION ALL. This results in the events query being run three times. Instead, we can likely get the same results using GROUPING SETS, which will only execute the underlying query once. https://github.com/puppetlabs/pe-console-ui/blob/83f6fb5197b88f5da1f24254faa4ad3400923253/src/puppetlabs/pe_console_middleware/cm/state_inspector/core.clj#L211-L214 https://www.postgresqltutorial.com/postgresql-grouping-sets/ https://www.postgresql.org/docs/10/queries-table-expressions.html#QUERIES-GROUPING-SETS
Add Comment
