explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cIsk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=155.15..8,644.01 rows=53,392 width=116) (actual rows= loops=)

  • Hash Cond: (location_city.country_id = location_country.id)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=145.17..8,358.49 rows=53,392 width=82) (actual rows= loops=)

  • Hash Cond: (location_city.state_id = location_state.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on location_city (cost=0.00..8,073.04 rows=53,392 width=55) (actual rows= loops=)

  • Filter: (st_distance(geography(point), '0101000020E61000000000000000805DC00000000000004340'::geography, false) <= '160934.4'::double precision)
4. 0.000 0.000 ↓ 0.0

Hash (cost=84.52..84.52 rows=4,852 width=27) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on location_state (cost=0.00..84.52 rows=4,852 width=27) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=6.10..6.10 rows=310 width=34) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on location_country (cost=0.00..6.10 rows=310 width=34) (actual rows= loops=)