Why performance of postgres is very slow in odoo 14?

Question

daily our customers post data so database size increases day by day.
From past few weeks we very experiencing very slow performance in our
application.

*Odoo Configuration*
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
limit_request = 8192
limit_time_cpu = 60
limit_time_real = 9999
limit_time_real_cron = -1

list_db = True
log_db = False
log_db_level = warning
log_handler = :INFO
log_level = info
logfile = /var/log/odoo/odoo-server.log
longpolling_port = 8072
max_cron_threads =

Globalist Technology · Accepted Answer

The information you enter are not very useful, unfortunately.
Where the Odoo instance is running? Are you using any monitoring tool for postgres or the instance in general? Why do you think is it postgres and not something else?
In you don't use any monitor tool you can try to found out in postgres itself:
Assuming you have configured the log_min_duration_statement in postgresql.conf you can use this query for listing the 50 heaviest queries runned yesterday.

SELECT query, max(duration) AS max_

This question has been flagged

Enjoying the discussion? Don't just read, join in!