explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lKuu

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 16,323.211 ↑ 1.0 10 1

Limit (cost=898,524.70..898,525.89 rows=10 width=388) (actual time=16,234.440..16,323.211 rows=10 loops=1)

2. 90.839 16,323.206 ↑ 404,454.0 10 1

Gather Merge (cost=898,524.70..1,382,796.24 rows=4,044,540 width=388) (actual time=16,234.439..16,323.206 rows=10 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 335.748 16,232.367 ↑ 126,391.9 8 5 / 5

Sort (cost=897,524.64..900,052.48 rows=1,011,135 width=388) (actual time=16,232.366..16,232.367 rows=8 loops=5)

  • Sort Key: ((timestamp_ms)::bigint)
  • Sort Method: top-N heapsort Memory: 33kB
  • Worker 0: Sort Method: top-N heapsort Memory: 36kB
  • Worker 1: Sort Method: top-N heapsort Memory: 35kB
  • Worker 2: Sort Method: top-N heapsort Memory: 34kB
  • Worker 3: Sort Method: top-N heapsort Memory: 36kB
4. 15,896.619 15,896.619 ↑ 1.3 808,506 5 / 5

Parallel Seq Scan on tweets_mix_normalized (cost=0.00..875,674.38 rows=1,011,135 width=388) (actual time=0.034..15,896.619 rows=808,506 loops=5)

Planning time : 2.810 ms
Execution time : 16,323.240 ms