explain.depesz.com

PostgreSQL's explain analyze made readable

Result: viKH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..14,954.56 rows=3,256 width=502) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on enrichissement_projet_copro proj (cost=0.00..107.56 rows=3,256 width=186) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Limit (cost=0.42..4.54 rows=1 width=324) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using parcelles_2020_01_geom_idx on parcelles_2020_01 cpeo (cost=0.42..37,715.72 rows=9,160 width=324) (actual rows= loops=)

  • Index Cond: (proj.geom && geom)
  • Order By: (geom <-> proj.geom)