explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2bau

Settings
# exclusive inclusive rows x rows loops node
1. 1.971 88.233 ↑ 1.5 2,860 1

Sort (cost=6,840.35..6,851.04 rows=4,274 width=447) (actual time=88.157..88.233 rows=2,860 loops=1)

  • Sort Key: eo.ord_id DESC, eo.ord_add_date DESC
  • Sort Method: quicksort Memory: 935kB
2. 1.455 86.262 ↑ 1.5 2,860 1

Hash Left Join (cost=3,003.54..6,582.60 rows=4,274 width=447) (actual time=22.699..86.262 rows=2,860 loops=1)

  • Hash Cond: (op.opr_sale_unit_id = uo.id)
3. 0.784 84.730 ↑ 1.5 2,860 1

Hash Left Join (cost=2,992.10..6,517.08 rows=4,274 width=252) (actual time=22.597..84.730 rows=2,860 loops=1)

  • Hash Cond: (op.fk_product_instance_id = pi.product_instance_id)
4. 0.360 79.154 ↑ 1.5 2,860 1

Hash Left Join (cost=2,162.72..5,676.48 rows=4,274 width=246) (actual time=17.700..79.154 rows=2,860 loops=1)

  • Hash Cond: (r.responsible_reviewer_id = rr.id)
5. 3.728 78.214 ↑ 1.5 2,860 1

Hash Join (cost=2,080.25..5,582.79 rows=4,274 width=239) (actual time=17.104..78.214 rows=2,860 loops=1)

  • Hash Cond: (eots.fk_ors_id = eotsd.id)
6. 10.217 74.443 ↓ 1.7 71,228 1

Hash Join (cost=2,079.11..5,421.90 rows=42,744 width=243) (actual time=17.049..74.443 rows=71,228 loops=1)

  • Hash Cond: (eo.ord_user_delivery_form = df.id)
7. 4.071 64.213 ↑ 1.0 35,614 1

Hash Left Join (cost=2,063.71..3,821.37 rows=35,621 width=169) (actual time=17.032..64.213 rows=35,614 loops=1)

  • Hash Cond: (eo.requisition_id = r.id)
8. 5.740 59.500 ↑ 1.0 35,614 1

Hash Join (cost=1,920.99..3,585.14 rows=35,621 width=169) (actual time=16.374..59.500 rows=35,614 loops=1)

  • Hash Cond: (eo.fk_osh_id = ship.osh_id)
9. 5.969 53.751 ↑ 1.0 35,614 1

Hash Join (cost=1,919.72..3,457.35 rows=35,621 width=173) (actual time=16.360..53.751 rows=35,614 loops=1)

  • Hash Cond: (eo.fk_orp_id = eop.orp_id)
10. 5.801 47.772 ↑ 1.0 35,614 1

Hash Join (cost=1,918.59..3,296.66 rows=35,621 width=177) (actual time=16.346..47.772 rows=35,614 loops=1)

  • Hash Cond: (eo.fk_ors_id = eos.ors_id)
11. 8.438 41.963 ↑ 1.0 35,614 1

Hash Join (cost=1,917.43..3,145.38 rows=35,621 width=181) (actual time=16.333..41.963 rows=35,614 loops=1)

  • Hash Cond: (eo.ord_id = eots.fk_ord_id)
12. 14.421 30.242 ↑ 1.0 35,666 1

Hash Right Join (cost=1,408.97..2,543.28 rows=35,666 width=177) (actual time=12.953..30.242 rows=35,666 loops=1)

  • Hash Cond: (op.fk_ord_id = eo.ord_id)
13. 3.040 3.040 ↑ 1.0 35,666 1

Seq Scan on eis_order_product op (cost=0.00..1,040.66 rows=35,666 width=68) (actual time=0.032..3.040 rows=35,666 loops=1)

14. 4.652 12.781 ↑ 1.0 18,221 1

