explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gr7f

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 1,185.410 ↓ 0.0 0 1

Sort (cost=319,457.78..319,457.79 rows=1 width=220) (actual time=1,185.410..1,185.410 rows=0 loops=1)

  • Sort Key: tracing.eb_tt_tracing_num DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.000 1,185.368 ↓ 0.0 0 1

Limit (cost=319,457.76..319,457.76 rows=1 width=220) (actual time=1,185.368..1,185.368 rows=0 loops=1)

3. 0.001 1,185.368 ↓ 0.0 0 1

Unique (cost=319,457.76..319,457.76 rows=1 width=220) (actual time=1,185.368..1,185.368 rows=0 loops=1)

4. 0.038 1,185.367 ↓ 0.0 0 1

Sort (cost=319,457.76..319,457.76 rows=1 width=220) (actual time=1,185.367..1,185.367 rows=0 loops=1)

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

Nested Loop Left Join (cost=169,140.57..319,457.75 rows=1 width=220) (actual time=1,185.329..1,185.329 rows=0 loops=1)

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

Nested Loop Left Join (cost=169,140.57..319,450.24 rows=1 width=218) (actual time=1,185.328..1,185.328 rows=0 loops=1)

  • Join Filter: (tsl_applique_origin.x_ec_country = country_origin.ec_country_num)
7. 30.554 1,185.327 ↓ 0.0 0 1

