explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7tL2 : extended

Settings
# exclusive inclusive rows x rows loops node
1. 10.647 1,355.642 ↑ 1.0 1 1

Aggregate (cost=24,018.50..24,018.51 rows=1 width=8) (actual time=1,355.641..1,355.642 rows=1 loops=1)

  • Buffers: shared hit=156,658
2. 12.389 1,344.995 ↑ 1.9 45,327 1

Nested Loop (cost=4.34..23,807.00 rows=84,600 width=0) (actual time=0.431..1,344.995 rows=45,327 loops=1)

  • Buffers: shared hit=156,658
3. 0.201 0.284 ↑ 1.0 229 1

Bitmap Heap Scan on congdistrictsdicesimple50_2014 lp (cost=4.06..189.99 rows=229 width=961) (actual time=0.101..0.284 rows=229 loops=1)

  • Recheck Cond: (district = '03'::text)
  • Heap Blocks: exact=37
  • Buffers: shared hit=40
4. 0.083 0.083 ↑ 1.0 229 1

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

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

Index Scan using cari03wetlands_the_geom_geom_idx on cari03wetlands cari (cost=0.29..102.97 rows=16 width=1,108) (actual time=0.412..5.818 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=156,492
Planning time : 4.454 ms
Execution time : 1,355.756 ms