explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hUg6

Settings
# exclusive inclusive rows x rows loops node
1. 7,227.581 7,227.581 ↓ 7.0 7 1

Index Scan using alberta_fireline_maps_ix01 on fireline.alberta_fireline_maps (cost=0.42..8.69 rows=1 width=368) (actual time=7,227.409..7,227.581 rows=7 loops=1)

  • Output: '01030000201F6900000100000005000000CF4386E2882129416056F91427F45441245CF0E715212941678C3AE918F5544174792A445F262941208CF2F922F5544187BB8B7CD22629413968D12531F45441CF4386E2882129416056F91427F45441'::geometry, alberta_fireline_maps.geom, alberta_fireline_maps.fuel
  • Index Cond: (alberta_fireline_maps.geom && '01030000201F6900000100000005000000CF4386E2882129416056F91427F45441245CF0E715212941678C3AE918F5544174792A445F262941208CF2F922F5544187BB8B7CD22629413968D12531F45441CF4386E2882129416056F91427F45441'::geometry)
  • Filter: _st_intersects(alberta_fireline_maps.geom, '01030000201F6900000100000005000000CF4386E2882129416056F91427F45441245CF0E715212941678C3AE918F5544174792A445F262941208CF2F922F5544187BB8B7CD22629413968D12531F45441CF4386E2882129416056F91427F45441'::geometry)
Planning time : 0.664 ms
Execution time : 7,227.899 ms