Re: Getting rid of duplicate tables.

Tom Lane wrote:

>Jared Carr <jared(at)89glass(dot)com> writes:
>
>
>>live=# select oid,ctid,cmax,xmax,cmin,xmin,* from pg_class where
>>relname='order_to_do';
>> oid | ctid | cmax | xmax | cmin | xmin |
>>relname | relnamespace | reltype | relowner | relam | relfilenode |
>>relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex |
>>relisshared | relkind | relnatts | relchecks | reltriggers | relukeys |
>>relfkeys | relrefs | relhasoids | relhaspkey | relhasrules |
>>relhassubclass | relacl
>>----------+---------+------+----------+----------+----------+-------------+--------------+----------+----------+-------+-------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+--------
>> 11462032 | (27,2) | 0 | 2 | 2 | 46034931 |
>>order_to_do | 2200 | 11462033 | 101 | 0 | 11462032
>>| 506 | 59401 | 11462039 | 0 | t |
>>f | r | 5 | 0 | 1 | 0
>>| 0 | 0 | t | t | f |
>>f |
>> 11462032 | (27,43) | 2 | 46034931 | 46034931 | 8051642 |
>>order_to_do | 2200 | 11462033 | 101 | 0 | 11462032
>>| 453 | 53407 | 11462039 | 0 | t |
>>f | r | 5 | 0 | 1 | 0
>>| 0 | 0 | t | t | f |
>>f |
>>(2 rows)
>>
>>
>
>Hmm. This does not look like an index problem --- it looks like a tuple
>status problem. Apparently transaction 46034931 updated this row,
>marking the tuple at (27,43) invalid and inserting a new version at
>(27,2). That's fine and is not a unique-index violation by itself,
>but we should only be able to see one of these versions of the row.
>Clearly, both of them appear good since both are visible to your current
>transaction. There is no way that both of these tuples should be
>considered good; one or the other ought to be invalid from the point of
>view of any observing transaction. I think somebody dropped a status
>update somewhere. Have you had any system crashes recently? What kind
>of disk hardware is this running on --- is it IDE, and if so, do you
>have write caching properly disabled
>
>

Hmm...there haven't been any crashes for a good long time, there were
some power oddities around
a month ago, but I think we would have noticed this by now. The
application that was built on it just
died yesterday, so...unfortunately I don't know for sure how long this
has been this way.

Next it is running scsi disks in a raid 5 array.

>To really dig into this, we need to get a physical dump of these rows.
>The best tool for this is pg_filedump, which you can get from
>http://sources.redhat.com/rhdb/utilities.html. You can run it with
>something like
> pg_filedump -i -f -R 27 $PGDATA/base/nnn/1259
>where nnn is the OID of the database with the problem (look in
>pg_database to determine this). 1259 is the known OID of pg_class.
>Both of the interesting tuples are on the same page 27, so this should
>get the data we need.
>
>

The filedump is pasted in at the end.

>Also, please show the output of "ls -l $PGDATA/pg_clog". If the
>relevant segments of clog are still around, we might want to look at
>what it says about the commit states of these two transactions.
>
>
>

ls -l $PGDATA/pg_clog gives

