quantile

Quantile aggregation function

Overview

Package	Version	Category	License	Language
`quantile`	`1.1.8`	FUNC	BSD-2-Clause	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
4610	`quantile`	No	Yes	No	Yes	No	No	-

Related	`ddsketch` `tdigest` `weighted_statistics` `lower_quantile` `topn` `count_distinct` `omnisketch` `datasketches` `hll`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PIGSTY	`1.1.8`	1817161514	`quantile`	-
RPM	PIGSTY	`1.1.8`	1817161514	`quantile_$v`	-
DEB	PIGSTY	`1.1.8`	1817161514	`postgresql-$v-quantile`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.1.8 el8.x86_64.pg18 : quantile_18 quantile_18-1.1.8-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.8 · 18.5KiB	PIGSTY 1.1.8 el8.x86_64.pg17 : quantile_17 quantile_17-1.1.8-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.8 · 18.5KiB	PIGSTY 1.1.8 el8.x86_64.pg16 : quantile_16 quantile_16-1.1.8-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.8 · 18.5KiB	PIGSTY 1.1.8 el8.x86_64.pg15 : quantile_15 quantile_15-1.1.8-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.8 · 18.5KiB	PIGSTY 1.1.8 el8.x86_64.pg14 : quantile_14 quantile_14-1.1.8-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.8 · 18.5KiB
el8.aarch64	PIGSTY 1.1.8 el8.aarch64.pg18 : quantile_18 quantile_18-1.1.8-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB	PIGSTY 1.1.8 el8.aarch64.pg17 : quantile_17 quantile_17-1.1.8-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB	PIGSTY 1.1.8 el8.aarch64.pg16 : quantile_16 quantile_16-1.1.8-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB	PIGSTY 1.1.8 el8.aarch64.pg15 : quantile_15 quantile_15-1.1.8-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB	PIGSTY 1.1.8 el8.aarch64.pg14 : quantile_14 quantile_14-1.1.8-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB
el9.x86_64	PIGSTY 1.1.8 el9.x86_64.pg18 : quantile_18 quantile_18-1.1.8-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.8 · 18.1KiB	PIGSTY 1.1.8 el9.x86_64.pg17 : quantile_17 quantile_17-1.1.8-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.8 · 18.2KiB	PIGSTY 1.1.8 el9.x86_64.pg16 : quantile_16 quantile_16-1.1.8-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.8 · 18.2KiB	PIGSTY 1.1.8 el9.x86_64.pg15 : quantile_15 quantile_15-1.1.8-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.8 · 18.2KiB	PIGSTY 1.1.8 el9.x86_64.pg14 : quantile_14 quantile_14-1.1.8-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.8 · 18.1KiB
el9.aarch64	PIGSTY 1.1.8 el9.aarch64.pg18 : quantile_18 quantile_18-1.1.8-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.8 · 17.5KiB	PIGSTY 1.1.8 el9.aarch64.pg17 : quantile_17 quantile_17-1.1.8-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.8 · 17.5KiB	PIGSTY 1.1.8 el9.aarch64.pg16 : quantile_16 quantile_16-1.1.8-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.8 · 17.5KiB	PIGSTY 1.1.8 el9.aarch64.pg15 : quantile_15 quantile_15-1.1.8-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.8 · 17.5KiB	PIGSTY 1.1.8 el9.aarch64.pg14 : quantile_14 quantile_14-1.1.8-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.8 · 17.5KiB
el10.x86_64	PIGSTY 1.1.8 el10.x86_64.pg18 : quantile_18 quantile_18-1.1.8-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.8 · 18.1KiB	PIGSTY 1.1.8 el10.x86_64.pg17 : quantile_17 quantile_17-1.1.8-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.8 · 18.1KiB	PIGSTY 1.1.8 el10.x86_64.pg16 : quantile_16 quantile_16-1.1.8-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.8 · 18.1KiB	PIGSTY 1.1.8 el10.x86_64.pg15 : quantile_15 quantile_15-1.1.8-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.8 · 18.1KiB	PIGSTY 1.1.8 el10.x86_64.pg14 : quantile_14 quantile_14-1.1.8-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.8 · 18.1KiB
el10.aarch64	PIGSTY 1.1.8 el10.aarch64.pg18 : quantile_18 quantile_18-1.1.8-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB	PIGSTY 1.1.8 el10.aarch64.pg17 : quantile_17 quantile_17-1.1.8-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB	PIGSTY 1.1.8 el10.aarch64.pg16 : quantile_16 quantile_16-1.1.8-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB	PIGSTY 1.1.8 el10.aarch64.pg15 : quantile_15 quantile_15-1.1.8-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB	PIGSTY 1.1.8 el10.aarch64.pg14 : quantile_14 quantile_14-1.1.8-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.8 · 17.8KiB
d12.x86_64	PIGSTY 1.1.8 d12.x86_64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.8 · 21.5KiB	PIGSTY 1.1.8 d12.x86_64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.8 · 21.2KiB	PIGSTY 1.1.8 d12.x86_64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.8 · 21.2KiB	PIGSTY 1.1.8 d12.x86_64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.8 · 21.2KiB	PIGSTY 1.1.8 d12.x86_64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.8 · 21.3KiB
d12.aarch64	PIGSTY 1.1.8 d12.aarch64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.8 · 21.2KiB	PIGSTY 1.1.8 d12.aarch64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.8 · 20.9KiB	PIGSTY 1.1.8 d12.aarch64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.8 · 20.9KiB	PIGSTY 1.1.8 d12.aarch64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.8 · 20.9KiB	PIGSTY 1.1.8 d12.aarch64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.8 · 21.0KiB
d13.x86_64	PIGSTY 1.1.8 d13.x86_64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.8 · 21.5KiB	PIGSTY 1.1.8 d13.x86_64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.8 · 21.2KiB	PIGSTY 1.1.8 d13.x86_64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.8 · 21.2KiB	PIGSTY 1.1.8 d13.x86_64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.8 · 21.2KiB	PIGSTY 1.1.8 d13.x86_64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.8 · 21.3KiB
d13.aarch64	PIGSTY 1.1.8 d13.aarch64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.8 · 21.3KiB	PIGSTY 1.1.8 d13.aarch64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.8 · 21.0KiB	PIGSTY 1.1.8 d13.aarch64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.8 · 21.0KiB	PIGSTY 1.1.8 d13.aarch64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.8 · 21.0KiB	PIGSTY 1.1.8 d13.aarch64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.8 · 21.1KiB
u22.x86_64	PIGSTY 1.1.8 u22.x86_64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.8 · 22.7KiB	PIGSTY 1.1.8 u22.x86_64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.8 · 23.9KiB	PIGSTY 1.1.8 u22.x86_64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.8 · 23.8KiB	PIGSTY 1.1.8 u22.x86_64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.8 · 23.6KiB	PIGSTY 1.1.8 u22.x86_64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.8 · 23.6KiB
u22.aarch64	PIGSTY 1.1.8 u22.aarch64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.8 · 21.8KiB	PIGSTY 1.1.8 u22.aarch64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.8 · 23.0KiB	PIGSTY 1.1.8 u22.aarch64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.8 · 23.0KiB	PIGSTY 1.1.8 u22.aarch64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.8 · 22.7KiB	PIGSTY 1.1.8 u22.aarch64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.8 · 22.7KiB
u24.x86_64	PIGSTY 1.1.8 u24.x86_64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.8 · 22.6KiB	PIGSTY 1.1.8 u24.x86_64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.8 · 22.3KiB	PIGSTY 1.1.8 u24.x86_64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.8 · 22.2KiB	PIGSTY 1.1.8 u24.x86_64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.8 · 22.2KiB	PIGSTY 1.1.8 u24.x86_64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.8 · 22.3KiB
u24.aarch64	PIGSTY 1.1.8 u24.aarch64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.8 · 22.2KiB	PIGSTY 1.1.8 u24.aarch64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.8 · 22.0KiB	PIGSTY 1.1.8 u24.aarch64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.8 · 21.9KiB	PIGSTY 1.1.8 u24.aarch64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.8 · 21.9KiB	PIGSTY 1.1.8 u24.aarch64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.8 · 22.0KiB
u26.x86_64	PIGSTY 1.1.8 u26.x86_64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.8 · 22.5KiB	PIGSTY 1.1.8 u26.x86_64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.8 · 22.4KiB	PIGSTY 1.1.8 u26.x86_64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.8 · 22.4KiB	PIGSTY 1.1.8 u26.x86_64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.8 · 22.6KiB	PIGSTY 1.1.8 u26.x86_64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.8 · 22.6KiB
u26.aarch64	PIGSTY 1.1.8 u26.aarch64.pg18 : postgresql-18-quantile postgresql-18-quantile_1.1.8-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.8 · 22.2KiB	PIGSTY 1.1.8 u26.aarch64.pg17 : postgresql-17-quantile postgresql-17-quantile_1.1.8-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.8 · 22.0KiB	PIGSTY 1.1.8 u26.aarch64.pg16 : postgresql-16-quantile postgresql-16-quantile_1.1.8-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.8 · 22.0KiB	PIGSTY 1.1.8 u26.aarch64.pg15 : postgresql-15-quantile postgresql-15-quantile_1.1.8-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.8 · 22.0KiB	PIGSTY 1.1.8 u26.aarch64.pg14 : postgresql-14-quantile postgresql-14-quantile_1.1.8-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.8 · 22.0KiB

