Skip site navigation (1) Skip section navigation (2)

Re: Selects query stats?

From: Alvis Tunkelis <alvis(at)datatechlabs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Francisco Reyes <lists(at)stringsutils(dot)com>
Subject: Re: Selects query stats?
Date: 2006-05-30 13:05:53
Message-ID: 447C4331.4090005@datatechlabs.com (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

pgsql-performance by date

Next:From: Mario SplivaloDate: 2006-05-30 14:18:01
Subject: Speedup hint needed, if available? :)
Previous:From: Jonathan BlitzDate: 2006-05-30 09:35:55
Subject: Re: Adding and filling new column on big table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group