Postgre consuming CPU for minutes

dario
Messages : 3
Inscription : lun. janv. 25, 2021 10:18 am

Postgre consuming CPU for minutes

Message 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!
Pièces jointes
Screenshot 2021-01-25 102233.jpg
Screenshot 2021-01-25 102233.jpg (49.02 Kio) Consulté 868 fois
dario
Messages : 3
Inscription : lun. janv. 25, 2021 10:18 am

Re: Postgre consuming CPU for minutes

Message 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!!!
Répondre

Revenir à « Installation & Base de données / Installation & Database »