explain.depesz.com

PostgreSQL's explain analyze made readable

Result: atSX : selection reference track&trace

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 7,478.830 ↑ 1.0 1 1

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

  • Sort Key: tracing.eb_tt_tracing_num DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=78428
2. 0.001 7,478.802 ↑ 1.0 1 1

Limit (cost=327,077.74..327,077.75 rows=1 width=220) (actual time=7,478.801..7,478.802 rows=1 loops=1)

  • Buffers: shared hit=78428
3. 0.002 7,478.801 ↑ 1.0 1 1

Unique (cost=327,077.74..327,077.75 rows=1 width=220) (actual time=7,478.800..7,478.801 rows=1 loops=1)

  • Buffers: shared hit=78428
4. 0.018 7,478.799 ↑ 1.0 1 1

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

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=78428
5. 0.051 7,478.781 ↑ 1.0 1 1

Nested Loop Left Join (cost=242,732.26..327,077.73 rows=1 width=220) (actual time=7,478.778..7,478.781 rows=1 loops=1)

  • Join Filter: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
  • Rows Removed by Join Filter: 156
  • Buffers: shared hit=78428
6. 0.028 7,478.690 ↑ 1.0 1 1

Nested Loop Left Join (cost=242,732.26..327,070.23 rows=1 width=218) (actual time=7,478.688..7,478.690 rows=1 loops=1)

  • Join Filter: (tsl_applique_origin.x_ec_country = country_origin.ec_country_num)
  • Rows Removed by Join Filter: 157
  • Buffers: shared hit=78426
7. 369.053 7,478.590 ↑ 1.0 1 1

Gather (cost=242,732.26..327,062.78 rows=1 width=212) (actual time=7,478.588..7,478.590 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=78424
8. 43.923 7,109.537 ↓ 0.0 0 3

Hash Left Join (cost=241,732.26..326,062.68 rows=1 width=212) (actual time=7,085.427..7,109.537 rows=0 loops=3)

  • Hash Cond: (demande_chargement.x_eb_chargement = chargement_not_routine.eb_chargement_num)
  • Filter: ((((chargement_not_routine.pick_slip)::text = '0817828966'::text) OR ((chargement_routine.pick_slip)::text = '0817828966'::text) OR ((demande.ref_transport)::text = '0817828966'::text) OR ((tracing.refere (...)
  • Rows Removed by Filter: 86040
  • Buffers: shared hit=234787
9. 2,011.429 6,702.107 ↑ 12.4 86,041 3

Merge Left Join (cost=221,039.22..246,387.15 rows=1,069,980 width=236) (actual time=3,842.413..6,702.107 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
  • Buffers: shared hit=197188
10. 130.718 3,523.221 ↑ 1.3 82,875 3

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

  • Sort Key: demande.eb_demande_num
  • Sort Method: quicksort Memory: 27069kB
  • Buffers: shared hit=190300
11. 74.848 3,392.503 ↑ 1.3 82,875 3

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

  • Hash Cond: (tracing.x_eb_chargement = chargement_routine.eb_chargement_num)
  • Buffers: shared hit=190292
12. 85.082 2,943.230 ↑ 1.3 82,875 3

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

  • Hash Cond: (tracing.eb_tt_tracing_num = tsl_applique_origin.x_eb_tt_tracing)
  • Buffers: shared hit=152696
13. 95.714 2,609.365 ↑ 1.3 82,875 3

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

  • Hash Cond: (tracing.x_eb_dernier_psl_applique_actif = tsl_applique_dest.eb_tt_psl_applique_num)
  • Buffers: shared hit=104703
14. 38.606 1,533.040 ↑ 1.3 82,875 3

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

  • Hash Cond: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
  • Buffers: shared hit=57960
15. 37.676 1,493.788 ↑ 1.3 82,875 3

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

  • Hash Cond: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
  • Buffers: shared hit=57939
16. 91.651 1,455.519 ↑ 1.3 82,875 3

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

  • Hash Cond: (tracing.x_eb_tt_psl_applique_last = psl_applique_statut.eb_tt_psl_applique_num)
  • Buffers: shared hit=57936
17. 90.424 195.012 ↑ 1.3 82,875 3

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

  • Hash Cond: (tracing.x_eb_demande = demande.eb_demande_num)
  • Buffers: shared hit=11193
18. 42.503 42.503 ↑ 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.024..42.503 rows=82,875 loops=3)

  • Buffers: shared hit=6536
19. 13.080 62.085 ↑ 1.0 27,102 3

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1805kB
  • Buffers: shared hit=4575
20. 24.824 49.005 ↑ 1.0 27,102 3

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

  • Hash Cond: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
  • Buffers: shared hit=4575
21. 23.602 23.602 ↑ 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.687..23.602 rows=27,102 loops=3)

  • Buffers: shared hit=4572
22. 0.020 0.579 ↑ 1.0 3 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
23. 0.559 0.559 ↑ 1.0 3 3

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

  • Buffers: shared hit=3
24. 554.233 1,168.856 ↑ 1.0 1,293,200 3

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

  • Buckets: 2097152 Batches: 1 Memory Usage: 66900kB
  • Buffers: shared hit=46743
25. 614.623 614.623 ↑ 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.079..614.623 rows=1,293,200 loops=3)

  • Buffers: shared hit=46743
26. 0.016 0.593 ↑ 1.0 5 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
27. 0.577 0.577 ↑ 1.0 5 3

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

  • Buffers: shared hit=3
28. 0.079 0.646 ↑ 1.0 116 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=21
29. 0.567 0.567 ↑ 1.0 116 3

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

  • Buffers: shared hit=21
30. 546.051 980.611 ↑ 1.0 1,293,200 3

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

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

  • Buffers: shared hit=46743
32. 102.218 248.783 ↑ 1.0 258,640 3

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

  • Buckets: 262144 Batches: 1 Memory Usage: 13984kB
  • Buffers: shared hit=47993
33. 117.304 146.565 ↑ 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=32.657..146.565 rows=258,640 loops=3)

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

  • Index Cond: (order_psl = 1)
  • Buffers: shared hit=2129
35. 150.733 374.425 ↑ 1.0 362,713 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 19806kB
  • Buffers: shared hit=37596
36. 223.692 223.692 ↑ 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.692..223.692 rows=362,713 loops=3)

  • Buffers: shared hit=37596
37. 1,055.495 1,167.457 ↓ 31.3 11,360,426 3

Sort (cost=39,403.31..40,309.79 rows=362,589 width=8) (actual time=335.003..1,167.457 rows=11,360,426 loops=3)

  • Sort Key: demande_chargement.x_eb_demande
  • Sort Method: quicksort Memory: 29277kB
  • Buffers: shared hit=6888
38. 111.962 111.962 ↑ 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.727..111.962 rows=362,431 loops=3)

  • Buffers: shared hit=6888
39. 192.990 363.507 ↑ 1.0 362,713 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 19806kB
  • Buffers: shared hit=37596
40. 170.517 170.517 ↑ 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.037..170.517 rows=362,713 loops=3)

  • Buffers: shared hit=37596
41. 0.072 0.072 ↑ 1.5 158 1

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

  • Buffers: shared hit=2
42. 0.040 0.040 ↑ 1.5 157 1

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

  • Buffers: shared hit=2
Planning time : 55.252 ms
Execution time : 7,578.513 ms