-rw------- 1 postgres postgres 262144 Nov 26 11:58 0000
-rw------- 1 postgres postgres 262144 Nov 28 11:15 0001
-rw------- 1 postgres postgres 262144 Nov 30 04:27 0002
-rw------- 1 postgres postgres 262144 Dec 1 07:23 0003
-rw------- 1 postgres postgres 262144 Dec 1 11:09 0004
-rw------- 1 postgres postgres 262144 Dec 1 12:50 0005
-rw------- 1 postgres postgres 262144 Dec 1 15:37 0006
-rw------- 1 postgres postgres 262144 Dec 2 05:58 0007
-rw------- 1 postgres postgres 262144 Dec 2 11:25 0008
-rw------- 1 postgres postgres 262144 Dec 2 16:54 0009
-rw------- 1 postgres postgres 262144 Dec 3 10:29 000A
-rw------- 1 postgres postgres 262144 Dec 3 16:31 000B
-rw------- 1 postgres postgres 262144 Dec 4 10:34 000C
-rw------- 1 postgres postgres 262144 Dec 5 00:00 000D
-rw------- 1 postgres postgres 262144 Dec 5 11:50 000E
-rw------- 1 postgres postgres 262144 Dec 6 14:41 000F
-rw------- 1 postgres postgres 262144 Dec 8 05:58 0010
-rw------- 1 postgres postgres 262144 Dec 8 09:30 0011
-rw------- 1 postgres postgres 262144 Dec 8 13:33 0012
-rw------- 1 postgres postgres 262144 Dec 9 06:15 0013
-rw------- 1 postgres postgres 262144 Dec 9 11:47 0014
-rw------- 1 postgres postgres 262144 Dec 10 05:45 0015
-rw------- 1 postgres postgres 262144 Dec 10 12:43 0016
-rw------- 1 postgres postgres 262144 Dec 11 08:11 0017
-rw------- 1 postgres postgres 262144 Dec 11 13:48 0018
-rw------- 1 postgres postgres 262144 Dec 12 06:20 0019
-rw------- 1 postgres postgres 262144 Dec 12 15:44 001A
-rw------- 1 postgres postgres 262144 Dec 14 19:30 001B
-rw------- 1 postgres postgres 262144 Dec 15 10:22 001C
-rw------- 1 postgres postgres 262144 Dec 15 20:41 001D
-rw------- 1 postgres postgres 262144 Dec 16 07:51 001E
-rw------- 1 postgres postgres 262144 Dec 16 13:18 001F
-rw------- 1 postgres postgres 262144 Dec 17 09:57 0020
-rw------- 1 postgres postgres 262144 Dec 18 06:00 0021
-rw------- 1 postgres postgres 262144 Dec 18 15:09 0022
-rw------- 1 postgres postgres 262144 Dec 19 12:25 0023
-rw------- 1 postgres postgres 262144 Dec 21 16:37 0024
-rw------- 1 postgres postgres 262144 Dec 22 13:30 0025
-rw------- 1 postgres postgres 262144 Dec 23 12:04 0026
-rw------- 1 postgres postgres 262144 Dec 25 17:07 0027
-rw------- 1 postgres postgres 262144 Dec 27 11:50 0028
-rw------- 1 postgres postgres 262144 Dec 29 08:27 0029
-rw------- 1 postgres postgres 262144 Dec 29 12:42 002A
-rw------- 1 postgres postgres 262144 Dec 29 17:40 002B
-rw------- 1 postgres postgres 262144 Dec 30 09:26 002C
-rw------- 1 postgres postgres 262144 Dec 30 14:18 002D
-rw------- 1 postgres postgres 262144 Dec 31 08:28 002E
-rw------- 1 postgres postgres 262144 Jan 1 00:05 002F
-rw------- 1 postgres postgres 262144 Jan 1 09:10 0030
-rw------- 1 postgres postgres 262144 Jan 2 10:04 0031
-rw------- 1 postgres postgres 262144 Jan 3 08:34 0032
-rw------- 1 postgres postgres 262144 Jan 5 08:30 0033
-rw------- 1 postgres postgres 262144 Jan 5 16:29 0034
-rw------- 1 postgres postgres 262144 Jan 6 10:50 0035
-rw------- 1 postgres postgres 262144 Jan 6 21:50 0036
-rw------- 1 postgres postgres 262144 Jan 7 13:11 0037
-rw------- 1 postgres postgres 262144 Jan 8 07:34 0038
-rw------- 1 postgres postgres 262144 Jan 8 14:47 0039
-rw------- 1 postgres postgres 262144 Jan 9 10:00 003A
-rw------- 1 postgres postgres 262144 Jan 10 16:58 003B
-rw------- 1 postgres postgres 262144 Jan 12 08:20 003C
-rw------- 1 postgres postgres 262144 Jan 12 15:13 003D
-rw------- 1 postgres postgres 262144 Jan 13 11:25 003E
-rw------- 1 postgres postgres 262144 Jan 14 08:23 003F
-rw------- 1 postgres postgres 262144 Jan 14 16:47 0040
-rw------- 1 postgres postgres 262144 Jan 15 13:06 0041
-rw------- 1 postgres postgres 262144 Jan 16 07:39 0042
-rw------- 1 postgres postgres 262144 Jan 16 14:28 0043
-rw------- 1 postgres postgres 90112 Jan 19 14:30 0044

