Page 1 sur 1

Postgre consuming CPU for minutes

Publié : lun. janv. 25, 2021 10:24 am
par dario
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!

Re: Postgre consuming CPU for minutes

Publié : mar. janv. 26, 2021 10:50 am
par dario
I solved!!

First: I needed to run the analyze command; secondo I had to turn Jit off.

The slow query was 6seconds, then 235ms and now it is 0.84ms!!!