explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CDYH

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 9,592.672 ↑ 1.0 1 1

Sort (cost=327,077.77..327,077.78 rows=1 width=220) (actual time=9,592.672..9,592.672 rows=1 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.001 9,592.651 ↑ 1.0 1 1

Limit (cost=327,077.74..327,077.75 rows=1 width=220) (actual time=9,592.651..9,592.651 rows=1 loops=1)

3. 0.001 9,592.650 ↑ 1.0 1 1

Unique (cost=327,077.74..327,077.75 rows=1 width=220) (actual time=9,592.650..9,592.650 rows=1 loops=1)

4. 0.101 9,592.649 ↑ 1.0 1 1

Sort (cost=327,077.74..327,077.75 rows=1 width=220) (actual time=9,592.649..9,592.649 rows=1 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 25kB
5. 0.016 9,592.548 ↑ 1.0 1 1

Nested Loop Left Join (cost=242,732.26..327,077.73 rows=1 width=220) (actual time=9,592.546..9,592.548 rows=1 loops=1)

  • Join Filter: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
  • Rows Removed by Join Filter: 156
6. 0.014 9,592.509 ↑ 1.0 1 1

Nested Loop Left Join (cost=242,732.26..327,070.23 rows=1 width=218) (actual time=9,592.507..9,592.509 rows=1 loops=1)

  • Join Filter: (tsl_applique_origin.x_ec_country = country_origin.ec_country_num)
  • Rows Removed by Join Filter: 157
7. 930.252 9,592.446 ↑ 1.0 1 1

Gather (cost=242,732.26..327,062.78 rows=1 width=212) (actual time=9,592.445..9,592.446 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 36.378 8,662.194 ↓ 0.0 0 3

Hash Left Join (cost=241,732.26..326,062.68 rows=1 width=212) (actual time=8,640.192..8,662.194 rows=0 loops=3)

  • Hash Cond: (demande_chargement.x_eb_chargement = chargement_not_routine.eb_chargement_num)
  • Filter: ((((chargement_not_routine.pick_slip)::text = '0817831281'::text) OR ((chargement_routine.pick_slip)::text = '0817831281'::text) OR ((demande.ref_transport)::text = '0817831281'::text) OR ((tracing.refere (...)
  • Rows Removed by Filter: 86040
9. 2,005.078 8,329.924 ↑ 12.4 86,041 3

Merge Left Join (cost=221,039.22..246,387.15 rows=1,069,980 width=236) (actual time=5,427.685..8,329.924 rows=86,041 loops=3)

  • Merge Cond: (demande.eb_demande_num = demande_chargement.x_eb_demande)
  • Join Filter: (demande.x_ec_type_transport IS DISTINCT FROM 3)
  • Rows Removed by Join Filter: 11200825
10. 157.341 5,136.786 ↑ 1.3 82,875 3

Sort (cost=181,635.90..181,900.91 rows=106,002 width=240) (actual time=5,113.601..5,136.786 rows=82,875 loops=3)

  • Sort Key: demande.eb_demande_num
  • Sort Method: quicksort Memory: 32024kB
11. 98.440 4,979.445 ↑ 1.3 82,875 3

Hash Left Join (cost=139,391.55..172,788.06 rows=106,002 width=240) (actual time=4,321.453..4,979.445 rows=82,875 loops=3)

  • Hash Cond: (tracing.x_eb_chargement = chargement_routine.eb_chargement_num)
12. 93.081 4,432.447 ↑ 1.3 82,875 3

Hash Left Join (cost=118,698.51..150,756.74 rows=106,002 width=236) (actual time=3,868.927..4,432.447 rows=82,875 loops=3)

  • Hash Cond: (tracing.eb_tt_tracing_num = tsl_applique_origin.x_eb_tt_tracing)
13. 132.943 4,005.042 ↑ 1.3 82,875 3

Hash Left Join (cost=91,763.57..105,798.27 rows=103,594 width=230) (actual time=3,532.730..4,005.042 rows=82,875 loops=3)

  • Hash Cond: (tracing.x_eb_dernier_psl_applique_actif = tsl_applique_dest.eb_tt_psl_applique_num)
14. 60.744 2,377.989 ↑ 1.3 82,875 3

Hash Left Join (cost=47,085.57..59,812.39 rows=103,594 width=204) (actual time=2,007.918..2,377.989 rows=82,875 loops=3)

  • Hash Cond: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
15. 48.870 2,316.402 ↑ 1.3 82,875 3

Hash Left Join (cost=47,075.96..58,502.83 rows=103,594 width=190) (actual time=2,007.048..2,316.402 rows=82,875 loops=3)

  • Hash Cond: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
16. 114.015 2,266.658 ↑ 1.3 82,875 3

Hash Left Join (cost=47,074.85..57,377.73 rows=103,594 width=158) (actual time=2,006.141..2,266.658 rows=82,875 loops=3)

  • Hash Cond: (tracing.x_eb_tt_psl_applique_last = psl_applique_statut.eb_tt_psl_applique_num)
17. 122.610 281.186 ↑ 1.3 82,875 3

Hash Left Join (cost=2,396.85..11,391.85 rows=103,594 width=158) (actual time=102.846..281.186 rows=82,875 loops=3)

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

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

19. 26.025 102.231 ↑ 1.0 27,102 3

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1805kB
20. 46.455 76.206 ↑ 1.0 27,102 3

Hash Left Join (cost=1.07..2,058.07 rows=27,102 width=49) (actual time=1.835..76.206 rows=27,102 loops=3)

  • Hash Cond: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
21. 28.910 28.910 ↑ 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.956..28.910 rows=27,102 loops=3)

22. 0.031 0.841 ↑ 1.0 3 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.810 0.810 ↑ 1.0 3 3

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

24. 870.689 1,871.457 ↑ 1.0 1,293,200 3

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

  • Buckets: 2097152 Batches: 1 Memory Usage: 66900kB
25. 1,000.768 1,000.768 ↑ 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.086..1,000.768 rows=1,293,200 loops=3)

26. 0.030 0.874 ↑ 1.0 5 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
27. 0.844 0.844 ↑ 1.0 5 3

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

28. 0.073 0.843 ↑ 1.0 116 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
29. 0.770 0.770 ↑ 1.0 116 3

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

30. 818.085 1,494.110 ↑ 1.0 1,293,200 3

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

  • Buckets: 2097152 Batches: 1 Memory Usage: 76064kB
31. 676.025 676.025 ↑ 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.050..676.025 rows=1,293,200 loops=3)

32. 137.556 334.324 ↑ 1.0 258,640 3

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

  • Buckets: 262144 Batches: 1 Memory Usage: 13984kB
33. 162.566 196.768 ↑ 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=38.956..196.768 rows=258,640 loops=3)

  • Recheck Cond: (order_psl = 1)
  • Heap Blocks: exact=15288
34. 34.202 34.202 ↑ 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=34.202..34.202 rows=258,640 loops=3)

  • Index Cond: (order_psl = 1)
35. 198.155 448.558 ↑ 1.0 362,713 3

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

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

Seq Scan on eb_chargement chargement_routine (cost=0.00..16,159.13 rows=362,713 width=12) (actual time=0.785..250.403 rows=362,713 loops=3)

37. 1,069.432 1,188.060 ↓ 31.4 11,374,391 3

Sort (cost=39,403.31..40,309.79 rows=362,589 width=8) (actual time=311.127..1,188.060 rows=11,374,391 loops=3)

  • Sort Key: demande_chargement.x_eb_demande
  • Sort Method: quicksort Memory: 29277kB
38. 118.628 118.628 ↑ 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.698..118.628 rows=362,431 loops=3)

39. 149.768 295.892 ↑ 1.0 362,713 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 19806kB
40. 146.124 146.124 ↑ 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.042..146.124 rows=362,713 loops=3)

41. 0.049 0.049 ↑ 1.5 158 1

Seq Scan on ec_country country_origin (cost=0.00..4.42 rows=242 width=14) (actual time=0.037..0.049 rows=158 loops=1)

42. 0.023 0.023 ↑ 1.5 157 1

Seq Scan on ec_country country_dest (cost=0.00..4.42 rows=242 width=14) (actual time=0.013..0.023 rows=157 loops=1)

Planning time : 38.456 ms
Execution time : 9,690.854 ms