{"inputs": [150000], "asOf": 1000000000021}
CREATE TABLE
DROP INDEX
DELETE 1
DO
SET
create|mentat_auto_datoms_long_new_a1000004
ANALYZE
DO
before|162.50
after|141.14
PLAN BEFORE
HashAggregate (cost=31396.89..32043.77 rows=32344 width=64)
Group Key: ((datoms_long_new.e)::text), ((datoms_long_new.v)::text)
InitPlan 1 (returns $0)
-> Index Scan using schema_ident_key on mentat.schema (cost=0.15..2.37 rows=1 width=8)
Index Cond: (schema.ident = ':h/a3'::text)
-> Gather (cost=27836.68..31232.80 rows=32344 width=64)
Workers Planned: 4
Params Evaluated: $0
-> HashAggregate (cost=26836.68..26998.40 rows=8086 width=64)
Group Key: (datoms_long_new.e)::text, (datoms_long_new.v)::text
-> Result (cost=0.86..26796.25 rows=8086 width=64)
One-Time Filter: ($0 = 1000004)
-> Nested Loop Anti Join (cost=0.86..26715.39 rows=8086 width=16)
-> Parallel Index Only Scan using idx_datoms_long_new_aevt on mentat.datoms_long_new (cost=0.43..13925.99 rows=12055 width=32)
Index Cond: ((datoms_long_new.store_id = '0'::bigint) AND (datoms_long_new.a = 1000004) AND (datoms_long_new.tx <= '1000000000021'::bigint))
Filter: (datoms_long_new.v >= '150000'::bigint)
-> Result (cost=0.43..1.05 rows=1 width=24)
One-Time Filter: ($0 = 1000004)
-> Index Only Scan using idx_datoms_long_new_eavt on mentat.datoms_long_new newer (cost=0.43..1.05 rows=1 width=24)
Index Cond: ((newer.store_id = '0'::bigint) AND (newer.e = datoms_long_new.e) AND (newer.a = 1000004) AND (newer.tx > datoms_long_new.tx) AND (newer.tx <= '100000
Query Identifier: -7173263478281195968
PLAN AFTER
HashAggregate (cost=26050.20..26665.20 rows=30750 width=64)
Group Key: ((datoms_long_new.e)::text), ((datoms_long_new.v)::text)
InitPlan 1 (returns $0)
-> Index Scan using schema_ident_key on mentat.schema (cost=0.15..2.37 rows=1 width=8)
Index Cond: (schema.ident = ':h/a3'::text)
-> Gather (cost=22614.08..25894.08 rows=30750 width=64)
Workers Planned: 3
Params Evaluated: $0
-> HashAggregate (cost=21614.08..21819.08 rows=10250 width=64)
Group Key: (datoms_long_new.e)::text, (datoms_long_new.v)::text
-> Result (cost=8812.73..21562.83 rows=10250 width=64)
One-Time Filter: ($0 = 1000004)
-> Parallel Hash Right Anti Join (cost=8812.73..21460.33 rows=10250 width=16)
Hash Cond: (newer.e = datoms_long_new.e)
Join Filter: (newer.tx > datoms_long_new.tx)
-> Result (cost=0.42..12171.21 rows=63518 width=24)
One-Time Filter: ($0 = 1000004)
-> Parallel Index Scan using mentat_auto_datoms_long_new_a1000004 on mentat.datoms_long_new newer (cost=0.42..12171.21 rows=63518 width=24)
Index Cond: ((newer.store_id = '0'::bigint) AND (newer.tx <= '1000000000021'::bigint))
-> Parallel Hash (cost=8564.33..8564.33 rows=19838 width=32)
-> Parallel Index Scan using mentat_auto_datoms_long_new_a1000004 on mentat.datoms_long_new (cost=0.42..8564.33 rows=19838 width=32)
Index Cond: ((datoms_long_new.store_id = '0'::bigint) AND (datoms_long_new.v >= '150000'::bigint) AND (datoms_long_new.tx <= '1000000000021'::bigint))
Query Identifier: -7173263478281195968
