explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lsBe

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 34,949.056 ↑ 1.0 1 1

Finalize Aggregate (cost=159,823.71..159,823.72 rows=1 width=8) (actual time=34,949.055..34,949.056 rows=1 loops=1)

2. 6.769 34,949.048 ↓ 1.5 3 1

Gather (cost=159,823.50..159,823.71 rows=2 width=8) (actual time=34,947.984..34,949.048 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1.676 34,942.279 ↑ 1.0 1 3

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

4. 62.718 34,940.603 ↑ 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=34,873.357..34,940.603 rows=6,303 loops=3)

  • Recheck Cond: ('0103000020E610000001000000050000009082A7902BF5314000E65AB400B14D402194F7713433324000E65AB400B14D402194F77134333240F67AF7C77BA54D409082A7902BF53140F67AF7C77BA54D409082A7902BF5314000E65AB400B14D40'::geometry ~ geom)
  • Filter: _st_contains('0103000020E610000001000000050000009082A7902BF5314000E65AB400B14D402194F7713433324000E65AB400B14D402194F77134333240F67AF7C77BA54D409082A7902BF53140F67AF7C77BA54D409082A7902BF5314000E65AB400B14D40'::geometry, geom)
  • Heap Blocks: exact=2524
5. 34,877.885 34,877.885 ↑ 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=34,877.885..34,877.885 rows=18,910 loops=1)

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