Postgres Pro
Downloads
Home   >   mailing lists

Re: High CPU usage in postgres servers - Mailing list pgsql-hackers

From Melvin Davidson
Subject Re: High CPU usage in postgres servers
Date
Msg-id CANu8Fixp25AuTpa_S30f=536HkUGjb-SgLz_sg5y8Mj9=NE9Vg@mail.gmail.com
Whole thread Raw
In response to High CPU usage in postgres servers  (nikhil raj <nikhilraj474@gmail.com>)
Responses Re: High CPU usage in postgres servers  (Michael Paquier <michael.paquier@gmail.com>)
Re: High CPU usage in postgres servers  (Michael Paquier <michael.paquier@gmail.com>)
Re: High CPU usage in postgres servers  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Tree view


On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj <nikhilraj474@gmail.com> wrote:



Hi guys ,
when check the task manager I see these many postgres.exe are running. How to identify which pid is running for which process please any one can help me out.
or Why these many postgres.exe are running on the server  

 Inline image 1

Thanks ,
Nikhil

It appears your O/S is Windows, but you have not included which version of PostgreSQL.
Since the structure of pg_stat_activity has changed between 9.4 and 9.5
the best I can advise is to
SELECT * FROM pg_stat_activity;

Otherwise, I would give you a query tailored to your version of PostgreSQL.
--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Attachment

pgsql-hackers by date:

Previous
From: Erik Rijkers
Date:
Subject: Re: PATCH: logical_work_mem and logical streaming of largein-progress transactions
Next
From: Stephen Frost
Date:
Subject: Re: WikiEditing - Editor privileges required!