Module approx_count_distinct

Source

Modulesยง

append_only ๐Ÿ”’
updatable ๐Ÿ”’

Structsยง

AppendOnlyApproxCountDistinct ๐Ÿ”’
Registers ๐Ÿ”’
Approximates the count of non-null rows using a modified version of the HyperLogLog algorithm. Each Bucket 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.
UpdatableApproxCountDistinct ๐Ÿ”’

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ยง

AppendOnlyRegisters ๐Ÿ”’
UpdatableRegisters ๐Ÿ”’