explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VNf

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 6,825.458 ↓ 5.0 5 1

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

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

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

3. 0.009 6,825.449 ↓ 5.0 5 1

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

4. 0.261 6,825.440 ↓ 85.0 85 1

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

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

Nested Loop Left Join (cost=225,278.62..298,504.74 rows=1 width=220) (actual time=2,982.628..6,825.179 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.269 6,818.465 ↓ 420.0 420 1

Nested Loop Left Join (cost=225,278.62..298,497.23 rows=1 width=218) (actual time=2,982.603..6,818.465 rows=420 loops=1)

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

Gather (cost=225,278.62..298,489.79 rows=1 width=212) (actual time=2,982.550..6,807.996 rows=420 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 2,387.717 5,945.147 ↓ 140.0 140 3

Merge Left Join (cost=224,278.62..297,489.69 rows=1 width=212) (actual time=2,964.155..5,945.147 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. 95.592 2,325.666 ↑ 1.3 82,875 3

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

  • Sort Key: demande.eb_demande_num
  • Sort Method: quicksort Memory: 33406kB
10. 64.642 2,230.074 ↑ 1.3 82,875 3

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

  • Hash Cond: (tracing.eb_tt_tracing_num = tsl_applique_origin.x_eb_tt_tracing)
11. 74.497 1,974.460 ↑ 1.3 82,875 3

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

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

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

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

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

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

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

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

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

  • Hash Cond: (tracing.x_eb_demande = demande.eb_demande_num)
16. 25.629 25.629 ↑ 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.024..25.629 rows=82,875 loops=3)

17. 11.512 48.682 ↑ 1.0 27,102 3

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

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

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

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

20. 0.018 0.558 ↑ 1.0 3 3

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

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

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

22. 420.121 853.025 ↑ 1.0 1,293,200 3

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

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

24. 0.015 0.512 ↑ 1.0 5 3

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

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

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

26. 0.052 0.574 ↑ 1.0 116 3

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

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

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

28. 442.335 783.796 ↑ 1.0 1,293,200 3

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

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

30. 80.461 190.972 ↑ 1.0 258,640 3

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

  • Buckets: 262144 Batches: 1 Memory Usage: 13984kB
31. 88.887 110.511 ↑ 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=24.645..110.511 rows=258,640 loops=3)

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

  • Index Cond: (order_psl = 1)
33. 713.069 1,231.764 ↓ 31.4 11,373,316 3

Sort (cost=64,674.03..65,580.51 rows=362,589 width=12) (actual time=645.935..1,231.764 rows=11,373,316 loops=3)

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

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

  • Hash Cond: (demande_chargement.x_eb_chargement = chargement_not_routine.eb_chargement_num)
35. 52.658 52.658 ↑ 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.647..52.658 rows=362,431 loops=3)

36. 116.376 265.635 ↑ 1.0 362,713 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 19806kB
37. 149.259 149.259 ↑ 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.511..149.259 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 : 12.493 ms
Execution time : 6,898.231 ms