explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Op8m

Settings
# exclusive inclusive rows x rows loops node
1. 82.589 82.589 ↑ 1.0 499,010 1

Seq Scan on employes_big (cost=0.00..12,149.22 rows=499,015 width=41) (actual time=0.064..82.589 rows=499,010 loops=1)

  • Filter: ((date_embauche >= '2006-01-01'::date) AND (date_embauche < '2007-01-01'::date))
  • Rows Removed by Filter: 5