Extensions / Functions and aggregates
Fast approximate row counts for tables and indexes in PostgreSQL 14+ from pg class.reltuples, with a governed ANALYZE refresh
pgext.cloud · Source code · Documentation · Control file
| Package | approx_count |
|---|---|
| Version | 1.0 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | approx_count |
| Stars | 1 |
| Latest commit | 2026-06-23 |
| Latest release | 2026-06-23 |
| Catalogue updated | 2026-08-30 |
| alohadb_approx | Approximate query processing: HLL, Count-Min Sketch, Top-K |
| probabilistic_counter | A C data type and aggregates for approximate distinct counting using the Flajolet-Martin probabilistic counting algorithm. |
| count_distinct | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |