| From: | Pawan Sharma <pawanpg0963(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | CPU SPIKE |
| Date: | 2019-10-21 05:15:33 |
| Message-ID: | CAKqG8NVPpbGOiQbNWdx8Ji5o8RB95-Kiwtz7MAs9MarsjFcsrw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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=#```
Regards,
Pawan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2019-10-21 05:40:19 | Re: CPU SPIKE |
| Previous Message | Abelard Hoffman | 2019-10-21 02:58:33 | Re: jsonb_set() strictness considered harmful to data |