explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ne3F

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

Sort (cost=2,146,505.24..2,147,438.30 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..1,897,644.85 rows=373,225 width=645) (actual rows= loops=)

3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Index Only Scan using products_product_6be37982 on products_product u0 (cost=0.42..32.45 rows=7 width=0) (actual rows= loops=)

  • Index Cond: (parent_id = products_product.id)