explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K7gX

Settings
# exclusive inclusive rows x rows loops node
1. 20.099 21.117 ↑ 66.2 24 1

Nested Loop Left Join (cost=10.80..6,249.91 rows=1,590 width=1,495) (actual time=1.190..21.117 rows=24 loops=1)

2.          

CTE parcel

3. 0.002 0.002 ↑ 1.0 1 1

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

4. 0.065 0.826 ↑ 66.2 24 1

Nested Loop (cost=10.50..1,284.93 rows=1,590 width=1,338) (actual time=0.303..0.826 rows=24 loops=1)

5. 0.017 0.617 ↑ 66.2 12 1

Nested Loop (cost=10.22..1,008.06 rows=795 width=1,201) (actual time=0.281..0.617 rows=12 loops=1)

6. 0.005 0.005 ↑ 1.0 1 1

CTE Scan on parcel p (cost=0.00..0.02 rows=1 width=32) (actual time=0.003..0.005 rows=1 loops=1)

7. 0.527 0.595 ↑ 6.6 12 1

Bitmap Heap Scan on features_il s (cost=10.22..1,007.25 rows=79 width=1,169) (actual time=0.274..0.595 rows=12 loops=1)

  • Recheck Cond: (wkb_geometry && p.wkb_geometry)
  • Filter: _st_intersects(wkb_geometry, p.wkb_geometry)
  • Rows Removed by Filter: 6
  • Heap Blocks: exact=15
8. 0.068 0.068 ↑ 13.2 18 1

Bitmap Index Scan on il_wkb_geometry (cost=0.00..10.20 rows=238 width=0) (actual time=0.068..0.068 rows=18 loops=1)

  • Index Cond: (wkb_geometry && p.wkb_geometry)
9. 0.144 0.144 ↑ 1.0 2 12

Index Scan using attributes_il_mukey_btree on attributes_il sa (cost=0.29..0.33 rows=2 width=137) (actual time=0.009..0.012 rows=2 loops=12)

  • Index Cond: (muaggatt_mukey = (s.mukey)::text)
10. 0.192 0.192 ↑ 1.0 1 24

Index Scan using il_fy2017_cpi_mapunit_area_btree on il_fy2013_cpi pi (cost=0.29..0.35 rows=1 width=122) (actual time=0.007..0.008 rows=1 loops=24)

  • Index Cond: ((mapunit_symbol = sa.mapunit_musym) AND (area_symbol = sa.legend_areasymbol))
Planning time : 1.219 ms
Execution time : 21.248 ms