X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A8C50D1B49E for ; Fri, 30 Jan 2004 18:10:16 +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 41278-08 for ; Fri, 30 Jan 2004 14:10:17 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 5CD3DD1B481 for ; Fri, 30 Jan 2004 14:10:16 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 62E1B355D9; Fri, 30 Jan 2004 10:10:16 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 61768355C2; Fri, 30 Jan 2004 10:10:16 -0800 (PST) Date: Fri, 30 Jan 2004 10:10:16 -0800 (PST) From: Stephan Szabo To: David Teran Cc: PgSQL Performance ML Subject: Re: another query optimization question In-Reply-To: <32DEEB93-534E-11D8-9392-000A95A6F0DC@cluster9.com> Message-ID: <20040130100845.E58632@megazone.bigpanda.com> References: <32DEEB93-534E-11D8-9392-000A95A6F0DC@cluster9.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/330 X-Sequence-Number: 5504 On Fri, 30 Jan 2004, David Teran wrote: > select > sum(job_property_difference(t0.int_value, t1.int_value)) as rank > from > job_property t0, > job_property t1 > where > t0.id_job_profile = 911 > and t0.id_job_attribute = t1.id_job_attribute > and t1.id_job_profile in (select id_job_profile from unemployed) > and t1.id_job_profile <> 911; > > results in a query plan result: Can we see explain analyze output for the query, it'll give more information about actual time and row counts than plain explain.