explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KGpi

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

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

2. 1.122 5.327 ↑ 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.724..5.327 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.078 2.865 ↑ 37,106.2 10 1

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

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

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

5. 0.073 0.446 ↑ 37,106.2 10 1

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

6. 0.153 0.153 ↑ 37,106.2 10 1

Index Scan Backward using eb_chargement_edi_pk on eb_chargement_edi chargement (cost=0.42..37,130.61 rows=371,062 width=1,826) (actual time=0.075..0.153 rows=10 loops=1)

7. 0.220 0.220 ↑ 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.021..0.022 rows=1 loops=10)

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

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

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

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

11. 1.191 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.149 0.149 ↑ 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.149 rows=121 loops=1)

Planning time : 1.796 ms
Execution time : 5.699 ms