explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tlhd : Optimization for: Optimization for: Optimization for: plan #RCrK; plan #Wrgv; plan #yVEU

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.036 2,374.879 ↑ 1.0 501 1

Limit (cost=45,962.05..46,020.51 rows=501 width=983) (actual time=2,280.973..2,374.879 rows=501 loops=1)

2. 137.947 2,374.843 ↑ 431.9 501 1

Gather Merge (cost=45,962.05..71,206.52 rows=216,366 width=983) (actual time=2,280.972..2,374.843 rows=501 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 745.891 2,236.896 ↑ 487.3 222 3 / 3

Sort (cost=44,962.03..45,232.49 rows=108,183 width=983) (actual time=2,236.878..2,236.896 rows=222 loops=3)

  • Sort Key: process_complete DESC, processed_at
  • Sort Method: top-N heapsort Memory: 167kB
  • Worker 0: Sort Method: top-N heapsort Memory: 171kB
  • Worker 1: Sort Method: top-N heapsort Memory: 167kB
4. 1,491.005 1,491.005 ↑ 1.3 86,546 3 / 3

Parallel Seq Scan on devices t (cost=0.00..39,569.83 rows=108,183 width=983) (actual time=0.009..1,491.005 rows=86,546 loops=3)