explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YQbk

Settings
# exclusive inclusive rows x rows loops node
1. 18.505 375.992 ↓ 5.0 5 1

Gather (cost=1,001.23..114,529.34 rows=1 width=16) (actual time=2.850..375.992 rows=5 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 128.018 357.487 ↓ 2.0 2 3

Hash Join (cost=1.23..113,529.24 rows=1 width=16) (actual time=235.342..357.487 rows=2 loops=3)

  • Hash Cond: ((house_listings.state)::text = (inspections.state)::text)
  • Join Filter: ((house_listings.location && _st_expand(inspections.location, '100'::double precision)) AND (inspections.location && _st_expand(house_listings.location, '100'::double precision)) AND _st_dwithin(house_listings.location, inspections.location, '100'::double precision, true))
  • Rows Removed by Join Filter: 29929
3. 229.392 229.392 ↑ 1.2 122,451 3

Parallel Seq Scan on house_listings (cost=0.00..92,692.62 rows=153,062 width=51) (actual time=0.087..229.392 rows=122,451 loops=3)

4. 0.016 0.077 ↑ 2.0 5 3

Hash (cost=1.10..1.10 rows=10 width=35) (actual time=0.077..0.077 rows=5 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.061 0.061 ↑ 1.0 10 3

Seq Scan on inspections (cost=0.00..1.10 rows=10 width=35) (actual time=0.057..0.061 rows=10 loops=3)