Postgre consuming CPU for minutes
Publié : lun. janv. 25, 2021 10:24 am
Hello, I just installed SquashTM and Postgre in a 4 CPU VM; I made some tests, and it works.
Then I added 21 test cases to an execution plan and tried testing it: all became incredibly slow.
I looked at the system, and found that when it is stuck, the situation is as in the picture: Postgre is consuming a CPU for minutes with status "idle" (or "SELECT", sometimes).
What should I do to fix it?
Thank you!
Then I added 21 test cases to an execution plan and tried testing it: all became incredibly slow.
I looked at the system, and found that when it is stuck, the situation is as in the picture: Postgre is consuming a CPU for minutes with status "idle" (or "SELECT", sometimes).
What should I do to fix it?
Thank you!