Postgres Pro
Downloads
Home   >   mailing lists

Postgres Eating cpu - Mailing list pgsql-admin

From Mahmoud Moharam
Subject Postgres Eating cpu
Date
Msg-id CAEXKJoX+wJBno91Po6tWDhoCCD_E+bacNAxFNQipWLVAm_HwdA@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
Greetings,
I have a high cpu usage from postgres queries and when I run "SELECT * FROM pg_stat_activity" I list all running queries but I found that process which eat cpu is a FETCH process the question is :- how can I know the query of that FETCH to enhance it or kill it

thanks in advance

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: suggestions for small but much needed ui imporvements in pgAdmin4
Next
From: Ron
Date:
Subject: Re: pg_restore takes more time on creation of rules