Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DC1676503FE for ; Wed, 30 Jul 2008 21:53:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 41312-01-10 for ; Wed, 30 Jul 2008 21:53:30 -0300 (ADT) X-Greylist: delayed 00:24:48.597122 by SQLgrey-1.7.6 Received: from urquell.c3sl.ufpr.br (mx.inf.ufpr.br [200.17.202.3]) by postgresql.org (Postfix) with ESMTP id 53A666505A7 for ; Wed, 30 Jul 2008 21:44:46 -0300 (ADT) Received: from webmail.inf.ufpr.br (calvados.c3sl.ufpr.br [200.17.202.2]) by urquell.c3sl.ufpr.br (Postfix) with ESMTP id E131E70000421 for ; Wed, 30 Jul 2008 21:19:14 -0300 (BRT) Received: from 201.15.49.76 (SquirrelMail authenticated user tarcizioab) by webmail.inf.ufpr.br with HTTP; Wed, 30 Jul 2008 21:19:15 -0300 (BRT) Message-ID: <50061.201.15.49.76.1217463555.squirrel@webmail.inf.ufpr.br> Date: Wed, 30 Jul 2008 21:19:15 -0300 (BRT) Subject: Difference between "Explain analyze" and "\timing" From: tarcizioab@c3sl.ufpr.br To: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.9a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/261 X-Sequence-Number: 30861 Hello friends The commands "\timing" and "EXPLAIN ANALYZE" return values related to the time of execution of the instruction. These values are "Time:" and "Total runtime:" respectively. What is the difference between these values, and the specific use of each command in queries? If someone can help me. Thank's for attention. Tarcizio Bini