explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cf3X

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 152.586 ↓ 0.0 0 1

Sort (cost=15,529.46..15,529.47 rows=5 width=220) (actual time=152.586..152.586 rows=0 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.000 152.580 ↓ 0.0 0 1

Limit (cost=15,529.32..15,529.35 rows=5 width=220) (actual time=152.580..152.580 rows=0 loops=1)

3. 0.001 152.580 ↓ 0.0 0 1

Unique (cost=15,529.32..15,529.37 rows=9 width=220) (actual time=152.580..152.580 rows=0 loops=1)

4. 0.002 152.579 ↓ 0.0 0 1

Sort (cost=15,529.32..15,529.34 rows=9 width=220) (actual time=152.579..152.579 rows=0 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 25kB
5. 0.001 152.577 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,002.56..15,529.18 rows=9 width=220) (actual time=152.577..152.577 rows=0 loops=1)

  • Join Filter: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
6. 0.000 152.576 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,002.56..15,490.94 rows=9 width=218) (actual time=152.576..152.576 rows=0 loops=1)

  • Join Filter: (tsl_applique_origin.x_ec_country = country_origin.ec_country_num)
7. 0.000 152.576 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,002.56..15,453.25 rows=9 width=212) (actual time=152.576..152.576 rows=0 loops=1)

8. 0.001 152.576 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,002.13..15,446.47 rows=9 width=186) (actual time=152.576..152.576 rows=0 loops=1)

9. 0.000 152.575 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,001.70..15,439.59 rows=9 width=180) (actual time=152.575..152.575 rows=0 loops=1)

  • Join Filter: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
10. 0.001 152.575 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,001.70..15,438.21 rows=9 width=152) (actual time=152.575..152.575 rows=0 loops=1)

  • Join Filter: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
11. 108.775 152.574 ↓ 0.0 0 1

Gather (cost=1,001.70..15,436.57 rows=9 width=120) (actual time=152.574..152.574 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
12. 0.003 43.799 ↓ 0.0 0 3

Nested Loop Left Join (cost=1.70..14,435.67 rows=4 width=120) (actual time=43.799..43.799 rows=0 loops=3)

13. 0.000 43.796 ↓ 0.0 0 3

Nested Loop Left Join (cost=1.56..14,435.03 rows=4 width=106) (actual time=43.796..43.796 rows=0 loops=3)

14. 0.001 43.796 ↓ 0.0 0 3

Nested Loop (cost=1.13..14,432.02 rows=4 width=106) (actual time=43.796..43.796 rows=0 loops=3)

  • Join Filter: (demande.eb_demande_num = tracing.x_eb_demande)
15. 0.000 43.795 ↓ 0.0 0 3

Nested Loop (cost=0.71..14,429.90 rows=1 width=21) (actual time=43.795..43.795 rows=0 loops=3)

16. 0.001 43.795 ↓ 0.0 0 3

Nested Loop (cost=0.42..14,429.58 rows=1 width=4) (actual time=43.795..43.795 rows=0 loops=3)

17. 43.794 43.794 ↓ 0.0 0 3

Parallel Seq Scan on eb_chargement chargement_not_routine (cost=0.00..14,421.13 rows=1 width=4) (actual time=43.794..43.794 rows=0 loops=3)

  • Filter: ((pick_slip)::text = 'OCD_8179'::text)
  • Rows Removed by Filter: 120904
18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ex_demande_chargement_pk on ex_demande_chargement demande_chargement (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Index Cond: (x_eb_chargement = chargement_not_routine.eb_chargement_num)
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Index Scan using eb_demande_pk on eb_demande demande (cost=0.29..0.32 rows=1 width=17) (never executed)

  • Index Cond: (eb_demande_num = demande_chargement.x_eb_demande)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_eb_tt_tracing_x_eb_demande on eb_tt_tracing tracing (cost=0.42..1.44 rows=54 width=97) (never executed)

  • Index Cond: (x_eb_demande = demande_chargement.x_eb_demande)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_eb_tt_psl_applique on eb_tt_psl_applique psl_applique_statut (cost=0.43..0.75 rows=1 width=8) (never executed)

  • Index Cond: (eb_tt_psl_applique_num = tracing.x_eb_tt_psl_applique_last)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using eb_transporteur_pk on eb_transporteur transporteur (cost=0.14..0.16 rows=1 width=22) (never executed)

  • Index Cond: (tracing.x_eb_transporteur = eb_transporteur_num)
23. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.08 rows=5 width=36) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on eb_tt_psl psl (cost=0.00..1.05 rows=5 width=36) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.04 rows=3 width=36) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on ec_type_transport type_transport (cost=0.00..1.03 rows=3 width=36) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_eb_tt_psl_applique_x_eb_tt_tracing_and_order_psl on eb_tt_psl_applique tsl_applique_origin (cost=0.43..0.76 rows=1 width=14) (never executed)

  • Index Cond: ((x_eb_tt_tracing = tracing.eb_tt_tracing_num) AND (order_psl = 1))
28. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_eb_tt_psl_applique on eb_tt_psl_applique tsl_applique_dest (cost=0.43..0.75 rows=1 width=38) (never executed)

  • Index Cond: (eb_tt_psl_applique_num = tracing.x_eb_dernier_psl_applique_actif)
29. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..5.63 rows=242 width=14) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Seq Scan on ec_country country_origin (cost=0.00..4.42 rows=242 width=14) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..5.63 rows=242 width=14) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Seq Scan on ec_country country_dest (cost=0.00..4.42 rows=242 width=14) (never executed)

Planning time : 11.779 ms
Execution time : 160.026 ms