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

Improved runtime of EXA_*_PROFILE_LAST_DAY views

    XMLWordPrintable

    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: