explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NMRj

Settings
# exclusive inclusive rows x rows loops node
1. 9,128.260 10,649.385 ↑ 1.9 45,327 1

Nested Loop (cost=4.34..26,228.19 rows=84,501 width=34) (actual time=1.804..10,649.385 rows=45,327 loops=1)

  • Buffers: shared hit=278044
2. 0.287 0.336 ↑ 1.0 229 1

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

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

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

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

Index Scan using cari03wetlands_the_geom_geom_idx on cari03wetlands cari (cost=0.29..103.38 rows=16 width=1,083) (actual time=0.634..6.641 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.399 ms
Execution time : 10,662.274 ms