explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2A6o : 234

Settings
# exclusive inclusive rows x rows loops node
1. 45.324 1,822.568 ↑ 1.0 10 1

Limit (cost=652,089.58..652,089.60 rows=10 width=72) (actual time=1,777.240..1,822.568 rows=10 loops=1)

2. 125.953 1,777.244 ↑ 15.1 10 1

Sort (cost=652,089.58..652,089.95 rows=151 width=72) (actual time=1,777.238..1,777.244 rows=10 loops=1)

  • Sort Key: tp.id_track_point
  • Sort Method: top-N heapsort Memory: 26kB
3. 255.698 1,651.291 ↓ 4,245.8 641,115 1

Gather (cost=1,000.00..652,086.31 rows=151 width=72) (actual time=589.463..1,651.291 rows=641,115 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
4. 8.509 1,395.593 ↓ 3,522.6 91,588 7

Append (cost=0.00..651,071.21 rows=26 width=72) (actual time=576.263..1,395.593 rows=91,588 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 (id_track_point > 2038476732) AND (tp_timestamp >= '2019-01-09'::date) AND (tp_timestamp < '2019-01-10 00:00:00'::timestamp without time zone) AND (tp_status = 'A'::bpchar))
6. 1,387.083 1,387.083 ↓ 3,663.5 91,588 7

Parallel Seq Scan on uzgps_track_point_2019m01 tp_1 (cost=0.00..651,071.21 rows=25 width=72) (actual time=576.260..1,387.083 rows=91,588 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-10 00:00:00'::timestamp without time zone) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 2481889