Hash Right Join (cost=169,140.57..319,442.80 rows=1 width=212) (actual time=1,185.327..1,185.327 rows=0 loops=1)

  • Hash Cond: (demande_chargement.x_eb_demande = demande.eb_demande_num)
  • Filter: ((((chargement_not_routine.pick_slip)::text = '0817831281'::text) OR ((chargement_routine.pick_slip)::text = '0817831281'::text) OR ((demande.ref_transport)::text = '0817831281'::text) OR ((tracing.reference_po (...)
  • Rows Removed by Filter: 17607
8. 123.678 304.308 ↑ 1.0 362,431 1

Hash Left Join (cost=20,693.04..31,192.61 rows=362,589 width=12) (actual time=159.319..304.308 rows=362,431 loops=1)

  • Hash Cond: (demande_chargement.x_eb_chargement = chargement_not_routine.eb_chargement_num)
9. 24.131 24.131 ↑ 1.0 362,431 1

Seq Scan on ex_demande_chargement demande_chargement (cost=0.00..5,921.89 rows=362,589 width=8) (actual time=0.026..24.131 rows=362,431 loops=1)

10. 89.524 156.499 ↑ 1.0 362,713 1

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

  • Buckets: 524288 Batches: 1 Memory Usage: 19806kB
11. 66.975 66.975 ↑ 1.0 362,713 1

Seq Scan on eb_chargement chargement_not_routine (cost=0.00..16,159.13 rows=362,713 width=12) (actual time=0.047..66.975 rows=362,713 loops=1)

12. 6.217 850.465 ↑ 23.7 8,110 1

Hash (cost=146,048.24..146,048.24 rows=191,943 width=236) (actual time=850.465..850.465 rows=8,110 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 3552kB
13. 4.221 844.248 ↑ 23.7 8,110 1

Hash Left Join (cost=103,851.87..146,048.24 rows=191,943 width=236) (actual time=582.592..844.248 rows=8,110 loops=1)

  • Hash Cond: (tracing.x_eb_chargement = chargement_routine.eb_chargement_num)
14. 2.266 695.604 ↑ 23.7 8,110 1

Hash Left Join (cost=83,158.82..122,931.92 rows=191,943 width=232) (actual time=435.850..695.604 rows=8,110 loops=1)

  • Hash Cond: (tracing.x_eb_transporteur = transporteur.eb_transporteur_num)
15. 2.243 693.248 ↑ 23.7 8,110 1

Hash Left Join (cost=83,149.21..120,513.72 rows=191,943 width=218) (actual time=435.753..693.248 rows=8,110 loops=1)

  • Hash Cond: (psl_applique_statut.x_eb_tt_psl = psl.eb_tt_psl_num)
16. 167.181 690.982 ↑ 23.7 8,110 1

Hash Right Join (cost=83,148.10..118,430.03 rows=191,943 width=186) (actual time=435.712..690.982 rows=8,110 loops=1)

  • Hash Cond: (tsl_applique_dest.eb_tt_psl_applique_num = tracing.x_eb_dernier_psl_applique_actif)
17. 89.307 89.307 ↑ 1.0 1,293,200 1

Seq Scan on eb_tt_psl_applique tsl_applique_dest (cost=0.00..28,513.00 rows=1,293,200 width=38) (actual time=0.040..89.307 rows=1,293,200 loops=1)

18. 4.964 434.494 ↑ 23.7 8,110 1

Hash (cost=80,748.81..80,748.81 rows=191,943 width=160) (actual time=434.494..434.494 rows=8,110 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 3363kB
19. 142.605 429.530 ↑ 23.7 8,110 1

Hash Right Join (cost=45,472.13..80,748.81 rows=191,943 width=160) (actual time=203.912..429.530 rows=8,110 loops=1)

  • Hash Cond: (psl_applique_statut.eb_tt_psl_applique_num = tracing.x_eb_tt_psl_applique_last)
20. 84.438 84.438 ↑ 1.0 1,293,200 1

Seq Scan on eb_tt_psl_applique psl_applique_statut (cost=0.00..28,513.00 rows=1,293,200 width=8) (actual time=0.030..84.438 rows=1,293,200 loops=1)

21. 4.595 202.487 ↑ 23.7 8,110 1

Hash (cost=43,072.85..43,072.85 rows=191,943 width=160) (actual time=202.487..202.487 rows=8,110 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 3363kB
22. 42.247 197.892 ↑ 23.7 8,110 1

Hash Right Join (cost=21,354.11..43,072.85 rows=191,943 width=160) (actual time=107.362..197.892 rows=8,110 loops=1)

  • Hash Cond: (tsl_applique_origin.x_eb_tt_tracing = tracing.eb_tt_tracing_num)
23. 52.341 65.463 ↑ 1.0 258,640 1

Bitmap Heap Scan on eb_tt_psl_applique tsl_applique_origin (cost=4,864.23..23,690.08 rows=259,588 width=14) (actual time=15.427..65.463 rows=258,640 loops=1)

  • Recheck Cond: (order_psl = 1)
  • Heap Blocks: exact=15288
24. 13.122 13.122 ↑ 1.0 258,640 1

Bitmap Index Scan on idx_eb_tt_psl_applique_order_psl (cost=0.00..4,799.34 rows=259,588 width=0) (actual time=13.122..13.122 rows=258,640 loops=1)

  • Index Cond: (order_psl = 1)
25. 4.547 90.182 ↑ 23.1 8,110 1

Hash (cost=14,145.09..14,145.09 rows=187,583 width=154) (actual time=90.182..90.182 rows=8,110 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 3315kB
26. 26.264 85.635 ↑ 23.1 8,110 1

Hash Join (cost=2,317.11..14,145.09 rows=187,583 width=154) (actual time=16.884..85.635 rows=8,110 loops=1)

  • Hash Cond: (tracing.x_eb_demande = demande.eb_demande_num)
27. 42.875 42.875 ↑ 1.0 248,625 1

Seq Scan on eb_tt_tracing tracing (cost=0.00..9,022.25 rows=248,625 width=113) (actual time=0.041..42.875 rows=248,625 loops=1)

28. 4.084 16.496 ↑ 1.0 20,448 1

Hash (cost=2,061.51..2,061.51 rows=20,448 width=45) (actual time=16.496..16.496 rows=20,448 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1335kB
29. 3.052 12.412 ↑ 1.0 20,448 1

Hash Left Join (cost=1.07..2,061.51 rows=20,448 width=45) (actual time=0.060..12.412 rows=20,448 loops=1)

  • Hash Cond: (demande.x_ec_type_transport = type_transport.ec_type_transport_num)
30. 9.338 9.338 ↑ 1.0 20,448 1

Seq Scan on eb_demande demande (cost=0.00..1,862.78 rows=20,448 width=17) (actual time=0.024..9.338 rows=20,448 loops=1)

  • Filter: (x_ec_type_transport <> 3)
  • Rows Removed by Filter: 6654
31. 0.009 0.022 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=36) (actual time=0.022..0.022 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 0.013 0.013 ↑ 1.0 3 1

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

33. 0.011 0.023 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=36) (actual time=0.023..0.023 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.012 0.012 ↑ 1.0 5 1

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

35. 0.030 0.090 ↑ 1.0 116 1

Hash (cost=8.16..8.16 rows=116 width=22) (actual time=0.090..0.090 rows=116 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
36. 0.060 0.060 ↑ 1.0 116 1

Seq Scan on eb_transporteur transporteur (cost=0.00..8.16 rows=116 width=22) (actual time=0.014..0.060 rows=116 loops=1)

37. 79.913 144.423 ↑ 1.0 362,713 1

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

  • Buckets: 524288 Batches: 1 Memory Usage: 19806kB
38. 64.510 64.510 ↑ 1.0 362,713 1

Seq Scan on eb_chargement chargement_routine (cost=0.00..16,159.13 rows=362,713 width=12) (actual time=0.021..64.510 rows=362,713 loops=1)

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

40. 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 : 20.941 ms
Execution time : 1,199.633 ms