Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YxXJ6-000183-HD for pgsql-admin@arkaria.postgresql.org; Wed, 27 May 2015 09:07:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YxXJ6-0007G2-0f for pgsql-admin@arkaria.postgresql.org; Wed, 27 May 2015 09:07:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YxXJ4-0007Dz-6q for pgsql-admin@postgresql.org; Wed, 27 May 2015 09:07:22 +0000 Received: from dub004-omc1s14.hotmail.com ([157.55.0.213]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1YxXIz-0003SC-T9 for pgsql-admin@postgresql.org; Wed, 27 May 2015 09:07:21 +0000 Received: from DUB127-W43 ([157.55.0.238]) by DUB004-OMC1S14.hotmail.com over TLS secured channel with Microsoft SMTPSVC(7.5.7601.22751); Wed, 27 May 2015 02:07:16 -0700 X-TMN: [sEgL9Ui3zaBPqUqz4kfHgLbI4APCY0No] X-Originating-Email: [kierenscott@hotmail.com] Message-ID: Content-Type: multipart/alternative; boundary="_38dcf605-13c0-4fb7-8119-7dae496c3c6d_" From: Kieren Scott To: "pgsql-admin@postgresql.org" Subject: Re: monitoring TPS and IOPS Date: Wed, 27 May 2015 09:07:16 +0000 Importance: Normal In-Reply-To: References: <36080D0D-56C4-4393-A08C-63979BD83600@cisco.com>, , , MIME-Version: 1.0 X-OriginalArrivalTime: 27 May 2015 09:07:16.0518 (UTC) FILETIME=[87200460:01D0985C] X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_38dcf605-13c0-4fb7-8119-7dae496c3c6d_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable For benchmarking TPS=2C have a look at pgbench if you haven't already done = so. http://www.postgresql.org/docs/devel/static/pgbench.html Kieren > From: plaporte@cisco.com > To: laurenz.albe@wien.gv.at=3B=20 > Subject: Re: [ADMIN] monitoring TPS and IOPS > Date: Wed=2C 27 May 2015 09:01:33 +0000 >=20 > Laurenz. Thank you. > For IOPS when doing load testing we would like to tell if the IO requests= made by the DB can be handled by the server. > In oracle this information is stored in tables and so wondering if simila= r data can be found in PG as well. > I=92m not sure how feasible it will be using OS tools. > For TPS we will explore pgBadger. > Regards=2C > __ > Pascal >=20 >=20 >=20 >=20 > On 27/05/15 10:43=2C "Albe Laurenz" wrote: >=20 > >Pascal Laporte wrote: > >> In what ways are we able to pull information about transactions and I/= O per second ? > >> For things like load testing we need this type of information. > >> In Oracle we retrieve it from the AWR reports. > >> Are PG admins also looking at this data=2C and how is that collected/p= resented? > > > >For operating system parameters like I/O and CPU load you have to use op= erating > >system tools=2C like "sar" on UNIX. > > > >For measuring things like TPS during a test run=2C I'd recommend pgBadge= r > >(http://dalibo.github.io/pgbadger/). > > > >Yours=2C > >Laurenz Albe >=20 > --=20 > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin = --_38dcf605-13c0-4fb7-8119-7dae496c3c6d_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
For benchmarking TPS=2C have a l= ook at pgbench if you haven't already done so.


Kieren

>=3B From: plaporte@cisco.com
>= =3B To: laurenz.albe@wien.gv.at=3B =3B
>=3B Subject: Re: [ADMIN] m= onitoring TPS and IOPS
>=3B Date: Wed=2C 27 May 2015 09:01:33 +0000>=3B
>=3B Laurenz. Thank you.
>=3B For IOPS when doing load t= esting we would like to tell if the IO requests made by the DB can be handl= ed by the server.
>=3B In oracle this information is stored in tables = and so wondering if similar data can be found in PG as well.
>=3B I=92= m not sure how feasible it will be using OS tools.
>=3B For TPS we wil= l explore pgBadger.
>=3B Regards=2C
>=3B __
>=3B Pascal
&= gt=3B
>=3B
>=3B
>=3B
>=3B On 27/05/15 10:43=2C "Alb= e Laurenz" <=3Blaurenz.albe@wien.gv.at>=3B wrote:
>=3B
>=3B = >=3BPascal Laporte wrote:
>=3B >=3B>=3B In what ways are we able= to pull information about transactions and I/O per second ?
>=3B >= =3B>=3B For things like load testing we need this type of information.>=3B >=3B>=3B In Oracle we retrieve it from the AWR reports.
>= =3B >=3B>=3B Are PG admins also looking at this data=2C and how is that= collected/presented?
>=3B >=3B
>=3B >=3BFor operating system= parameters like I/O and CPU load you have to use operating
>=3B >= =3Bsystem tools=2C like "sar" on UNIX.
>=3B >=3B
>=3B >=3BFor= measuring things like TPS during a test run=2C I'd recommend pgBadger
&= gt=3B >=3B(http://dalibo.github.io/pgbadger/).
>=3B >=3B
>=3B= >=3BYours=2C
>=3B >=3BLaurenz Albe
>=3B
>=3B --
&g= t=3B Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>= =3B To make changes to your subscription:
>=3B http://www.postgresql.o= rg/mailpref/pgsql-admin
= --_38dcf605-13c0-4fb7-8119-7dae496c3c6d_--