Postgres Eating cpu

From: Mahmoud Moharam <mmoharam(at)lucidya(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Postgres Eating cpu
Date: 2019-05-16 06:04:01
Message-ID: CAEXKJoX+wJBno91Po6tWDhoCCD_E+bacNAxFNQipWLVAm_HwdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Mariel Cherkassky 2019-05-20 14:39:48 Trying to handle db corruption 9.6
Previous Message Tom Lane 2019-05-15 14:13:41 Re: suggestions for small but much needed ui imporvements in pgAdmin4