explain.depesz.com

PostgreSQL's explain analyze made readable

Result: txym

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=743,064,857.03..761,953,105.22 rows=5,495,970 width=24) (actual rows= loops=)

  • Group Key: a.hex_id
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=743,064,857.03..761,843,185.82 rows=10,991,940 width=24) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=743,063,857.00..760,573,443.18 rows=5,495,970 width=24) (actual rows= loops=)

  • Group Key: a.hex_id
4. 0.000 0.000 ↓ 0.0

Sort (cost=743,063,857.00..748,882,065.83 rows=2,327,283,530 width=24) (actual rows= loops=)

  • Sort Key: a.hex_id
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.41..190,075,109.30 rows=2,327,283,530 width=24) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on poi_dwh_tmp b (cost=0.00..38,111.58 rows=1,270,358 width=40) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using cz_grid_res10_geom_idx on cz_grid_res10 a (cost=0.41..147.76 rows=183 width=48) (actual rows= loops=)

  • Index Cond: (geom && b.geom)
  • Filter: _st_intersects(geom, b.geom)