camunda-prometheus-process-engine-plugin icon indicating copy to clipboard operation
camunda-prometheus-process-engine-plugin copied to clipboard

Add support for SQL based queries : Allowing complex group by that is performed at DB layer

Open StephenOTT opened this issue 6 years ago • 2 comments

datasource = getProcessEngineConfiguration().getDataSource()

Groovy: new Sql(datasource)

StephenOTT avatar Nov 11 '19 23:11 StephenOTT

Query Types:

  1. Active
  2. Suspended
  3. Duration of Activity Defs Per Def Key/ID: Histo
  4. Per Tenant
  5. Per Def Key
  6. Per Def Id
  7. Per Task Type (such as Script)
  8. Assigned / Reassigned
  9. Specific Usage of Specific Delegates
  10. Process Count
  11. Process Duration (without the need for a execution listener)
  12. Msg Start Counts
  13. Timer Start Counts
  14. Number of executions per Process Instance Def/key (Histo to view parallel activity)
  15. Activity Duration Histo: Per Task Type, Per Key Per Tenant
  16. Global Variable Counts
  17. Parallel Gateway counts
  18. Multi-Instance Counts
  19. BPMN Error counts
  20. Messages Counts
  21. User Tasks
  22. Compensations
  23. Timers + Timer Defs
  24. Incidents
  25. Call Activities
  26. Messages Waiting for catch
  27. Timers Due within a Date Range (Next 15min, Next 1 day, Next 30 days, this year, etc)
  28. Boundary Timers
  29. Event Sub Processes
  30. Timers that match a specific patterns such as short timers (1min as example)

StephenOTT avatar Nov 11 '19 23:11 StephenOTT

Add query support to iterate over time windows to bring in older data

StephenOTT avatar Nov 11 '19 23:11 StephenOTT