Extensions
pg_dirtyread

pg_dirtyread

pg_dirtyread : Read dead but unvacuumed rows from table

Overview

ID Extension Package Version Category License Language
5050
pg_dirtyread
pg_dirtyread
 2.7
ADMIN
BSD 3-Clause
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
pg_orphaned
pg_surgery
pageinspect
pg_visibility
pg_cheat_funcs
amcheck
pg_repack
pg_squeeze

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
MIXED
 2.7
18
17
16
15
14
13
 pg_dirtyread -
RPM
PIGSTY
 2.7
18
17
16
15
14
13
 pg_dirtyread_$v* -
DEB
PGDG
 2.7
18
17
16
15
14
13
 postgresql-$v-dirtyread -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
el8.aarch64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
el9.x86_64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
el9.aarch64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
el10.x86_64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
el10.aarch64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
d12.x86_64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
d12.aarch64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
d13.x86_64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
d13.aarch64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
u22.x86_64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
u22.aarch64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
u24.x86_64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
u24.aarch64
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
PGDG 2.7
Package Version OS ORG SIZE File URL
pg_dirtyread_18 2.7 el8.x86_64 pgdg 17.0 KiB pg_dirtyread_18-2.7-4PGDG.rhel8.x86_64.rpm
pg_dirtyread_18 2.7 el8.aarch64 pgdg 16.9 KiB pg_dirtyread_18-2.7-4PGDG.rhel8.aarch64.rpm
pg_dirtyread_18 2.7 el9.x86_64 pgdg 17.2 KiB pg_dirtyread_18-2.7-4PGDG.rhel9.x86_64.rpm
pg_dirtyread_18 2.7 el9.aarch64 pgdg 16.6 KiB pg_dirtyread_18-2.7-4PGDG.rhel9.aarch64.rpm
pg_dirtyread_18 2.7 el10.x86_64 pgdg 17.7 KiB pg_dirtyread_18-2.7-4PGDG.rhel10.x86_64.rpm
pg_dirtyread_18 2.7 el10.aarch64 pgdg 17.5 KiB pg_dirtyread_18-2.7-4PGDG.rhel10.aarch64.rpm
postgresql-18-dirtyread 2.7 d12.x86_64 pgdg 21.1 KiB postgresql-18-dirtyread_2.7-3.pgdg12+1_amd64.deb
postgresql-18-dirtyread 2.7 d12.aarch64 pgdg 20.9 KiB postgresql-18-dirtyread_2.7-3.pgdg12+1_arm64.deb
postgresql-18-dirtyread 2.7 d13.x86_64 pgdg 21.1 KiB postgresql-18-dirtyread_2.7-3.pgdg13+1_amd64.deb
postgresql-18-dirtyread 2.7 d13.aarch64 pgdg 20.9 KiB postgresql-18-dirtyread_2.7-3.pgdg13+1_arm64.deb
postgresql-18-dirtyread 2.7 u22.x86_64 pgdg 22.0 KiB postgresql-18-dirtyread_2.7-3.pgdg22.04+1_amd64.deb
postgresql-18-dirtyread 2.7 u22.aarch64 pgdg 21.4 KiB postgresql-18-dirtyread_2.7-3.pgdg22.04+1_arm64.deb
postgresql-18-dirtyread 2.7 u24.x86_64 pgdg 21.2 KiB postgresql-18-dirtyread_2.7-3.pgdg24.04+1_amd64.deb
postgresql-18-dirtyread 2.7 u24.aarch64 pgdg 20.9 KiB postgresql-18-dirtyread_2.7-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_dirtyread_17 2.7 el8.x86_64 pgdg 16.8 KiB pg_dirtyread_17-2.7-2PGDG.rhel8.x86_64.rpm
pg_dirtyread_17 2.7 el8.aarch64 pgdg 16.7 KiB pg_dirtyread_17-2.7-2PGDG.rhel8.aarch64.rpm
pg_dirtyread_17 2.7 el9.x86_64 pgdg 17.0 KiB pg_dirtyread_17-2.7-2PGDG.rhel9.x86_64.rpm
pg_dirtyread_17 2.7 el9.aarch64 pgdg 16.6 KiB pg_dirtyread_17-2.7-2PGDG.rhel9.aarch64.rpm
pg_dirtyread_17 2.7 el10.x86_64 pgdg 17.6 KiB pg_dirtyread_17-2.7-4PGDG.rhel10.x86_64.rpm
pg_dirtyread_17 2.7 el10.aarch64 pgdg 17.4 KiB pg_dirtyread_17-2.7-4PGDG.rhel10.aarch64.rpm
postgresql-17-dirtyread 2.7 d12.x86_64 pgdg 20.9 KiB postgresql-17-dirtyread_2.7-3.pgdg12+1_amd64.deb
postgresql-17-dirtyread 2.7 d12.aarch64 pgdg 20.8 KiB postgresql-17-dirtyread_2.7-3.pgdg12+1_arm64.deb
postgresql-17-dirtyread 2.7 d13.x86_64 pgdg 20.9 KiB postgresql-17-dirtyread_2.7-3.pgdg13+1_amd64.deb
postgresql-17-dirtyread 2.7 d13.aarch64 pgdg 20.9 KiB postgresql-17-dirtyread_2.7-3.pgdg13+1_arm64.deb
postgresql-17-dirtyread 2.7 u22.x86_64 pgdg 26.0 KiB postgresql-17-dirtyread_2.7-3.pgdg22.04+1_amd64.deb
postgresql-17-dirtyread 2.7 u22.aarch64 pgdg 25.3 KiB postgresql-17-dirtyread_2.7-3.pgdg22.04+1_arm64.deb
postgresql-17-dirtyread 2.7 u24.x86_64 pgdg 21.1 KiB postgresql-17-dirtyread_2.7-3.pgdg24.04+1_amd64.deb
postgresql-17-dirtyread 2.7 u24.aarch64 pgdg 20.8 KiB postgresql-17-dirtyread_2.7-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_dirtyread_16 2.7 el8.x86_64 pgdg 16.7 KiB pg_dirtyread_16-2.7-1PGDG.rhel8.x86_64.rpm
pg_dirtyread_16 2.7 el8.aarch64 pgdg 16.6 KiB pg_dirtyread_16-2.7-1PGDG.rhel8.aarch64.rpm
pg_dirtyread_16 2.7 el9.x86_64 pgdg 16.9 KiB pg_dirtyread_16-2.7-1PGDG.rhel9.x86_64.rpm
pg_dirtyread_16 2.7 el9.aarch64 pgdg 16.5 KiB pg_dirtyread_16-2.7-1PGDG.rhel9.aarch64.rpm
pg_dirtyread_16 2.7 el10.x86_64 pgdg 17.6 KiB pg_dirtyread_16-2.7-4PGDG.rhel10.x86_64.rpm
pg_dirtyread_16 2.7 el10.aarch64 pgdg 17.4 KiB pg_dirtyread_16-2.7-4PGDG.rhel10.aarch64.rpm
postgresql-16-dirtyread 2.7 d12.x86_64 pgdg 20.9 KiB postgresql-16-dirtyread_2.7-3.pgdg12+1_amd64.deb
postgresql-16-dirtyread 2.7 d12.aarch64 pgdg 20.8 KiB postgresql-16-dirtyread_2.7-3.pgdg12+1_arm64.deb
postgresql-16-dirtyread 2.7 d13.x86_64 pgdg 21.0 KiB postgresql-16-dirtyread_2.7-3.pgdg13+1_amd64.deb
postgresql-16-dirtyread 2.7 d13.aarch64 pgdg 20.9 KiB postgresql-16-dirtyread_2.7-3.pgdg13+1_arm64.deb
postgresql-16-dirtyread 2.7 u22.x86_64 pgdg 25.5 KiB postgresql-16-dirtyread_2.7-3.pgdg22.04+1_amd64.deb
postgresql-16-dirtyread 2.7 u22.aarch64 pgdg 24.9 KiB postgresql-16-dirtyread_2.7-3.pgdg22.04+1_arm64.deb
postgresql-16-dirtyread 2.7 u24.x86_64 pgdg 21.1 KiB postgresql-16-dirtyread_2.7-3.pgdg24.04+1_amd64.deb
postgresql-16-dirtyread 2.7 u24.aarch64 pgdg 20.8 KiB postgresql-16-dirtyread_2.7-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_dirtyread_15 2.7 el8.x86_64 pgdg 16.8 KiB pg_dirtyread_15-2.7-1PGDG.rhel8.x86_64.rpm
pg_dirtyread_15 2.7 el8.aarch64 pgdg 16.6 KiB pg_dirtyread_15-2.7-1PGDG.rhel8.aarch64.rpm
pg_dirtyread_15 2.7 el9.x86_64 pgdg 17.0 KiB pg_dirtyread_15-2.7-1PGDG.rhel9.x86_64.rpm
pg_dirtyread_15 2.7 el9.aarch64 pgdg 16.8 KiB pg_dirtyread_15-2.7-1PGDG.rhel9.aarch64.rpm
pg_dirtyread_15 2.7 el10.x86_64 pgdg 17.7 KiB pg_dirtyread_15-2.7-4PGDG.rhel10.x86_64.rpm
pg_dirtyread_15 2.7 el10.aarch64 pgdg 17.6 KiB pg_dirtyread_15-2.7-4PGDG.rhel10.aarch64.rpm
postgresql-15-dirtyread 2.7 d12.x86_64 pgdg 21.1 KiB postgresql-15-dirtyread_2.7-3.pgdg12+1_amd64.deb
postgresql-15-dirtyread 2.7 d12.aarch64 pgdg 20.8 KiB postgresql-15-dirtyread_2.7-3.pgdg12+1_arm64.deb
postgresql-15-dirtyread 2.7 d13.x86_64 pgdg 21.1 KiB postgresql-15-dirtyread_2.7-3.pgdg13+1_amd64.deb
postgresql-15-dirtyread 2.7 d13.aarch64 pgdg 20.9 KiB postgresql-15-dirtyread_2.7-3.pgdg13+1_arm64.deb
postgresql-15-dirtyread 2.7 u22.x86_64 pgdg 25.6 KiB postgresql-15-dirtyread_2.7-3.pgdg22.04+1_amd64.deb
postgresql-15-dirtyread 2.7 u22.aarch64 pgdg 25.0 KiB postgresql-15-dirtyread_2.7-3.pgdg22.04+1_arm64.deb
postgresql-15-dirtyread 2.7 u24.x86_64 pgdg 21.1 KiB postgresql-15-dirtyread_2.7-3.pgdg24.04+1_amd64.deb
postgresql-15-dirtyread 2.7 u24.aarch64 pgdg 20.9 KiB postgresql-15-dirtyread_2.7-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_dirtyread_14 2.7 el8.x86_64 pgdg 16.8 KiB pg_dirtyread_14-2.7-1PGDG.rhel8.x86_64.rpm
pg_dirtyread_14 2.7 el8.aarch64 pgdg 16.6 KiB pg_dirtyread_14-2.7-1PGDG.rhel8.aarch64.rpm
pg_dirtyread_14 2.7 el9.x86_64 pgdg 17.0 KiB pg_dirtyread_14-2.7-1PGDG.rhel9.x86_64.rpm
pg_dirtyread_14 2.7 el9.aarch64 pgdg 16.8 KiB pg_dirtyread_14-2.7-1PGDG.rhel9.aarch64.rpm
pg_dirtyread_14 2.7 el10.x86_64 pgdg 17.7 KiB pg_dirtyread_14-2.7-4PGDG.rhel10.x86_64.rpm
pg_dirtyread_14 2.7 el10.aarch64 pgdg 17.6 KiB pg_dirtyread_14-2.7-4PGDG.rhel10.aarch64.rpm
postgresql-14-dirtyread 2.7 d12.x86_64 pgdg 21.0 KiB postgresql-14-dirtyread_2.7-3.pgdg12+1_amd64.deb
postgresql-14-dirtyread 2.7 d12.aarch64 pgdg 20.8 KiB postgresql-14-dirtyread_2.7-3.pgdg12+1_arm64.deb
postgresql-14-dirtyread 2.7 d13.x86_64 pgdg 21.1 KiB postgresql-14-dirtyread_2.7-3.pgdg13+1_amd64.deb
postgresql-14-dirtyread 2.7 d13.aarch64 pgdg 20.9 KiB postgresql-14-dirtyread_2.7-3.pgdg13+1_arm64.deb
postgresql-14-dirtyread 2.7 u22.x86_64 pgdg 25.5 KiB postgresql-14-dirtyread_2.7-3.pgdg22.04+1_amd64.deb
postgresql-14-dirtyread 2.7 u22.aarch64 pgdg 25.0 KiB postgresql-14-dirtyread_2.7-3.pgdg22.04+1_arm64.deb
postgresql-14-dirtyread 2.7 u24.x86_64 pgdg 21.1 KiB postgresql-14-dirtyread_2.7-3.pgdg24.04+1_amd64.deb
postgresql-14-dirtyread 2.7 u24.aarch64 pgdg 20.8 KiB postgresql-14-dirtyread_2.7-3.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_dirtyread_13 2.7 el8.x86_64 pgdg 16.7 KiB pg_dirtyread_13-2.7-1PGDG.rhel8.x86_64.rpm
pg_dirtyread_13 2.7 el8.aarch64 pgdg 16.6 KiB pg_dirtyread_13-2.7-1PGDG.rhel8.aarch64.rpm
pg_dirtyread_13 2.7 el9.x86_64 pgdg 17.0 KiB pg_dirtyread_13-2.7-1PGDG.rhel9.x86_64.rpm
pg_dirtyread_13 2.7 el9.aarch64 pgdg 16.7 KiB pg_dirtyread_13-2.7-1PGDG.rhel9.aarch64.rpm
pg_dirtyread_13 2.7 el10.x86_64 pgdg 17.7 KiB pg_dirtyread_13-2.7-4PGDG.rhel10.x86_64.rpm
pg_dirtyread_13 2.7 el10.aarch64 pgdg 17.6 KiB pg_dirtyread_13-2.7-4PGDG.rhel10.aarch64.rpm
postgresql-13-dirtyread 2.7 d12.x86_64 pgdg 20.9 KiB postgresql-13-dirtyread_2.7-3.pgdg12+1_amd64.deb
postgresql-13-dirtyread 2.7 d12.aarch64 pgdg 20.8 KiB postgresql-13-dirtyread_2.7-3.pgdg12+1_arm64.deb
postgresql-13-dirtyread 2.7 d13.x86_64 pgdg 20.9 KiB postgresql-13-dirtyread_2.7-3.pgdg13+1_amd64.deb
postgresql-13-dirtyread 2.7 d13.aarch64 pgdg 20.7 KiB postgresql-13-dirtyread_2.7-3.pgdg13+1_arm64.deb
postgresql-13-dirtyread 2.7 u22.x86_64 pgdg 25.2 KiB postgresql-13-dirtyread_2.7-3.pgdg22.04+1_amd64.deb
postgresql-13-dirtyread 2.7 u22.aarch64 pgdg 24.9 KiB postgresql-13-dirtyread_2.7-3.pgdg22.04+1_arm64.deb
postgresql-13-dirtyread 2.7 u24.x86_64 pgdg 20.9 KiB postgresql-13-dirtyread_2.7-3.pgdg24.04+1_amd64.deb
postgresql-13-dirtyread 2.7 u24.aarch64 pgdg 20.6 KiB postgresql-13-dirtyread_2.7-3.pgdg24.04+1_arm64.deb

Source

Repository
github.com/df7cb/pg_dirtyread
 Source Tarball
pg_dirtyread-2.7.tar.gz
 
pig build pkg pg_dirtyread;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install pg_dirtyread;		# install via package name, for the active PG version

pig install pg_dirtyread -v 18;   # install for PG 18
pig install pg_dirtyread -v 17;   # install for PG 17
pig install pg_dirtyread -v 16;   # install for PG 16
pig install pg_dirtyread -v 15;   # install for PG 15
pig install pg_dirtyread -v 14;   # install for PG 14
pig install pg_dirtyread -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pg_dirtyread;
Last updated on
pg_squeezepgfincore