explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yyIr

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

Update on poi b (cost=0.00..1,582,395.65 rows=258,268 width=367) (actual time=785.406..785.406 rows=0 loops=1)

  • Functions: 7
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 4.878 ms, Inlining 22.475 ms, Optimization 383.263 ms, Emission 190.484 ms, Total 601.099 ms"Execution Time: 790.602 ms
2. 39.054 785.404 ↓ 0.0 0 1

Nested Loop (cost=0.00..1,582,395.65 rows=258,268 width=367) (actual time=785.404..785.404 rows=0 loops=1)

3. 746.350 746.350 ↑ 1.0 129,134 1

Seq Scan on parcels p (cost=0.00..10,482.34 rows=129,134 width=6) (actual time=596.716..746.350 rows=129,134 loops=1)

4. 0.000 0.000 ↓ 0.0 0 129,134

Materialize (cost=0.00..1,568,684.96 rows=2 width=357) (actual time=0.000..0.000 rows=0 loops=129,134)

5. 5.260 5.260 ↓ 0.0 0 1

Seq Scan on poi b (cost=0.00..1,568,684.95 rows=2 width=357) (actual time=5.260..5.260 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