explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9wH

Settings
# exclusive inclusive rows x rows loops node
1. 11.092 9,201.114 ↓ 2.7 3,409 1

Nested Loop (cost=5,020.17..567,429.60 rows=1,274 width=100) (actual time=11.697..9,201.114 rows=3,409 loops=1)

2.          

CTE tmp

3. 1.389 46.812 ↓ 4.6 6,913 1

Nested Loop (cost=41.35..4,647.26 rows=1,492 width=39) (actual time=8.528..46.812 rows=6,913 loops=1)

4. 0.030 0.030 ↑ 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.026..0.030 rows=1 loops=1)

  • Index Cond: ((code_insee)::text = '93048'::text)
5. 37.480 45.393 ↓ 18.5 6,913 1

Bitmap Heap Scan on osm_point o (cost=40.93..4,635.08 rows=374 width=39) (actual time=8.497..45.393 rows=6,913 loops=1)

  • Recheck Cond: (c.geom && way)
  • Filter: _st_intersects(c.geom, way)
  • Rows Removed by Filter: 10398
  • Heap Blocks: exact=1871
6. 7.913 7.913 ↓ 15.4 17,311 1

Bitmap Index Scan on osm_point_geom (cost=0.00..40.84 rows=1,123 width=0) (actual time=7.913..7.913 rows=17,311 loops=1)

  • Index Cond: (c.geom && way)
7. 51.036 51.036 ↓ 4.6 6,913 1

CTE Scan on tmp t (cost=0.00..29.84 rows=1,492 width=100) (actual time=8.532..51.036 rows=6,913 loops=1)

8. 62.217 9,138.986 ↓ 0.0 0 6,913

Bitmap Heap Scan on parcelle p (cost=372.90..377.17 rows=1 width=256) (actual time=1.322..1.322 rows=0 loops=6,913)

  • Recheck Cond: (((code_insee)::text = '93048'::text) AND (t.way && geom))
  • Filter: _st_intersects(t.way, geom)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=8165
9. 933.255 9,076.769 ↓ 0.0 0 6,913

BitmapAnd (cost=372.90..372.90 rows=1 width=0) (actual time=1.313..1.313 rows=0 loops=6,913)

10. 7,334.693 7,334.693 ↓ 5.4 13,765 6,913

Bitmap Index Scan on parcelle_code_insee_idx (cost=0.00..51.77 rows=2,561 width=0) (actual time=1.061..1.061 rows=13,765 loops=6,913)

  • Index Cond: ((code_insee)::text = '93048'::text)
11. 808.821 808.821 ↑ 8,910.0 1 6,913

Bitmap Index Scan on parcelle_geom_gist (cost=0.00..320.24 rows=8,910 width=0) (actual time=0.117..0.117 rows=1 loops=6,913)

  • Index Cond: (t.way && geom)
Planning time : 10.485 ms
Execution time : 9,201.638 ms