CPU SPIKE - Mailing list 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