explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P5N : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,429.106 ↑ 1.3 113 1

Sort (cost=652,265.88..652,266.26 rows=151 width=72) (actual time=1,429.090..1,429.106 rows=113 loops=1)

  • Sort Key: tp.id_track_point
  • Sort Method: quicksort Memory: 40kB
2. 48.296 1,463.896 ↑ 1.3 113 1

Gather (cost=1,000.00..652,260.42 rows=151 width=72) (actual time=1,410.693..1,463.896 rows=113 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
3. 0.034 1,415.600 ↑ 1.6 16 7

Append (cost=0.00..651,245.32 rows=26 width=72) (actual time=1,381.235..1,415.600 rows=16 loops=7)

4. 0.001 0.001 ↓ 0.0 0 7

Parallel Seq Scan on uzgps_track_point tp (cost=0.00..0.00 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=7)

  • Filter: ((tp_unit_id IS NOT NULL) AND (id_track_point > 2038476732) AND (tp_timestamp >= '2019-01-09'::date) AND (tp_timestamp < '2019-01-09 01:00:00'::timestamp without time zone) AND (tp_status = 'A'::bpchar))
5. 1,415.565 1,415.565 ↑ 1.6 16 7

Parallel Seq Scan on uzgps_track_point_2019m01 tp_1 (cost=0.00..651,245.32 rows=25 width=72) (actual time=1,381.230..1,415.565 rows=16 loops=7)

  • Filter: ((tp_unit_id IS NOT NULL) AND (id_track_point > 2038476732) AND (tp_timestamp >= '2019-01-09'::date) AND (tp_timestamp < '2019-01-09 01:00:00'::timestamp without time zone) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 2574130