explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iGaS : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.136 ↓ 8.0 24 1

Sort (cost=1,766.22..1,766.23 rows=3 width=1,160) (actual time=0.131..0.136 rows=24 loops=1)

  • Sort Key: uzgps_track_point.tp_timestamp DESC
  • Sort Method: quicksort Memory: 31kB
2. 0.005 0.114 ↓ 8.0 24 1

Append (cost=0.00..1,766.19 rows=3 width=1,160) (actual time=0.045..0.114 rows=24 loops=1)

3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on uzgps_track_point (cost=0.00..0.00 rows=1 width=1,160) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((tp_timestamp >= '2019-01-01 00:00:00'::timestamp without time zone) AND (tp_timestamp <= '2019-01-01 02:00:00'::timestamp without time zone) AND (tp_unit_id = 1060) AND (tp_status = 'A'::bpchar))
4. 0.077 0.106 ↓ 12.0 24 1

Bitmap Heap Scan on uzgps_track_point_2019m01 (cost=22.10..1,766.19 rows=2 width=1,160) (actual time=0.042..0.106 rows=24 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND (tp_timestamp >= '2019-01-01 00:00:00'::timestamp without time zone) AND (tp_timestamp <= '2019-01-01 02:00:00'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
  • Heap Blocks: exact=23
5. 0.029 0.029 ↑ 18.5 24 1

Bitmap Index Scan on uzgps_track_point_2019m01_tp_unit_id_tp_timestamp_idx (cost=0.00..22.10 rows=443 width=0) (actual time=0.029..0.029 rows=24 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND (tp_timestamp >= '2019-01-01 00:00:00'::timestamp without time zone) AND (tp_timestamp <= '2019-01-01 02:00:00'::timestamp without time zone))