Date: Tue, 26 Dec 2017 09:19:01 +0900
From: Michael Paquier <michael.paquier@gmail.com>
To: Melvin Davidson <melvin6925@gmail.com>
Cc: nikhil raj <nikhilraj474@gmail.com>,
	"pgsql-general@postgresql.org >> PG-General Mailing List"
 <pgsql-general@postgresql.org>,
	pgsql-sql@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: High CPU usage in postgres servers
Message-ID: <20171226001901.GB8114@paquier.xyz>
References: 
 <CAG1ps1wwTzJky2q=A7fYOKczBRXno2BkFYDEkYHbTgAAeGOxMA@mail.gmail.com>
 <CANu8Fixp25AuTpa_S30f=536HkUGjb-SgLz_sg5y8Mj9=NE9Vg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
	protocol="application/pgp-signature"; boundary="dTy3Mrz/UPE2dbVg"
Content-Disposition: inline
In-Reply-To: 
 <CANu8Fixp25AuTpa_S30f=536HkUGjb-SgLz_sg5y8Mj9=NE9Vg@mail.gmail.com>
Precedence: bulk


--dTy3Mrz/UPE2dbVg
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Dec 25, 2017 at 06:12:05PM -0500, Melvin Davidson wrote:
> On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj <nikhilraj474@gmail.com> wrot=
e:
>> Hi guys ,
>> when check the task manager I see these many postgres.exe are running. H=
ow
>> to identify which pid is running for which process please any one can he=
lp
>> me out.
>> or Why these many postgres.exe are running on the server
>>
>>  [image: Inline image 1]
>>
>> Thanks ,
>> Nikhil
>>
>=20
> 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;
>=20
> Otherwise, I would give you a query tailored to your version of PostgreSQ=
L.

Looking at queries that take a long time and look at their plans can help in
measuring the impact on CPU. For example, a sequential scan with a large OR=
DER
BY would be bad. Windows is also paked with perfmon (Performance Monitor) t=
hat
you could use. Combined with PostgreSQL logs with PID information, you could
always extract some information.

In the context of Windows which has no POSIX fork() implementation, note th=
at
the build runs under the context of EXEC_BACKEND, where each process is dir=
ectly
called via automaticly-built command lines.

Still you are giving close to no information regarding your system, so gene=
ral
pieces of advices are the best you can get.
--
Michael

--dTy3Mrz/UPE2dbVg
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlpBlXUACgkQnvQgOdby
QH36hw/9FoERgOnu3prVuTdhJ4/blRSqrqtgiMAY4HLwkK6J/dxJqjhWsPqNBoJv
lu0VbuHnvO9pwsplCqTqn3THJ+pjnpgmS0flsUVblGYg72j9r7UJQx1QAUYW6IEo
NhbHX05n8pO6KZC0HbjIMbby/nKtuMAfCcE00FPgyX5lxIkh/7XqDbidxPRvqmOu
gfylCwoEg21/7bDEh6IU5yW7JGDw7wu7GldIpZ76hPXaogxnoRrEc02SjQrV0ghB
T2xcJGVEXJV6ICON6p6KFSXUk4AZzJysJ/vg6b9Fbwzt09TMdBu4+Qdopz4uGJ9p
seIc5CB2YYYAX/dzm0tkOtL/52dcyAwb35nWFlzbaLQS5sTH0ai1Gtc8TuMbkyIf
0aEJkZsa6TxQH7uMbndH9zOLVY7hCNO6yo58XjnPV4ITRbqNggXvV/I5AB/Ykm8Q
pa2muhhPLu97y/tjM0FeXzjDWO2X95MgU1FMplDy/pSQtIX+o+uSrKfCG4LWC1ey
NGrlBQsGBaik5boCKfeEF2YtXBYcxpmwT79ccldfXgevfJiqvC9j2KP3GMlYDnq8
FsXElNfbtkcPW414xp8DR1NW/oEXPAe66No4nv1Vr1sDJY0XdMp4aGt/IcmNOHyf
4K0rVSRza3num/+cf+jurlUvHSBCrCNz2qMra53i7aj/aqEXfrc=
=39X3
-----END PGP SIGNATURE-----

--dTy3Mrz/UPE2dbVg--