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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 4.12.0
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: