explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WBKX

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 5.412 ↑ 1.0 10 1

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

2. 1.139 5.373 ↑ 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.753..5.373 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.085 2.904 ↑ 37,106.2 10 1

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

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

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

5. 0.071 0.469 ↑ 37,106.2 10 1

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

6. 0.158 0.158 ↑ 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.086..0.158 rows=10 loops=1)

7. 0.240 0.240 ↑ 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.024..0.024 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.005..0.005 rows=1 loops=10)

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

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

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

11. 1.172 1.330 ↑ 1.0 121 10

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

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

Planning time : 3.067 ms
Execution time : 5.713 ms