Jira (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, 10000 and 100000 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

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

Dave Woods (Jira)

unread,

Jul 20, 2021, 9:51:03 AM7/20/21

to puppe...@googlegroups.com

Dave Woods updated an issue

PuppetDB /

Change By:	Dave Woods
Issue Type:	Story Task

Dave Woods (Jira)

unread,

Jul 20, 2021, 9:57:02 AM7/20/21

to puppe...@googlegroups.com

Dave Woods commented on

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

Dave Woods (Jira)

unread,

Jul 21, 2021, 4:43:02 AM7/21/21

to puppe...@googlegroups.com

Dave Woods assigned an issue to Andrei Filipovici

PuppetDB /

Change By:	Dave Woods
Assignee:	Dave Woods Andrei Filipovici

Dave Woods (Jira)

unread,

Sep 3, 2021, 10:40:03 AM9/3/21

to puppe...@googlegroups.com

Dave Woods commented on

Hi Andrei Filipovici and Bogdan Irimie, has there been any more progress on this?

Nicole Joe (Jira)

unread,

Oct 13, 2021, 5:37:03 PM10/13/21

to puppe...@googlegroups.com

Nicole Joe commented on

We were reviewing these results with the HDP team for comparison and are wondering what the number of users refers to in these tests. Are these separate users performing the same query in the same environment in parallel?

Dave Woods (Jira)

unread,

Oct 18, 2021, 9:54:02 AM10/18/21

to puppe...@googlegroups.com

Dave Woods commented on

Andrei Filipovici can this be closed now? I am hoping to close LIDAR-915.

Eric Thompson (Jira)

unread,

Nov 2, 2021, 9:03:03 PM11/2/21

to puppe...@googlegroups.com

Eric Thompson commented on

Austin Blatt is this one on our list?

with the TSR folks leaving, we probably need to re-prioritize this onto HAHA

David McTavish (Jira)

unread,

Feb 10, 2022, 9:58:03 AM2/10/22

to puppe...@googlegroups.com

David McTavish assigned an issue to Unassigned

PuppetDB /

Change By:	David McTavish
Assignee:	Andrei Filipovici