Re: 7.4Beta1 hang?

On Sat, 09 Aug 2003 21:17:05 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> said something like:

> Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> writes:
> > [much data]
>
> Could you supply the relation names corresponding to the relation OIDs
> appearing in pg_locks, so we can be sure who's processing what?
>

Well, there appears to be a mail problem. Not sure if it's on my end,
or somewhere else.

I dug around a little and I might have what you asked for. The relname
looks correct for what's currently being processed, but I don't know why
some of the relation wouldn't have a name. Of course, I made this up,
so it may be verrrry wrong...

tassiv=# select relation, mode, relname from pg_locks left join pg_class
on ( pg_locks.relation = pg_class.relfilenode );
relation | mode | relname
----------+--------------------------+-------------------
1259 | AccessShareLock | pg_class
16759 | AccessShareLock | pg_locks
17835 | AccessShareLock | groups
17835 | RowShareLock | groups
17844 | AccessShareLock | pairs_pair_id_seq
17846 | AccessShareLock | pairs
17846 | RowShareLock | pairs
17846 | RowExclusiveLock | pairs
17855 | AccessShareLock | files_file_id_seq
17857 | AccessShareLock | files
17857 | RowShareLock | files
17857 | RowExclusiveLock | files
17879 | AccessShareLock | fits
17879 | RowExclusiveLock | fits
17912 | AccessShareLock | obs_id_seq
17971 | AccessShareLock | obs_v
17971 | RowExclusiveLock | obs_v
17984 | AccessShareLock | temp_obs_v
17984 | RowExclusiveLock | temp_obs_v
17984 | ShareLock | temp_obs_v
17984 | AccessExclusiveLock | temp_obs_v
18015 | ShareUpdateExclusiveLock | obs_i
18015 | AccessShareLock | obs_i
18015 | RowExclusiveLock | obs_i
18015 | ShareUpdateExclusiveLock | obs_i
18028 | AccessShareLock | temp_obs_i
18028 | RowExclusiveLock | temp_obs_i
18028 | ShareLock | temp_obs_i
18028 | AccessExclusiveLock | temp_obs_i
18045 | AccessShareLock | imported
18045 | RowExclusiveLock | imported
18096 | AccessExclusiveLock | obs_i_loc_index
18096 | AccessExclusiveLock | obs_i_loc_index
18099 | ShareLock |
18099 | AccessExclusiveLock |
18101 | ShareLock |
18101 | AccessExclusiveLock |
34526324 | AccessShareLock |
34526324 | ShareLock |
34526324 | AccessExclusiveLock |
34527019 | ShareLock |
34527019 | AccessExclusiveLock |
34527020 | ShareLock |
34527020 | AccessExclusiveLock |
| ExclusiveLock |
| ExclusiveLock |
| ExclusiveLock |

--
09:02:24 up 9 days, 1:47, 4 users, load average: 2.01, 2.03, 2.00