explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T5H0

Settings
# exclusive inclusive rows x rows loops node
1. 207.188 89,617.951 ↓ 4,965.5 9,931 1

Nested Loop Left Join (cost=173,473.04..173,478.06 rows=2 width=167) (actual time=89,419.371..89,617.951 rows=9,931 loops=1)

  • Output: segment_event_operational_snapshot.sid, vehicle.vehicle_sid, vehicle.organization_sid, vehicle.organization_id, vehicle.organization_name, COALESCE((dim_dim_driver.driver_sid)::bigint, 0::bigint), vehicle.vehicle_id, COALESCE(dim_dim_driver.driver_id, ''::character varying), COALESCE(dim_dim_driver.first_name, ''::character varying), COALESCE(dim_dim_driver.last_name, ''::character varying), segment_event_operational_snapshot.gps_date_time, segment_event_operational_snapshot.gps_latitude, segment_event_operational_snapshot.gps_longitude, 1, ''::character varying, segment_event_operational_snapshot.current_motion_state, 1, segment_event_operational_snapshot.gps_heading, CASE WHEN (segment_event_operational_snapshot.total_vehicle_distance > 10000000::double precision) THEN (-1)::double precision ELSE segment_event_operational_snapshot.total_vehicle_distance END, segment_event_operational_snapshot.road_speed, false, COALESCE(segment_event_operational_snapshot.jurisdiction_name, 255), segment_event_operational_snapshot.gps_speed, segment_event_operational_snapshot.modified_date, segment_event_operational_snapshot.current_state_ignition, COALESCE(segment_event_operational_snapshot.total_engine_hours, 0::double precision), COALESCE(segment_event_operational_snapshot.engine_speed, 0::double precision)
  • Buffers: shared hit=53952 read=53187 dirtied=77, local hit=151
2. 89,410.763 89,410.763 ↓ 4,965.5 9,931 1

Limit (cost=173,472.63..173,472.64 rows=2 width=151) (actual time=89,407.789..89,410.763 rows=9,931 loops=1)

  • Output: segment_event_operational_snapshot.sid, vehicle.vehicle_sid, vehicle.vehicle_id, vehicle.organization_sid, vehicle.organization_id,