explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jmtB

Settings
# exclusive inclusive rows x rows loops node
1. 0.077 111.355 ↓ 0.0 0 1

Sort (cost=16,119.66..16,119.68 rows=5 width=220) (actual time=111.355..111.355 rows=0 loops=1)

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

Limit (cost=16,119.53..16,119.56 rows=5 width=220) (actual time=111.278..111.278 rows=0 loops=1)

3. 0.000 111.277 ↓ 0.0 0 1

Unique (cost=16,119.53..16,119.58 rows=9 width=220) (actual time=111.277..111.277 rows=0 loops=1)

4. 0.013 111.277 ↓ 0.0 0 1

Sort (cost=16,119.53..16,119.55 rows=9 width=220) (actual time=111.277..111.277 rows=0 loops=1)

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

Nested Loop Left Join (cost=1,002.41..16,119.39 rows=9 width=220) (actual time=111.264..111.264 rows=0 loops=1)

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

Nested Loop Left Join (cost=1,002.41..16,081.15 rows=9 width=218) (actual time=111.263..111.263 rows=0 loops=1)

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

Nested Loop Left Join (cost=1,002.41..16,043.46 rows=9 width=212) (actual time=111.263..111.263 rows=0 loops=1)

8. 0.000 111.262 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,001.99..16,036.68 rows=9 width=186) (actual time=111.262..111.262 rows=0 loops=1)

9. 0.000 111.262 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,001.56..16,029.80 rows=9 width=180) (actual time=111.262..111.262 rows=0 loops=1)

  • Join Filter: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
10. 0.001 111.262 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,001.56..16,005.69 rows=9 width=166) (actual time=111.262..111.262 rows=0 loops=1)

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

Nested Loop Left Join (cost=1,001.56..16,004.05 rows=9 width=134) (actual time=111.261..111.261 rows=0 loops=1)

  • Join Filter: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
12. 61.786 111.261 ↓ 0.0 0 1

Gather (cost=1,001.56..16,002.67 rows=9 width=106) (actual time=111.261..111.261 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
13. 0.003 49.475 ↓ 0.0 0 3

Nested Loop Left Join (cost=1.56..15,001.77 rows=4 width=106) (actual time=49.475..49.475 rows=0 loops=3)

14. 0.000 49.472 ↓ 0.0 0 3

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

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

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

16. 0.001 49.471 ↓ 0.0 0 3

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

17. 49.470 49.470 ↓ 0.0 0 3

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

  • Filter: (((pick_slip)::text = 'OCD_8179'::text) AND ((pick_slip)::text = ANY ('{OCD_8179,ocd_8179,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

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

23. 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)

24. 0.000 0.000 ↓ 0.0 0

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

25. 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)

26. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..8.74 rows=116 width=22) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Seq Scan on eb_transporteur transporteur (cost=0.00..8.16 rows=116 width=22) (never executed)

28. 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))
29. 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)
30. 0.000 0.000 ↓ 0.0 0

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

31. 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)

32. 0.000 0.000 ↓ 0.0 0

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

33. 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 : 12.413 ms
Execution time : 119.834 ms