Re: [NEWBIE] need help optimizing this query

From: Dexter Tad-y <dexterbt1(at)my(dot)smart(dot)com(dot)ph>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: [NEWBIE] need help optimizing this query
Date: 2004-03-10 16:43:30
Message-ID: 1078937010.7007.1.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> explain select * from foo where xmax not in
> (select transaction from pg_locks where transaction is not null);

Thanks a lot! This query is what i've been looking for.

Cheers!

Dexter Tad-y

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Cohen 2004-03-10 16:45:24 pg_aggregate weird stuff
Previous Message Tom Lane 2004-03-10 16:35:23 Re: [NEWBIE] need help optimizing this query