explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XLmS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=4,425,234.43..4,426,167.49 rows=373,225 width=645) (actual rows= loops=)

  • Sort Key: products_product.name, products_product.created_on DESC
2. 0.000 0.000 ↓ 0.0

Seq Scan on products_product (cost=0.00..4,176,374.04 rows=373,225 width=645) (actual rows= loops=)

3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Index Scan using products_product_6be37982 on products_product u0 (cost=0.42..32.46 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (parent_id = products_product.id)
  • Filter: ((listing_state)::text <> 'Archived'::text)