explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LP9M : 12321

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 1,796.953 ↓ 0.0 0 1

Sort (cost=5,269.21..5,269.22 rows=2 width=16) (actual time=1,796.953..1,796.953 rows=0 loops=1)

  • Sort Key: t2.tp_timestamp
  • Sort Method: quicksort Memory: 25kB
2. 8.621 1,796.934 ↓ 0.0 0 1

Subquery Scan on t2 (cost=0.00..5,269.20 rows=2 width=16) (actual time=1,796.934..1,796.934 rows=0 loops=1)

  • Filter: (t2.point_in_staion_before AND (NOT t2.point_in_staion_now))
  • Rows Removed by Filter: 82590
3. 16.687 1,788.313 ↓ 10,323.8 82,590 1

Result (cost=0.00..5,269.12 rows=8 width=26) (actual time=69.144..1,788.313 rows=82,590 loops=1)

4. 9.430 1,771.626 ↓ 10,323.8 82,590 1

Append (cost=0.00..5,269.04 rows=8 width=16) (actual time=69.142..1,771.626 rows=82,590 loops=1)

5. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on uzgps_track_point tp (cost=0.00..0.00 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((tp_timestamp >= '2019-01-01 00:00:00'::timestamp without time zone) AND (tp_timestamp < '2019-01-11 00:00:00'::timestamp without time zone) AND (tp_unit_id = 1182) AND (tp_status = 'A'::bpchar))
6. 1,698.469 1,762.191 ↓ 11,798.6 82,590 1

Bitmap Heap Scan on uzgps_track_point_2019m01 tp_1 (cost=57.12..5,269.04 rows=7 width=16) (actual time=69.136..1,762.191 rows=82,590 loops=1)

  • Recheck Cond: ((tp_unit_id = 1182) AND (tp_timestamp >= '2019-01-01 00:00:00'::timestamp without time zone) AND (tp_timestamp < '2019-01-11 00:00:00'::timestamp without time zone))
  • Rows Removed by Index Recheck: 1999938
  • Filter: (tp_status = 'A'::bpchar)
  • Heap Blocks: exact=15738 lossy=66670
7. 63.722 63.722 ↓ 62.4 82,590 1

Bitmap Index Scan on uzgps_track_point_2019m01_tp_unit_id_tp_timestamp_idx (cost=0.00..57.11 rows=1,324 width=0) (actual time=63.722..63.722 rows=82,590 loops=1)

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