> 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: expl
Sorry for my last blank post, anyway, im not sure this helps but have
you tried using EXPLAIN?
Dexter Tad-y
On Mon, 2004-03-08 at 17:41, sferriol wrote:
> hello
> in a 'SELECT', does postgres read the 'WHERE' condition from left to right.
>
> for example
&g
On Mon, 2004-03-08 at 17:41, sferriol wrote:
> hello
> in a 'SELECT', does postgres read the 'WHERE' condition from left to right.
>
> for example
> 1) select ... where a and b;
> 2) select ... where b and a;
>
> 1 and 2 will use the same cpu time or not ?
>
> sylvain
-
