explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LQXh

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

Sort (cost=184,656.24..186,871.56 rows=886,127 width=40) (actual rows= loops=)

  • Sort Key: product_product.ordering, product_product.name
  • JIT:
  • Functions: 19
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=704.96..72,889.01 rows=886,127 width=40) (actual rows= loops=)

  • Hash Cond: (product_product.vat_id = vat_vat.id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=703.89..67,275.80 rows=886,127 width=40) (actual rows= loops=)

  • Hash Cond: (product_product.supplier_id = organization_organization.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on product_product (cost=0.00..64,245.27 rows=886,127 width=40) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=483.95..483.95 rows=17,595 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on organization_organization (cost=0.00..483.95 rows=17,595 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=3 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on vat_vat (cost=0.00..1.03 rows=3 width=4) (actual rows= loops=)