Extensions / Functions and aggregates
Aggregation functions and data type for distinct estimation based on HyperLogLog.
pgext.cloud · Source code · Documentation · License text · Control file · PGXN
| Package | distinct_estimators |
|---|---|
| Version | 1.2.6 |
| PostgreSQL versions | 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Archived |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 18 |
| Latest commit | 2019-11-03 |
| Latest release | 2015-09-01 |
| Catalogue updated | 2026-08-30 |
| hll | type for storing hyperloglog data |
| pghll | Provides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters. |
| argm | argmax, argmin, and anyold aggregate functions |
| pg_prob | Probabilistic data types for PostgreSQL - Monte Carlo simulation in SQL |
| count_distinct | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |
| kissfft | Fast-Fourier transformer (fft) |
| binvec | C helper for summing integer bit values into arrays |
| pg_etag | Fast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates. |
| median | Median aggregate function for input sets |
| graph_component | Compute graph components |
| adaptive_counter | Aggregation functions and data type for distinct estimation based on adaptive sampling. |
| bitmap_counter | Aggregation functions and data type for distinct estimation based on s-bitmap. |
| loglog_counter | Aggregation functions and data type for distinct estimation based on LogLog. |
| pcsa_counter | Aggregation functions and data type for distinct estimation based on PCSA. |
| probabilistic_counter | A C data type and aggregates for approximate distinct counting using the Flajolet-Martin probabilistic counting algorithm. |
| superloglog_counter | C data type, functions, and aggregates for approximate distinct counting with the SuperLogLog algorithm. |