And finally the dump.

*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility - Version 3.0-Beta
*
* File: /var/tmp/pgsql/data74/base/11462031/1259
* Options used: -i -f -R 27
*
* Dump created on: Tue Jan 20 08:17:53 2004
*******************************************************************

Block 27 ********************************************************
<Header> -----
Block Offset: 0x00036000 Offsets: Lower 232 (0x00e8)
Block: Size 8192 Version 1 Upper 6416 (0x1910)
LSN: logid 7 recoff 0x2e369840 Special 8192 (0x2000)
Items: 53 Free Space: 6184
Length (including item array): 236

0000: 07000000 4098362e 18000000 e8001019 (dot)(dot)(dot)(dot)(at)(dot)6(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)
0010: 00200120 cc1a0000 cc9a2801 389a2801 . . ......(.8.(.
0020: 10190000 a4992801 e8170000 10992801 ......(.......(.
0030: 601b0000 cc1a0000 381a0000 a4190000 `.......8.......
0040: 10190000 7c180000 e8170000 54170000 ....|.......T...
0050: c0160000 2c160000 98150000 04150000 ....,...........
0060: 70140000 dc130000 48130000 b4120000 p.......H.......
0070: 20120000 8c110000 f8100000 64100000 ...........d...
0080: d00f0000 3c0f0000 a80e0000 140e0000 ....<...........
0090: 800d0000 ec0c0000 580c0000 c40b0000 ........X.......
00a0: 300b0000 9c0a0000 080a0000 74090000 0...........t...
00b0: e0080000 4c080000 b8070000 6c9f2801 ....L.......l.(.
00c0: d89e2801 fc050000 449e2801 b09d2801 ..(.....D.(...(.
00d0: 40040000 1c9d2801 889c2801 f49b2801 @.....(...(...(.
00e0: f0010000 609b2801 00000000 ....`.(.....

<Data> ------
Item 1 -- Length: 0 Offset: 6860 (0x1acc) Flags: 0x00
Item 2 -- Length: 148 Offset: 6860 (0x1acc) Flags: USED
XID: min (46034931) CMIN|XMAX: 2 CMAX|XVAC: 0
Block Id: 27 linp Index: 2 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1acc: f36fbe02 02000000 00000000 00001b00 .o..............
1adc: 02001700 10291c00 90e5ae00 6f726465 .....)......orde
1aec: 725f746f 5f646f00 00000000 00000000 r_to_do.........
1afc: 00000000 00000000 00000000 00000000 ................
1b0c: 00000000 00000000 00000000 00000000 ................
1b1c: 00000000 00000000 00000000 98080000 ................
1b2c: 91e5ae00 65000000 00000000 90e5ae00 ....e...........
1b3c: fa010000 00096847 97e5ae00 00000000 ......hG........
1b4c: 01007200 05000000 01000000 00000000 ..r.............
1b5c: 01010000 ....

Item 3 -- Length: 148 Offset: 6712 (0x1a38) Flags: USED
XID: min (46034931) CMIN|XMAX: 3 CMAX|XVAC: 0
Block Id: 27 linp Index: 3 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1a38: f36fbe02 03000000 00000000 00001b00 .o..............
1a48: 03001700 10291c00 9ae5ae00 6f726465 .....)......orde
1a58: 725f746f 5f646f5f 706b6579 00000000 r_to_do_pkey....
1a68: 00000000 00000000 00000000 00000000 ................
1a78: 00000000 00000000 00000000 00000000 ................
1a88: 00000000 00000000 00000000 98080000 ................
1a98: 00000000 65000000 93010000 72c7b501 ....e.......r...
1aa8: 1d010000 00096847 00000000 00000000 ......hG........
1ab8: 00006900 02000000 00000000 00000000 ..i.............
1ac8: 00000000 ....

Item 4 -- Length: 0 Offset: 6416 (0x1910) Flags: 0x00
Item 5 -- Length: 148 Offset: 6564 (0x19a4) Flags: USED
XID: min (46034931) CMIN|XMAX: 7 CMAX|XVAC: 0
Block Id: 27 linp Index: 5 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

19a4: f36fbe02 07000000 00000000 00001b00 .o..............
19b4: 05001700 10291c00 bb7e2101 746f5f64 .....)...~!.to_d
19c4: 6f5f6964 5f627472 65655f69 6e646578 o_id_btree_index
19d4: 00000000 00000000 00000000 00000000 ................
19e4: 00000000 00000000 00000000 00000000 ................
19f4: 00000000 00000000 00000000 98080000 ................
1a04: 00000000 64000000 93010000 73c7b501 ....d.......s...
1a14: fd000000 00096847 00000000 00000000 ......hG........
1a24: 00006900 01000000 00000000 00000000 ..i.............
1a34: 00000000 ....

Item 6 -- Length: 0 Offset: 6120 (0x17e8) Flags: 0x00
Item 7 -- Length: 148 Offset: 6416 (0x1910) Flags: USED
XID: min (46034931) CMIN|XMAX: 11 CMAX|XVAC: 0
Block Id: 27 linp Index: 7 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1910: f36fbe02 0b000000 00000000 00001b00 .o..............
1920: 07001700 10291c00 99e5ae00 70675f74 .....)......pg_t
1930: 6f617374 5f313134 36323033 325f696e oast_11462032_in
1940: 64657800 00000000 00000000 00000000 dex.............
1950: 00000000 00000000 00000000 00000000 ................
1960: 00000000 00000000 00000000 63000000 ............c...
1970: 00000000 65000000 93010000 74c7b501 ....e.......t...
1980: 01000000 00000000 00000000 00000000 ................
1990: 00006900 02000000 00000000 00000000 ..i.............
19a0: 00000000 ....

Item 8 -- Length: 0 Offset: 7008 (0x1b60) Flags: 0x00
Item 9 -- Length: 0 Offset: 6860 (0x1acc) Flags: 0x00
Item 10 -- Length: 0 Offset: 6712 (0x1a38) Flags: 0x00
Item 11 -- Length: 0 Offset: 6564 (0x19a4) Flags: 0x00
Item 12 -- Length: 0 Offset: 6416 (0x1910) Flags: 0x00
Item 13 -- Length: 0 Offset: 6268 (0x187c) Flags: 0x00
Item 14 -- Length: 0 Offset: 6120 (0x17e8) Flags: 0x00
Item 15 -- Length: 0 Offset: 5972 (0x1754) Flags: 0x00
Item 16 -- Length: 0 Offset: 5824 (0x16c0) Flags: 0x00
Item 17 -- Length: 0 Offset: 5676 (0x162c) Flags: 0x00
Item 18 -- Length: 0 Offset: 5528 (0x1598) Flags: 0x00
Item 19 -- Length: 0 Offset: 5380 (0x1504) Flags: 0x00
Item 20 -- Length: 0 Offset: 5232 (0x1470) Flags: 0x00
Item 21 -- Length: 0 Offset: 5084 (0x13dc) Flags: 0x00
Item 22 -- Length: 0 Offset: 4936 (0x1348) Flags: 0x00
Item 23 -- Length: 0 Offset: 4788 (0x12b4) Flags: 0x00
Item 24 -- Length: 0 Offset: 4640 (0x1220) Flags: 0x00
Item 25 -- Length: 0 Offset: 4492 (0x118c) Flags: 0x00
Item 26 -- Length: 0 Offset: 4344 (0x10f8) Flags: 0x00
Item 27 -- Length: 0 Offset: 4196 (0x1064) Flags: 0x00
Item 28 -- Length: 0 Offset: 4048 (0x0fd0) Flags: 0x00
Item 29 -- Length: 0 Offset: 3900 (0x0f3c) Flags: 0x00
Item 30 -- Length: 0 Offset: 3752 (0x0ea8) Flags: 0x00
Item 31 -- Length: 0 Offset: 3604 (0x0e14) Flags: 0x00
Item 32 -- Length: 0 Offset: 3456 (0x0d80) Flags: 0x00
Item 33 -- Length: 0 Offset: 3308 (0x0cec) Flags: 0x00
Item 34 -- Length: 0 Offset: 3160 (0x0c58) Flags: 0x00
Item 35 -- Length: 0 Offset: 3012 (0x0bc4) Flags: 0x00
Item 36 -- Length: 0 Offset: 2864 (0x0b30) Flags: 0x00
Item 37 -- Length: 0 Offset: 2716 (0x0a9c) Flags: 0x00
Item 38 -- Length: 0 Offset: 2568 (0x0a08) Flags: 0x00
Item 39 -- Length: 0 Offset: 2420 (0x0974) Flags: 0x00
Item 40 -- Length: 0 Offset: 2272 (0x08e0) Flags: 0x00
Item 41 -- Length: 0 Offset: 2124 (0x084c) Flags: 0x00
Item 42 -- Length: 0 Offset: 1976 (0x07b8) Flags: 0x00
Item 43 -- Length: 148 Offset: 8044 (0x1f6c) Flags: USED
XID: min (8051642) CMIN|XMAX: 46034931 CMAX|XVAC: 2
Block Id: 27 linp Index: 2 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1f6c: badb7a00 f36fbe02 02000000 00001b00 ..z..o..........
1f7c: 02001700 10291c00 90e5ae00 6f726465 .....)......orde
1f8c: 725f746f 5f646f00 00000000 00000000 r_to_do.........
1f9c: 00000000 00000000 00000000 00000000 ................
1fac: 00000000 00000000 00000000 00000000 ................
1fbc: 00000000 00000000 00000000 98080000 ................
1fcc: 91e5ae00 65000000 00000000 90e5ae00 ....e...........
1fdc: c5010000 009f5047 97e5ae00 00000000 ......PG........
1fec: 01007200 05000000 01000000 00000000 ..r.............
1ffc: 01010000 ....

