Starting a new thread to look into your issue!

· Sorted by Oldest

Starting a new thread to look into your issue!

· Sorted by Oldest

Olivia P.
·
·
cc Henri K. Yana is off for the day but we can look into the delay you're hitting in the meantime.
Tseegi (.
·
·
Hey Henri K.! After looking into your issue, what we found is that today's runs are on prod_moder while the previous faster runs were on dev_moder with a significant difference in rows being scanned. If you have any successful *kpi table insertions on prod, could you point us to a timeframe so we can compare? As a standalone query, fact_property_kpis_vs_last_year is spilling heavily, mostly due to ORDER BY 1 and FULL OUTER JOIN being the heaviest operations. Please let us know if you'd like help optimizing the query! The Duckling Overview Page is also a great place to start.
Henri K.
·
·
ok, let's move this to portal chat for possible details
Tseegi (.
·
·
Sure, Henri! Have you reached out to us?

Olivia P.
·
·
cc Henri K. Yana is off for the day but we can look into the delay you're hitting in the meantime.
Tseegi (.
·
·
Hey Henri K.! After looking into your issue, what we found is that today's runs are on prod_moder while the previous faster runs were on dev_moder with a significant difference in rows being scanned. If you have any successful *kpi table insertions on prod, could you point us to a timeframe so we can compare? As a standalone query, fact_property_kpis_vs_last_year is spilling heavily, mostly due to ORDER BY 1 and FULL OUTER JOIN being the heaviest operations. Please let us know if you'd like help optimizing the query! The Duckling Overview Page is also a great place to start.
Henri K.
·
·
ok, let's move this to portal chat for possible details
Tseegi (.
·
·
Sure, Henri! Have you reached out to us?