explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DxH1 : Optimization for: Optimization for: Optimization for: plan #347v; plan #eq6U; plan #V0V4

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2.412 163.607 ↑ 12.7 218 1

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

  • Buffers: shared hit=341
2. 0.153 161.195 ↑ 19.2 332 1

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

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

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

  • Buffers: shared hit=341
4. 1.821 160.933 ↑ 19.2 332 1

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

  • Buffers: shared hit=339
5. 1.540 1.540 ↑ 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.54 rows=19,095 loops=1)

  • Buffers: shared hit=142
6. 0.187 157.572 ↑ 12.6 219 1

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

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

Seq Scan on cities cities (cost=0..2,389.79 rows=2,762 width=140) (actual time=0.854..157.385 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.033 ↑ 1.0 75 1

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

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

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

  • Buffers: shared hit=2