Jack Wang
Jack Wang
I chose an arbitrary report_id where next_action = 'none' to generate explain plans. In staging: ``` Nested Loop (cost=752327.09..1732214.23 rows=411835 width=685) CTE lineage -> Recursive Union (cost=0.43..655548.21 rows=758026 width=48) ->...
VACUUM and ANALYZE for the tables involved in the expensive merge join on staging (report_file, report_lineage) appears to be up to date. However, there are more indexes on staging than...
At this time it appears the performance difference is resolved via spot-checking transactions in Azure appinsights. I've confirmed the indexes dropped are currently not created via the flyway migrations and...
AL1, DG1, IN1, IN3 were implemented in #16549. On a quick check, the EVN 2.7 class should be sufficient but we will need to create ROL and PR1 classes.
@dependabot rebase
@dependabot recreate
@dependabot rebase
As stated in #18533 this change is not necessary from a security standpoint as the input for this function is system generated at run time without using external input.
Built on @wcutshall's work in this PR: #18105
@dependabot recreate