Logging of queryies

From: Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Logging of queryies
Date: 2003-01-21 16:56:08
Message-ID: Pine.LNX.4.44.0301211650140.1212-100000@RedDragon.Childs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

After listening to a long talk on the glories of MySql (Its no
better than Postgres, Postgres can do things MySql can't do and MySql can
do things Postgres can't do... So I'm not going to change camp) but it is
a good idea to know what the other camp thinks.
One nice feature that was meationed was the ability to log queries
by how long they took, I'm already loggin all my queries but this produces
alot of junk. Is it possible to just log all the queries that take longer
than say 30secs so I can then work on those that really take ages to speed
my program up.

Thanks in advance.

Peter Childs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-01-21 16:59:07 Re: repost of how to do select in a constraint
Previous Message Tom Lane 2003-01-21 16:47:44 Re: Help on query plan.