| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | obtaining row locking information |
| Date: | 2005-08-07 12:46:08 |
| Message-ID: | 20050807.214608.74754910.t-ishii@sra.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
With a help from Bruce, I wrote a small function which returns row
locking information(see attached file if you are interested). Here is
a sample result:
test=# select * from pgrowlocks('t1');
locked_row | lock_type | locker | multi
------------+-----------+--------+-------
(0,1) | Shared | 1 | t
(0,3) | Exclusive | 575 | f
(2 rows)
I think it will be more usefull if actual xids are shown in the case
"locker" is a multixid. It seems GetMultiXactIdMembers() does the
job. Unfortunately that is a static funtcion, however. Is there any
chance GetMultiXactIdMembers() becomes public funtion?
--
Tatsuo Ishii
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 4.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2005-08-07 13:52:00 | Re: Cygwin - make check broken |
| Previous Message | Brendan Jurd | 2005-08-07 06:10:17 | gettime() - a timeofday() alternative |