Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-5257

Historic Activity Statistics Query cannot use index

    Details

      Description

      Problem Description:
      Historic Activity Statistics Query cannot use any indexes. If the history table contains many entries, the query performance decreases.

      Impacts responsiveness of Cockpit since this query is the one used to populate the counts on the process definition page.

      Solution:
      Maybe the following index can improve the performance:

      create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
      

        Activity

        Show
        meyer Daniel Meyer added a comment - Does this change affect the index? https://github.com/camunda/camunda-bpm-platform/commit/fed8d37adb18cf18e3bc87e300c043085d4a9848#diff-287531d1e7c905a2bae35fa2d54586dbL354
        Hide
        sebastian.menski Sebastian Menski added a comment - - edited

        Oops my fault. The change is in another query which is used for runtime I think.

        Show
        sebastian.menski Sebastian Menski added a comment - - edited Oops my fault. The change is in another query which is used for runtime I think.

          People

          • Assignee:
            michael.schoettes Michael Schoettes
            Reporter:
            meyer Daniel Meyer
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development