explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tERG

Settings
# exclusive inclusive rows x rows loops node
1. 1,738.537 1,738.537 ↑ 1.0 20,991 1

Seq Scan on entity_eton_agg d (cost=0.00..69,166.17 rows=21,077 width=608) (actual time=0.585..1,738.537 rows=20,991 loops=1)

  • Filter: (active AND (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[])))
  • Rows Removed by Filter: 13792