Hash (cost=1,181.21..1,181.21 rows=18,221 width=113) (actual time=12.781..12.781 rows=18,221 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2498kB
15. 8.129 8.129 ↑ 1.0 18,221 1

Seq Scan on eis_order eo (cost=0.00..1,181.21 rows=18,221 width=113) (actual time=0.020..8.129 rows=18,221 loops=1)

16. 1.749 3.283 ↑ 1.0 18,198 1

Hash (cost=280.98..280.98 rows=18,198 width=8) (actual time=3.283..3.283 rows=18,198 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 967kB
17. 1.534 1.534 ↑ 1.0 18,198 1

Seq Scan on eis_order_temporary_status eots (cost=0.00..280.98 rows=18,198 width=8) (actual time=0.010..1.534 rows=18,198 loops=1)

18. 0.002 0.008 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=4) (actual time=0.008..0.008 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.006 0.006 ↑ 1.0 7 1

Seq Scan on eis_order_status eos (cost=0.00..1.07 rows=7 width=4) (actual time=0.005..0.006 rows=7 loops=1)

20. 0.004 0.010 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=4) (actual time=0.010..0.010 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 0.006 0.006 ↑ 1.0 6 1

Seq Scan on eis_order_payment eop (cost=0.00..1.06 rows=6 width=4) (actual time=0.005..0.006 rows=6 loops=1)

22. 0.002 0.009 ↑ 1.0 12 1

Hash (cost=1.12..1.12 rows=12 width=4) (actual time=0.009..0.009 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.007 0.007 ↑ 1.0 12 1

Seq Scan on eis_order_shipping ship (cost=0.00..1.12 rows=12 width=4) (actual time=0.006..0.007 rows=12 loops=1)

24. 0.065 0.642 ↑ 1.0 521 1

Hash (cost=136.21..136.21 rows=521 width=32) (actual time=0.642..0.642 rows=521 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
25. 0.577 0.577 ↑ 1.0 521 1

Seq Scan on requisition r (cost=0.00..136.21 rows=521 width=32) (actual time=0.014..0.577 rows=521 loops=1)

26. 0.004 0.013 ↑ 60.0 4 1

Hash (cost=12.40..12.40 rows=240 width=106) (actual time=0.013..0.013 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
27. 0.009 0.009 ↑ 60.0 4 1

Seq Scan on delivery_form df (cost=0.00..12.40 rows=240 width=106) (actual time=0.009..0.009 rows=4 loops=1)

28. 0.003 0.043 ↑ 1.0 1 1

Hash (cost=1.13..1.13 rows=1 width=4) (actual time=0.043..0.043 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.040 0.040 ↑ 1.0 1 1

Seq Scan on eis_order_temporary_status_dictionary eotsd (cost=0.00..1.13 rows=1 width=4) (actual time=0.039..0.040 rows=1 loops=1)

  • Filter: ((name)::text = 'DODANE DO IFS'::text)
  • Rows Removed by Filter: 9
30. 0.330 0.580 ↑ 1.0 2,110 1

Hash (cost=56.10..56.10 rows=2,110 width=39) (actual time=0.580..0.580 rows=2,110 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 180kB
31. 0.250 0.250 ↑ 1.0 2,110 1

Seq Scan on "user" rr (cost=0.00..56.10 rows=2,110 width=39) (actual time=0.008..0.250 rows=2,110 loops=1)

32. 2.590 4.792 ↑ 1.0 21,839 1

Hash (cost=556.39..556.39 rows=21,839 width=14) (actual time=4.792..4.792 rows=21,839 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1248kB
33. 2.202 2.202 ↑ 1.0 21,839 1

Seq Scan on eis_product_instance pi (cost=0.00..556.39 rows=21,839 width=14) (actual time=0.008..2.202 rows=21,839 loops=1)

34. 0.041 0.077 ↑ 1.0 375 1

Hash (cost=6.75..6.75 rows=375 width=8) (actual time=0.077..0.077 rows=375 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
35. 0.036 0.036 ↑ 1.0 375 1

Seq Scan on unit_of_measure uo (cost=0.00..6.75 rows=375 width=8) (actual time=0.012..0.036 rows=375 loops=1)