explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6kax

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 4,222.720 ↓ 0.0 0 1

Sort (cost=80,662.79..80,662.80 rows=1 width=220) (actual time=4,222.720..4,222.720 rows=0 loops=1)

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

Limit (cost=80,662.76..80,662.77 rows=1 width=220) (actual time=4,222.714..4,222.714 rows=0 loops=1)

3. 0.000 4,222.713 ↓ 0.0 0 1

Unique (cost=80,662.76..80,662.77 rows=1 width=220) (actual time=4,222.713..4,222.713 rows=0 loops=1)

4. 0.004 4,222.713 ↓ 0.0 0 1

Sort (cost=80,662.76..80,662.77 rows=1 width=220) (actual time=4,222.713..4,222.713 rows=0 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 25kB
5. 0.000 4,222.709 ↓ 0.0 0 1

Nested Loop Left Join (cost=43,437.62..80,662.75 rows=1 width=220) (actual time=4,222.709..4,222.709 rows=0 loops=1)

  • Join Filter: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
6. 0.001 4,222.709 ↓ 0.0 0 1

Nested Loop Left Join (cost=43,437.62..80,655.25 rows=1 width=218) (actual time=4,222.709..4,222.709 rows=0 loops=1)

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

Nested Loop Left Join (cost=43,437.62..80,647.80 rows=1 width=212) (actual time=4,222.708..4,222.708 rows=0 loops=1)

8. 0.000 4,222.708 ↓ 0.0 0 1

Nested Loop Left Join (cost=43,437.19..80,647.05 rows=1 width=186) (actual time=4,222.708..4,222.708 rows=0 loops=1)

9. 0.000 4,222.708 ↓ 0.0 0 1

Nested Loop Left Join (cost=43,436.77..80,646.29 rows=1 width=180) (actual time=4,222.708..4,222.708 rows=0 loops=1)

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

Nested Loop Left Join (cost=43,436.77..80,645.22 rows=1 width=152) (actual time=4,222.708..4,222.708 rows=0 loops=1)

  • Join Filter: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
11. 0.000 4,222.707 ↓ 0.0 0 1

Nested Loop Left Join (cost=43,436.77..80,635.61 rows=1 width=138) (actual time=4,222.707..4,222.707 rows=0 loops=1)

  • Join Filter: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
12. 0.001 4,222.707 ↓ 0.0 0 1

Nested Loop Left Join (cost=43,436.77..80,634.50 rows=1 width=106) (actual time=4,222.707..4,222.707 rows=0 loops=1)

13. 116.897 4,222.706 ↓ 0.0 0 1

Gather (cost=43,436.34..80,633.74 rows=1 width=106) (actual time=4,222.706..4,222.706 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
14. 2,971.591 4,105.809 ↓ 0.0 0 3

Hash Left Join (cost=42,436.34..79,633.64 rows=1 width=106) (actual time=4,105.809..4,105.809 rows=0 loops=3)

  • Hash Cond: (tracing.x_eb_demande = demande.eb_demande_num)
  • Filter: ((((chargement_not_routine.pick_slip)::text = 'OCD_8179'::text) OR ((tracing.reference_po)::text = 'OCD_8179'::text)) AND (((chargement_not_routine.pick_slip)::text = ' (...)
  • Rows Removed by Filter: 11206803
15. 50.394 50.394 ↑ 1.3 82,875 3

Parallel Seq Scan on eb_tt_tracing tracing (cost=0.00..7,571.94 rows=103,594 width=109) (actual time=0.023..50.394 rows=82,875 loops=3)

16. 174.708 1,083.824 ↑ 1.0 362,507 3

Hash (cost=37,903.98..37,903.98 rows=362,589 width=25) (actual time=1,083.824..1,083.824 rows=362,507 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 25460kB
17. 240.955 909.116 ↑ 1.0 362,507 3

Hash Left Join (cost=22,826.84..37,903.98 rows=362,589 width=25) (actual time=424.277..909.116 rows=362,507 loops=3)

  • Hash Cond: (demande_chargement.x_eb_chargement = chargement_not_routine.eb_chargement_num)
18. 190.127 285.439 ↑ 1.0 362,507 3

Hash Right Join (cost=2,133.80..12,633.26 rows=362,589 width=21) (actual time=38.560..285.439 rows=362,507 loops=3)

  • Hash Cond: (demande_chargement.x_eb_demande = demande.eb_demande_num)
19. 57.549 57.549 ↑ 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.594..57.549 rows=362,431 loops=3)

20. 14.638 37.763 ↑ 1.0 27,102 3

Hash (cost=1,795.02..1,795.02 rows=27,102 width=17) (actual time=37.763..37.763 rows=27,102 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1633kB
21. 23.125 23.125 ↑ 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.657..23.125 rows=27,102 loops=3)

22. 158.705 382.722 ↑ 1.0 362,713 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 19806kB
23. 224.017 224.017 ↑ 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.633..224.017 rows=362,713 loops=3)

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

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

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

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

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

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

Planning time : 9.517 ms
Execution time : 4,267.478 ms