Verbose query logging improvements

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Diagnostics, Querying
    • None
    • Query Execution
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      The verbose query logs at logLevel 5 can prove immensely helpful for understanding how a query is executing. We should do a pass in order to clean up what information we generate, and also to make logLevel 4 useful. Currently, operators of live systems may wish to enable verbosity 0 or 1 for the query log component. Developers may wish to enable verbosity 5. However, levels 2-4 are rarely useful.

      The "query" log component at logLevel 4 should give some high-level detail about the steps the planner is taking in order to plan a query. It should provide the following:

      • The parsed query.
      • The tagged and "rated" MatchExpression tree.
      • The candidate plans generated, and their scores.
      • An indication of which plan won.

      At logLevel 5, we may provide additional details from each planning step. For instance, verbosity 5 may generate messages describing some of the details of predicate assignment in the access planner or details of covering analysis in the PlannerAnalysis step.

            Assignee:
            [DO NOT USE] Backlog - Query Execution
            Reporter:
            J Rassi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: