explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T4Or

Settings
# exclusive inclusive rows x rows loops node
1. 0.419 139,138.350 ↑ 1.0 50 1

Limit (cost=907.24..77,710.54 rows=50 width=68) (actual time=135,086.891..139,138.350 rows=50 loops=1)

2. 2,135.375 139,137.931 ↑ 838.9 50 1

Nested Loop (cost=907.24..64,431,197.14 rows=41,945 width=68) (actual time=135,086.888..139,137.931 rows=50 loops=1)

  • Join Filter: (l.id = ls.launch_id)
  • Rows Removed by Join Filter: 2,133,025
3. 0.956 0.956 ↑ 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.019..0.956 rows=50 loops=1)

4. 2,131.705 137,001.600 ↓ 1.0 42,662 50

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

5. 109.439 134,869.895 ↓ 1.0 42,686 1

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

6. 337.113 134,760.456 ↓ 1.0 42,686 1

GroupAggregate (cost=906.95..38,038,963.13 rows=41,945 width=40) (actual time=0.289..134,760.456 rows=42,686 loops=1)

  • Group Key: l_1.id
7. 389.412 134,423.343 ↑ 3.1 66,973 1

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

8. 213.321 213.321 ↓ 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.043..213.321 rows=42,686 loops=1)

  • Heap Fetches: 35,040
9. 15,580.390 133,820.610 ↑ 5.0 1 42,686

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

  • Group Key: tr.status
10. 118,240.220 118,240.220 ↑ 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.032..2.770 rows=210 loops=42,686)

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