explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZWhw

Settings
# exclusive inclusive rows x rows loops node
1. 0.091 10,683.215 ↑ 5.0 1 1

Sort (cost=68,965.92..68,965.93 rows=5 width=220) (actual time=10,683.215..10,683.215 rows=1 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7065208 read=1972 dirtied=5
  • I/O Timings: read=158.366
2. 0.002 10,683.124 ↑ 5.0 1 1

Limit (cost=1,003.42..68,965.81 rows=5 width=220) (actual time=10,399.998..10,683.124 rows=1 loops=1)

  • Buffers: shared hit=7065208 read=1972 dirtied=5
  • I/O Timings: read=158.366
3. 0.002 10,683.122 ↑ 195.0 1 1

Unique (cost=1,003.42..2,651,536.66 rows=195 width=220) (actual time=10,399.997..10,683.122 rows=1 loops=1)

  • Buffers: shared hit=7065208 read=1972 dirtied=5
  • I/O Timings: read=158.366
4. 0.014 10,683.120 ↑ 195.0 1 1

Nested Loop Left Join (cost=1,003.42..2,651,536.17 rows=195 width=220) (actual time=10,399.996..10,683.120 rows=1 loops=1)

  • Join Filter: (tsl_applique_dest.x_ec_country = country_dest.ec_country_num)
  • Rows Removed by Join Filter: 156
  • Buffers: shared hit=7065208 read=1972 dirtied=5
  • I/O Timings: read=158.366
5. 0.009 10,683.042 ↑ 195.0 1 1

Nested Loop Left Join (cost=1,003.42..2,650,811.60 rows=195 width=218) (actual time=10,399.918..10,683.042 rows=1 loops=1)

  • Join Filter: (tsl_applique_origin.x_ec_country = country_origin.ec_country_num)
  • Rows Removed by Join Filter: 157
  • Buffers: shared hit=7065206 read=1972 dirtied=5
  • I/O Timings: read=158.366
6. 197.068 10,682.907 ↑ 195.0 1 1

Nested Loop Left Join (cost=1,003.42..2,650,098.72 rows=195 width=212) (actual time=10,399.783..10,682.907 rows=1 loops=1)

  • Filter: (((chargement_not_routine.pick_slip)::text = '0817828966'::text) OR ((chargement_routine.pick_slip)::text = '0817828966'::text) OR ((demande.ref_transport)::text = '0817828966'::text) OR ((tracing.reference_po)::text (...)
  • Rows Removed by Filter: 258121
  • Buffers: shared hit=7065204 read=1972 dirtied=5
  • I/O Timings: read=158.366
7. 1,806.167 10,485.839 ↑ 9.9 258,122 1

Nested Loop Left Join (cost=1,003.00..1,066,290.86 rows=2,567,951 width=236) (actual time=92.646..10,485.839 rows=258,122 loops=1)

  • Join Filter: (demande.x_ec_type_transport IS DISTINCT FROM 3)
  • Rows Removed by Join Filter: 33602474
  • Buffers: shared hit=6994820 read=1888 dirtied=5
  • I/O Timings: read=154.286
8. 198.079 2,712.672 ↑ 1.0 248,625 1

Nested Loop Left Join (cost=1,002.58..522,168.80 rows=254,404 width=240) (actual time=92.239..2,712.672 rows=248,625 loops=1)

  • Buffers: shared hit=2230108 read=1751
  • I/O Timings: read=83.688
9. 556.313 2,017.343 ↑ 1.0 248,625 1

Merge Left Join (cost=1,002.16..354,853.32 rows=254,404 width=236) (actual time=91.878..2,017.343 rows=248,625 loops=1)

  • Merge Cond: (tracing.eb_tt_tracing_num = tsl_applique_origin.x_eb_tt_tracing)
  • Buffers: shared hit=1269460 read=1025
  • I/O Timings: read=50.396
  • -> 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..59720.68 rows=259588 width=14) (actual time=0.031..369.003 rows=258640 loops= (...)
10. 194.893 1,461.030 ↑ 1.0 248,625 1

Nested Loop Left Join (cost=1,001.73..291,319.00 rows=248,625 width=230) (actual time=91.843..1,461.030 rows=248,625 loops=1)

  • Join Filter: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
  • Rows Removed by Join Filter: 489464
  • Buffers: shared hit=1059738 read=924
  • I/O Timings: read=46.746
  • Index Cond: (order_psl = 1)
  • Buffers: shared hit=209722 read=101
  • I/O Timings: read=3.649
11. 213.153 1,266.137 ↑ 1.0 248,625 1

Nested Loop Left Join (cost=1,001.73..281,994.52 rows=248,625 width=198) (actual time=91.810..1,266.137 rows=248,625 loops=1)

  • Join Filter: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
  • Rows Removed by Join Filter: 853163
  • Buffers: shared hit=1059737 read=924
  • I/O Timings: read=46.746
12. 0.000 1,052.984 ↑ 1.0 248,625 1

Gather Merge (cost=1,001.73..265,832.84 rows=248,625 width=166) (actual time=91.733..1,052.984 rows=248,625 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1059736 read=924
  • I/O Timings: read=46.746
13. 80.640 3,006.270 ↑ 1.3 82,875 3

Nested Loop Left Join (cost=1.70..236,135.32 rows=103,594 width=166) (actual time=2.420..1,002.090 rows=82,875 loops=3)

  • Buffers: shared hit=3424730 read=3584
  • I/O Timings: read=214.317
14. 266.766 2,428.380 ↑ 1.3 82,875 3

Nested Loop Left Join (cost=1.28..158,152.58 rows=103,594 width=140) (actual time=2.404..809.460 rows=82,875 loops=3)

  • Buffers: shared hit=2429754 read=3420
  • I/O Timings: read=205.485
15. 107.298 1,912.989 ↑ 1.3 82,875 3

Nested Loop Left Join (cost=0.99..123,888.24 rows=103,594 width=127) (actual time=2.068..637.663 rows=82,875 loops=3)

  • Buffers: shared hit=1684187 read=3357
  • I/O Timings: read=195.696
16. 1,557.066 1,557.066 ↑ 1.3 82,875 3

Nested Loop Left Join (cost=0.85..107,313.54 rows=103,594 width=113) (actual time=2.030..519.022 rows=82,875 loops=3)

  • Buffers: shared hit=1186993 read=3357
  • I/O Timings: read=195.696
  • -> Parallel Index Scan using idx_eb_tt_tracing_eb_tt_tracing_num_asc on eb_tt_tracing tracing (cost=0.42..29330.80 rows=103594 width=113) (actual time=0.180..124. (...)
  • Buffers: shared hit=197927 read=19
  • I/O Timings: read=2.095
  • -> 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.004..0.004 rows=1 loops=248625 (...)
  • Index Cond: (eb_tt_psl_applique_num = tracing.x_eb_tt_psl_applique_last)
  • Buffers: shared hit=989066 read=3338
  • I/O Timings: read=193.601
17. 248.625 248.625 ↑ 1.0 1 248,625

Index Scan using eb_transporteur_pk on eb_transporteur transporteur (cost=0.14..0.16 rows=1 width=22) (actual time=0.001..0.001 rows=1 loops=248,625)

  • Index Cond: (tracing.x_eb_transporteur = eb_transporteur_num)
  • Buffers: shared hit=497194
18. 248.625 248.625 ↑ 1.0 1 248,625

Index Scan using eb_demande_pk on eb_demande demande (cost=0.29..0.33 rows=1 width=17) (actual time=0.001..0.001 rows=1 loops=248,625)

  • Index Cond: (tracing.x_eb_demande = eb_demande_num)
  • Buffers: shared hit=745567 read=63
  • I/O Timings: read=9.788
19. 497.250 497.250 ↑ 1.0 1 248,625

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=248,625)

  • Index Cond: (eb_tt_psl_applique_num = tracing.x_eb_dernier_psl_applique_actif)
  • Buffers: shared hit=994976 read=164
  • I/O Timings: read=8.832
20. 0.000 0.000 ↑ 1.2 4 248,625

Materialize (cost=0.00..1.08 rows=5 width=36) (actual time=0.000..0.000 rows=4 loops=248,625)

  • Buffers: shared hit=1
21. 0.022 0.022 ↑ 1.0 5 1

Seq Scan on eb_tt_psl psl (cost=0.00..1.05 rows=5 width=36) (actual time=0.020..0.022 rows=5 loops=1)

  • Buffers: shared hit=1
22. 0.000 0.000 ↑ 1.0 3 248,625

Materialize (cost=0.00..1.04 rows=3 width=36) (actual time=0.000..0.000 rows=3 loops=248,625)

  • Buffers: shared hit=1
23. 0.014 0.014 ↑ 1.0 3 1

Seq Scan on ec_type_transport type_transport (cost=0.00..1.03 rows=3 width=36) (actual time=0.013..0.014 rows=3 loops=1)

  • Buffers: shared hit=1
24. 497.250 497.250 ↑ 1.0 1 248,625

Index Scan using eb_chargement_pk on eb_chargement chargement_routine (cost=0.42..0.66 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=248,625)

  • Index Cond: (eb_chargement_num = tracing.x_eb_chargement)
  • Buffers: shared hit=960648 read=726
  • I/O Timings: read=33.293
25. 5,967.000 5,967.000 ↓ 3.3 135 248,625

Index Scan using ex_demande_chargement_eb_demande_fk on ex_demande_chargement demande_chargement (cost=0.42..1.63 rows=41 width=8) (actual time=0.003..0.024 rows=135 loops=248,625)

  • Index Cond: (x_eb_demande = demande.eb_demande_num)
  • Buffers: shared hit=4764712 read=137 dirtied=5
  • I/O Timings: read=70.597
26. 0.000 0.000 ↓ 0.0 0 258,122

Index Scan using eb_chargement_pk on eb_chargement chargement_not_routine (cost=0.42..0.59 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=258,122)

  • Index Cond: (eb_chargement_num = demande_chargement.x_eb_chargement)
  • Buffers: shared hit=70384 read=84
  • I/O Timings: read=4.080
27. 0.082 0.126 ↑ 1.5 158 1

Materialize (cost=0.00..5.63 rows=242 width=14) (actual time=0.081..0.126 rows=158 loops=1)

  • Buffers: shared hit=2
28. 0.044 0.044 ↑ 1.5 158 1

Seq Scan on ec_country country_origin (cost=0.00..4.42 rows=242 width=14) (actual time=0.029..0.044 rows=158 loops=1)

  • Buffers: shared hit=2
29. 0.041 0.064 ↑ 1.5 157 1

Materialize (cost=0.00..5.63 rows=242 width=14) (actual time=0.026..0.064 rows=157 loops=1)

  • Buffers: shared hit=2
30. 0.023 0.023 ↑ 1.5 157 1

Seq Scan on ec_country country_dest (cost=0.00..4.42 rows=242 width=14) (actual time=0.009..0.023 rows=157 loops=1)

  • Buffers: shared hit=2
Planning time : 15.105 ms
Execution time : 10,692.969 ms