Jira (PDB-3561) store report statuses in the reports table

19 views
Skip to first unread message

Wyatt Alt (JIRA)

unread,
Jun 15, 2017, 4:42:03 PM6/15/17
to puppe...@googlegroups.com
Wyatt Alt created an issue
 
PuppetDB / Bug PDB-3561
store report statuses in the reports table
Issue Type: Bug Bug
Assignee: Unassigned
Created: 2017/06/15 1:41 PM
Priority: Normal Normal
Reporter: Wyatt Alt

We can eliminate a costly join we do sometimes just by storing report statuses in the reports table and getting rid of report_statuses. Here's an example query that's slow, made by the reports page in PE: https://gist.github.com/wkalt/93f787744df2a527db9488254ba86bb5

unfortunately moving the column to reports will may require a table rewrite due to the expense of an update, but we can experiment.
Add Comment Add Comment
 
This message was sent by Atlassian JIRA (v6.4.14#64029-sha1:ae256fe)
Atlassian logo

Russell Mull (JIRA)

unread,
Jun 15, 2017, 5:12:16 PM6/15/17
to puppe...@googlegroups.com
Russell Mull updated an issue
Change By: Russell Mull
Sprint: Hopper

Russell Mull (JIRA)

unread,
Jun 16, 2017, 12:55:03 PM6/16/17
to puppe...@googlegroups.com
Russell Mull updated an issue
Change By: Russell Mull
Fix Version/s: PDB 5.1.0

Kenn Hussey (JIRA)

unread,
Jul 20, 2017, 11:24:04 AM7/20/17
to puppe...@googlegroups.com
Kenn Hussey updated an issue
Change By: Kenn Hussey
Team: Data Platform

Russell Mull (JIRA)

unread,
Aug 22, 2017, 12:43:03 PM8/22/17
to puppe...@googlegroups.com
Russell Mull updated an issue
Change By: Russell Mull
Fix Version/s: PDB 5.1.0
Fix Version/s: PDB 5.2.0

Russell Mull (JIRA)

unread,
Oct 11, 2017, 4:37:04 PM10/11/17
to puppe...@googlegroups.com
Russell Mull updated an issue
Change By: Russell Mull
Fix Version/s: PDB 5.2.0

Zachary Kent (Jira)

unread,
Feb 17, 2021, 12:36:03 PM2/17/21
to puppe...@googlegroups.com
Zachary Kent updated an issue
Change By: Zachary Kent
Labels: needs-investigation pdb-migration
This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935)
Atlassian logo

Zachary Kent (Jira)

unread,
Feb 17, 2021, 7:17:03 PM2/17/21
to puppe...@googlegroups.com

Zachary Kent (Jira)

unread,
Mar 10, 2021, 3:33:04 PM3/10/21
to puppe...@googlegroups.com
Zachary Kent updated an issue
Change By: Zachary Kent
Sprint:

Zachary Kent (Jira)

unread,
Mar 10, 2021, 3:34:05 PM3/10/21
to puppe...@googlegroups.com
Zachary Kent updated an issue
Change By: Zachary Kent
Sprint: Release Engineering Hopper

Morgan Rhodes (Jira)

unread,
Mar 11, 2021, 2:27:03 PM3/11/21
to puppe...@googlegroups.com
Morgan Rhodes updated an issue
Change By: Morgan Rhodes
Sprint: Release Engineering Hopper
Reply all
Reply to author
Forward
0 new messages