explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dll3 : Optimization for: plan #yDhO

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 19.733 19.733 ↓ 1.0 1,704 1

Seq Scan on se_details (cost=0.00..5,692.84 rows=1,690 width=4) (actual time=0.086..19.733 rows=1,704 loops=1)

  • Filter: (state = 'NEW YORK'::text)
  • Rows Removed by Filter: 53963
Planning time : 0.087 ms
Execution time : 19.838 ms