postgres queries limited by CPU

[jmigueldelgado]

Currently wms is querying postgres on every zoom and pan operation. Querying and rendering is taking about 10-14 s. When zooming and panning I get the following warning from glances:

                     2019-01-25 14:38:33 (0:00:04) - CRITICAL on CPU_SYSTEM (100.0)
                     2019-01-25 14:38:33 (0:00:16) - WARNING on CPU_USER (86.8)
                     2019-01-25 14:38:04 (0:00:06) - WARNING on CPU_USER (86.6)
                     2019-01-25 14:37:34 (0:00:04) - CRITICAL on CPU_SYSTEM (100.0)
                     2019-01-25 14:37:27 (0:00:04) - CRITICAL on CPU_SYSTEM (100.0)
                     2019-01-25 14:37:27 (0:00:11) - WARNING on CPU_USER (86.8)
                     2019-01-25 14:36:54 (0:00:04) - CRITICAL on CPU_SYSTEM (100.0)

The virtual machine is currently running on 4 cores. I have tried optimizing with work_mem (right now at 8MB, tested 4-64MB) and shared_buffers (128MB right now, tested 512MB) with no visible improvement.

[jmigueldelgado]

we need to host this on a better server