explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yIz : external

Settings
# exclusive inclusive rows x rows loops node
1. 10.517 1,107.217 ↑ 1.0 1 1

Aggregate (cost=24,115.67..24,115.68 rows=1 width=8) (actual time=1,107.217..1,107.217 rows=1 loops=1)

  • Buffers: shared hit=163033
2. 12.122 1,096.700 ↑ 1.9 45,327 1

Nested Loop (cost=4.34..23,904.42 rows=84,501 width=0) (actual time=1.137..1,096.700 rows=45,327 loops=1)

  • Buffers: shared hit=163033
3. 0.183 0.263 ↑ 1.0 229 1

Bitmap Heap Scan on congdistrictsdicesimple50_2014 lp (cost=4.06..193.41 rows=229 width=961) (actual time=0.100..0.263 rows=229 loops=1)

  • Recheck Cond: (district = '03'::text)
  • Heap Blocks: exact=35
  • Buffers: shared hit=38
4. 0.080 0.080 ↑ 1.0 229 1

Bitmap Index Scan on ind_district_2014 (cost=0.00..4.00 rows=229 width=0) (actual time=0.080..0.080 rows=229 loops=1)

  • Index Cond: (district = '03'::text)
  • Buffers: shared hit=3
5. 1,084.315 1,084.315 ↓ 12.4 198 229

Index Scan using cari03wetlands_the_geom_geom_idx on cari03wetlands cari (cost=0.29..103.38 rows=16 width=1,057) (actual time=0.607..4.735 rows=198 loops=229)

  • Index Cond: (the_geom && lp.the_geom)
  • Filter: _st_intersects(the_geom, lp.the_geom)
  • Rows Removed by Filter: 12
  • Buffers: shared hit=162868
Planning time : 4.584 ms
Execution time : 1,107.335 ms