explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uEBF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,572.488 ↑ 1.0 1 1

Aggregate (cost=2,701,022.06..2,701,022.07 rows=1 width=32) (actual time=3,572.487..3,572.488 rows=1 loops=1)

  • Functions: 14
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 12.955 ms, Inlining 179.476 ms, Optimization 1188.417 ms, Emission 613.475 ms, Total 1994.324 ms"Execution Time: 3,587.008 ms
2. 54.282 3,581.787 ↑ 1.6 8 1

Gather (cost=1,000.00..2,701,022.02 rows=13 width=138) (actual time=718.582..3,581.787 rows=8 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 3,527.505 3,527.505 ↑ 1.7 3 3 / 3

Parallel Seq Scan on parcels p (cost=0.00..2,700,020.73 rows=5 width=138) (actual time=1,615.189..3,527.505 rows=3 loops=3)

  • Filter: st_intersects('0103000020E6100000010000000C00000000FE06B32AFE47409063A769E1523D40F078F9C12CFE4740C0AE00F5D2523D4038A892A827FE474060A906F2D0523D4000C1E60027FE4740E0D5E027D5523D40C8B28FD11EFE4740803145A7D1523D40D0B328721CFE47400054E513E3523D40C8F207A024FE474070AC288BE6523D4068A28D9823FE4740D0EF73D7ED523D4038FFCDFD28FE474030B24E16F0523D40886F72762DFE4740901BFAD8F1523D40707692842FFE4740B08A879CE3523D4000FE06B32AFE47409063A769E1523D40'::geometry, st_buffer(geom, '1e-08'::double precision, ''::text))
  • Rows Removed by Filter: 43,042