explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RxD4

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 1.124 ↑ 1.0 200 1

Limit (cost=0.00..85.57 rows=200 width=523) (actual time=0.025..1.124 rows=200 loops=1)

2. 0.194 1.108 ↑ 615.3 200 1

Seq Scan on bo_instance i (cost=0.00..52,652.22 rows=123,062 width=523) (actual time=0.024..1.108 rows=200 loops=1)

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

SubPlan (forSeq Scan)

4. 0.457 0.914 ↓ 0.0 0 457

Limit (cost=0.00..0.07 rows=1 width=1) (actual time=0.001..0.002 rows=0 loops=457)

5. 0.457 0.457 ↓ 0.0 0 457

Function Scan on unnest n (cost=0.00..1.25 rows=20 width=1) (actual time=0.001..0.001 rows=0 loops=457)

  • Filter: ((n)::text ~~* 'as%'::text)
Planning time : 0.085 ms
Execution time : 1.154 ms