Modulesยง
- append_
only ๐ - updatable ๐
Structsยง
- Append
Only ๐Approx Count Distinct - Registers ๐
- Approximates the count of non-null rows using a modified version of the
HyperLogLog
algorithm. EachBucket
stores a count of how many hash values have x trailing zeroes for all x from 1-64. This allows the algorithm to support insertion and deletion, but uses up more memory and limits the number of rows that can be counted. - Updatable
Approx ๐Count Distinct
Constantsยง
- BIAS_
CORRECTION ๐ - COUNT_
BITS ๐ - INDEX_
BITS ๐ - LOG_
COUNT_ ๐BITS - NUM_
OF_ ๐REGISTERS
Staticsยง
- _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ anyarray_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ anyarray_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ anymap_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ anymap_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ boolean_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ boolean_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ bytea_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ bytea_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ date_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ date_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ decimal_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ decimal_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ float4_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ float4_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ float8_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ float8_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ int2_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ int2_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ int4_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ int4_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ int8_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ int8_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ int256_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ int256_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ interval_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ interval_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ jsonb_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ jsonb_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ serial_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ serial_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ struct_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ struct_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ time_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ time_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ timestamp_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ timestamp_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ timestamptz_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ timestamptz_ int8_ append_ only - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ varchar_ int8 - _LINKME_
ELEMENT_ ๐approx_ count_ distinct_ varchar_ int8_ append_ only
Traitsยง
- Bucket ๐
Functionsยง
- approx_
count_ ๐distinct_ anyarray_ int8 - approx_
count_ ๐distinct_ anyarray_ int8_ append_ only - approx_
count_ ๐distinct_ anymap_ int8 - approx_
count_ ๐distinct_ anymap_ int8_ append_ only - approx_
count_ ๐distinct_ boolean_ int8 - approx_
count_ ๐distinct_ boolean_ int8_ append_ only - approx_
count_ ๐distinct_ bytea_ int8 - approx_
count_ ๐distinct_ bytea_ int8_ append_ only - approx_
count_ ๐distinct_ date_ int8 - approx_
count_ ๐distinct_ date_ int8_ append_ only - approx_
count_ ๐distinct_ decimal_ int8 - approx_
count_ ๐distinct_ decimal_ int8_ append_ only - approx_
count_ ๐distinct_ float4_ int8 - approx_
count_ ๐distinct_ float4_ int8_ append_ only - approx_
count_ ๐distinct_ float8_ int8 - approx_
count_ ๐distinct_ float8_ int8_ append_ only - approx_
count_ ๐distinct_ int2_ int8 - approx_
count_ ๐distinct_ int2_ int8_ append_ only - approx_
count_ ๐distinct_ int4_ int8 - approx_
count_ ๐distinct_ int4_ int8_ append_ only - approx_
count_ ๐distinct_ int8_ int8 - approx_
count_ ๐distinct_ int8_ int8_ append_ only - approx_
count_ ๐distinct_ int256_ int8 - approx_
count_ ๐distinct_ int256_ int8_ append_ only - approx_
count_ ๐distinct_ interval_ int8 - approx_
count_ ๐distinct_ interval_ int8_ append_ only - approx_
count_ ๐distinct_ jsonb_ int8 - approx_
count_ ๐distinct_ jsonb_ int8_ append_ only - approx_
count_ ๐distinct_ serial_ int8 - approx_
count_ ๐distinct_ serial_ int8_ append_ only - approx_
count_ ๐distinct_ struct_ int8 - approx_
count_ ๐distinct_ struct_ int8_ append_ only - approx_
count_ ๐distinct_ time_ int8 - approx_
count_ ๐distinct_ time_ int8_ append_ only - approx_
count_ ๐distinct_ timestamp_ int8 - approx_
count_ ๐distinct_ timestamp_ int8_ append_ only - approx_
count_ ๐distinct_ timestamptz_ int8 - approx_
count_ ๐distinct_ timestamptz_ int8_ append_ only - approx_
count_ ๐distinct_ varchar_ int8 - approx_
count_ ๐distinct_ varchar_ int8_ append_ only - build_
append_ ๐only - Count the approximate number of unique non-null values.
- build_
updatable ๐ - Count the approximate number of unique non-null values.
- pos_
in_ ๐serialized
Type Aliasesยง
- Append
Only ๐Registers - Updatable
Registers ๐