explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jqm1

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1,963.121 ↑ 1.0 1 1

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

2. 19.617 1,963.115 ↓ 1.5 3 1

Gather (cost=159,823.50..159,823.71 rows=2 width=8) (actual time=1,962.888..1,963.115 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.460 1,943.498 ↑ 1.0 1 3

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

4. 0.000 1,943.038 ↑ 3.9 1,852 3

Parallel Bitmap Heap Scan on world_osmamenitydata (cost=2,641.10..158,805.33 rows=7,265 width=0) (actual time=1,938.038..1,943.038 rows=1,852 loops=3)

  • Recheck Cond: ('0103000020E610000001000000050000001C42959A3DCC51C0D1217024D0324540925A28999CBD51C0D1217024D0324540925A28999CBD51C0F4FBFECD8B2545401C42959A3DCC51C0F4FBFECD8B2545401C42959A3DCC51C0D1217024D0324540'::geometry ~ geom)
  • Filter: _st_contains('0103000020E610000001000000050000001C42959A3DCC51C0D1217024D0324540925A28999CBD51C0D1217024D0324540925A28999CBD51C0F4FBFECD8B2545401C42959A3DCC51C0F4FBFECD8B2545401C42959A3DCC51C0D1217024D0324540'::geometry, geom)
  • Heap Blocks: exact=600
5. 1,956.120 1,956.120 ↑ 9.4 5,555 1

Bitmap Index Scan on world_osmamenitydata_geom_id (cost=0.00..2,636.74 rows=52,309 width=0) (actual time=1,956.120..1,956.120 rows=5,555 loops=1)

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