explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L3rO

Settings
# exclusive inclusive rows x rows loops node
1. 57.055 124.850 ↑ 1.0 1 1

Aggregate (cost=1,824.73..1,824.74 rows=1 width=32) (actual time=124.850..124.850 rows=1 loops=1)

2.          

CTE bounds

3. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=64) (actual time=0.002..0.002 rows=1 loops=1)

4. 3.292 67.795 ↓ 19.9 7,664 1

Nested Loop (cost=31.85..1,813.14 rows=386 width=1,133) (actual time=12.265..67.795 rows=7,664 loops=1)

5. 0.010 0.010 ↑ 1.0 1 1

CTE Scan on bounds (cost=0.00..0.02 rows=1 width=64) (actual time=0.008..0.010 rows=1 loops=1)

6. 53.339 64.493 ↓ 196.5 7,664 1

Bitmap Heap Scan on planet_osm_line (cost=31.85..1,812.73 rows=39 width=1,101) (actual time=12.249..64.493 rows=7,664 loops=1)

  • Recheck Cond: (way && bounds.original)
  • Filter: (((waterway = 'river'::text) OR (waterway = 'canal'::text) OR (waterway = 'stream'::text) OR (waterway = 'brook'::text) OR (waterway = 'drain'::text) OR (waterway = 'ditch'::text)) AND (st_asmvtgeom(way, (bounds.mercator)::box2d, 4096, 64, true) IS NOT NULL))
  • Rows Removed by Filter: 37723
  • Heap Blocks: exact=2312
7. 11.154 11.154 ↓ 99.3 45,387 1

Bitmap Index Scan on planet_osm_line_index (cost=0.00..31.84 rows=457 width=0) (actual time=11.154..11.154 rows=45,387 loops=1)

  • Index Cond: (way && bounds.original)
Planning time : 1.272 ms
Execution time : 126.274 ms