explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NcUN

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,250.715 ↓ 0.0 0 1

Update on poi b (cost=0.28..1,570,111.31 rows=1 width=367) (actual time=1,250.715..1,250.715 rows=0 loops=1)

  • Functions: 12
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 6.284 ms, Inlining 106.353 ms, Optimization 757.781 ms, Emission 378.894 ms, Total 1249.312 ms"Execution Time: 1,280.068 ms
2. 0.002 1,250.714 ↓ 0.0 0 1

Nested Loop (cost=0.28..1,570,111.31 rows=1 width=367) (actual time=1,250.714..1,250.714 rows=0 loops=1)

3. 1,250.712 1,250.712 ↓ 0.0 0 1

Seq Scan on poi b (cost=0.00..1,568,684.95 rows=2 width=357) (actual time=1,250.712..1,250.712 rows=0 loops=1)

  • Filter: ((parcel_id = 512) AND ((NOT st_intersects(geom, '0106000020E61000000100000001030000000100000006000000E8847CAF25FE47403007CF5EDF523D4000FE06B32AFE47409063A769E1523D40F078F9C12CFE4740C0AE00F5D2523D4038A892A827FE474060A906F2D0523D4000C1E60027FE4740E0D5E027D5523D40E8847CAF25FE47403007CF5EDF523D40'::geometry)) OR (round((st_area(st_intersection(geom, '0106000020E61000000100000001030000000100000006000000E8847CAF25FE47403007CF5EDF523D4000FE06B32AFE47409063A769E1523D40F078F9C12CFE4740C0AE00F5D2523D4038A892A827FE474060A906F2D0523D4000C1E60027FE4740E0D5E027D5523D40E8847CAF25FE47403007CF5EDF523D40'::geometry)))::numeric, 8) <> round((st_area(geom))::numeric, 8))))
  • Rows Removed by Filter: 31,038
4. 0.000 0.000 ↓ 0.0 0

Index Scan using parcels_geom_idx on parcels p (cost=0.28..713.17 rows=1 width=148) (never executed)

  • Index Cond: (geom && b.geom)
  • Filter: (st_intersects(b.geom, geom) AND (round((st_area(st_intersection(b.geom, geom)))::numeric, 8) = round((st_area(b.geom))::numeric, 8)))