explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sLBD : Product order name, ordering

Settings
# exclusive inclusive rows x rows loops node
1. 5,804.944 6,835.005 ↓ 1.0 886,150 1

Sort (cost=184,656.24..186,871.56 rows=886,127 width=40) (actual time=6,329.608..6,835.005 rows=886,150 loops=1)

  • Sort Key: product_product.ordering, product_product.name
  • Sort Method: external merge Disk: 43,424kB
  • JIT:
  • Functions: 19
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 2.082 ms, Inlining 0.000 ms, Optimization 1.126 ms, Emission 16.124 ms, Total 19.332 ms
2. 164.399 1,030.061 ↓ 1.0 886,150 1

Hash Join (cost=704.96..72,889.01 rows=886,127 width=40) (actual time=30.281..1,030.061 rows=886,150 loops=1)

  • Hash Cond: (product_product.vat_id = vat_vat.id)
3. 417.215 844.601 ↓ 1.0 886,150 1

Hash Left Join (cost=703.89..67,275.80 rows=886,127 width=40) (actual time=9.213..844.601 rows=886,150 loops=1)

  • Hash Cond: (product_product.supplier_id = organization_organization.id)
4. 418.212 418.212 ↓ 1.0 886,150 1

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

5. 3.568 9.174 ↑ 1.0 17,595 1

Hash (cost=483.95..483.95 rows=17,595 width=4) (actual time=9.173..9.174 rows=17,595 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 875kB
6. 5.606 5.606 ↑ 1.0 17,595 1

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

7. 0.009 21.061 ↑ 1.0 3 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 21.052 21.052 ↑ 1.0 3 1

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

Planning time : 0.472 ms
Execution time : 6,878.610 ms