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