Build

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

pig build pkg quantile         # build RPM / DEB packages

Install

You can install quantile 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 quantile;          # Install for current active PG version

pig

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

dnf

dnf install -y quantile_18       # PG 18
dnf install -y quantile_17       # PG 17
dnf install -y quantile_16       # PG 16
dnf install -y quantile_15       # PG 15
dnf install -y quantile_14       # PG 14

apt

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

Create Extension:

CREATE EXTENSION quantile;

Usage

quantile: quantile aggregate functions for PostgreSQL

Provides aggregate functions to compute quantiles. Overloaded for int, bigint, double precision, and numeric.

CREATE EXTENSION quantile;

Functions

Function	Description
`quantile(value, quantile float)`	Compute a single quantile (0 to 1)
`quantile(value, quantiles float[])`	Compute multiple quantiles at once, returns array

Examples

-- Compute the median (0.5 quantile)
SELECT quantile(i, 0.5) FROM generate_series(1, 1000) s(i);
-- 500

-- Compute the 95th percentile
SELECT quantile(i, 0.95) FROM generate_series(1, 1000) s(i);

-- Compute all quartiles at once (more efficient than separate calls)
SELECT quantile(i, ARRAY[0.25, 0.5, 0.75])
FROM generate_series(1, 1000) s(i);
-- {250, 500, 750}

Note: Since PostgreSQL 9.4, built-in percentile_cont and percentile_disc functions are available. Consider using those first and only use this extension if it provides measurably better performance for your workload.

quantile

Overview

Version

Build

Install

Usage

Functions

Examples

Was this page helpful?