From: Alvis Tunkelis <alvis@datatechlabs.com>
To: pgsql-performance@postgresql.org
Cc: Francisco Reyes <lists@stringsutils.com>
Subject: Re: Selects query stats?
Date: Tue, 30 May 2006 13:05:53 +0000
Message-ID: <447C4331.4090005@datatechlabs.com> (raw)
In-Reply-To: <cone.1148961155.527933.34675.1000@zoraida.natserv.net>
References: <9C4E40CF-6C06-4297-AF32-A7EF2A3F3C0F@hi5.com>
<4473512E.7020805@ca.sophos.com>
<82252882-2A15-4823-A517-7AB3161889D1@hi5.com>
<4473553C.1010804@ca.sophos.com>
<127D68F6-7620-4A62-8D1A-9B475E7571CD@hi5.com>
<c014a9590605240327h3f95ebbat8a6fcbc90680633@mail.gmail.com>
<20060524213352.GN59464@pervasive.com>
<cone.1148961155.527933.34675.1000@zoraida.natserv.net>
try pgtop. It is mytop clone for postgresql.
Regards,
alvis
Francisco Reyes wrote:
> I am not sure if this is what the original poster was refering to, but I
> have used an application called mtop that shows how many queries per
> second mysql is doing.
>
> In my case this is helpfull because we have a number of machines running
> postfix and each incoming mail generates about 7 queries. Queries are
> all very simmilar to each other in that scenario.
>
> Having access to that query/second stat allowed me to improve the
> settings in MysQL. Ultimately once we migrated to a new server I could
> see how moving to the new machine increased the speed at which we could
> accept emails.
>
> I am, little by little, getting PostgreSQL to be used, but for now the
> postfix queries are tied to MySQL. By the time we hopefully do move to
> PostgreSQL for the Postfix backend it will be very helpfull to have some
> sort of way to measure queries/time period.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvis@datatechlabs.com, lists@stringsutils.com
Subject: Re: Selects query stats?
In-Reply-To: <447C4331.4090005@datatechlabs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox