X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 058DD329E7B for ; Mon, 11 Oct 2004 22:03:46 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68539-07 for ; Mon, 11 Oct 2004 21:03:35 +0000 (GMT) Received: from mail1.acecape.com (mail1.acecape.com [66.114.74.12]) by svr1.postgresql.org (Postfix) with ESMTP id 1BDC5329D5F for ; Mon, 11 Oct 2004 22:03:36 +0100 (BST) Received: from p65-147.acedsl.com (p65-147.acedsl.com [66.114.65.147]) by mail1.acecape.com (8.12.11/8.12.11) with ESMTP id i9BL3bLP025166 for ; Mon, 11 Oct 2004 17:03:37 -0400 Date: Mon, 11 Oct 2004 17:04:16 -0400 (EDT) From: Francisco Reyes X-X-Sender: fran@zoraida.natserv.net To: PostgreSQL performance Subject: Understanding explains Message-ID: <20041011164950.J97379@zoraida.natserv.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/141 X-Sequence-Number: 8617 Is there a tutorial or reference to the different terms that appear on the explain output? Items such as "Nested Loop", "Hash".. Also is there a way to easily tell which of two explains is "worse". Example I am running a query with "set enable_seqscan to off;" and i see the explain now shows index scans, but not sure if is any faster now. I tried "explain analyze" and the "total runtime" for the one with seq_scan off was faster, but after repeathing them they both dropped in time, likely due to data getting cached. Even after the time drops for both the one with seqscan off was always faster. Is there any disadvantage of having the enable_seqscan off?