Re: High CPU usage in postgres servers

On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj <[email protected]> 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
>
>  [image: 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.