explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kV3I : Optimization for: Optimization for: plan #N1w5; plan #Q3LG

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 161.345 161.345 ↓ 1.0 111,112 1

Seq Scan on big2 (cost=0.00..17,906.00 rows=111,111 width=14) (actual time=0.016..161.345 rows=111,112 loops=1)

  • Filter: (a ~~ '%d1%'::text)
  • Rows Removed by Filter: 888888