Skip site navigation (1) Skip section navigation (2)

Re: another query optimization question

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: David Teran <david(dot)teran(at)cluster9(dot)com>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: another query optimization question
Date: 2004-01-30 18:10:16
Message-ID: 20040130100845.E58632@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.

In response to

Responses

pgsql-performance by date

Next:From: David TeranDate: 2004-01-30 18:20:24
Subject: Re: another query optimization question
Previous:From: PC DrewDate: 2004-01-30 18:09:40
Subject: Re: another query optimization question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group