explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2ZWf

Settings
# exclusive inclusive rows x rows loops node
1. 1.507 43.493 ↓ 34.5 6,010 1

Sort (cost=36.64..37.07 rows=174 width=16) (actual time=43.251..43.493 rows=6,010 loops=1)

  • Sort Key: _st_valuecount.value
  • Sort Method: quicksort Memory: 474kB
2. 1.730 41.986 ↓ 34.5 6,010 1

HashAggregate (cost=28.42..30.16 rows=174 width=16) (actual time=41.325..41.986 rows=6,010 loops=1)

  • Group Key: _st_valuecount.value
3. 0.522 40.256 ↓ 18.0 6,010 1

Nested Loop (cost=0.39..26.76 rows=333 width=12) (actual time=39.254..40.256 rows=6,010 loops=1)

4. 0.003 0.124 ↑ 1.0 1 1

Nested Loop (cost=0.14..10.67 rows=1 width=50) (actual time=0.122..0.124 rows=1 loops=1)

5. 0.004 0.004 ↑ 1.0 1 1

Function Scan on geom (cost=0.00..0.01 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=1)

6. 0.117 0.117 ↑ 1.0 1 1

Index Scan using f100_st_convexhull_idx on f100 r (cost=0.14..10.65 rows=1 width=18) (actual time=0.115..0.117 rows=1 loops=1)

  • Index Cond: ((rast)::geometry && geom.geom)
  • Filter: _st_intersects(geom.geom, rast, NULL::integer)
7. 39.610 39.610 ↓ 18.0 6,010 1

Function Scan on _st_valuecount (cost=0.25..12.75 rows=333 width=12) (actual time=39.130..39.610 rows=6,010 loops=1)

  • Filter: (value > '0'::double precision)
  • Rows Removed by Filter: 2