Details
Description
Reported in SUPPORT-5776:
On a PostgreSQL 10.6 instance, the job count query
select COUNT(DISTINCT RES.ID_) fom ACT_RU_JOB RES where RES.SUSPENSION_STATE_ = 1
performs about 4 times slower than
select COUNT(RES.ID_) fom ACT_RU_JOB RES where RES.SUSPENSION_STATE_ = 1
and
select COUNT(*) from ( select DISTINCT RES.ID_ from ACT_RU_JOB RES where RES.SUSPENSION_STATE_ = 1)
The problem for this is explained here:
https://stackoverflow.com/questions/11250253/postgresql-countdistinct-very-slow
mgm-controller-panel
This is the controller panel for Smart Panels app
Attachments
Issue Links
- is related to
-
CAM-8733 Fetching total count of historic data takes too long
- Closed