tdigest

Provides tdigest aggregate function.

Overview

ID	Extension	Package	Version	Category	License	Language
4700	tdigest	tdigest	`1.4.3`	FUNC	Apache-2.0	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_idkit pgx_ulid pg_uuidv7 pg_hashids sequential_uuids topn quantile lower_quantile

Packages

Type	Repo	Version	PG Major Availability	Package Pattern	Dependencies
EL	PGDG	`1.4.2`	18 17 16 15 14 13	`tdigest_$v*`	-
Debian	PGDG	`1.4.3`	18 17 16 15 14 13	`postgresql-$v-tdigest`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.1	PGDG 1.4.1	PGDG 1.4.1	PGDG 1.4.1
el8.aarch64	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.1	PGDG 1.4.1	PGDG 1.4.1	PGDG 1.4.1
el9.x86_64	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.1	PGDG 1.4.1	PGDG 1.4.1	PGDG 1.4.1
el9.aarch64	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.1	PGDG 1.4.1	PGDG 1.4.1	PGDG 1.4.1
el10.x86_64	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.2
el10.aarch64	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.2	PGDG 1.4.2
d12.x86_64	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3
d12.aarch64	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3
d13.x86_64	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3
d13.aarch64	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3
u22.x86_64	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3
u22.aarch64	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3
u24.x86_64	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3
u24.aarch64	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3	PGDG 1.4.3