Item 44 -- Length: 148 Offset: 7896 (0x1ed8) Flags: USED
XID: min (8051642) CMIN|XMAX: 46034931 CMAX|XVAC: 0
Block Id: 27 linp Index: 1 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1ed8: badb7a00 f36fbe02 00000000 00001b00 ..z..o..........
1ee8: 01001700 10291c00 9ae5ae00 6f726465 .....)......orde
1ef8: 725f746f 5f646f5f 706b6579 00000000 r_to_do_pkey....
1f08: 00000000 00000000 00000000 00000000 ................
1f18: 00000000 00000000 00000000 00000000 ................
1f28: 00000000 00000000 00000000 98080000 ................
1f38: 00000000 65000000 93010000 54722401 ....e.......Tr$.
1f48: 03010000 009f5047 00000000 00000000 ......PG........
1f58: 00006900 02000000 00000000 00000000 ..i.............
1f68: 00000000 ....

Item 45 -- Length: 0 Offset: 1532 (0x05fc) Flags: 0x00
Item 46 -- Length: 148 Offset: 7748 (0x1e44) Flags: USED
XID: min (8051642) CMIN|XMAX: 46034931 CMAX|XVAC: 4
Block Id: 27 linp Index: 4 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1e44: badb7a00 f36fbe02 04000000 00001b00 ..z..o..........
1e54: 04001700 10291c00 bb7e2101 746f5f64 .....)...~!.to_d
1e64: 6f5f6964 5f627472 65655f69 6e646578 o_id_btree_index
1e74: 00000000 00000000 00000000 00000000 ................
1e84: 00000000 00000000 00000000 00000000 ................
1e94: 00000000 00000000 00000000 98080000 ................
1ea4: 00000000 64000000 93010000 55722401 ....d.......Ur$.
1eb4: e1000000 009f5047 00000000 00000000 ......PG........
1ec4: 00006900 01000000 00000000 00000000 ..i.............
1ed4: 00000000 ....

