explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fQX6

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

Seq Scan on poi b (cost=0.00..1,568,762.55 rows=1 width=355) (actual time=191.680..191.681 rows=0 loops=1)

  • Filter: (((parcel_id IS NULL) OR (parcel_id <> 512)) AND (parcel_id = 512) AND st_intersects(geom, '0106000020E61000000100000001030000000100000006000000E8847CAF25FE47403007CF5EDF523D4000FE06B32AFE47409063A769E1523D40F078F9C12CFE4740C0AE00F5D2523D4038A892A827FE474060A906F2D0523D4000C1E60027FE4740E0D5E027D5523D40E8847CAF25FE47403007CF5EDF523D40'::geometry) AND (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 1.375 ms, Inlining 18.194 ms, Optimization 114.149 ms, Emission 53.021 ms, Total 186.738 ms"Execution Time: 193.183 ms