SET enable_seqscan = off; CREATE TABLE t (val sparsevec(3)); INSERT INTO t (val) VALUES ('{}/3'), ('{0:1,1:2,2:3}/3'), ('{0:1,1:1,2:1}/3'), (NULL); CREATE INDEX ON t USING hnsw (val sparsevec_ip_ops); INSERT INTO t (val) VALUES ('{0:1,1:2,2:4}/3'); SELECT * FROM t ORDER BY val <#> '{0:3,1:3,2:3}/3'; SELECT COUNT(*) FROM (SELECT * FROM t ORDER BY val <#> (SELECT NULL::sparsevec)) t2; DROP TABLE t;