explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V3lu : 123

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

Sort (cost=652,424.80..652,425.17 rows=150 width=72) (actual time=1,390.949..1,390.966 rows=113 loops=1)

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

Gather (cost=1,000.00..652,419.38 rows=150 width=72) (actual time=1,348.922..1,435.494 rows=113 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
3. 0.010 1,379.996 ↑ 1.6 16 7

Append (cost=0.00..651,404.38 rows=26 width=72) (actual time=1,345.413..1,379.996 rows=16 loops=7)

4. 0.000 0.000 ↓ 0.0 0 7

Parallel Seq Scan on uzgps_track_point tp (cost=0.00..0.00 rows=1 width=72) (actual time=0.000..0.000 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,379.986 1,379.986 ↑ 1.6 16 7

Parallel Seq Scan on uzgps_track_point_2019m01 tp_1 (cost=0.00..651,404.38 rows=25 width=72) (actual time=1,345.406..1,379.986 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: 2575448