explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v6LD

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

Nested Loop (cost=0.00..10,845,679.69 rows=11,754 width=158) (actual rows= loops=)

  • Join Filter: (((st_makepoint((smart_stop_copy.longitude)::double precision, (smart_stop_copy.latitude)::double precision, 4326::double precision))::geography && (st_transform(b.the_geom, 4326))::geography) AND (_st_distance((st_makepoint((smart_stop_copy.longitude)::double precision, (smart_stop_copy.latitude)::double precision, 4326::double precision))::geography, (st_transform(b.the_geom, 4326))::geography, 0::double precision, false) < 1e-05::double precision))
2. 0.000 0.000 ↓ 0.0

Seq Scan on village b (cost=0.00..2,436.92 rows=8,592 width=3,994) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..144.56 rows=4,104 width=129) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on smart_stop_copy (cost=0.00..124.04 rows=4,104 width=129) (actual rows= loops=)