pagevis

Visualise database pages in ascii code

Overview

Package	Version	Category	License	Language
`pagevis`	`0.1`	STAT	MIT	SQL

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
6860	`pagevis`	No	No	No	Yes	No	Yes	-

Related	`pg_buffercache` `pageinspect` `toastinfo` `pg_visibility` `pg_freespacemap` `pgstattuple` `pgfincore` `pgcozy` `pg_prewarm`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PIGSTY	`0.1`	1817161514	`pagevis`	-
RPM	PIGSTY	`0.1`	1817161514	`pagevis_$v`	-
DEB	PIGSTY	`0.1`	1817161514	`postgresql-$v-pagevis`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.1 el8.x86_64.pg18 : pagevis_18 pagevis_18-0.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el8.x86_64.pg17 : pagevis_17 pagevis_17-0.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el8.x86_64.pg16 : pagevis_16 pagevis_16-0.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el8.x86_64.pg15 : pagevis_15 pagevis_15-0.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el8.x86_64.pg14 : pagevis_14 pagevis_14-0.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 0.1 · 8.1KiB
el8.aarch64	PIGSTY 0.1 el8.aarch64.pg18 : pagevis_18 pagevis_18-0.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el8.aarch64.pg17 : pagevis_17 pagevis_17-0.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el8.aarch64.pg16 : pagevis_16 pagevis_16-0.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el8.aarch64.pg15 : pagevis_15 pagevis_15-0.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el8.aarch64.pg14 : pagevis_14 pagevis_14-0.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 0.1 · 8.1KiB
el9.x86_64	PIGSTY 0.1 el9.x86_64.pg18 : pagevis_18 pagevis_18-0.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el9.x86_64.pg17 : pagevis_17 pagevis_17-0.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el9.x86_64.pg16 : pagevis_16 pagevis_16-0.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el9.x86_64.pg15 : pagevis_15 pagevis_15-0.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el9.x86_64.pg14 : pagevis_14 pagevis_14-0.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 0.1 · 8.2KiB
el9.aarch64	PIGSTY 0.1 el9.aarch64.pg18 : pagevis_18 pagevis_18-0.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el9.aarch64.pg17 : pagevis_17 pagevis_17-0.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el9.aarch64.pg16 : pagevis_16 pagevis_16-0.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el9.aarch64.pg15 : pagevis_15 pagevis_15-0.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1 · 8.1KiB	PIGSTY 0.1 el9.aarch64.pg14 : pagevis_14 pagevis_14-0.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 0.1 · 8.1KiB
el10.x86_64	PIGSTY 0.1 el10.x86_64.pg18 : pagevis_18 pagevis_18-0.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el10.x86_64.pg17 : pagevis_17 pagevis_17-0.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el10.x86_64.pg16 : pagevis_16 pagevis_16-0.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el10.x86_64.pg15 : pagevis_15 pagevis_15-0.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el10.x86_64.pg14 : pagevis_14 pagevis_14-0.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 0.1 · 8.2KiB
el10.aarch64	PIGSTY 0.1 el10.aarch64.pg18 : pagevis_18 pagevis_18-0.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el10.aarch64.pg17 : pagevis_17 pagevis_17-0.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el10.aarch64.pg16 : pagevis_16 pagevis_16-0.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el10.aarch64.pg15 : pagevis_15 pagevis_15-0.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1 · 8.2KiB	PIGSTY 0.1 el10.aarch64.pg14 : pagevis_14 pagevis_14-0.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 0.1 · 8.2KiB
d12.x86_64	PIGSTY 0.1 d12.x86_64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d12.x86_64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d12.x86_64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d12.x86_64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d12.x86_64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 0.1 · 5.2KiB
d12.aarch64	PIGSTY 0.1 d12.aarch64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d12.aarch64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d12.aarch64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d12.aarch64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d12.aarch64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 0.1 · 5.2KiB
d13.x86_64	PIGSTY 0.1 d13.x86_64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d13.x86_64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d13.x86_64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d13.x86_64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d13.x86_64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~trixie_amd64.deb PIGSTY · 0.1 · 5.2KiB
d13.aarch64	PIGSTY 0.1 d13.aarch64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d13.aarch64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d13.aarch64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d13.aarch64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 d13.aarch64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~trixie_arm64.deb PIGSTY · 0.1 · 5.2KiB
u22.x86_64	PIGSTY 0.1 u22.x86_64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u22.x86_64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u22.x86_64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u22.x86_64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u22.x86_64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~jammy_amd64.deb PIGSTY · 0.1 · 5.2KiB
u22.aarch64	PIGSTY 0.1 u22.aarch64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u22.aarch64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u22.aarch64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u22.aarch64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u22.aarch64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~jammy_arm64.deb PIGSTY · 0.1 · 5.2KiB
u24.x86_64	PIGSTY 0.1 u24.x86_64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~noble_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u24.x86_64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~noble_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u24.x86_64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~noble_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u24.x86_64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~noble_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u24.x86_64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~noble_amd64.deb PIGSTY · 0.1 · 5.2KiB
u24.aarch64	PIGSTY 0.1 u24.aarch64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~noble_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u24.aarch64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~noble_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u24.aarch64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~noble_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u24.aarch64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~noble_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u24.aarch64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~noble_arm64.deb PIGSTY · 0.1 · 5.2KiB
u26.x86_64	PIGSTY 0.1 u26.x86_64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u26.x86_64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u26.x86_64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u26.x86_64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u26.x86_64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~resolute_amd64.deb PIGSTY · 0.1 · 5.2KiB
u26.aarch64	PIGSTY 0.1 u26.aarch64.pg18 : postgresql-18-pagevis postgresql-18-pagevis_0.1-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u26.aarch64.pg17 : postgresql-17-pagevis postgresql-17-pagevis_0.1-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u26.aarch64.pg16 : postgresql-16-pagevis postgresql-16-pagevis_0.1-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u26.aarch64.pg15 : postgresql-15-pagevis postgresql-15-pagevis_0.1-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1 · 5.2KiB	PIGSTY 0.1 u26.aarch64.pg14 : postgresql-14-pagevis postgresql-14-pagevis_0.1-1PIGSTY~resolute_arm64.deb PIGSTY · 0.1 · 5.2KiB

