X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 56195D1E9DF for ; Mon, 5 Apr 2004 14:29:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 84181-07 for ; Mon, 5 Apr 2004 11:29:52 -0300 (ADT) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by svr1.postgresql.org (Postfix) with SMTP id C686ED1E9E6 for ; Mon, 5 Apr 2004 11:29:21 -0300 (ADT) Received: (qmail 24635 invoked from network); 5 Apr 2004 11:01:06 -0000 Received: from unknown (HELO trade-india.com) (203.145.130.142) by ns5.trade-india.com with SMTP; 5 Apr 2004 11:01:06 -0000 Message-ID: <40716D62.8040200@trade-india.com> Date: Mon, 05 Apr 2004 19:59:54 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "'pgsql-admin@postgresql.org'" Subject: debugging queries from psql Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/42 X-Sequence-Number: 13015 Greeting, i have 2 identical queries. One of that finish faast another takes ages. there are couble of trigers that run on update. I want to know where exactly the sencond query takes time. is there any way to increase debug logging from the psql prompt so that i can see whats going behind? Regds Mallah. tradein_clients=# UPDATE users set last_visit=now() WHERE userid= 34866; UPDATE 1 Time: 436.591 ms tradein_clients=# UPDATE users set last_visit=now() WHERE userid= 72643; Time: Takes ages