explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mD2c

Settings
# exclusive inclusive rows x rows loops node
1. 15,563.713 34,019.935 ↓ 0.0 0 1

Update on parsel (cost=4.32..721.67 rows=1 width=7,136) (actual time=34,019.935..34,019.935 rows=0 loops=1)

2. 55.686 18,456.222 ↓ 54,002.0 54,002 1

Nested Loop (cost=4.32..721.67 rows=1 width=7,136) (actual time=2.216..18,456.222 rows=54,002 loops=1)

3. 0.120 0.120 ↑ 1.0 24 1

Seq Scan on geomahalle (cost=0.00..15.24 rows=24 width=42) (actual time=0.018..0.120 rows=24 loops=1)

4. 18,388.176 18,400.416 ↓ 2,250.0 2,250 24

Bitmap Heap Scan on parsel (cost=4.32..29.42 rows=1 width=7,126) (actual time=103.969..766.684 rows=2,250 loops=24)

  • Recheck Cond: (geomahalle.poly && poly)
  • Filter: ((geomahalle.poly ~ st_pointonsurface(poly)) AND _st_contains(geomahalle.poly, st_pointonsurface(poly)))
  • Rows Removed by Filter: 1468
  • Heap Blocks: exact=10294
5. 12.240 12.240 ↓ 726.5 4,359 24

Bitmap Index Scan on gix_parsel (cost=0.00..4.32 rows=6 width=0) (actual time=0.510..0.510 rows=4,359 loops=24)

  • Index Cond: (geomahalle.poly && poly)
Planning time : 2.933 ms