explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UzWu

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 5.692 ↑ 1.0 10 1

Limit (cost=0.98..44.60 rows=10 width=1,895) (actual time=0.918..5.692 rows=10 loops=1)

2. 1.234 5.652 ↑ 37,106.2 10 1

Nested Loop Left Join (cost=0.98..1,618,565.05 rows=371,062 width=1,895) (actual time=0.914..5.652 rows=10 loops=1)

  • Join Filter: ((chargement.code_real_transporteur)::text = (eb_real_trans_f.code_filiale)::text)
  • Rows Removed by Join Filter: 1210
3. 1.098 3.078 ↑ 37,106.2 10 1

Nested Loop Left Join (cost=0.98..945,084.01 rows=371,062 width=1,877) (actual time=0.406..3.078 rows=10 loops=1)

  • Join Filter: ((chargement.code_transporteur)::text = (eb_trans_f.code_filiale)::text)
  • Rows Removed by Join Filter: 1082
4. 0.053 0.730 ↑ 37,106.2 10 1

Nested Loop Left Join (cost=0.98..271,602.97 rows=371,062 width=1,859) (actual time=0.337..0.730 rows=10 loops=1)

5. 0.069 0.627 ↑ 37,106.2 10 1

Nested Loop Left Join (cost=0.84..211,242.32 rows=371,062 width=1,853) (actual time=0.319..0.627 rows=10 loops=1)

6. 0.278 0.278 ↑ 37,106.2 10 1

Index Scan using idx_eb_chargement_edi_eb_chargement_edi_num_backward on eb_chargement_edi chargement (cost=0.42..37,130.61 rows=371,062 width=1,826) (actual time=0.243..0.278 rows=10 loops=1)

7. 0.280 0.280 ↑ 1.0 1 10

Index Scan using eb_party_pk on eb_party party (cost=0.42..0.47 rows=1 width=35) (actual time=0.027..0.028 rows=1 loops=10)

  • Index Cond: (eb_party_num = chargement.x_eb_party)
8. 0.050 0.050 ↑ 1.0 1 10

Index Scan using ec_country_pk on ec_country country (cost=0.14..0.16 rows=1 width=14) (actual time=0.004..0.005 rows=1 loops=10)

  • Index Cond: (ec_country_num = party.x_ec_country)
9. 1.085 1.250 ↑ 1.1 109 10

Materialize (cost=0.00..3.81 rows=121 width=25) (actual time=0.006..0.125 rows=109 loops=10)

10. 0.165 0.165 ↑ 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.043..0.165 rows=121 loops=1)

11. 1.185 1.340 ↑ 1.0 121 10

Materialize (cost=0.00..3.81 rows=121 width=25) (actual time=0.003..0.134 rows=121 loops=10)

12. 0.155 0.155 ↑ 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.010..0.155 rows=121 loops=1)

Planning time : 2.823 ms
Execution time : 6.070 ms