Determining Whether Query Load is Too High for PostgreSQL Server I just started experiencing some write-heavy load on a PostgreSQL 11.2 system running inside a Docker container on an Ubuntu 18.04 server. PostgreSQL is receiving about 1-4k INSERT queries/second. 

How can one determine whether this amount of load is too high for the system? Are there some metrics to monitor, like one that shows the number of queries being queued up at any one time?



System Specs


Intel® Atom™ C2750 (8-Core, 2.4GHz)
8GB DDR3
240 GB SSD 


Output of htop

2 node.js app concurrently sending queries to PostgreSQL. Both app and database are running on the same server.



Output of iotop



Output of iostat -c 5 999



Output of vmstat 1



pgAdmin
This is not a horrible load for modern server hardware.

On a write heavy DB its going to be dependent on the Hard-disk layer, triggers, functions, indexes and constraints that have to be processed/checked. 

An easy way to get to the information you want is to install pgAdmin,  and use the dashboard to see what is going on. Number of connections, transactions per second, tuples in and out  

From there need to study system load using,  some kind of System Monitor,  i like glances,  this will get the information on the CPU , Network and HD loads,

If there is significant wait times on the CPU or HD,  can adjust the log settings in postgresql.conf to record which queries take longer than X time