explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4UdV

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

Gather (cost=1,153.73..34,664.60 rows=53,452 width=2,308) (actual rows= loops=)

  • Workers Planned: 1
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=153.73..27,769.15 rows=31,442 width=2,308) (actual rows= loops=)

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

Hash Join (cost=145.17..26,890.60 rows=31,442 width=1,112) (actual rows= loops=)

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

Parallel Seq Scan on location_city (cost=0.00..26,662.83 rows=31,442 width=560) (actual rows= loops=)

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

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

6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

Hash (cost=5.47..5.47 rows=247 width=1,196) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on location_country (cost=0.00..5.47 rows=247 width=1,196) (actual rows= loops=)