explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WiUk

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 7,966.111 ↓ 5.0 5 1

Sort (cost=298,504.77..298,504.78 rows=1 width=220) (actual time=7,966.110..7,966.111 rows=5 loops=1)

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

Limit (cost=298,504.75..298,504.75 rows=1 width=220) (actual time=7,966.046..7,966.069 rows=5 loops=1)

3. 0.017 7,966.067 ↓ 5.0 5 1

Unique (cost=298,504.75..298,504.75 rows=1 width=220) (actual time=7,966.045..7,966.067 rows=5 loops=1)

4. 0.380 7,966.050 ↓ 85.0 85 1

Sort (cost=298,504.75..298,504.75 rows=1 width=220) (actual time=7,966.043..7,966.050 rows=85 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 136kB
5. 8.282 7,965.670 ↓ 420.0 420 1

Nested Loop Left Join (cost=225,278.62..298,504.74 rows=1 width=220) (actual time=3,560.968..7,965.670 rows=420 loops=1)

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

Nested Loop Left Join (cost=225,278.62..298,497.23 rows=1 width=218) (actual time=3,560.917..7,953.608 rows=420 loops=1)

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

Gather (cost=225,278.62..298,489.79 rows=1 width=212) (actual time=3,560.835..7,935.598 rows=420 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 3,245.222 7,503.024 ↓ 140.0 140 3

Merge Left Join (cost=224,278.62..297,489.69 rows=1 width=212) (actual time=3,483.153..7,503.024 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. 121.826 2,740.127 ↑ 1.3 82,875 3

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

  • Sort Key: demande.eb_demande_num
  • Sort Method: quicksort Memory: 27503kB
10. 78.910 2,618.301 ↑ 1.3 82,875 3

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

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

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

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

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

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

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

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

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

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

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

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

17. 12.147 51.816 ↑ 1.0 27,102 3

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

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

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

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

20. 0.020 0.466 ↑ 1.0 3 3

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

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

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

22. 461.117 982.002 ↑ 1.0 1,293,200 3

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

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

24. 0.018 0.834 ↑ 1.0 5 3

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

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

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

26. 0.051 1.112 ↑ 1.0 116 3

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

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

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

28. 512.709 925.411 ↑ 1.0 1,293,200 3

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

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

30. 91.961 222.160 ↑ 1.0 258,640 3

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

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

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

  • Index Cond: (order_psl = 1)
33. 904.311 1,517.675 ↓ 31.3 11,362,166 3

Sort (cost=64,674.03..65,580.51 rows=362,589 width=12) (actual time=747.302..1,517.675 rows=11,362,166 loops=3)

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

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

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

36. 137.138 340.839 ↑ 1.0 362,713 3

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

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

38. 7.140 7.140 ↑ 1.5 158 420

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

39. 3.780 3.780 ↑ 3.0 80 420

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

Planning time : 43.373 ms
Execution time : 8,056.268 ms