Re: CPU SPIKE

2019-10-21 Thread Francisco Olarte
You'll have to provide more data: On Mon, Oct 21, 2019 at 7:14 AM Pawan Sharma wrote: > Having real high CPU issue (95-98%), with SELECT statements and select > queries contains multiple AND operator, is it will cause any CPU Spike..??? If you do a query the only reason it is not hitting 100% c

Re: CPU SPIKE

2019-10-20 Thread Tomas Vondra
On Mon, Oct 21, 2019 at 10:45:33AM +0530, Pawan Sharma wrote: 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 Any query executi

Re: CPU SPIKE

2019-10-20 Thread Pavel Stehule
Hi po 21. 10. 2019 v 7:14 odesílatel Pawan Sharma 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=#