Approximate count distincts

This section includes functions related to approximating distinct counts. Approximate count distincts are used to find the number of unique values, or cardinality, in a large dataset. For more information about approximate count distinct functions, see the hyperfunctions documentation.

Some hyperfunctions are included in the default TimescaleDB product. For additional hyperfunctions, you need to install the Timescale Toolkit PostgreSQL extension.

Hyperfunction subfamilyHyperfunction typeAPI callToolkitExperimental
HyperloglogAggregatehyperloglog
Accessordistinct_count
stderror
Rolluprollup

Found an issue on this page?

Report an issue!

Related Content