Provide estimated time to completion for materialized view builds

    • 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

            Assignee:
            Unassigned
            Reporter:
            Hewan Kidanemariam
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: