Qlik Sense Enterprise on Windows: PostgresSQL consuming 100% of CPU in two-hourly intervals

[JanJorissen]

The PostgreSQL instance used by Qlik Sense (on-premise) uses 100% of CPU capacity. This behavior can be seen in an interval of 2 hours.

Cause

The Resource Distribution Service is set to run a 2-hourly scan on all extensions and themes as part of a sync to Qlik Sense Cloud. This has proven to have a dramatic effect in very large environments where postgres.exe is causing the CPU to spike to 100% for an extended duration, making the environment unusable.

Resolution

Switch off Resource Distribution or set it to run every 24 hours.

Switch off Resource Distribution

1. Open the services.conf file (default: C:\Program Files\Qlik\Sense\ServiceDispatcher\services.conf) in a text editor elevated to Administrator permissions
2. Locate the [resource-distribution] section.
3. Set Disabled to true:
   

   [resource-distribution]
   Disabled=true
   Identity=Qlik.resource-distribution
   DisplayName=Resource Distribution
   ExePath=Node\node.exe
   Script=..\ResourceDistributionService\server.js

4. Save the file
5. Restart the Service Dispatcher

Schedule it to run every 24 hours

1. Open the services.conf file (default: C:\Program Files\Qlik\Sense\ServiceDispatcher\services.conf) in a text editor elevated to Administrator permissions
2. Locate the [resource-distribution] section.
3. Set Disabled to false as //Disabled=true:
   

   [resource-distribution]
   //Disabled=true
   Identity=Qlik.resource-distribution
   DisplayName=Resource Distribution
   ExePath=Node\node.exe
   Script=..\ResourceDistributionService\server.js
   
   [resource-distribution.parameters]
   --secure
   --wes-port=${WESPort}
   --mode=server
   --log-path=${LogPath}
   --log-level=info
   --interval-time=86400000
   

4. Save the file
5. Restart the Service Dispatcher

Internal Investigation ID(s)

QB-18723

Environment

Qlik Sense Enterprise on Windows (November 2022 and later)

[GeorgeSavu]

HI @JanJorissen ,

Which QSEoW versions are impacted by this issue ?

BR,

George

[Sonja_Bauernfeind]

@GeorgeSavu 

Qlik Sense November 2022 and later have introduced this setting. I've added the information to the article, thank you for reaching out!

[skumar]

We seen this in Qlik Sense November 2024 version
recently upgraded the PostgreSQL patch from 14.2 to 14.17 on the server and the issue started
CPU reaching 100% every 2 hours.

applied this changes

[resource-distribution]
Disabled=true
Identity=Qlik.resource-distribution
DisplayName=Resource Distribution
ExePath=Node\node.exe
Script=..\ResourceDistributionService\server.js

Before the Fix:

After the fix: