explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N14oH

Settings
# exclusive inclusive rows x rows loops node
1. 185.517 185.517 ↓ 0.0 0 1

Seq Scan on poi b (cost=0.00..1,568,684.95 rows=2 width=355) (actual time=185.517..185.517 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
  • Functions: 2
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 2.228 ms, Inlining 16.574 ms, Optimization 101.817 ms, Emission 60.215 ms, Total 180.835 ms"Execution Time: 187.999 ms