explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QFlC

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

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

2. 1.128 5.212 ↑ 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.693..5.212 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.088 2.764 ↑ 37,106.2 10 1

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

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

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

5. 0.076 0.340 ↑ 37,106.2 10 1

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

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

7. 0.150 0.150 ↑ 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.015..0.015 rows=1 loops=10)

  • Index Cond: (eb_party_num = chargement.x_eb_party)
8. 0.030 0.030 ↑ 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.003..0.003 rows=1 loops=10)

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

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

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

11. 1.183 1.320 ↑ 1.0 121 10

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

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

Planning time : 1.724 ms
Execution time : 5.460 ms