explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Azpa : Optimization for: plan #MTo3

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.59..31,009,137.58 rows=20,383,251 width=151) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.31..233,703.21 rows=298,553 width=605) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.03..4,868.40 rows=2,952 width=368) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on potential_fire a (cost=0.00..12.64 rows=264 width=241) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using idx_us_fl_fishnet_label_13 on fishnet_label_13 p (cost=1.03..18.38 rows=1 width=127) (actual rows= loops=)

  • Index Cond: (wkb && (a.rast)::geometry)
  • Filter: _st_intersects(wkb, a.rast, NULL::integer)
6. 0.000 0.000 ↓ 0.0

Index Scan using landcover_st_convexhull_idx on landcover c (cost=0.28..77.42 rows=10 width=237) (actual rows= loops=)

  • Index Cond: (p.wkb && (rast)::geometry)
  • Filter: _st_intersects(p.wkb, rast, NULL::integer)
7. 0.000 0.000 ↓ 0.0

Index Scan using flatlow_st_convexhull_idx on flatlow b (cost=0.28..51.81 rows=7 width=282) (actual rows= loops=)

  • Index Cond: (p.wkb && (rast)::geometry)
  • Filter: _st_intersects(p.wkb, rast, NULL::integer)