Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-4007

Surface time at which byte/row estimate information was computed in explain plan output

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.12.0
    • Labels:
      None

      Description

      As part of PHOENIX-3822, we surfaced byte and row estimates for queries in explain plan. Since we collect this information through stats collection, it would also be helpful to surface when this information was last updated to reflect its freshness. We already store last_stats_update_time in SYSTEM.STATS. So the task would be essentially surfacing last_stats_update_time as another column in the explain plan result set.

        Attachments

        1. PHOENIX-4007_v1.patch
          74 kB
          Samarth Jain
        2. PHOENIX-4007_v10.patch
          126 kB
          Samarth Jain
        3. PHOENIX-4007_v2.patch
          77 kB
          Samarth Jain
        4. PHOENIX-4007_v3.patch
          80 kB
          Samarth Jain
        5. PHOENIX-4007_v4.patch
          80 kB
          Samarth Jain
        6. PHOENIX-4007_v6.patch
          91 kB
          Samarth Jain
        7. PHOENIX-4007_v7.patch
          102 kB
          Samarth Jain
        8. PHOENIX-4007_v8.patch
          116 kB
          Samarth Jain
        9. PHOENIX-4007_v9.patch
          123 kB
          Samarth Jain

          Activity

            People

            • Assignee:
              samarthjain Samarth Jain
              Reporter:
              samarthjain Samarth Jain
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: