> 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 your friend