Item 47 -- Length: 148 Offset: 7600 (0x1db0) Flags: USED
XID: min (8051642) CMIN|XMAX: 46034931 CMAX|XVAC: 8
Block Id: 27 linp Index: 6 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1db0: badb7a00 f36fbe02 08000000 00001b00 ..z..o..........
1dc0: 06001700 10291c00 99e5ae00 70675f74 .....)......pg_t
1dd0: 6f617374 5f313134 36323033 325f696e oast_11462032_in
1de0: 64657800 00000000 00000000 00000000 dex.............
1df0: 00000000 00000000 00000000 00000000 ................
1e00: 00000000 00000000 00000000 63000000 ............c...
1e10: 00000000 65000000 93010000 62722401 ....e.......br$.
1e20: 01000000 00000000 00000000 00000000 ................
1e30: 00006900 02000000 00000000 00000000 ..i.............
1e40: 00000000 ....

Item 48 -- Length: 0 Offset: 1088 (0x0440) Flags: 0x00
Item 49 -- Length: 148 Offset: 7452 (0x1d1c) Flags: USED
XID: min (8051658) CMIN|XMAX: 3 CMAX|XVAC: 0
Block Id: 27 linp Index: 49 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1d1c: cadb7a00 03000000 00000000 00001b00 ..z.............
1d2c: 31001700 10291c00 9ce5ae00 746f5f64 1....)......to_d
1d3c: 6f5f6974 656d7300 00000000 00000000 o_items.........
1d4c: 00000000 00000000 00000000 00000000 ................
1d5c: 00000000 00000000 00000000 00000000 ................
1d6c: 00000000 00000000 00000000 98080000 ................
1d7c: 9de5ae00 65000000 00000000 9ce5ae00 ....e...........
1d8c: 01000000 00004041 a8e5ae00 00000000 (dot)(dot)(dot)(dot)(dot)(dot)(at)A(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)
1d9c: 01007200 0b000300 01000000 00000000 ..r.............
1dac: 01010000 ....

