explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IEu5

Settings
# exclusive inclusive rows x rows loops node
1. 0.100 117.715 ↑ 1.0 50 1

Limit (cost=906.95..46,250.61 rows=50 width=68) (actual time=3.727..117.715 rows=50 loops=1)

2. 0.513 117.615 ↑ 838.9 50 1

GroupAggregate (cost=906.95..38,039,707.13 rows=41,945 width=68) (actual time=3.723..117.615 rows=50 loops=1)

  • Group Key: l.id
3. 0.655 117.102 ↑ 2,996.1 70 1

Nested Loop (cost=906.95..38,038,134.19 rows=209,725 width=68) (actual time=0.397..117.102 rows=70 loops=1)

4. 0.191 0.191 ↑ 749.0 56 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..0.191 rows=56 loops=1)

5. 34.216 116.256 ↑ 5.0 1 56

HashAggregate (cost=906.66..906.72 rows=5 width=36) (actual time=2.074..2.076 rows=1 loops=56)

  • Group Key: tr.status
6. 82.040 82.040 ↑ 2.0 385 56

Index Scan using "test_result-launch" on test_result tr (cost=0.43..902.72 rows=787 width=4) (actual time=0.017..1.465 rows=385 loops=56)

  • Index Cond: (launch_id = l.id)
  • Filter: (hidden IS FALSE)
  • Rows Removed by Filter: 0
Planning time : 0.381 ms
Execution time : 117.865 ms