explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N2Gf : Optimization for: plan #iedG

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.005 0.155 ↑ 1.0 1 1

Limit (cost=0.70..650.05 rows=1 width=40) (actual time=0.153..0.155 rows=1 loops=1)

  • Output: uzgps_track_point.id_track_point, uzgps_track_point.tp_latitude, uzgps_track_point.tp_longitude, uzgps_track_point.tp_angle, uzgps_track_point.tp_speed, uzgps_track_point.tp_timestamp, uzgps_track_point.tp_io_movement, uzgps_track_point.tp_io_eng (...)
  • Buffers: shared hit=9
2. 0.002 0.150 ↑ 6.0 1 1

Merge Append (cost=0.70..3,896.78 rows=6 width=40) (actual time=0.150..0.150 rows=1 loops=1)

  • Sort Key: uzgps_track_point.tp_timestamp DESC
  • Buffers: shared hit=9
3. 0.021 0.021 ↓ 0.0 0 1

Index Scan Backward using uzgps_track_point_tp_unit_id_tp_timestamp_idx on public.uzgps_track_point (cost=0.12..8.15 rows=1 width=40) (actual time=0.021..0.021 rows=0 loops=1)

  • Output: uzgps_track_point.id_track_point, uzgps_track_point.tp_latitude, uzgps_track_point.tp_longitude, uzgps_track_point.tp_angle, uzgps_track_point.tp_speed, uzgps_track_point.tp_timestamp, uzgps_track_point.tp_io_movement, uzgps_track_poi (...)
  • Index Cond: ((uzgps_track_point.tp_unit_id = 708) AND (uzgps_track_point.tp_timestamp >= '2019-01-06 15:09:55.119367'::timestamp without time zone) AND (uzgps_track_point.tp_timestamp <= '2019-01-06 15:49:55.119367'::timestamp without time zo (...)
  • Filter: (uzgps_track_point.tp_status = 'A'::bpchar)
  • Buffers: shared hit=4
4. 0.127 0.127 ↑ 5.0 1 1

Index Scan Backward using uzgps_track_point_2019m01_tp_unit_id_tp_timestamp_idx on public.uzgps_track_point_2019m01 (cost=0.56..3,888.54 rows=5 width=40) (actual time=0.127..0.127 rows=1 loops=1)

  • Output: uzgps_track_point_2019m01.id_track_point, uzgps_track_point_2019m01.tp_latitude, uzgps_track_point_2019m01.tp_longitude, uzgps_track_point_2019m01.tp_angle, uzgps_track_point_2019m01.tp_speed, uzgps_track_point_2019m01.tp_timestamp, u (...)
  • Index Cond: ((uzgps_track_point_2019m01.tp_unit_id = 708) AND (uzgps_track_point_2019m01.tp_timestamp >= '2019-01-06 15:09:55.119367'::timestamp without time zone) AND (uzgps_track_point_2019m01.tp_timestamp <= '2019-01-06 15:49:55.119367'::t (...)
  • Filter: (uzgps_track_point_2019m01.tp_status = 'A'::bpchar)
  • Buffers: shared hit=5