explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d6Dd

Settings
# exclusive inclusive rows x rows loops node
1. 8.894 28,101.042 ↑ 66.7 3 1

HashAggregate (cost=3,360,125.20..3,360,127.70 rows=200 width=44) (actual time=28,101.041..28,101.042 rows=3 loops=1)

  • Group Key: f.artype
2.          

CTE dyrkbarar5

3. 30.786 28,092.084 ↑ 66,337.6 16 1

Nested Loop (cost=0.42..3,036,397.59 rows=1,061,402 width=36) (actual time=4,233.505..28,092.084 rows=16 loops=1)

4. 27,138.490 28,045.337 ↑ 59.1 11 1

Nested Loop (cost=0.00..622,658.82 rows=650 width=546) (actual time=4,231.114..28,045.337 rows=11 loops=1)

  • Join Filter: (((st_transform(a_1.geo, 4258))::geometry(Geometry,4258) && u.geo) AND _st_intersects((st_transform(a_1.geo, 4258))::geometry(Geometry,4258), u.geo))
  • Rows Removed by Join Filter: 1949072
5. 0.030 0.030 ↑ 1.0 1 1

Seq Scan on user_request u (cost=0.00..2.08 rows=1 width=269) (actual time=0.010..0.030 rows=1 loops=1)

  • Filter: ((jobid)::text = 'jaspertest'::text)
  • Rows Removed by Filter: 34
6. 906.817 906.817 ↑ 1.0 1,949,083 1

Seq Scan on dyrkbarjord_flate a_1 (cost=0.00..91,078.46 rows=1,950,746 width=277) (actual time=0.048..906.817 rows=1,949,083 loops=1)

7. 15.961 15.961 ↑ 163.0 1 11

Index Scan using geoidx_org_ar5__ar5_flate on ar5_flate a (cost=0.42..3,695.49 rows=163 width=2,262) (actual time=0.941..1.451 rows=1 loops=11)

  • Index Cond: (geo && st_intersection((st_transform(a_1.geo, 4258))::geometry(Geometry,4258), u.geo))
  • Filter: ((artype = ANY ('{22,23,30,50,60}'::integer[])) AND _st_intersects(geo, st_intersection((st_transform(a_1.geo, 4258))::geometry(Geometry,4258), u.geo)))
  • Rows Removed by Filter: 5
8. 28,092.148 28,092.148 ↑ 66,337.6 16 1

CTE Scan on dyrkbarar5 f (cost=0.00..21,228.04 rows=1,061,402 width=36) (actual time=4,233.510..28,092.148 rows=16 loops=1)

Planning time : 1.273 ms
Execution time : 28,101.274 ms