explain.depesz.com

PostgreSQL's explain analyze made readable

Result: De4g : Optimization for: Optimization for: Optimization for: Optimization for: plan #yUoW; plan #DDBr; plan #Vs0g; plan #yTyx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.062 903,741.448 ↓ 0.0 0 1

Sort (cost=3,887,090.54..3,887,093.30 rows=1,107 width=4) (actual time=903,741.448..903,741.448 rows=0 loops=1)

  • Sort Key: orders.id
  • Sort Method: quicksort Memory: 25kB
2. 903,741.386 903,741.386 ↓ 0.0 0 1

Seq Scan on orders (cost=0.00..3,887,034.56 rows=1,107 width=4) (actual time=903,741.386..903,741.386 rows=0 loops=1)

  • Filter: (lower((customer_name)::text) ~~ '%081282660390%'::text)
  • Rows Removed by Filter: 11,072,588
Planning time : 3.689 ms
Execution time : 903,741.506 ms