Jira (PDB-5221) Investigate query performance for "CONS - nodes details"

0 views
Skip to first unread message

Bogdan Irimie (Jira)

unread,
Jul 29, 2021, 9:44:03 AM7/29/21
to puppe...@googlegroups.com
Bogdan Irimie created an issue
 
PuppetDB / Task PDB-5221
Investigate query performance for "CONS - nodes details"
Issue Type: Task Task
Assignee: Unassigned
Created: 2021/07/29 6:43 AM
Priority: Normal 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", "nodes", ["extract", ["certname", "report_timestamp", "latest_report_hash"], ["=", "node_state", "active"]]]'

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 Add Comment
 
This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)
Atlassian logo
Reply all
Reply to author
Forward
0 new messages