explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wwmV

Settings
# exclusive inclusive rows x rows loops node
1. 583.597 9,266.754 ↑ 1.0 231,488 1

Sort (cost=629,205.51..629,784.23 rows=231,488 width=341) (actual time=9,149.634..9,266.754 rows=231,488 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num DESC
  • Sort Method: external merge Disk: 40296kB
2. 184.234 8,683.157 ↑ 1.0 231,488 1

Unique (cost=262,849.03..533,471.38 rows=231,488 width=341) (actual time=6,462.326..8,683.157 rows=231,488 loops=1)

3. 0.000 8,498.923 ↑ 1.0 231,488 1

Gather Merge (cost=262,849.03..532,874.80 rows=238,633 width=341) (actual time=6,462.323..8,498.923 rows=231,488 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 274.899 23,826.717 ↑ 1.3 77,163 3

Merge Left Join (cost=261,849.00..490,012.63 rows=99,430 width=345) (actual time=6,304.685..7,942.239 rows=77,163 loops=3)

  • Merge Cond: (tracing.eb_tt_tracing_num = psl_cs.x_eb_tt_tracing)
5. 272.928 22,784.382 ↑ 1.3 77,163 3

Merge Left Join (cost=261,844.10..433,722.87 rows=98,601 width=321) (actual time=6,304.643..7,594.794 rows=77,163 loops=3)

  • Merge Cond: (tracing.eb_tt_tracing_num = psl_dl.x_eb_tt_tracing)
6. 251.373 21,739.995 ↑ 1.3 77,163 3

Merge Left Join (cost=261,839.13..377,506.19 rows=98,601 width=297) (actual time=6,304.621..7,246.665 rows=77,163 loops=3)

  • Merge Cond: (tracing.eb_tt_tracing_num = psl_ar.x_eb_tt_tracing)
7. 255.645 20,807.706 ↑ 1.3 77,163 3

Merge Left Join (cost=261,834.25..321,197.83 rows=97,072 width=273) (actual time=6,304.605..6,935.902 rows=77,163 loops=3)

  • Merge Cond: (tracing.eb_tt_tracing_num = psl_dp.x_eb_tt_tracing)
8. 359.118 19,745.352 ↑ 1.2 77,163 3

Merge Left Join (cost=261,829.33..264,945.66 rows=96,453 width=249) (actual time=6,304.551..6,581.784 rows=77,163 loops=3)

  • Merge Cond: (tracing.eb_tt_tracing_num = psl_pu.x_eb_tt_tracing)
9. 944.250 17,184.423 ↑ 1.2 77,163 3

Sort (cost=207,923.53..208,164.66 rows=96,453 width=225) (actual time=5,678.920..5,728.141 rows=77,163 loops=3)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: external merge Disk: 12504kB
10. 134.562 16,240.173 ↑ 1.2 77,163 3

Hash Left Join (cost=128,174.69..189,385.91 rows=96,453 width=225) (actual time=3,165.337..5,413.391 rows=77,163 loops=3)

  • Hash Cond: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
11. 2,365.602 16,103.823 ↑ 1.2 77,163 3

Hash Left Join (cost=128,173.58..188,338.28 rows=96,453 width=193) (actual time=3,164.696..5,367.941 rows=77,163 loops=3)

  • Hash Cond: (tracing.x_eb_tt_psl_applique_last = psl_applique_statut.eb_tt_psl_applique_num)
12. 149.514 10,485.669 ↑ 1.2 77,163 3

Hash Left Join (cost=83,653.04..132,802.03 rows=96,453 width=193) (actual time=2,079.426..3,495.223 rows=77,163 loops=3)

  • Hash Cond: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
13. 128.391 10,332.804 ↑ 1.2 77,163 3

Hash Left Join (cost=83,643.48..131,582.25 rows=96,453 width=178) (actual time=2,078.282..3,444.268 rows=77,163 loops=3)

  • Hash Cond: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
14. 134.277 10,203.711 ↑ 1.2 77,163 3

Hash Left Join (cost=83,636.06..130,358.53 rows=96,453 width=172) (actual time=2,078.020..3,401.237 rows=77,163 loops=3)

  • Hash Cond: (tsl_applique_origin.x_ec_country = country_origin.ec_country_num)
15. 215.118 10,067.538 ↑ 1.2 77,163 3

Hash Left Join (cost=83,628.63..129,134.81 rows=96,453 width=166) (actual time=2,077.355..3,355.846 rows=77,163 loops=3)

  • Hash Cond: (tracing.x_eb_demande = demande.eb_demande_num)
16. 2,449.647 9,666.288 ↑ 1.2 77,163 3

Hash Left Join (cost=81,391.18..125,572.57 rows=96,453 width=129) (actual time=2,015.024..3,222.096 rows=77,163 loops=3)

  • Hash Cond: (tracing.x_eb_dernier_psl_applique_actif = tsl_applique_dest.eb_tt_psl_applique_num)
17. 849.762 3,327.657 ↑ 1.2 77,163 3

Hash Left Join (cost=32,348.64..63,252.32 rows=96,453 width=103) (actual time=700.206..1,109.219 rows=77,163 loops=3)

  • Hash Cond: (tracing.eb_tt_tracing_num = tsl_applique_origin.x_eb_tt_tracing)
18. 386.259 386.259 ↑ 1.2 77,163 3

Parallel Seq Scan on eb_tt_tracing tracing (cost=0.00..7,035.53 rows=96,453 width=97) (actual time=0.658..128.753 rows=77,163 loops=3)

19. 459.762 2,091.636 ↓ 1.0 231,507 3

Hash (cost=28,423.19..28,423.19 rows=225,796 width=14) (actual time=697.212..697.212 rows=231,507 loops=3)

  • Buckets: 131072 Batches: 4 Memory Usage: 3703kB
20. 1,631.874 1,631.874 ↓ 1.0 231,507 3

Seq Scan on eb_tt_psl_applique tsl_applique_origin (cost=0.00..28,423.19 rows=225,796 width=14) (actual time=0.644..543.958 rows=231,507 loops=3)

  • Filter: (order_psl = 1)
  • Rows Removed by Filter: 926028
21. 2,387.634 3,888.984 ↑ 1.0 1,157,535 3

Hash (cost=25,529.35..25,529.35 rows=1,157,535 width=38) (actual time=1,296.328..1,296.328 rows=1,157,535 loops=3)

  • Buckets: 65536 Batches: 32 Memory Usage: 2189kB
22. 1,501.350 1,501.350 ↑ 1.0 1,157,535 3

Seq Scan on eb_tt_psl_applique tsl_applique_dest (cost=0.00..25,529.35 rows=1,157,535 width=38) (actual time=0.025..500.450 rows=1,157,535 loops=3)

23. 39.198 186.132 ↑ 1.0 25,411 3

Hash (cost=1,919.82..1,919.82 rows=25,411 width=45) (actual time=62.044..62.044 rows=25,411 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1609kB
24. 65.169 146.934 ↑ 1.0 25,411 3

Hash Left Join (cost=1.07..1,919.82 rows=25,411 width=45) (actual time=1.067..48.978 rows=25,411 loops=3)

  • Hash Cond: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
25. 80.124 80.124 ↑ 1.0 25,411 3

Seq Scan on eb_demande demande (cost=0.00..1,673.11 rows=25,411 width=17) (actual time=0.493..26.708 rows=25,411 loops=3)

26. 0.060 1.641 ↑ 1.0 3 3

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

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

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

28. 0.255 1.896 ↑ 1.0 241 3

Hash (cost=4.41..4.41 rows=241 width=14) (actual time=0.632..0.632 rows=241 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
29. 1.641 1.641 ↑ 1.0 241 3

Seq Scan on ec_country country_origin (cost=0.00..4.41 rows=241 width=14) (actual time=0.495..0.547 rows=241 loops=3)

30. 0.246 0.702 ↑ 1.0 241 3

Hash (cost=4.41..4.41 rows=241 width=14) (actual time=0.234..0.234 rows=241 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
31. 0.456 0.456 ↑ 1.0 241 3

Seq Scan on ec_country country_dest (cost=0.00..4.41 rows=241 width=14) (actual time=0.021..0.152 rows=241 loops=3)

32. 0.384 3.351 ↑ 1.0 114 3

Hash (cost=8.14..8.14 rows=114 width=23) (actual time=1.117..1.117 rows=114 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
33. 2.967 2.967 ↑ 1.0 114 3

Seq Scan on eb_transporteur transporteur (cost=0.00..8.14 rows=114 width=23) (actual time=0.940..0.989 rows=114 loops=3)

34. 1,785.618 3,252.552 ↑ 1.0 1,157,535 3

Hash (cost=25,529.35..25,529.35 rows=1,157,535 width=8) (actual time=1,084.184..1,084.184 rows=1,157,535 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 3859kB
35. 1,466.934 1,466.934 ↑ 1.0 1,157,535 3

Seq Scan on eb_tt_psl_applique psl_applique_statut (cost=0.00..25,529.35 rows=1,157,535 width=8) (actual time=0.025..488.978 rows=1,157,535 loops=3)

36. 0.060 1.788 ↑ 1.0 5 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 1.728 1.728 ↑ 1.0 5 3

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

38. 112.050 2,201.811 ↓ 1.0 231,504 3

Materialize (cost=53,905.71..55,034.69 rows=225,796 width=28) (actual time=625.620..733.937 rows=231,504 loops=3)

39. 975.714 2,089.761 ↓ 1.0 231,504 3

Sort (cost=53,905.71..54,470.20 rows=225,796 width=28) (actual time=625.600..696.587 rows=231,504 loops=3)

  • Sort Key: psl_pu.x_eb_tt_tracing
  • Sort Method: external merge Disk: 6496kB
40. 1,114.047 1,114.047 ↓ 1.0 231,507 3

Seq Scan on eb_tt_psl_applique psl_pu (cost=0.00..28,423.19 rows=225,796 width=28) (actual time=0.029..371.349 rows=231,507 loops=3)

  • Filter: (order_psl = 1)
  • Rows Removed by Filter: 926028
41. 806.709 806.709 ↑ 1.0 231,504 3

Index Scan using idx_eb_tt_psl_applique_x_eb_tt_tracing_and_order_psl on eb_tt_psl_applique psl_dp (cost=0.43..54,464.02 rows=232,973 width=28) (actual time=0.049..268.903 rows=231,504 loops=3)

  • Index Cond: (order_psl = 2)
42. 680.916 680.916 ↑ 1.0 231,504 3

Index Scan using idx_eb_tt_psl_applique_x_eb_tt_tracing_and_order_psl on eb_tt_psl_applique psl_ar (cost=0.43..54,497.93 rows=235,134 width=28) (actual time=0.012..226.972 rows=231,504 loops=3)

  • Index Cond: (order_psl = 3)
43. 771.459 771.459 ↓ 1.0 231,504 3

Index Scan using idx_eb_tt_psl_applique_x_eb_tt_tracing_and_order_psl on eb_tt_psl_applique psl_dl (cost=0.43..54,420.16 rows=230,195 width=28) (actual time=0.018..257.153 rows=231,504 loops=3)

  • Index Cond: (order_psl = 5)
44. 767.436 767.436 ↑ 1.0 231,504 3

Index Scan using idx_eb_tt_psl_applique_x_eb_tt_tracing_and_order_psl on eb_tt_psl_applique psl_cs (cost=0.43..54,471.49 rows=233,436 width=28) (actual time=0.033..255.812 rows=231,504 loops=3)

  • Index Cond: (order_psl = 4)
Planning time : 44.515 ms
Execution time : 9,306.777 ms