> 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
---(end of broadcast)---
TIP 8: explain analyze is
On Wed, 10 Mar 2004, Dexter Tad-y wrote:
> On Wed, 2004-03-10 at 23:08, Stephan Szabo wrote:
> > On Wed, 10 Mar 2004, Dexter Tad-y wrote:
> >
> > > Greetings,
> > > I need help in optimizing this query:
> > >
> > > select a.id, b.transaction from test as a left join pg_locks as b on
> > > a.xmax
