Jira (PDB-5220) Investigate query performance for "CONS - reports attributes"

[Bogdan Irimie (Jira)]

Bogdan Irimie created an issue

PuppetDB / PDB-5220 Investigate query performance for "CONS - reports attributes" Issue Type: Task Assignee: Unassigned Created: 2021/07/29 6:42 AM Priority: Normal Reporter: Bogdan Irimie From the performance test we ran in https://docs.google.com/spreadsheets/d/1eaOZhSoTyZ3k_0905_3BSDZpViz3WbTTJGQzGdoTsnI/edit?usp=sharing curl --location -g --request GET 'http://localhost:8080/pdb/query/v4?query=["from", "reports", ["extract", ["hash", "end_time", "certname", "status", "job_id", "noop", "noop_pending", "metrics", "environment", "corrective_change"]]]' is an outlier and we should investigate if this query can be rewritten in a more efficient way or if we can make changes to the query engine in order to improve it's performance Add Comment

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

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5220 Investigate query performance for "CONS - reports attributes"

Change By: Bogdan Irimie Sprint: ghost-08.09.2021

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5220 Investigate query performance for "CONS - reports attributes"

Change By: Bogdan Irimie Sprint: ghost- 08 22 .09.2021

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5220 Investigate query performance for "CONS - reports attributes"

Change By: Bogdan Irimie Story Points: 3

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5220 Investigate query performance for "CONS - reports attributes"

Change By: Bogdan Irimie Sprint: ghost-22.09.2021 , ghost-6.10.2021

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5220 Investigate query performance for "CONS - reports attributes"

Change By: Bogdan Irimie Sprint: ghost-22.09.2021, ghost- 6 20 .10. 2021 2022

Add Comment

[Bogdan Irimie (Jira)]

Bogdan Irimie updated an issue

PuppetDB / PDB-5220 Investigate query performance for "CONS - reports attributes"

Change By: Bogdan Irimie Sprint: ghost-22.09.2021 , ghost-20.10.2022

Add Comment