On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj <nikhilraj...@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 > > [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.
