explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KDhZ

Settings
# exclusive inclusive rows x rows loops node
1. 614.422 31,025.177 ↑ 1.0 232,002 1

Sort (cost=434,650.38..435,230.39 rows=232,002 width=340) (actual time=30,788.594..31,025.177 rows=232,002 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 67848kB
2. 470.556 30,410.755 ↑ 1.0 232,002 1

Unique (cost=410,453.33..411,654.60 rows=232,002 width=344) (actual time=29,687.941..30,410.755 rows=232,002 loops=1)

3. 801.588 29,940.199 ↑ 1.0 232,002 1

Sort (cost=410,453.33..411,053.97 rows=240,255 width=344) (actual time=29,687.933..29,940.199 rows=232,002 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 67848kB
4. 1,254.423 29,138.611 ↑ 1.0 232,002 1

Hash Right Join (cost=339,103.54..388,981.49 rows=240,255 width=344) (actual time=27,368.014..29,138.611 rows=232,002 loops=1)

  • Hash Cond: (psl_dl.x_eb_tt_tracing = tracing.eb_tt_tracing_num)
5. 519.036 519.036 ↑ 1.0 232,021 1

Seq Scan on eb_tt_psl_applique psl_dl (cost=0.00..30,413.96 rows=235,212 width=28) (actual time=0.021..519.036 rows=232,021 loops=1)

  • Filter: (order_psl = 5)
  • Rows Removed by Filter: 928084
6. 533.157 27,365.152 ↑ 1.0 232,002 1

Hash (cost=336,141.34..336,141.34 rows=236,976 width=320) (actual time=27,365.152..27,365.152 rows=232,002 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 45748kB
7. 1,002.733 26,831.995 ↑ 1.0 232,002 1

Hash Right Join (cost=300,874.63..336,141.34 rows=236,976 width=320) (actual time=25,320.046..26,831.995 rows=232,002 loops=1)

  • Hash Cond: (psl_cs.x_eb_tt_tracing = tracing.eb_tt_tracing_num)
8. 509.468 509.468 ↓ 1.0 232,021 1

Seq Scan on eb_tt_psl_applique psl_cs (cost=0.00..30,413.96 rows=226,084 width=28) (actual time=0.023..509.468 rows=232,021 loops=1)

  • Filter: (order_psl = 4)
  • Rows Removed by Filter: 928084
9. 561.521 25,319.794 ↑ 1.0 232,002 1

Hash (cost=297,912.43..297,912.43 rows=236,976 width=296) (actual time=25,319.794..25,319.794 rows=232,002 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 45697kB
10. 510.435 24,758.273 ↑ 1.0 232,002 1

Hash Left Join (cost=248,465.19..297,912.43 rows=236,976 width=296) (actual time=18,985.065..24,758.273 rows=232,002 loops=1)

  • Hash Cond: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
11. 504.301 24,247.804 ↑ 1.0 232,002 1

Hash Left Join (cost=248,464.08..294,652.89 rows=236,976 width=264) (actual time=18,984.985..24,247.804 rows=232,002 loops=1)

  • Hash Cond: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
12. 3,580.586 23,739.511 ↑ 1.0 232,002 1

Hash Right Join (cost=248,456.51..291,387.23 rows=236,976 width=250) (actual time=18,980.905..23,739.511 rows=232,002 loops=1)

  • Hash Cond: (psl_applique_statut.eb_tt_psl_applique_num = tracing.x_eb_tt_psl_applique_last)
13. 1,178.627 1,178.627 ↑ 1.0 1,160,105 1

Seq Scan on eb_tt_psl_applique psl_applique_statut (cost=0.00..27,512.97 rows=1,160,397 width=8) (actual time=0.013..1,178.627 rows=1,160,105 loops=1)

14. 512.340 18,980.298 ↑ 1.0 232,002 1

Hash (cost=245,494.31..245,494.31 rows=236,976 width=250) (actual time=18,980.298..18,980.298 rows=232,002 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 41818kB
15. 1,085.497 18,467.958 ↑ 1.0 232,002 1

Hash Right Join (cost=210,061.83..245,494.31 rows=236,976 width=250) (actual time=16,846.550..18,467.958 rows=232,002 loops=1)

  • Hash Cond: (psl_ar.x_eb_tt_tracing = tracing.eb_tt_tracing_num)
16. 536.298 536.298 ↑ 1.0 232,021 1

Seq Scan on eb_tt_psl_applique psl_ar (cost=0.00..30,413.96 rows=235,445 width=28) (actual time=0.022..536.298 rows=232,021 loops=1)

  • Filter: (order_psl = 3)
  • Rows Removed by Filter: 928084
17. 476.702 16,846.163 ↑ 1.0 232,002 1

Hash (cost=207,142.95..207,142.95 rows=233,511 width=226) (actual time=16,846.163..16,846.163 rows=232,002 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 41750kB
18. 504.377 16,369.461 ↑ 1.0 232,002 1

Hash Left Join (cost=169,936.93..207,142.95 rows=233,511 width=226) (actual time=14,360.537..16,369.461 rows=232,002 loops=1)

  • Hash Cond: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
19. 999.029 15,864.548 ↑ 1.0 232,002 1

Hash Right Join (cost=169,929.51..205,305.58 rows=233,511 width=220) (actual time=14,359.966..15,864.548 rows=232,002 loops=1)

  • Hash Cond: (psl_dp.x_eb_tt_tracing = tracing.eb_tt_tracing_num)
20. 505.831 505.831 ↑ 1.0 232,021 1

Seq Scan on eb_tt_psl_applique psl_dp (cost=0.00..30,413.96 rows=233,511 width=28) (actual time=0.037..505.831 rows=232,021 loops=1)

  • Filter: (order_psl = 2)
  • Rows Removed by Filter: 928084
21. 462.089 14,359.688 ↑ 1.0 232,002 1

Hash (cost=167,029.48..167,029.48 rows=232,002 width=196) (actual time=14,359.688..14,359.688 rows=232,002 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 41259kB
22. 964.434 13,897.599 ↑ 1.0 232,002 1

Hash Right Join (cost=131,724.94..167,029.48 rows=232,002 width=196) (actual time=12,441.528..13,897.599 rows=232,002 loops=1)

  • Hash Cond: (psl_pu.x_eb_tt_tracing = tracing.eb_tt_tracing_num)
23. 492.011 492.011 ↓ 1.0 232,021 1

Seq Scan on eb_tt_psl_applique psl_pu (cost=0.00..30,413.96 rows=230,145 width=28) (actual time=0.018..492.011 rows=232,021 loops=1)

  • Filter: (order_psl = 1)
  • Rows Removed by Filter: 928084
24. 485.776 12,441.154 ↑ 1.0 232,002 1

Hash (cost=128,824.91..128,824.91 rows=232,002 width=172) (actual time=12,441.154..12,441.154 rows=232,002 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 36907kB
25. 510.703 11,955.378 ↑ 1.0 232,002 1

Hash Left Join (cost=78,612.00..128,824.91 rows=232,002 width=172) (actual time=6,454.642..11,955.378 rows=232,002 loops=1)

  • Hash Cond: (tsl_applique_origin.x_ec_country = country_origin.ec_country_num)
26. 625.991 11,444.120 ↑ 1.0 232,002 1

Hash Left Join (cost=78,604.58..126,999.37 rows=232,002 width=166) (actual time=6,454.036..11,444.120 rows=232,002 loops=1)

  • Hash Cond: (tracing.x_eb_demande = demande.eb_demande_num)
27. 4,364.471 8,632.605 ↑ 1.0 232,002 1

Hash Right Join (cost=58,113.61..101,000.99 rows=232,002 width=129) (actual time=4,268.432..8,632.605 rows=232,002 loops=1)

  • Hash Cond: (tsl_applique_dest.eb_tt_psl_applique_num = tracing.x_eb_dernier_psl_applique_actif)
  • -> Seq Scan on eb_tt_psl_applique tsl_applique_dest (cost=0.00..27512.97 rows=1160397 width=38) (actual time=0.012..1177.556 rows=11 (...)
28. 388.422 4,268.134 ↑ 1.0 232,002 1

Hash (cost=55,213.59..55,213.59 rows=232,002 width=103) (actual time=4,268.134..4,268.134 rows=232,002 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 29202kB
29. 3,197.802 3,879.712 ↑ 1.0 232,002 1

Hash Right Join (cost=19,909.05..55,213.59 rows=232,002 width=103) (actual time=682.153..3,879.712 rows=232,002 loops=1)

  • Hash Cond: (tsl_applique_origin.x_eb_tt_tracing = tracing.eb_tt_tracing_num)
  • -> Seq Scan on eb_tt_psl_applique tsl_applique_origin (cost=0.00..30413.96 rows=230145 width=14) (actual time=0.009..227 (...)
  • Filter: (order_psl = 1)
  • Rows Removed by Filter: 928084
30. 681.910 681.910 ↑ 1.0 232,002 1

Hash (cost=17,009.02..17,009.02 rows=232,002 width=97) (actual time=681.910..681.910 rows=232,002 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 27456kB
  • -> Seq Scan on eb_tt_tracing tracing (cost=0.00..17009.02 rows=232002 width=97) (actual time=0.011..351.458 rows=2 (...)
31. 37.637 2,185.524 ↑ 1.4 25,427 1

Hash (cost=20,041.69..20,041.69 rows=35,942 width=45) (actual time=2,185.524..2,185.524 rows=25,427 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1354kB
32. 71.228 2,147.887 ↑ 1.4 25,427 1

Hash Left Join (cost=1.07..20,041.69 rows=35,942 width=45) (actual time=37.676..2,147.887 rows=25,427 loops=1)

  • Hash Cond: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
33. 2,075.151 2,075.151 ↑ 1.4 25,427 1

Seq Scan on eb_demande demande (cost=0.00..19,546.42 rows=35,942 width=17) (actual time=36.130..2,075.151 rows=25,427 loops=1)

34. 1.508 1.508 ↑ 1.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • -> Seq Scan on ec_type_transport type_transport (cost=0.00..1.03 rows=3 width=36) (actual time=1.494..1.498 rows=3 loops (...)
35. 0.294 0.555 ↑ 1.0 241 1

Hash (cost=4.41..4.41 rows=241 width=14) (actual time=0.555..0.555 rows=241 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
36. 0.261 0.261 ↑ 1.0 241 1

Seq Scan on ec_country country_origin (cost=0.00..4.41 rows=241 width=14) (actual time=0.009..0.261 rows=241 loops=1)

37. 0.271 0.536 ↑ 1.0 241 1

Hash (cost=4.41..4.41 rows=241 width=14) (actual time=0.536..0.536 rows=241 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
38. 0.265 0.265 ↑ 1.0 241 1

Seq Scan on ec_country country_dest (cost=0.00..4.41 rows=241 width=14) (actual time=0.006..0.265 rows=241 loops=1)

39. 0.150 3.992 ↑ 1.0 114 1

Hash (cost=6.14..6.14 rows=114 width=22) (actual time=3.992..3.992 rows=114 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
40. 3.842 3.842 ↑ 1.0 114 1

Seq Scan on eb_transporteur transporteur (cost=0.00..6.14 rows=114 width=22) (actual time=0.025..3.842 rows=114 loops=1)

41. 0.011 0.034 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=36) (actual time=0.034..0.034 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
42. 0.023 0.023 ↑ 1.0 5 1

Seq Scan on eb_tt_psl psl (cost=0.00..1.05 rows=5 width=36) (actual time=0.018..0.023 rows=5 loops=1)

Planning time : 9.069 ms
Execution time : 31,299.063 ms