explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iedG

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.054 ↑ 1.0 1 1

Limit (cost=0.70..620.53 rows=1 width=40) (actual time=0.053..0.054 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=6
2. 0.000 0.052 ↑ 6.0 1 1

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

  • Sort Key: uzgps_track_point.tp_timestamp DESC
  • Buffers: shared hit=6
3. 0.011 0.011 ↓ 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.009..0.011 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 = 732) AND (uzgps_track_point.tp_timestamp >= '2019-01-06 00:00:00'::timestamp without time zone) AND (uzgps_track_point.tp_timestamp <= '2019-01-07 00:00:00'::timestamp without time zone))
  • Filter: (uzgps_track_point.tp_status = 'A'::bpchar)
  • Buffers: shared hit=1
4. 0.041 0.041 ↑ 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,711.44 rows=5 width=40) (actual time=0.041..0.041 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 = 732) AND (uzgps_track_point_2019m01.tp_timestamp >= '2019-01-06 00:00:00'::timestamp without time zone) AND (uzgps_track_point_2019m01.tp_timestamp <= '2019-01-07 00:00:00'::timestamp witho (...)
  • Filter: (uzgps_track_point_2019m01.tp_status = 'A'::bpchar)
  • Buffers: shared hit=5