Jira (PDB-5133) Use grouping sets for event-counts endpoints

[Austin Blatt (Jira)]

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

This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)

[Austin Blatt (Jira)]

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

[Zachary Kent (Jira)]

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

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints

Change By: Zachary Kent Story Points: 5

Add Comment

[Austin Blatt (Jira)]

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

[Austin Boyd (Jira)]

Austin Boyd updated an issue

PuppetDB / PDB-5133 Use grouping sets for event-counts endpoints

Change By: Austin Boyd Labels: jira_escalated

Add Comment

[Austin Boyd (Jira)]

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

[Eric Thompson (Jira)]

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

[Eric Thompson (Jira)]

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

[Eric Thompson (Jira)]

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