Postgres Pro
Downloads
Home   >   mailing lists

Re: [NEWBIE] need help optimizing this query - Mailing list pgsql-general

From Dexter Tad-y
Subject Re: [NEWBIE] need help optimizing this query
Date
Msg-id 1078937010.7007.1.camel@localhost
Whole thread Raw
In response to [NEWBIE] need help optimizing this query  (Dexter Tad-y <dexterbt1@my.smart.com.ph>)
Responses Ident authentication is not supported on local connections on this platform
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Alexander Cohen
Date:
Subject: pg_aggregate weird stuff
Next
From: "scott.marlowe"
Date:
Subject: Re: load testing