explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4hVj

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 7.069 ↑ 1.0 1 1

GroupAggregate (cost=906.95..908.16 rows=1 width=40) (actual time=7.067..7.069 rows=1 loops=1)

  • Group Key: l.id
2. 0.019 7.045 ↑ 1.0 5 1

Nested Loop Left Join (cost=906.95..908.13 rows=5 width=40) (actual time=7.013..7.045 rows=5 loops=1)

3. 0.036 0.036 ↑ 1.0 1 1

Index Only Scan using launch_pkey on launch l (cost=0.29..1.31 rows=1 width=8) (actual time=0.031..0.036 rows=1 loops=1)

  • Index Cond: (id = 50,847)
  • Heap Fetches: 1
4. 3.352 6.990 ↑ 1.0 5 1

HashAggregate (cost=906.66..906.72 rows=5 width=36) (actual time=6.973..6.990 rows=5 loops=1)

  • Group Key: tr.status
5. 3.638 3.638 ↑ 2.6 300 1

Index Scan using "test_result-launch" on test_result tr (cost=0.43..902.72 rows=787 width=2,263) (actual time=0.118..3.638 rows=300 loops=1)

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