explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KPI9

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 5,133.562 ↓ 5.0 5 1

Sort (cost=108,345.77..108,345.78 rows=1 width=220) (actual time=5,133.562..5,133.562 rows=5 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num DESC
  • Sort Method: quicksort Memory: 26kB
2. 0.003 5,133.513 ↓ 5.0 5 1

Limit (cost=108,345.74..108,345.75 rows=1 width=220) (actual time=5,133.480..5,133.513 rows=5 loops=1)

3. 0.021 5,133.510 ↓ 5.0 5 1

Unique (cost=108,345.74..108,345.75 rows=1 width=220) (actual time=5,133.478..5,133.510 rows=5 loops=1)

4. 0.680 5,133.489 ↓ 85.0 85 1

Sort (cost=108,345.74..108,345.75 rows=1 width=220) (actual time=5,133.476..5,133.489 rows=85 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num
  • Sort Method: quicksort Memory: 136kB
5. 7.952 5,132.809 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,437.62..108,345.73 rows=1 width=220) (actual time=2,810.590..5,132.809 rows=420 loops=1)

  • Join Filter: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
  • Rows Removed by Join Filter: 33369
6. 10.546 5,120.657 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,437.62..108,338.23 rows=1 width=218) (actual time=2,810.410..5,120.657 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.247 5,086.171 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,437.62..108,330.78 rows=1 width=212) (actual time=2,810.355..5,086.171 rows=420 loops=1)

8. 0.415 5,084.664 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,437.19..108,330.03 rows=1 width=186) (actual time=2,810.347..5,084.664 rows=420 loops=1)

9. 11.247 5,082.569 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,436.77..108,329.27 rows=1 width=180) (actual time=2,810.325..5,082.569 rows=420 loops=1)

  • Join Filter: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
  • Rows Removed by Join Filter: 840
10. 4.753 5,070.902 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,436.77..108,328.20 rows=1 width=152) (actual time=2,810.265..5,070.902 rows=420 loops=1)

  • Join Filter: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
  • Rows Removed by Join Filter: 15120
11. 3.767 5,063.629 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,436.77..108,318.59 rows=1 width=138) (actual time=2,810.221..5,063.629 rows=420 loops=1)

  • Join Filter: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
  • Rows Removed by Join Filter: 1344
12. 0.621 5,059.442 ↓ 420.0 420 1

Nested Loop Left Join (cost=43,436.77..108,317.48 rows=1 width=106) (actual time=2,810.189..5,059.442 rows=420 loops=1)

13. 60.551 5,057.561 ↓ 420.0 420 1

Gather (cost=43,436.34..108,316.72 rows=1 width=106) (actual time=2,810.155..5,057.561 rows=420 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
14. 3,852.172 4,997.010 ↓ 140.0 140 3

Hash Left Join (cost=42,436.34..107,316.62 rows=1 width=106) (actual time=2,335.716..4,997.010 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. 42.816 42.816 ↑ 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.026..42.816 rows=82,875 loops=3)

16. 164.532 1,102.022 ↑ 1.0 362,507 3

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

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

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

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

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

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

20. 10.921 40.840 ↑ 1.0 27,102 3

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

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

22. 188.689 410.930 ↑ 1.0 362,713 3

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

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

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

26. 2.520 2.520 ↑ 3.1 37 420

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

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

28. 1.680 1.680 ↑ 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.004..0.004 rows=1 loops=420)

  • Index Cond: ((x_eb_tt_tracing = tracing.eb_tt_tracing_num) AND (order_psl = 1))
29. 1.260 1.260 ↑ 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.003..0.003 rows=1 loops=420)

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

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

31. 4.200 4.200 ↑ 3.0 80 420

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

Planning time : 21.803 ms
Execution time : 5,190.418 ms