aqo icon indicating copy to clipboard operation
aqo copied to clipboard

AQO state for IndexScan doesn't contain Index column

Open danolivo opened this issue 4 years ago • 0 comments

explore_query_plan.sql.zip

Index Scan using person_pkey on person (cost=0.29..3226.29 rows=9738 width=8) (actual rows=9738 loops=1) (AQO: cardinality=9738, error=0%, fss hash = -1150030445)

SELECT * FROM aqo_data WHERE fsspace_hash=-1150030445;
fspace_hash | fsspace_hash | nfeatures | features | targets -------------+--------------+-----------+----------+--------- 1916361181 | -1150030445 | 0 | | {0.01}

Index Only Scan using person_id_age_idx on public.person (cost=0.29..8.31 rows=1 width=8) (actual rows=1 loops=10) (AQO: cardinality=1, error=0%, fss hash = 1972255378)

SELECT * FROM aqo_data WHERE fsspace_hash=1972255378; fspace_hash | fsspace_hash | nfeatures | features | targets -------------+--------------+-----------+-------------------------+--------- 1916361181 | 1972255378 | 1 | {{-11.512925464970229}} | {0}

danolivo avatar Feb 23 '21 18:02 danolivo