explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UoN3

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 3,355.702 ↓ 5.0 5 1

Sort (cost=116,996.70..116,996.71 rows=1 width=220) (actual time=3,355.701..3,355.702 rows=5 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num DESC
  • Sort Method: quicksort Memory: 26kB
2. 0.002 3,355.686 ↓ 5.0 5 1

Limit (cost=116,996.68..116,996.68 rows=1 width=220) (actual time=3,355.646..3,355.686 rows=5 loops=1)

3. 0.027 3,355.684 ↓ 5.0 5 1

Unique (cost=116,996.68..116,996.68 rows=1 width=220) (actual time=3,355.645..3,355.684 rows=5 loops=1)

4. 0.571 3,355.657 ↓ 85.0 85 1

Sort (cost=116,996.68..116,996.68 rows=1 width=220) (actual time=3,355.643..3,355.657 rows=85 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 136kB
5. 6.508 3,355.086 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,437.62..116,996.67 rows=1 width=220) (actual time=1,500.345..3,355.086 rows=420 loops=1)

  • Join Filter: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
  • Rows Removed by Join Filter: 33369
6. 9.126 3,344.798 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,437.62..116,989.16 rows=1 width=218) (actual time=1,500.309..3,344.798 rows=420 loops=1)

  • Join Filter: (tsl_applique_origin.x_ec_country = country_origin.ec_country_num)
  • Rows Removed by Join Filter: 65940
7. 0.437 3,328.952 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,437.62..116,981.72 rows=1 width=212) (actual time=1,500.255..3,328.952 rows=420 loops=1)

8. 0.561 3,327.675 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,437.19..116,980.96 rows=1 width=186) (actual time=1,500.244..3,327.675 rows=420 loops=1)

9. 4.483 3,325.854 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,436.77..116,980.20 rows=1 width=180) (actual time=1,500.180..3,325.854 rows=420 loops=1)

  • Join Filter: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
  • Rows Removed by Join Filter: 15120
10. 3.153 3,319.271 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,436.77..116,970.59 rows=1 width=166) (actual time=1,500.154..3,319.271 rows=420 loops=1)

  • Join Filter: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
  • Rows Removed by Join Filter: 1344
11. 0.375 3,315.698 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,436.77..116,969.47 rows=1 width=134) (actual time=1,500.129..3,315.698 rows=420 loops=1)

12. 3.433 3,314.063 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,436.34..116,968.72 rows=1 width=134) (actual time=1,500.111..3,314.063 rows=420 loops=1)

  • Join Filter: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
  • Rows Removed by Join Filter: 840
13. 31.351 3,310.210 ↓ 420.0 420 1

Gather (cost=43,436.34..116,967.65 rows=1 width=106) (actual time=1,500.087..3,310.210 rows=420 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
14. 2,514.122 3,278.859 ↓ 140.0 140 3

Hash Left Join (cost=42,436.34..115,967.55 rows=1 width=106) (actual time=1,558.407..3,278.859 rows=140 loops=3)

  • Hash Cond: (tracing.x_eb_demande = demande.eb_demande_num)
  • Filter: ((((chargement_not_routine.pick_slip)::text = 'OCD_8179'::text) OR ((demande.ref_transport)::text = 'OCD_8179'::text) OR ((tracing.reference_po)::text = 'OCD_8179'::tex (...)
  • Rows Removed by Filter: 11206663
15. 28.858 28.858 ↑ 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.022..28.858 rows=82,875 loops=3)

16. 105.869 735.879 ↑ 1.0 362,507 3

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

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

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

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

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

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

20. 9.071 32.021 ↑ 1.0 27,102 3

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

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

22. 117.494 268.927 ↑ 1.0 362,713 3

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

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

24. 0.420 0.420 ↑ 1.0 3 420

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

25. 1.260 1.260 ↑ 1.0 1 420

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) (actual time=0.003..0.003 rows=1 loops=420)

  • Index Cond: (eb_tt_psl_applique_num = tracing.x_eb_tt_psl_applique_last)
26. 0.420 0.420 ↑ 1.2 4 420

Seq Scan on eb_tt_psl psl (cost=0.00..1.05 rows=5 width=36) (actual time=0.001..0.001 rows=4 loops=420)

27. 2.100 2.100 ↑ 3.1 37 420

Seq Scan on eb_transporteur transporteur (cost=0.00..8.16 rows=116 width=22) (actual time=0.002..0.005 rows=37 loops=420)

28. 1.260 1.260 ↑ 1.0 1 420

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) (actual time=0.003..0.003 rows=1 loops=420)

  • Index Cond: ((x_eb_tt_tracing = tracing.eb_tt_tracing_num) AND (order_psl = 1))
29. 0.840 0.840 ↑ 1.0 1 420

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) (actual time=0.002..0.002 rows=1 loops=420)

  • Index Cond: (eb_tt_psl_applique_num = tracing.x_eb_dernier_psl_applique_actif)
30. 6.720 6.720 ↑ 1.5 158 420

Seq Scan on ec_country country_origin (cost=0.00..4.42 rows=242 width=14) (actual time=0.003..0.016 rows=158 loops=420)

31. 3.780 3.780 ↑ 3.0 80 420

Seq Scan on ec_country country_dest (cost=0.00..4.42 rows=242 width=14) (actual time=0.003..0.009 rows=80 loops=420)

Planning time : 8.478 ms
Execution time : 3,402.132 ms