explain.depesz.com

PostgreSQL's explain analyze made readable

Result: itvh

Settings
# exclusive inclusive rows x rows loops node
1. 0.067 85,058.501 ↑ 1.0 50 1

Limit (cost=1,777,013.38..1,777,017.38 rows=50 width=68) (actual time=85,058.010..85,058.501 rows=50 loops=1)

2. 0.151 85,058.434 ↑ 838.9 50 1

GroupAggregate (cost=1,777,013.38..1,780,366.53 rows=41,945 width=68) (actual time=85,058.006..85,058.434 rows=50 loops=1)

  • Group Key: l.id
3. 0.158 85,058.283 ↑ 831.5 68 1

Merge Left Join (cost=1,777,013.38..1,779,559.52 rows=56,540 width=68) (actual time=85,057.969..85,058.283 rows=68 loops=1)

  • Merge Cond: (l.id = data.id)
4. 0.120 0.120 ↑ 822.5 51 1

Index Scan Backward using launch_pkey on launch l (cost=0.29..1,593.46 rows=41,945 width=36) (actual time=0.011..0.120 rows=51 loops=1)

5. 84.913 85,058.005 ↑ 883.4 64 1

Sort (cost=1,777,013.09..1,777,154.44 rows=56,540 width=40) (actual time=85,057.945..85,058.005 rows=64 loops=1)

  • Sort Key: data.id DESC
  • Sort Method: quicksort Memory: 5,981kB
6. 118.120 84,973.092 ↓ 1.0 56,894 1

Subquery Scan on data (cost=1,771,277.96..1,772,550.11 rows=56,540 width=40) (actual time=84,638.238..84,973.092 rows=56,894 loops=1)

7. 15,033.993 84,854.972 ↓ 1.0 56,894 1

HashAggregate (cost=1,771,277.96..1,771,984.71 rows=56,540 width=44) (actual time=84,638.235..84,854.972 rows=56,894 loops=1)

  • Group Key: tr.launch_id, tr.status
8. 69,820.979 69,820.979 ↓ 1.0 8,953,104 1

Seq Scan on test_result tr (cost=0.00..1,704,548.99 rows=8,897,196 width=12) (actual time=0.053..69,820.979 rows=8,953,104 loops=1)

  • Filter: (hidden IS FALSE)
  • Rows Removed by Filter: 1,500,904
Planning time : 0.431 ms
Execution time : 85,063.055 ms