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

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

JanJorissen — Fri, 15 Mar 2024 15:36:48 GMT

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

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

Set Disabled to true:

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

Save the file
Restart the Service Dispatcher

Schedule it to run every 24 hours

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

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

Save the file
Restart the Service Dispatcher

Internal Investigation ID(s)

QB-18723

Environment

(November 2022 and later)

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

GeorgeSavu — Tue, 12 Mar 2024 07:24:40 GMT

HI @JanJorissen ,

Which QSEoW versions are impacted by this issue ?

BR,

George

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

Sonja_Bauernfeind — Tue, 12 Mar 2024 07:27:41 GMT

@GeorgeSavu

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

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

skumar — Wed, 28 May 2025 17:45:47 GMT

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: