explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LyHo

Settings
# exclusive inclusive rows x rows loops node
1. 58.344 1,509.453 ↓ 0.0 0 1

Gather (cost=61,882.68..446,706.04 rows=1 width=707) (actual time=1,499.480..1,509.453 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 5.937 1,451.109 ↓ 0.0 0 3 / 3

Parallel Hash Left Join (cost=60,882.68..445,705.94 rows=1 width=707) (actual time=1,451.109..1,451.109 rows=0 loops=3)

  • Hash Cond: (((p."Name")::text = (s."Name")::text) AND (p."CountyID" = s."CountyID") AND ((p."StreetType")::text = (s."StreetType")::text) AND ((p."DirectionPrefix")::text = (s."DirectionPrefix")::text) AND ((p."DirectionSuffix")::text = (s."DirectionSuffix")::text))
  • Join Filter: ((s."FromAddress" <= p."FromAddress") AND (p."FromAddress" <= s."ToAddress") AND (st_distance((p."Geometry")::geography, (s."Geometry")::geography, true) < '50'::double precision))
  • Rows Removed by Join Filter: 284
  • Filter: (s."ID" IS NULL)
  • Rows Removed by Filter: 3
3. 1,204.803 1,204.803 ↓ 2.0 2 3 / 3

Parallel Seq Scan on "Parcels" p (cost=0.00..384,590.67 rows=1 width=699) (actual time=697.118..1,204.803 rows=2 loops=3)

  • Filter: ((("Name")::text = 'PINE'::text) AND ("FromAddress" = 290))
  • Rows Removed by Filter: 1,290,665
4. 0.451 240.369 ↑ 1.5 779 3 / 3

Parallel Hash (cost=60,856.09..60,856.09 rows=1,182 width=152) (actual time=240.369..240.369 rows=779 loops=3)

  • Buckets: 4,096 Batches: 1 Memory Usage: 480kB
5. 239.918 239.918 ↑ 1.5 779 3 / 3

Parallel Seq Scan on "Streets" s (cost=0.00..60,856.09 rows=1,182 width=152) (actual time=94.318..239.918 rows=779 loops=3)

  • Filter: (("Name")::text = 'PINE'::text)
  • Rows Removed by Filter: 555,221
Planning time : 0.783 ms
Execution time : 1,509.530 ms