Item 50 -- Length: 148 Offset: 7304 (0x1c88) Flags: USED
XID: min (8051658) CMIN|XMAX: 4 CMAX|XVAC: 0
Block Id: 27 linp Index: 50 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1c88: cadb7a00 04000000 00000000 00001b00 ..z.............
1c98: 32001700 10291c00 abe5ae00 746f5f64 2....)......to_d
1ca8: 6f5f6974 656d735f 706b6579 00000000 o_items_pkey....
1cb8: 00000000 00000000 00000000 00000000 ................
1cc8: 00000000 00000000 00000000 00000000 ................
1cd8: 00000000 00000000 00000000 98080000 ................
1ce8: 00000000 65000000 93010000 63722401 ....e.......cr$.
1cf8: 02000000 00004041 00000000 00000000 (dot)(dot)(dot)(dot)(dot)(dot)(at)A(dot)(dot)(dot)(dot)(dot)(dot)(dot)(dot)
1d08: 00006900 01000000 00000000 00000000 ..i.............
1d18: 00000000 ....

Item 51 -- Length: 148 Offset: 7156 (0x1bf4) Flags: USED
XID: min (8051658) CMIN|XMAX: 5 CMAX|XVAC: 0
Block Id: 27 linp Index: 51 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1bf4: cadb7a00 05000000 00000000 00001b00 ..z.............
1c04: 33001700 10291c00 aae5ae00 70675f74 3....)......pg_t
1c14: 6f617374 5f313134 36323034 345f696e oast_11462044_in
1c24: 64657800 00000000 00000000 00000000 dex.............
1c34: 00000000 00000000 00000000 00000000 ................
1c44: 00000000 00000000 00000000 63000000 ............c...
1c54: 00000000 65000000 93010000 64722401 ....e.......dr$.
1c64: 01000000 00000000 00000000 00000000 ................
1c74: 00006900 02000000 00000000 00000000 ..i.............
1c84: 00000000 ....

Item 52 -- Length: 0 Offset: 496 (0x01f0) Flags: 0x00
Item 53 -- Length: 148 Offset: 7008 (0x1b60) Flags: USED
XID: min (8051660) CMIN|XMAX: 4 CMAX|XVAC: 0
Block Id: 27 linp Index: 53 Attributes: 23 Size: 28
infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

1b60: ccdb7a00 04000000 00000000 00001b00 ..z.............
1b70: 35001700 10291c00 b8e5ae00 61646d69 5....)......admi
1b80: 6e5f7365 7373696f 6e735f70 6b657900 n_sessions_pkey.
1b90: 00000000 00000000 00000000 00000000 ................
1ba0: 00000000 00000000 00000000 00000000 ................
1bb0: 00000000 00000000 00000000 98080000 ................
1bc0: 00000000 65000000 93010000 65722401 ....e.......er$.
1bd0: 49000000 00008841 00000000 00000000 I......A........
1be0: 00006900 01000000 00000000 00000000 ..i.............
1bf0: 00000000 ....

*** End of Requested Range Encountered. Last Block Read: 27 ***

Thanks,
Jared Carr