Re: CPU SPIKE

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: CPU SPIKE
Дата
Msg-id CAFj8pRAzO151QowQkwqeMKF9HSjc0QKjXTpgi4Jz+U=YfJKuNQ@mail.gmail.com
обсуждение исходный текст
Ответ на CPU SPIKE  (Pawan Sharma <pawanpg0963@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi

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

В списке pgsql-general по дате отправления: