Postgres Eating cpu

Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Postgres Eating cpu

Mahmoud Moharam
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