explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 347v

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2.612 158.303 ↑ 12.7 218 1

Aggregate (cost=3,230.89..10,234.07 rows=2,762 width=204) (actual time=155.775..158.303 rows=218 loops=1)

  • Buffers: shared hit=341
2. 0.256 155.691 ↑ 19.2 332 1

Sort (cost=3,230.89..3,246.8 rows=6,365 width=156) (actual time=155.634..155.691 rows=332 loops=1)

  • Sort Key: cities.id
  • Sort Method: quicksort Memory: 113kB
  • Buffers: shared hit=341
3. 0.096 155.435 ↑ 19.2 332 1

Hash Join (cost=2,428..2,828.75 rows=6,365 width=156) (actual time=151.05..155.435 rows=332 loops=1)

  • Buffers: shared hit=341
4. 2.391 155.302 ↑ 19.2 332 1

Hash Join (cost=2,424.32..2,807.41 rows=6,365 width=153) (actual time=151.004..155.302 rows=332 loops=1)

  • Buffers: shared hit=339
5. 1.933 1.933 ↑ 1.0 19,095 1

Seq Scan on city_provider_source city_provider_source (cost=0..332.95 rows=19,095 width=17) (actual time=0.005..1.933 rows=19,095 loops=1)

  • Buffers: shared hit=142
6. 0.182 150.978 ↑ 12.6 219 1

Hash (cost=2,389.79..2,389.79 rows=2,762 width=140) (actual time=150.978..150.978 rows=219 loops=1)

  • Buffers: shared hit=197
7. 150.796 150.796 ↑ 12.6 219 1

Seq Scan on cities cities (cost=0..2,389.79 rows=2,762 width=140) (actual time=0.919..150.796 rows=219 loops=1)

  • Filter: (_st_distance((cities.bbox)::geography, '0101000020E610000000000000800F3640F4E942B024854740'::geography, '0'::double precision, true) < '1000000'::double precision)
  • Buffers: shared hit=197
8. 0.015 0.037 ↑ 1.0 75 1

Hash (cost=2.75..2.75 rows=75 width=11) (actual time=0.037..0.037 rows=75 loops=1)

  • Buffers: shared hit=2
9. 0.022 0.022 ↑ 1.0 75 1

Seq Scan on providers providers (cost=0..2.75 rows=75 width=11) (actual time=0.01..0.022 rows=75 loops=1)

  • Buffers: shared hit=2