explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OYrX

Settings
# exclusive inclusive rows x rows loops node
1. 10,337.343 10,337.343 ↓ 1.0 3,852,304 1

Seq Scan on users (cost=0.00..240,192.50 rows=3,847,667 width=463) (actual time=0.375..10,337.343 rows=3,852,304 loops=1)

  • Filter: (valid = 'Y'::bpchar)
  • Rows Removed by Filter: 63,896