explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Gac

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 947.013 ↓ 0.0 0 1

Limit (cost=102,961.16..102,961.18 rows=8 width=5) (actual time=947.012..947.013 rows=0 loops=1)

2. 0.007 947.011 ↓ 0.0 0 1

Sort (cost=102,961.16..102,961.24 rows=32 width=5) (actual time=947.011..947.011 rows=0 loops=1)

  • Sort Key: (COALESCE(product_product.coreassortment, false)) DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 947.004 ↓ 0.0 0 1

Nested Loop (cost=0.42..102,960.52 rows=32 width=5) (actual time=947.004..947.004 rows=0 loops=1)

4. 947.003 947.003 ↓ 0.0 0 1

Seq Scan on product_product (cost=0.00..102,882.44 rows=32 width=9) (actual time=947.003..947.003 rows=0 loops=1)

  • Filter: (active AND (unaccent((default_code)::text) ~~* '%maranell%'::text))
  • Rows Removed by Filter: 373175
5. 0.000 0.000 ↓ 0.0 0

Index Scan using product_template_pkey on product_template product_product__product_tmpl_id (cost=0.42..2.44 rows=1 width=4) (never executed)

  • Index Cond: (id = product_product.product_tmpl_id)
  • Filter: sale_ok
Planning time : 0.385 ms
Execution time : 947.055 ms