explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TnwN

Settings
# exclusive inclusive rows x rows loops node
1. 1,043.036 6,691.293 ↓ 1.0 370,961 1

Unique (cost=74,573.70..113,149.44 rows=367,388 width=1,383) (actual time=5,201.130..6,691.293 rows=370,961 loops=1)

2. 1,431.274 5,648.257 ↓ 1.0 370,961 1

Sort (cost=74,573.70..75,492.17 rows=367,388 width=1,383) (actual time=5,201.119..5,648.257 rows=370,961 loops=1)

  • Sort Key: chargement.eb_chargement_edi_num, chargement.iftsta_file, chargement.pick_slip, chargement.ifcsum_file, chargement.date_creation, chargement.date_reception_ifcsum, chargement.date_reception_iftstat, chargement.code_transporteur, chargemen (...)
  • Sort Method: quicksort Memory: 202,430kB
3. 811.267 4,216.983 ↓ 1.0 370,961 1

Hash Left Join (cost=3,850.75..40,614.29 rows=367,388 width=1,383) (actual time=356.939..4,216.983 rows=370,961 loops=1)

  • Hash Cond: ((chargement.code_real_transporteur)::text = (eb_real_trans_f.code_filiale)::text)
4. 821.203 3,405.282 ↓ 1.0 370,961 1

Hash Left Join (cost=3,846.03..35,568.27 rows=367,388 width=1,365) (actual time=356.477..3,405.282 rows=370,961 loops=1)

  • Hash Cond: ((chargement.code_transporteur)::text = (eb_trans_f.code_filiale)::text)
5. 1,660.529 2,583.739 ↓ 1.0 370,961 1

Hash Left Join (cost=3,841.31..30,514.65 rows=367,388 width=1,347) (actual time=356.094..2,583.739 rows=370,961 loops=1)

  • Hash Cond: (chargement.x_eb_party = party.eb_party_num)
6. 567.227 567.227 ↓ 1.0 370,961 1

Seq Scan on eb_chargement_edi chargement (cost=0.00..17,947.88 rows=367,388 width=1,314) (actual time=0.031..567.227 rows=370,961 loops=1)

7. 94.185 355.983 ↑ 1.0 72,258 1

Hash (cost=2,932.62..2,932.62 rows=72,695 width=41) (actual time=355.983..355.983 rows=72,258 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 4,417kB
8. 168.784 261.798 ↑ 1.0 72,258 1

Hash Left Join (cost=7.45..2,932.62 rows=72,695 width=41) (actual time=0.631..261.798 rows=72,258 loops=1)

  • Hash Cond: (party.x_ec_country = country.ec_country_num)
9. 92.407 92.407 ↑ 1.0 72,258 1

Seq Scan on eb_party party (cost=0.00..2,135.95 rows=72,695 width=35) (actual time=0.004..92.407 rows=72,258 loops=1)

10. 0.320 0.607 ↑ 1.0 242 1

Hash (cost=4.42..4.42 rows=242 width=14) (actual time=0.607..0.607 rows=242 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
11. 0.287 0.287 ↑ 1.0 242 1

Seq Scan on ec_country country (cost=0.00..4.42 rows=242 width=14) (actual time=0.004..0.287 rows=242 loops=1)

12. 0.154 0.340 ↑ 1.0 121 1

Hash (cost=3.21..3.21 rows=121 width=25) (actual time=0.340..0.340 rows=121 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 7kB
13. 0.186 0.186 ↑ 1.0 121 1

Seq Scan on eb_transporteur_filiale eb_trans_f (cost=0.00..3.21 rows=121 width=25) (actual time=0.045..0.186 rows=121 loops=1)

14. 0.239 0.434 ↑ 1.0 121 1

Hash (cost=3.21..3.21 rows=121 width=25) (actual time=0.434..0.434 rows=121 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 7kB
15. 0.195 0.195 ↑ 1.0 121 1

Seq Scan on eb_transporteur_filiale eb_real_trans_f (cost=0.00..3.21 rows=121 width=25) (actual time=0.006..0.195 rows=121 loops=1)

Planning time : 5.281 ms
Execution time : 7,053.035 ms