explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N1w5

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 461.982 461.982 ↓ 1.0 1,000,000 1

Seq Scan on big2 (cost=0.00..17,906.00 rows=999,900 width=14) (actual time=0.021..461.982 rows=1,000,000 loops=1)

  • Filter: (a ~~ '%d%'::text)