[Join Optimization] Introduce metric to track how often WT page counts are available

    • Type: Task
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      In WT-17175 and WT-18059, the storage engine added an API to get the approximate number of pages a b-tree contains. The join optimizer consumes this value in SERVER-129082. This API may return a sentinel value indicating the statistic is unavailable. In the join optimizer's metrics collection, we should indicate how many times this occurs as it can allow us to debug bad plans if we see this estimate being unavailable.

            Assignee:
            Unassigned
            Reporter:
            Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: