Re: CPU SPIKE

Hi

po 21. 10. 2019 v 7:14 odesílatel Pawan Sharma <pawanpg0963(at)gmail(dot)com>
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
>