explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h7bC

Settings
# exclusive inclusive rows x rows loops node
1. 0.089 223.673 ↑ 1.0 2,000 1

Limit (cost=0.42..8,010.24 rows=2,000 width=523) (actual time=219.476..223.673 rows=2,000 loops=1)

2. 223.584 223.584 ↑ 61.5 2,000 1

Index Scan using bo_instance_pkey on bo_instance i (cost=0.42..492,852.91 rows=123,062 width=523) (actual time=219.475..223.584 rows=2,000 loops=1)

  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 232889
3.          

SubPlan (forIndex Scan)

4. 0.000 0.000 ↓ 0.0 0 234,889

Limit (cost=0.00..1.50 rows=1 width=1) (actual time=0.000..0.000 rows=0 loops=234,889)

5. 0.000 0.000 ↓ 0.0 0 234,889

Function Scan on unnest n (cost=0.00..1.50 rows=1 width=1) (actual time=0.000..0.000 rows=0 loops=234,889)

  • Filter: (((n)::text ~~* 'asdas%'::text) OR ((n)::text ~~* 'sfrewf%'::text))
  • Rows Removed by Filter: 0
Planning time : 0.099 ms
Execution time : 223.741 ms