Build

You can build the RPM / DEB packages for pagevis using pig build:

pig build pkg pagevis         # build RPM / DEB packages

Install

You can install pagevis directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

Install

pig install pagevis;          # Install for current active PG version

pig

pig ext install -y pagevis -v 18  # PG 18
pig ext install -y pagevis -v 17  # PG 17
pig ext install -y pagevis -v 16  # PG 16
pig ext install -y pagevis -v 15  # PG 15
pig ext install -y pagevis -v 14  # PG 14

dnf

dnf install -y pagevis_18       # PG 18
dnf install -y pagevis_17       # PG 17
dnf install -y pagevis_16       # PG 16
dnf install -y pagevis_15       # PG 15
dnf install -y pagevis_14       # PG 14

apt

apt install -y postgresql-18-pagevis   # PG 18
apt install -y postgresql-17-pagevis   # PG 17
apt install -y postgresql-16-pagevis   # PG 16
apt install -y postgresql-15-pagevis   # PG 15
apt install -y postgresql-14-pagevis   # PG 14

Create Extension:

CREATE EXTENSION pagevis;

Usage

pagevis: ASCII visualization of PostgreSQL database pages

pagevis provides an ASCII-graphical representation of the contents of a PostgreSQL database page. It requires the pageinspect extension.

Function

-- show_page(relation, block_number, line_width)
SELECT show_page('my_table', 0, 64);

Output Characters

Character	Meaning
`P`	Page header
`U`	Unused line pointer
`N`	Normal line pointer
`R`	Redirect line pointer
`D`	Dead line pointer
(space)	Free space (the “hole”)
`[n]`	Tuple number (overlaid on tuple header)
`H`	Tuple header
`#`	Tuple data
`-`	Tuple invisible to current transaction (dead)
`.`	Inter-tuple padding

Example

SELECT show_page('pvtest', 0, 64);
                             show_page
------------------------------------------------------------------
 PPPPPPPPPPPPPPPPPPPPPPPP001N002N003N004N005N006N007N008N009N010N
 011N012N013N014N015N016N017N018N019N020N...

 [226]HHHHHHHHHHHHHHHHHHH####....[225]HHHHHHHHHHHHHHHHHHH####....
 [224]HHHHHHHHHHHHHHHHHHH####....[223]HHHHHHHHHHHHHHHHHHH####....

The page header (P) and line pointers (N) appear at the start, free space in the middle, and tuples grow from the end of the page backward. The page is full when no more space remains between line pointers and tuples.

Requires superuser access (uses pageinspect’s get_raw_page).

pagevis

Overview

Version

Build

Install

Usage

Function

Output Characters

Example

Was this page helpful?