PostgreSQL的pageinspect插件

安装编译

1
2
3
4
su - root
cd /home/postgresql-12.11/contrib/pageinspect
make
make install

安装pageinspect

1
2
3
4
5
6
7
8
9
10
11
psql

create extension pageinspect;
CREATE EXTENSION

select lp as tuple,t_xmin,t_xmax,t_field3 as t_cid,t_ctid  from heap_page_items(get_raw_page('tbl',0));
 tuple | t_xmin  | t_xmax | t_cid | t_ctid 
-------+---------+--------+-------+--------
     1 | 6342159 |      0 |     0 | (0,1)
(1 row)