explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bvB9 : Optimization for: plan #ey76

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Seq Scan on t_history_entry he (cost=0.00..45,493,244.07 rows=13,242 width=365) (actual rows= loops=)

  • Filter: ((data ~~ '{"from":"RELEASED","to":"LOADED"}'::text) AND ((event_type)::text = 'STATE'::text) AND (NOT (SubPlan 1)))
2.          

SubPlan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..2,644.50 rows=1 width=16) (actual rows= loops=)

  • Group Key: he.fk_history_id
4. 0.000 0.000 ↓ 0.0

Seq Scan on t_history_entry heinner (cost=0.00..2,512.06 rows=26,485 width=16) (actual rows= loops=)

  • Filter: ((data ~~ '{"from":"RELEASED","to":"LOADED"}'::text) AND ((event_type)::text = 'STATE'::text))