Message-ID: <447C4331.4090005@datatechlabs.com>
Date: Tue, 30 May 2006 13:05:53 +0000
From: Alvis Tunkelis <alvis@datatechlabs.com>
User-Agent: Thunderbird 1.5.0.2 (X11/20060427)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Cc: Francisco Reyes <lists@stringsutils.com>
Subject: Re: Selects query stats?
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>
In-Reply-To: <cone.1148961155.527933.34675.1000@zoraida.natserv.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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