explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nl4F

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 41,238.974 ↑ 1.0 1 1

Finalize Aggregate (cost=159,823.71..159,823.72 rows=1 width=8) (actual time=41,238.974..41,238.974 rows=1 loops=1)

2. 5.487 41,238.969 ↓ 1.5 3 1

Gather (cost=159,823.50..159,823.71 rows=2 width=8) (actual time=41,237.864..41,238.969 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2.211 41,233.482 ↑ 1.0 1 3

Partial Aggregate (cost=158,823.50..158,823.51 rows=1 width=8) (actual time=41,233.482..41,233.482 rows=1 loops=3)

4. 2,152.818 41,231.271 ↑ 1.2 6,303 3

Parallel Bitmap Heap Scan on world_osmamenitydata (cost=2,641.10..158,805.33 rows=7,265 width=0) (actual time=39,076.230..41,231.271 rows=6,303 loops=3)

  • Recheck Cond: ('0103000020E610000001000000050000009082A7902BF5314000E65AB400B14D402194F7713433324000E65AB400B14D402194F77134333240F67AF7C77BA54D409082A7902BF53140F67AF7C77BA54D409082A7902BF5314000E65AB400B14D40'::geometry ~ geom)
  • Filter: _st_contains('0103000020E610000001000000050000009082A7902BF5314000E65AB400B14D402194F7713433324000E65AB400B14D402194F77134333240F67AF7C77BA54D409082A7902BF53140F67AF7C77BA54D409082A7902BF5314000E65AB400B14D40'::geometry, geom)
  • Heap Blocks: exact=2204
5. 39,078.453 39,078.453 ↑ 2.8 18,910 1

Bitmap Index Scan on world_osmamenitydata_geom_id (cost=0.00..2,636.74 rows=52,309 width=0) (actual time=39,078.453..39,078.453 rows=18,910 loops=1)

  • Index Cond: ('0103000020E610000001000000050000009082A7902BF5314000E65AB400B14D402194F7713433324000E65AB400B14D402194F77134333240F67AF7C77BA54D409082A7902BF53140F67AF7C77BA54D409082A7902BF5314000E65AB400B14D40'::geometry ~ geom)