-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Problem: Materialized views can take minutes to hours to complete. Today, currentOp can show that a build is running and how long it has been running, but it does not provide an estimate of how long it will take to complete. This gap was raised through field feedback from Disney, where a team spending $1.6 million annually reruns their build 3–4 times a month and has to blindly guess how long a build will take. The team must communicate this estimate to their end-users but risk underestimating the amount of time it takes to complete the build
Impact: This creates operational uncertainty for application teams during rebuilds because they cannot reliably communicate how much work remains or when the rebuilt view is ready for use
Requested behavior: Provide an estimated time to completion for materialized view builds, and a clear indication of when the rebuilt view is ready for application consumption