Just validate your environment once via the below states ...
-top -p $(pgrep -d',' postgres)
-Review the PostgreSQL logs (typically located in /var/log/postgresql/ or
/var/lib/pgsql/data/pg_log/)
-- check if any long running active query running via below query
SELECT pid, query, state, start_ti
On 2/4/25 09:11, KK CHN wrote:
List,
Could someone point out how can I trace what causes the edb-postgres
process with %CPU usage reaching 73 to 80.1 percentage in this box.
What's wrong with the server VM..
What version of EDB database are you using?
If it is not their install of the
List,
Could someone point out how can I trace what causes the edb-postgres
process with %CPU usage reaching 73 to 80.1 percentage in this box.
What's wrong with the server VM..
The clients connecting the databases experience slow responses ..
The top out put of the DB server is pasted below
