explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sxXT : Q1

Settings

Optimization(s) for this plan:

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

Unique (cost=197,528.23..198,365.36 rows=111,617 width=12) (actual rows= loops=)

2.          

Initplan (for Unique)

3. 0.000 0.000 ↓ 0.0

Index Scan using pk_l_areas on l_areas (cost=0.42..8.47 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id_area = 1234)
4. 0.000 0.000 ↓ 0.0

Sort (cost=197,519.76..197,798.81 rows=111,617 width=12) (actual rows= loops=)

  • Sort Key: taxref.cd_ref, (count(DISTINCT synthese.id_synthese))
5. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=183,814.48..186,250.68 rows=111,617 width=12) (actual rows= loops=)

  • Group Key: taxref.cd_ref
6. 0.000 0.000 ↓ 0.0

Sort (cost=183,814.48..184,254.49 rows=176,005 width=8) (actual rows= loops=)

  • Sort Key: taxref.cd_ref
7. 0.000 0.000 ↓ 0.0

Gather (cost=30,844.15..166,071.81 rows=176,005 width=8) (actual rows= loops=)

  • Workers Planned: 2
  • Params Evaluated: $0
8. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=29,844.15..147,471.31 rows=73,335 width=8) (actual rows= loops=)

  • Hash Cond: (synthese.cd_nom = taxref.cd_nom)
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on synthese (cost=0.00..115,963.66 rows=73,335 width=8) (actual rows= loops=)

  • Filter: st_intersects(the_geom_local, st_buffer(st_geomfromewkb($0), '2000'::double precision))
10. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=26,078.18..26,078.18 rows=229,518 width=8) (actual rows= loops=)

  • -> Parallel Seq Scan on taxref (cost=0.00..26078.18 rows=229518 width=8