explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CE0V : 13

Settings
# exclusive inclusive rows x rows loops node
1. 50.378 1,914.862 ↑ 1.0 10 1

Limit (cost=667,040.75..667,040.77 rows=10 width=72) (actual time=1,864.479..1,914.862 rows=10 loops=1)

2. 109.968 1,864.484 ↑ 1.7 10 1

Sort (cost=667,040.75..667,040.79 rows=17 width=72) (actual time=1,864.477..1,864.484 rows=10 loops=1)

  • Sort Key: tp.id_track_point
  • Sort Method: top-N heapsort Memory: 26kB
3. 231.118 1,754.516 ↓ 37,553.0 638,401 1

Gather (cost=1,000.00..667,040.40 rows=17 width=72) (actual time=611.624..1,754.516 rows=638,401 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
4. 8.077 1,523.398 ↓ 22,800.0 91,200 7

Append (cost=0.00..666,038.70 rows=4 width=72) (actual time=598.997..1,523.398 rows=91,200 loops=7)

5. 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 (tp_longitude IS NOT NULL) AND (tp_latitude IS NOT NULL) AND (id_track_point > 2038476732) AND (tp_timestamp >= '2019-01-09'::date) AND (tp_timestamp < '2019-01-10 00:00:00'::timestamp without (...)
6. 1,515.320 1,515.320 ↓ 30,400.0 91,200 7

Parallel Seq Scan on uzgps_track_point_2019m01 tp_1 (cost=0.00..666,038.70 rows=3 width=72) (actual time=598.993..1,515.320 rows=91,200 loops=7)

  • Filter: ((tp_unit_id IS NOT NULL) AND (tp_longitude IS NOT NULL) AND (tp_latitude IS NOT NULL) AND (id_track_point > 2038476732) AND (tp_timestamp >= '2019-01-09'::date) AND (tp_timestamp < '2019-01-10 00:00:00'::timestamp without (...)
  • Rows Removed by Filter: 2481939