explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wPyv

Settings
# exclusive inclusive rows x rows loops node
1. 0.133 123,265.337 ↑ 1.0 50 1

Limit (cost=907.24..77,710.54 rows=50 width=68) (actual time=119,249.396..123,265.337 rows=50 loops=1)

2. 2,128.203 123,265.204 ↑ 838.9 50 1

Nested Loop Left Join (cost=907.24..64,431,197.14 rows=41,945 width=68) (actual time=119,249.393..123,265.204 rows=50 loops=1)

  • Join Filter: (l.id = ls.launch_id)
  • Rows Removed by Join Filter: 2,133,025
3. 1.151 1.151 ↑ 838.9 50 1

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

4. 2,082.749 121,135.850 ↓ 1.0 42,662 50

Materialize (cost=906.95..38,039,592.31 rows=41,945 width=40) (actual time=0.170..2,422.717 rows=42,662 loops=50)

5. 106.971 119,053.101 ↓ 1.0 42,686 1

Subquery Scan on ls (cost=906.95..38,039,382.58 rows=41,945 width=40) (actual time=8.431..119,053.101 rows=42,686 loops=1)

6. 296.837 118,946.130 ↓ 1.0 42,686 1

GroupAggregate (cost=906.95..38,038,963.13 rows=41,945 width=40) (actual time=8.428..118,946.130 rows=42,686 loops=1)

  • Group Key: l_1.id
7. 324.778 118,649.293 ↑ 3.1 66,973 1

Nested Loop Left Join (cost=906.95..38,037,390.19 rows=209,725 width=40) (actual time=8.365..118,649.293 rows=66,973 loops=1)

8. 169.667 169.667 ↓ 1.0 42,686 1

Index Only Scan using launch_pkey on launch l_1 (cost=0.29..849.46 rows=41,945 width=8) (actual time=0.056..169.667 rows=42,686 loops=1)

  • Heap Fetches: 35,040
9. 13,958.322 118,154.848 ↑ 5.0 1 42,686

HashAggregate (cost=906.66..906.72 rows=5 width=36) (actual time=2.765..2.768 rows=1 loops=42,686)

  • Group Key: tr.status
10. 104,196.526 104,196.526 ↑ 3.7 210 42,686

Index Scan using "test_result-launch" on test_result tr (cost=0.43..902.72 rows=787 width=2,263) (actual time=0.027..2.441 rows=210 loops=42,686)

  • Index Cond: (launch_id = l_1.id)
  • Filter: (hidden IS FALSE)
  • Rows Removed by Filter: 35
Planning time : 0.555 ms
Execution time : 123,267.206 ms