Package	Version	OS	ORG	SIZE	File URL
`tdigest_18`	1.4.2	`el8.x86_64`	pgdg	33.5 KiB	tdigest_18-1.4.2-2PGDG.rhel8.x86_64.rpm
`tdigest_18`	1.4.2	`el8.aarch64`	pgdg	32.1 KiB	tdigest_18-1.4.2-2PGDG.rhel8.aarch64.rpm
`tdigest_18`	1.4.2	`el9.x86_64`	pgdg	33.6 KiB	tdigest_18-1.4.2-2PGDG.rhel9.x86_64.rpm
`tdigest_18`	1.4.2	`el9.aarch64`	pgdg	32.3 KiB	tdigest_18-1.4.2-2PGDG.rhel9.aarch64.rpm
`tdigest_18`	1.4.2	`el10.x86_64`	pgdg	33.8 KiB	tdigest_18-1.4.2-2PGDG.rhel10.x86_64.rpm
`tdigest_18`	1.4.2	`el10.aarch64`	pgdg	33.2 KiB	tdigest_18-1.4.2-2PGDG.rhel10.aarch64.rpm
`postgresql-18-tdigest`	1.4.3	`d12.x86_64`	pgdg	57.6 KiB	postgresql-18-tdigest_1.4.3-2.pgdg12+1_amd64.deb
`postgresql-18-tdigest`	1.4.3	`d12.aarch64`	pgdg	56.7 KiB	postgresql-18-tdigest_1.4.3-2.pgdg12+1_arm64.deb
`postgresql-18-tdigest`	1.4.3	`d13.x86_64`	pgdg	57.5 KiB	postgresql-18-tdigest_1.4.3-2.pgdg13+1_amd64.deb
`postgresql-18-tdigest`	1.4.3	`d13.aarch64`	pgdg	56.9 KiB	postgresql-18-tdigest_1.4.3-2.pgdg13+1_arm64.deb
`postgresql-18-tdigest`	1.4.3	`u22.x86_64`	pgdg	58.0 KiB	postgresql-18-tdigest_1.4.3-2.pgdg22.04+1_amd64.deb
`postgresql-18-tdigest`	1.4.3	`u22.aarch64`	pgdg	57.0 KiB	postgresql-18-tdigest_1.4.3-2.pgdg22.04+1_arm64.deb
`postgresql-18-tdigest`	1.4.3	`u24.x86_64`	pgdg	57.7 KiB	postgresql-18-tdigest_1.4.3-2.pgdg24.04+1_amd64.deb
`postgresql-18-tdigest`	1.4.3	`u24.aarch64`	pgdg	56.9 KiB	postgresql-18-tdigest_1.4.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`tdigest_17`	1.4.2	`el8.x86_64`	pgdg	33.5 KiB	tdigest_17-1.4.2-1PGDG.rhel8.x86_64.rpm
`tdigest_17`	1.4.1	`el8.x86_64`	pgdg	33.2 KiB	tdigest_17-1.4.1-3PGDG.rhel8.x86_64.rpm
`tdigest_17`	1.4.2	`el8.aarch64`	pgdg	32.1 KiB	tdigest_17-1.4.2-1PGDG.rhel8.aarch64.rpm
`tdigest_17`	1.4.1	`el8.aarch64`	pgdg	31.8 KiB	tdigest_17-1.4.1-3PGDG.rhel8.aarch64.rpm
`tdigest_17`	1.4.2	`el9.x86_64`	pgdg	33.6 KiB	tdigest_17-1.4.2-1PGDG.rhel9.x86_64.rpm
`tdigest_17`	1.4.1	`el9.x86_64`	pgdg	33.3 KiB	tdigest_17-1.4.1-3PGDG.rhel9.x86_64.rpm
`tdigest_17`	1.4.2	`el9.aarch64`	pgdg	32.4 KiB	tdigest_17-1.4.2-1PGDG.rhel9.aarch64.rpm
`tdigest_17`	1.4.1	`el9.aarch64`	pgdg	32.1 KiB	tdigest_17-1.4.1-3PGDG.rhel9.aarch64.rpm
`tdigest_17`	1.4.2	`el10.x86_64`	pgdg	33.8 KiB	tdigest_17-1.4.2-2PGDG.rhel10.x86_64.rpm
`tdigest_17`	1.4.2	`el10.aarch64`	pgdg	33.2 KiB	tdigest_17-1.4.2-2PGDG.rhel10.aarch64.rpm
`postgresql-17-tdigest`	1.4.3	`d12.x86_64`	pgdg	57.6 KiB	postgresql-17-tdigest_1.4.3-2.pgdg12+1_amd64.deb
`postgresql-17-tdigest`	1.4.3	`d12.aarch64`	pgdg	56.7 KiB	postgresql-17-tdigest_1.4.3-2.pgdg12+1_arm64.deb
`postgresql-17-tdigest`	1.4.3	`d13.x86_64`	pgdg	57.5 KiB	postgresql-17-tdigest_1.4.3-2.pgdg13+1_amd64.deb
`postgresql-17-tdigest`	1.4.3	`d13.aarch64`	pgdg	57.0 KiB	postgresql-17-tdigest_1.4.3-2.pgdg13+1_arm64.deb
`postgresql-17-tdigest`	1.4.3	`u22.x86_64`	pgdg	60.2 KiB	postgresql-17-tdigest_1.4.3-2.pgdg22.04+1_amd64.deb
`postgresql-17-tdigest`	1.4.3	`u22.aarch64`	pgdg	59.3 KiB	postgresql-17-tdigest_1.4.3-2.pgdg22.04+1_arm64.deb
`postgresql-17-tdigest`	1.4.3	`u24.x86_64`	pgdg	57.6 KiB	postgresql-17-tdigest_1.4.3-2.pgdg24.04+1_amd64.deb
`postgresql-17-tdigest`	1.4.3	`u24.aarch64`	pgdg	56.9 KiB	postgresql-17-tdigest_1.4.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`tdigest_16`	1.4.1	`el8.x86_64`	pgdg	33.0 KiB	tdigest_16-1.4.1-1PGDG.rhel8.x86_64.rpm
`tdigest_16`	1.4.1	`el8.aarch64`	pgdg	31.6 KiB	tdigest_16-1.4.1-1PGDG.rhel8.aarch64.rpm
`tdigest_16`	1.4.1	`el9.x86_64`	pgdg	33.1 KiB	tdigest_16-1.4.1-1PGDG.rhel9.x86_64.rpm
`tdigest_16`	1.4.1	`el9.aarch64`	pgdg	31.6 KiB	tdigest_16-1.4.1-1PGDG.rhel9.aarch64.rpm
`tdigest_16`	1.4.2	`el10.x86_64`	pgdg	33.8 KiB	tdigest_16-1.4.2-2PGDG.rhel10.x86_64.rpm
`tdigest_16`	1.4.2	`el10.aarch64`	pgdg	33.2 KiB	tdigest_16-1.4.2-2PGDG.rhel10.aarch64.rpm
`postgresql-16-tdigest`	1.4.3	`d12.x86_64`	pgdg	57.5 KiB	postgresql-16-tdigest_1.4.3-2.pgdg12+1_amd64.deb
`postgresql-16-tdigest`	1.4.3	`d12.aarch64`	pgdg	56.7 KiB	postgresql-16-tdigest_1.4.3-2.pgdg12+1_arm64.deb
`postgresql-16-tdigest`	1.4.3	`d13.x86_64`	pgdg	57.5 KiB	postgresql-16-tdigest_1.4.3-2.pgdg13+1_amd64.deb
`postgresql-16-tdigest`	1.4.3	`d13.aarch64`	pgdg	57.0 KiB	postgresql-16-tdigest_1.4.3-2.pgdg13+1_arm64.deb
`postgresql-16-tdigest`	1.4.3	`u22.x86_64`	pgdg	60.2 KiB	postgresql-16-tdigest_1.4.3-2.pgdg22.04+1_amd64.deb
`postgresql-16-tdigest`	1.4.3	`u22.aarch64`	pgdg	59.3 KiB	postgresql-16-tdigest_1.4.3-2.pgdg22.04+1_arm64.deb
`postgresql-16-tdigest`	1.4.3	`u24.x86_64`	pgdg	57.6 KiB	postgresql-16-tdigest_1.4.3-2.pgdg24.04+1_amd64.deb
`postgresql-16-tdigest`	1.4.3	`u24.aarch64`	pgdg	56.9 KiB	postgresql-16-tdigest_1.4.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`tdigest_15`	1.4.1	`el8.x86_64`	pgdg	33.0 KiB	tdigest_15-1.4.1-1PGDG.rhel8.x86_64.rpm
`tdigest_15`	1.4.0	`el8.x86_64`	pgdg	70.1 KiB	tdigest_15-1.4.0-1.rhel8.x86_64.rpm
`tdigest_15`	1.4.1	`el8.aarch64`	pgdg	31.6 KiB	tdigest_15-1.4.1-1PGDG.rhel8.aarch64.rpm
`tdigest_15`	1.4.0	`el8.aarch64`	pgdg	68.6 KiB	tdigest_15-1.4.0-1.rhel8.aarch64.rpm
`tdigest_15`	1.4.1	`el9.x86_64`	pgdg	33.1 KiB	tdigest_15-1.4.1-1PGDG.rhel9.x86_64.rpm
`tdigest_15`	1.4.0	`el9.x86_64`	pgdg	72.1 KiB	tdigest_15-1.4.0-1.rhel9.x86_64.rpm
`tdigest_15`	1.4.1	`el9.aarch64`	pgdg	31.6 KiB	tdigest_15-1.4.1-1PGDG.rhel9.aarch64.rpm
`tdigest_15`	1.4.0	`el9.aarch64`	pgdg	70.6 KiB	tdigest_15-1.4.0-1.rhel9.aarch64.rpm
`tdigest_15`	1.4.2	`el10.x86_64`	pgdg	33.8 KiB	tdigest_15-1.4.2-2PGDG.rhel10.x86_64.rpm
`tdigest_15`	1.4.2	`el10.aarch64`	pgdg	33.2 KiB	tdigest_15-1.4.2-2PGDG.rhel10.aarch64.rpm
`postgresql-15-tdigest`	1.4.3	`d12.x86_64`	pgdg	57.6 KiB	postgresql-15-tdigest_1.4.3-2.pgdg12+1_amd64.deb
`postgresql-15-tdigest`	1.4.3	`d12.aarch64`	pgdg	56.7 KiB	postgresql-15-tdigest_1.4.3-2.pgdg12+1_arm64.deb
`postgresql-15-tdigest`	1.4.3	`d13.x86_64`	pgdg	57.5 KiB	postgresql-15-tdigest_1.4.3-2.pgdg13+1_amd64.deb
`postgresql-15-tdigest`	1.4.3	`d13.aarch64`	pgdg	57.0 KiB	postgresql-15-tdigest_1.4.3-2.pgdg13+1_arm64.deb
`postgresql-15-tdigest`	1.4.3	`u22.x86_64`	pgdg	60.5 KiB	postgresql-15-tdigest_1.4.3-2.pgdg22.04+1_amd64.deb
`postgresql-15-tdigest`	1.4.3	`u22.aarch64`	pgdg	59.5 KiB	postgresql-15-tdigest_1.4.3-2.pgdg22.04+1_arm64.deb
`postgresql-15-tdigest`	1.4.3	`u24.x86_64`	pgdg	57.6 KiB	postgresql-15-tdigest_1.4.3-2.pgdg24.04+1_amd64.deb
`postgresql-15-tdigest`	1.4.3	`u24.aarch64`	pgdg	56.9 KiB	postgresql-15-tdigest_1.4.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`tdigest_14`	1.4.1	`el8.x86_64`	pgdg	33.0 KiB	tdigest_14-1.4.1-1PGDG.rhel8.x86_64.rpm
`tdigest_14`	1.2.0	`el8.x86_64`	pgdg	60.3 KiB	tdigest_14-1.2.0-2.rhel8.x86_64.rpm
`tdigest_14`	1.4.1	`el8.aarch64`	pgdg	31.6 KiB	tdigest_14-1.4.1-1PGDG.rhel8.aarch64.rpm
`tdigest_14`	1.4.0	`el8.aarch64`	pgdg	68.5 KiB	tdigest_14-1.4.0-1.rhel8.aarch64.rpm
`tdigest_14`	1.4.1	`el9.x86_64`	pgdg	33.1 KiB	tdigest_14-1.4.1-1PGDG.rhel9.x86_64.rpm
`tdigest_14`	1.4.0	`el9.x86_64`	pgdg	72.2 KiB	tdigest_14-1.4.0-1.rhel9.x86_64.rpm
`tdigest_14`	1.4.1	`el9.aarch64`	pgdg	31.6 KiB	tdigest_14-1.4.1-1PGDG.rhel9.aarch64.rpm
`tdigest_14`	1.4.0	`el9.aarch64`	pgdg	70.6 KiB	tdigest_14-1.4.0-1.rhel9.aarch64.rpm
`tdigest_14`	1.4.2	`el10.x86_64`	pgdg	33.8 KiB	tdigest_14-1.4.2-2PGDG.rhel10.x86_64.rpm
`tdigest_14`	1.4.2	`el10.aarch64`	pgdg	33.2 KiB	tdigest_14-1.4.2-2PGDG.rhel10.aarch64.rpm
`postgresql-14-tdigest`	1.4.3	`d12.x86_64`	pgdg	57.5 KiB	postgresql-14-tdigest_1.4.3-2.pgdg12+1_amd64.deb
`postgresql-14-tdigest`	1.4.3	`d12.aarch64`	pgdg	56.7 KiB	postgresql-14-tdigest_1.4.3-2.pgdg12+1_arm64.deb
`postgresql-14-tdigest`	1.4.3	`d13.x86_64`	pgdg	57.5 KiB	postgresql-14-tdigest_1.4.3-2.pgdg13+1_amd64.deb
`postgresql-14-tdigest`	1.4.3	`d13.aarch64`	pgdg	56.9 KiB	postgresql-14-tdigest_1.4.3-2.pgdg13+1_arm64.deb
`postgresql-14-tdigest`	1.4.3	`u22.x86_64`	pgdg	60.4 KiB	postgresql-14-tdigest_1.4.3-2.pgdg22.04+1_amd64.deb
`postgresql-14-tdigest`	1.4.3	`u22.aarch64`	pgdg	59.4 KiB	postgresql-14-tdigest_1.4.3-2.pgdg22.04+1_arm64.deb
`postgresql-14-tdigest`	1.4.3	`u24.x86_64`	pgdg	57.5 KiB	postgresql-14-tdigest_1.4.3-2.pgdg24.04+1_amd64.deb
`postgresql-14-tdigest`	1.4.3	`u24.aarch64`	pgdg	56.9 KiB	postgresql-14-tdigest_1.4.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`tdigest_13`	1.4.1	`el8.x86_64`	pgdg	32.4 KiB	tdigest_13-1.4.1-1PGDG.rhel8.x86_64.rpm
`tdigest_13`	1.2.0	`el8.x86_64`	pgdg	59.9 KiB	tdigest_13-1.2.0-2.rhel8.x86_64.rpm
`tdigest_13`	1.0.1	`el8.x86_64`	pgdg	47.5 KiB	tdigest_13-1.0.1-1.rhel8.x86_64.rpm
`tdigest_13`	1.4.1	`el8.aarch64`	pgdg	31.6 KiB	tdigest_13-1.4.1-1PGDG.rhel8.aarch64.rpm
`tdigest_13`	1.4.0	`el8.aarch64`	pgdg	68.4 KiB	tdigest_13-1.4.0-1.rhel8.aarch64.rpm
`tdigest_13`	1.4.1	`el9.x86_64`	pgdg	33.1 KiB	tdigest_13-1.4.1-1PGDG.rhel9.x86_64.rpm
`tdigest_13`	1.4.0	`el9.x86_64`	pgdg	71.7 KiB	tdigest_13-1.4.0-1.rhel9.x86_64.rpm
`tdigest_13`	1.4.1	`el9.aarch64`	pgdg	31.7 KiB	tdigest_13-1.4.1-1PGDG.rhel9.aarch64.rpm
`tdigest_13`	1.4.0	`el9.aarch64`	pgdg	70.5 KiB	tdigest_13-1.4.0-1.rhel9.aarch64.rpm
`tdigest_13`	1.4.2	`el10.x86_64`	pgdg	33.8 KiB	tdigest_13-1.4.2-2PGDG.rhel10.x86_64.rpm
`tdigest_13`	1.4.2	`el10.aarch64`	pgdg	33.2 KiB	tdigest_13-1.4.2-2PGDG.rhel10.aarch64.rpm
`postgresql-13-tdigest`	1.4.3	`d12.x86_64`	pgdg	57.3 KiB	postgresql-13-tdigest_1.4.3-2.pgdg12+1_amd64.deb
`postgresql-13-tdigest`	1.4.3	`d12.aarch64`	pgdg	56.9 KiB	postgresql-13-tdigest_1.4.3-2.pgdg12+1_arm64.deb
`postgresql-13-tdigest`	1.4.3	`d13.x86_64`	pgdg	57.6 KiB	postgresql-13-tdigest_1.4.3-2.pgdg13+1_amd64.deb
`postgresql-13-tdigest`	1.4.3	`d13.aarch64`	pgdg	56.9 KiB	postgresql-13-tdigest_1.4.3-2.pgdg13+1_arm64.deb
`postgresql-13-tdigest`	1.4.3	`u22.x86_64`	pgdg	60.5 KiB	postgresql-13-tdigest_1.4.3-2.pgdg22.04+1_amd64.deb
`postgresql-13-tdigest`	1.4.3	`u22.aarch64`	pgdg	59.4 KiB	postgresql-13-tdigest_1.4.3-2.pgdg22.04+1_arm64.deb
`postgresql-13-tdigest`	1.4.3	`u24.x86_64`	pgdg	57.8 KiB	postgresql-13-tdigest_1.4.3-2.pgdg24.04+1_amd64.deb
`postgresql-13-tdigest`	1.4.3	`u24.aarch64`	pgdg	56.8 KiB	postgresql-13-tdigest_1.4.3-2.pgdg24.04+1_arm64.deb

Source

Repository

github.com/tvondra/tdigest

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install tdigest; # install by extension name, for the current active PG version
pig ext install tdigest; # install via package alias, for the active PG version
pig ext install tdigest -v 18;   # install for PG 18
pig ext install tdigest -v 17;   # install for PG 17
pig ext install tdigest -v 16;   # install for PG 16
pig ext install tdigest -v 15;   # install for PG 15
pig ext install tdigest -v 14;   # install for PG 14
pig ext install tdigest -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION tdigest;

Last updated on 2025-11-02

xicor first_last_agg