explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zo1M

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.741 ↑ 1.0 10 1

Limit (cost=0.99..155.68 rows=10 width=75) (actual time=0.153..1.741 rows=10 loops=1)

2. 0.005 1.740 ↑ 245.7 10 1

Nested Loop (cost=0.99..38,008.80 rows=2,457 width=75) (actual time=0.153..1.740 rows=10 loops=1)

3. 0.010 1.695 ↑ 245.7 10 1

Nested Loop (cost=0.56..33,399.08 rows=2,457 width=42) (actual time=0.145..1.695 rows=10 loops=1)

4. 1.665 1.665 ↑ 248.9 10 1

Index Scan using idx_nentre_bis on vehicule vo (cost=0.42..32,970.45 rows=2,489 width=46) (actual time=0.140..1.665 rows=10 loops=1)

  • Filter: ((upper((nentre)::text) ~~ '%AB%'::text) OR (upper((immatriculation)::text) ~~ '%AB%'::text))
  • Rows Removed by Filter: 1,042
5. 0.020 0.020 ↑ 1.0 1 10

Index Scan using pk_localisation on localisation l (cost=0.14..0.16 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (cle = vo.site_cle)
  • Filter: (NOT blocked)
6. 0.040 0.040 ↑ 1.0 1 10

Index Scan using modele_perso_mv_pkey on modele_perso_mv m (cost=0.42..1.87 rows=1 width=41) (actual time=0.004..0.004 rows=1 loops=10)

  • Index Cond: (modele_cle = vo.modele_perso_cle)
Planning time : 0.547 ms
Execution time : 1.845 ms