explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zl54

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2,181.544 2,631.118 ↑ 70.2 3,525 1

Nested Loop Left Join (cost=0.00..311,303.74 rows=247,374 width=190) (actual time=3.465..2,631.118 rows=3,525 loops=1)

  • Join Filter: st_contains(zones.geom, st_setsrid(st_makepoint(trips."LONGITUDE", trips."LATITUDE"), 4326))
  • Rows Removed by Join Filter: 853225
2. 386.124 386.124 ↓ 1.2 3,525 1

Seq Scan on sc_with_stops_trips trips (cost=0.00..96,028.32 rows=3,054 width=206) (actual time=0.044..386.124 rows=3,525 loops=1)

  • Filter: ("BUS_NO" = 207)
  • Rows Removed by Filter: 2472576
3. 63.250 63.450 ↑ 1.0 243 3,525

Materialize (cost=0.00..60.65 rows=243 width=1,583) (actual time=0.000..0.018 rows=243 loops=3,525)

4. 0.200 0.200 ↑ 1.0 243 1

Seq Scan on zone zones (cost=0.00..59.43 rows=243 width=1,583) (actual time=0.010..0.200 rows=243 loops=1)