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

Historic Activity Statistics Query cannot use index

    XMLWordPrintable

    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_);
      

        Attachments

          Activity

            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: