Optimize the pgsql database

Job ID: 31305030

Budget: $15 – $25 USD

I want to optimize the database (pgsql ) query, I have a Centos 7 server with 256Gb in Ram, but when there are several processes running at the same time it takes time to load the list of tasks and statestic graphics.