explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MXVB

Settings
# exclusive inclusive rows x rows loops node
1. 0.107 80.496 ↑ 1.0 50 1

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

2. 0.243 80.389 ↑ 838.9 50 1

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

  • Group Key: l.id
3. 0.266 80.146 ↑ 2,996.1 70 1

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

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

5. 24.192 79.688 ↑ 5.0 1 56

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

  • Group Key: tr.status
6. 55.496 55.496 ↑ 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.011..0.991 rows=385 loops=56)

  • Index Cond: (launch_id = l.id)
  • Filter: (hidden IS FALSE)
  • Rows Removed by Filter: 0