Extensions / Functions and aggregates
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
pgext.cloud · Source code · License text · Control file · PGXN
| Package | count_distinct |
|---|---|
| Version | 3.0.2 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | Multiple repositories |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 80 |
| Latest commit | 2025-08-04 |
| Latest release | 2025-01-09 |
| Catalogue updated | 2026-08-30 |
| ddsketch | Provides ddsketch aggregate function |
| tdigest | Provides tdigest aggregate function. |
| topn | type for top-n JSONB |
| omnisketch | data structure for on-line agg of data into approximate sketch |
| datasketches | Approximate analytics sketches and aggregates for PostgreSQL |
| hll | type for storing hyperloglog data |
| intagg | integer aggregator and enumerator (obsolete) |
| intarray | functions, operators, and index support for 1-D arrays of integers |