Re: CPU SPIKE

[Pavel Stehule]

Hi

po 21. 10. 2019 v 7:14 odesílatel Pawan Sharma <pawanpg0...@gmail.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
>