Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
Hi,
In customer's system, the CPU usage is 100% because of the processes of PostgreSQL.
Any idea about it ? The workload is not so heavy , why is the CPU usage so high?
----------------------Version-----------------------------------
Thingworx 8.4.4, Windows server 2016, Postgresql 10.7
Regards,
Sean
Solved! Go to Solution.
All the transaction shown (aside from autovacuum), seem to be operating against the data_table. There is a know performance issue with this table:
https://www.ptc.com/en/support/article?n=CS261063
I would recommend:
1. Adding the missing index above
2. Running vacuum analyze data_table;
3. Running select entity_id,count(*) from data_table group by entity_id;
If you provide the output for #3, there may be some platform data that could be truncated to speed up these data_table queries.
All the transaction shown (aside from autovacuum), seem to be operating against the data_table. There is a know performance issue with this table:
https://www.ptc.com/en/support/article?n=CS261063
I would recommend:
1. Adding the missing index above
2. Running vacuum analyze data_table;
3. Running select entity_id,count(*) from data_table group by entity_id;
If you provide the output for #3, there may be some platform data that could be truncated to speed up these data_table queries.
Hi @seanccc.
If the response provided by @Tudor helped to resolve your issue, please mark it as the Accepted Solution for the benefit of others with the same problem. If you are still seeing issues, please provide the details of what is occurring since making the recommended changes.
Regards.
--Sharon