explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GsO8

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 6,941.639 ↓ 5.0 5 1

Sort (cost=298,504.77..298,504.78 rows=1 width=220) (actual time=6,941.639..6,941.639 rows=5 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num DESC
  • Sort Method: quicksort Memory: 26kB
2. 0.001 6,941.626 ↓ 5.0 5 1

Limit (cost=298,504.75..298,504.75 rows=1 width=220) (actual time=6,941.613..6,941.626 rows=5 loops=1)

3. 0.010 6,941.625 ↓ 5.0 5 1

Unique (cost=298,504.75..298,504.75 rows=1 width=220) (actual time=6,941.612..6,941.625 rows=5 loops=1)

4. 0.262 6,941.615 ↓ 85.0 85 1

Sort (cost=298,504.75..298,504.75 rows=1 width=220) (actual time=6,941.611..6,941.615 rows=85 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 136kB
5. 4.716 6,941.353 ↓ 420.0 420 1

Nested Loop Left Join (cost=225,278.62..298,504.74 rows=1 width=220) (actual time=3,013.437..6,941.353 rows=420 loops=1)

  • Join Filter: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
  • Rows Removed by Join Filter: 33369
6. 6.516 6,934.537 ↓ 420.0 420 1

Nested Loop Left Join (cost=225,278.62..298,497.23 rows=1 width=218) (actual time=3,013.419..6,934.537 rows=420 loops=1)

  • Join Filter: (tsl_applique_origin.x_ec_country = country_origin.ec_country_num)
  • Rows Removed by Join Filter: 65940
7. 787.237 6,923.821 ↓ 420.0 420 1

Gather (cost=225,278.62..298,489.79 rows=1 width=212) (actual time=3,013.365..6,923.821 rows=420 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 2,519.589 6,136.584 ↓ 140.0 140 3

Merge Left Join (cost=224,278.62..297,489.69 rows=1 width=212) (actual time=3,000.771..6,136.584 rows=140 loops=3)

  • Merge Cond: (demande.eb_demande_num = demande_chargement.x_eb_demande)
  • Filter: ((((chargement_not_routine.pick_slip)::text = 'OCD_8179'::text) OR ((demande.ref_transport)::text = 'OCD_8179'::text) OR ((tracing.reference_po)::text = 'OCD_8179'::text) OR ((tracing.reference_transporte (...)
  • Rows Removed by Filter: 11206663
9. 100.759 2,381.557 ↑ 1.3 82,875 3

Sort (cost=159,604.58..159,869.59 rows=106,002 width=228) (actual time=2,366.835..2,381.557 rows=82,875 loops=3)

  • Sort Key: demande.eb_demande_num
  • Sort Method: quicksort Memory: 31530kB
10. 65.684 2,280.798 ↑ 1.3 82,875 3

Hash Left Join (cost=118,698.51..150,756.74 rows=106,002 width=228) (actual time=1,947.347..2,280.798 rows=82,875 loops=3)

  • Hash Cond: (tracing.eb_tt_tracing_num = tsl_applique_origin.x_eb_tt_tracing)
11. 78.767 2,026.088 ↑ 1.3 82,875 3

Hash Left Join (cost=91,763.57..105,798.27 rows=103,594 width=222) (actual time=1,756.719..2,026.088 rows=82,875 loops=3)

  • Hash Cond: (tracing.x_eb_dernier_psl_applique_actif = tsl_applique_dest.eb_tt_psl_applique_num)
12. 28.855 1,172.168 ↑ 1.3 82,875 3

Hash Left Join (cost=47,085.57..59,812.39 rows=103,594 width=196) (actual time=967.026..1,172.168 rows=82,875 loops=3)

  • Hash Cond: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
13. 28.884 1,142.751 ↑ 1.3 82,875 3

Hash Left Join (cost=47,075.96..58,502.83 rows=103,594 width=182) (actual time=966.444..1,142.751 rows=82,875 loops=3)

  • Hash Cond: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
14. 68.574 1,113.267 ↑ 1.3 82,875 3

Hash Left Join (cost=47,074.85..57,377.73 rows=103,594 width=150) (actual time=965.821..1,113.267 rows=82,875 loops=3)

  • Hash Cond: (tracing.x_eb_tt_psl_applique_last = psl_applique_statut.eb_tt_psl_applique_num)
15. 65.319 134.154 ↑ 1.3 82,875 3

Hash Left Join (cost=2,396.85..11,391.85 rows=103,594 width=150) (actual time=43.662..134.154 rows=82,875 loops=3)

  • Hash Cond: (tracing.x_eb_demande = demande.eb_demande_num)
16. 25.429 25.429 ↑ 1.3 82,875 3

Parallel Seq Scan on eb_tt_tracing tracing (cost=0.00..7,571.94 rows=103,594 width=109) (actual time=0.018..25.429 rows=82,875 loops=3)

17. 10.125 43.406 ↑ 1.0 27,102 3

Hash (cost=2,058.07..2,058.07 rows=27,102 width=45) (actual time=43.406..43.406 rows=27,102 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1699kB
18. 19.230 33.281 ↑ 1.0 27,102 3

Hash Left Join (cost=1.07..2,058.07 rows=27,102 width=45) (actual time=0.852..33.281 rows=27,102 loops=3)

  • Hash Cond: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
19. 13.641 13.641 ↑ 1.0 27,102 3

Seq Scan on eb_demande demande (cost=0.00..1,795.02 rows=27,102 width=17) (actual time=0.427..13.641 rows=27,102 loops=3)

20. 0.015 0.410 ↑ 1.0 3 3

Hash (cost=1.03..1.03 rows=3 width=36) (actual time=0.410..0.410 rows=3 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 0.395 0.395 ↑ 1.0 3 3

Seq Scan on ec_type_transport type_transport (cost=0.00..1.03 rows=3 width=36) (actual time=0.394..0.395 rows=3 loops=3)

22. 446.596 910.539 ↑ 1.0 1,293,200 3

Hash (cost=28,513.00..28,513.00 rows=1,293,200 width=8) (actual time=910.539..910.539 rows=1,293,200 loops=3)

  • Buckets: 2097152 Batches: 1 Memory Usage: 66900kB
23. 463.943 463.943 ↑ 1.0 1,293,200 3

Seq Scan on eb_tt_psl_applique psl_applique_statut (cost=0.00..28,513.00 rows=1,293,200 width=8) (actual time=0.053..463.943 rows=1,293,200 loops=3)

24. 0.014 0.600 ↑ 1.0 5 3

Hash (cost=1.05..1.05 rows=5 width=36) (actual time=0.600..0.600 rows=5 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.586 0.586 ↑ 1.0 5 3

Seq Scan on eb_tt_psl psl (cost=0.00..1.05 rows=5 width=36) (actual time=0.585..0.586 rows=5 loops=3)

26. 0.047 0.562 ↑ 1.0 116 3

Hash (cost=8.16..8.16 rows=116 width=22) (actual time=0.562..0.562 rows=116 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
27. 0.515 0.515 ↑ 1.0 116 3

Seq Scan on eb_transporteur transporteur (cost=0.00..8.16 rows=116 width=22) (actual time=0.469..0.515 rows=116 loops=3)

28. 441.319 775.153 ↑ 1.0 1,293,200 3

Hash (cost=28,513.00..28,513.00 rows=1,293,200 width=38) (actual time=775.153..775.153 rows=1,293,200 loops=3)

  • Buckets: 2097152 Batches: 1 Memory Usage: 76064kB
29. 333.834 333.834 ↑ 1.0 1,293,200 3

Seq Scan on eb_tt_psl_applique tsl_applique_dest (cost=0.00..28,513.00 rows=1,293,200 width=38) (actual time=0.034..333.834 rows=1,293,200 loops=3)

30. 81.492 189.026 ↑ 1.0 258,640 3

Hash (cost=23,690.08..23,690.08 rows=259,588 width=14) (actual time=189.026..189.026 rows=258,640 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 13984kB
31. 89.724 107.534 ↑ 1.0 258,640 3

Bitmap Heap Scan on eb_tt_psl_applique tsl_applique_origin (cost=4,864.23..23,690.08 rows=259,588 width=14) (actual time=20.778..107.534 rows=258,640 loops=3)

  • Recheck Cond: (order_psl = 1)
  • Heap Blocks: exact=15288
32. 17.810 17.810 ↑ 1.0 258,640 3

Bitmap Index Scan on idx_eb_tt_psl_applique_order_psl (cost=0.00..4,799.34 rows=259,588 width=0) (actual time=17.810..17.810 rows=258,640 loops=3)

  • Index Cond: (order_psl = 1)
33. 739.247 1,235.438 ↓ 31.4 11,370,638 3

Sort (cost=64,674.03..65,580.51 rows=362,589 width=12) (actual time=621.848..1,235.438 rows=11,370,638 loops=3)

  • Sort Key: demande_chargement.x_eb_demande
  • Sort Method: quicksort Memory: 29278kB
34. 184.036 496.191 ↑ 1.0 362,431 3

Hash Left Join (cost=20,693.04..31,192.61 rows=362,589 width=12) (actual time=267.880..496.191 rows=362,431 loops=3)

  • Hash Cond: (demande_chargement.x_eb_chargement = chargement_not_routine.eb_chargement_num)
35. 48.324 48.324 ↑ 1.0 362,431 3

Seq Scan on ex_demande_chargement demande_chargement (cost=0.00..5,921.89 rows=362,589 width=8) (actual time=0.573..48.324 rows=362,431 loops=3)

36. 116.593 263.831 ↑ 1.0 362,713 3

Hash (cost=16,159.13..16,159.13 rows=362,713 width=12) (actual time=263.831..263.831 rows=362,713 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 19806kB
37. 147.238 147.238 ↑ 1.0 362,713 3

Seq Scan on eb_chargement chargement_not_routine (cost=0.00..16,159.13 rows=362,713 width=12) (actual time=0.603..147.238 rows=362,713 loops=3)

38. 4.200 4.200 ↑ 1.5 158 420

Seq Scan on ec_country country_origin (cost=0.00..4.42 rows=242 width=14) (actual time=0.002..0.010 rows=158 loops=420)

39. 2.100 2.100 ↑ 3.0 80 420

Seq Scan on ec_country country_dest (cost=0.00..4.42 rows=242 width=14) (actual time=0.002..0.005 rows=80 loops=420)

Planning time : 21.751 ms
Execution time : 7,015.231 ms