explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x8xp

Settings
# exclusive inclusive rows x rows loops node
1. 0.543 5,446.245 ↓ 12.4 3,409 1

Nested Loop (cost=1.40..32,980.06 rows=274 width=7) (actual time=2.705..5,446.245 rows=3,409 loops=1)

2. 0.024 0.024 ↑ 1.0 1 1

Index Scan using commune_insee_idx on commune c (cost=0.41..8.44 rows=1 width=2,917) (actual time=0.023..0.024 rows=1 loops=1)

  • Index Cond: ((code_insee)::text = '93048'::text)
3. 13.474 5,445.678 ↓ 1.3 3,409 1

Nested Loop (cost=0.98..32,946.01 rows=2,561 width=39) (actual time=2.678..5,445.678 rows=3,409 loops=1)

4. 8.794 8.794 ↓ 5.4 13,765 1

Index Scan using parcelle_code_insee_idx on parcelle p (cost=0.57..10,031.47 rows=2,561 width=256) (actual time=0.029..8.794 rows=13,765 loops=1)

  • Index Cond: ((code_insee)::text = '93048'::text)
5. 5,423.410 5,423.410 ↓ 0.0 0 13,765

Index Scan using osm_point_geom on osm_point o (cost=0.42..8.94 rows=1 width=39) (actual time=0.357..0.394 rows=0 loops=13,765)

  • Index Cond: ((way && p.geom) AND (way && c.geom))
  • Filter: (_st_intersects(way, p.geom) AND _st_intersects(way, c.geom))
  • Rows Removed by Filter: 0
Planning time : 27.084 ms
Execution time : 5,446.575 ms