explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3BdU : Optimization for: Query plan for reply select query; plan #G4X

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 79.160 79.160 ↓ 1.0 305,013 1

Seq Scan on package_products (cost=0.00..19,346.88 rows=302,537 width=129) (actual time=0.096..79.160 rows=305,013 loops=1)

  • Filter: ((order_type)::text = 'ALL'::text)
  • Rows Removed by Filter: 330257
Planning time : 0.079 ms
Execution time : 89.309 ms