explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YMNH : Optimization for: plan #tbJK

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 599.663 599.663 ↓ 123.5 10,000 1

Seq Scan on tbl (cost=0.00..194,247.65 rows=81 width=8) (actual time=0.693..599.663 rows=10,000 loops=1)

  • Filter: ((col1 = 1) AND (col2 = 0))
  • Rows Removed by Filter: 9,990,000