Re: CPU SPIKE

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

po 21. 10. 2019 v 7:14 odesílatel Pawan Sharma <pawanpg0963@xxxxxxxxx> napsal:

Hi All, 

Having real high CPU issue (95-98%), with SELECT statements and select queries contains multiple AND operator, is it will cause any CPU Spike..??? 

apps team is using sub-partition, PG11, CPU:24, Mem: 16GB

```test=# show shared_buffers ;

 shared_buffers

----------------

 7680MB

(1 row)

test=# show work_mem ;

 work_mem

----------

 104MB

(1 row)

test=# show maintenance_work_mem ;

 maintenance_work_mem

----------------------

 1GB

(1 row)

test=# show effective_cache_size ;

 effective_cache_size

----------------------

 22GB

(1 row)

                              

test=# show max_worker_processes;

 max_worker_processes

----------------------

 8

(1 row)

test=#```

It's hard to say what is reason. But good tool for debugging is `perf top` if you are on linux. Then you can see what routines uses CPU intensively.

Regards

Pavel

Regards, 

Pawan