explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1wKu : Optimization for: plan #Ztf5

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 104.691 106,447.232 ↑ 2.1 28 1

Finalize GroupAggregate (cost=8,035.19..8,065.77 rows=59 width=32) (actual time=106,344.511..106,447.232 rows=28 loops=1)

  • Group Key: admingeom.admingeom_id
  • Buffers: shared hit=13147574
2. 0.000 106,342.541 ↑ 4.2 28 1

Gather Merge (cost=8,035.19..8,048.95 rows=118 width=2,608) (actual time=106,342.411..106,342.541 rows=28 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=13269651
3. 0.306 106,948.008 ↑ 6.6 9 3

Sort (cost=7,035.16..7,035.31 rows=59 width=2,608) (actual time=35,649.332..35,649.336 rows=9 loops=3)

  • Sort Key: admingeom.admingeom_id
  • Sort Method: quicksort Memory: 50kB
  • Worker 0: Sort Method: quicksort Memory: 29kB
  • Worker 1: Sort Method: quicksort Memory: 37kB
  • Buffers: shared hit=13269651
4. 16.467 106,947.702 ↑ 6.6 9 3

Partial HashAggregate (cost=7,032.84..7,033.43 rows=59 width=2,608) (actual time=35,649.230..35,649.234 rows=9 loops=3)

  • Group Key: admingeom.admingeom_id
  • Buffers: shared hit=13269637
5. 9.234 106,931.235 ↓ 9.1 13,925 3

Nested Loop (cost=3.61..7,025.17 rows=1,534 width=2,600) (actual time=16.229..35,643.745 rows=13,925 loops=3)

  • Buffers: shared hit=13269637
6. 42.285 42.285 ↑ 1.4 18 3

Parallel Seq Scan on admingeom (cost=0.00..3,836.29 rows=25 width=2,600) (actual time=3.172..14.095 rows=18 loops=3)

  • Filter: ((label <> 'Monde'::text) AND (adminclass_id = 1))
  • Rows Removed by Filter: 13811
  • Buffers: shared hit=3577
7. 8.694 106,879.716 ↓ 129.0 774 54

Append (cost=3.61..127.50 rows=6 width=32) (actual time=1,844.276..1,979.254 rows=774 loops=54)

  • Buffers: shared hit=13266060
8. 106,767.990 106,871.022 ↓ 129.0 774 54

Bitmap Heap Scan on localization_2019 (cost=3.61..127.47 rows=6 width=32) (actual time=1,844.264..1,979.093 rows=774 loops=54)

  • Recheck Cond: (admingeom.contour && coord)
  • Filter: ((date >= '2019-01-01 00:00:00+00'::timestamp with time zone) AND (date <= '2019-01-31 23:59:59+00'::timestamp with time zone) AND _st_intersects(admingeom.contour, coord))
  • Rows Removed by Filter: 13697
  • Heap Blocks: exact=32208
  • Buffers: shared hit=13266060
9. 103.032 103.032 ↓ 328.9 14,471 54

Bitmap Index Scan on localization_2019_coord_idx (cost=0.00..3.61 rows=44 width=0) (actual time=1.908..1.908 rows=14,471 loops=54)

  • Index Cond: (admingeom.contour && coord)
  • Buffers: shared hit=5697