explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1bI7

Settings
# exclusive inclusive rows x rows loops node
1. 2.120 93.370 ↑ 1.5 2,860 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Hash Cond: (op.fk_ord_id = eo.ord_id)
13. 3.045 3.045 ↑ 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.019..3.045 rows=35,666 loops=1)

14. 5.116 14.142 ↑ 1.0 18,221 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 2498kB
15. 9.026 9.026 ↑ 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.010..9.026 rows=18,221 loops=1)

16. 1.730 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.553 1.553 ↑ 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.553 rows=18,198 loops=1)

18. 0.003 0.009 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=4) (actual time=0.009..0.009 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.006..0.006 rows=7 loops=1)

20. 0.002 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.008 0.008 ↑ 1.0 6 1

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

22. 0.003 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.006 0.006 ↑ 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.006 rows=12 loops=1)

24. 0.061 0.474 ↑ 1.0 521 1

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

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

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

26. 0.006 0.014 ↑ 60.0 4 1

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

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

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

28. 0.020 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.023 0.023 ↑ 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.022..0.023 rows=1 loops=1)

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

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

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

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

32. 3.724 6.450 ↑ 1.0 21,839 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1248kB
33. 2.726 2.726 ↑ 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.016..2.726 rows=21,839 loops=1)

34. 0.042 0.087 ↑ 1.0 375 1

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

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

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