Chris writes:
>> Is there a way to tell what tables have locks on them?
>
> SELECT * from pg_locks ;
>
> (version 7.4 and above at least, don't have an install earlier than that).
And this is per DB right?
Any way to tell locks in all DBs?
In particular if planning to bounce back the DB would be nice to know if
anyone had any locks open..