explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lfPS : test2

Settings
# exclusive inclusive rows x rows loops node
1. 1.968 726.486 ↑ 1,657.3 240 1

Nested Loop (cost=0.42..8,992.75 rows=397,749 width=111) (actual time=0.346..726.486 rows=240 loops=1)

2. 0.522 0.522 ↑ 1.0 238 1

Seq Scan on veh_vehicles v (cost=0.00..9.89 rows=245 width=10) (actual time=0.010..0.522 rows=238 loops=1)

  • Filter: is_active
  • Rows Removed by Filter: 56
3. 723.996 723.996 ↑ 1.0 1 238

Index Scan using veh_vehcurrstat_1_idx on veh_vehicle_current_status vcs (cost=0.42..8.24 rows=1 width=84) (actual time=0.235..3.042 rows=1 loops=238)

  • Index Cond: (vehicle_id = v.id)