Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-2918

Improved runtime of EXA_*_PROFILE_LAST_DAY views

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: Exasol 7.1.0
    • Component/s: None
    • Labels:
      None
    • Changed Behavior:
      On first database startup all last day profile data will be truncated.

      Description

      Background

      Profiling is typically used to analyze and optimize single queries. When an optimization affects not just a single query but the database as a whole (e.g. replication border) or a complete table (e.g. distribution keys), it is often necessary to aggregate profiling information of all queries.
      On systems with large amounts of profiling data such aggregation queries can take very long.

      Improvement

      Query performance for aggregating large profile data has been improved.

      Upgrade note

      During the update to 7.1 all EXA_*_PROFILE_LAST_DAY data is truncated.

        Attachments

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: