explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ygOv

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.417 ↑ 5.0 1 1

Nested Loop Left Join (cost=907.23..4,558.70 rows=5 width=68) (actual time=0.383..0.417 rows=1 loops=1)

2. 0.008 0.069 ↑ 5.0 1 1

Limit (cost=0.44..24.58 rows=5 width=36) (actual time=0.042..0.069 rows=1 loops=1)

3. 0.010 0.061 ↑ 9.0 1 1

Nested Loop (cost=0.44..43.89 rows=9 width=36) (actual time=0.039..0.061 rows=1 loops=1)

4. 0.036 0.036 ↑ 9.0 1 1

Index Only Scan Backward using launch_defect_pkey on launch_defect (cost=0.15..23.12 rows=9 width=8) (actual time=0.018..0.036 rows=1 loops=1)

  • Index Cond: (defect_id = 1)
  • Heap Fetches: 1
5. 0.015 0.015 ↑ 1.0 1 1

Index Scan using launch_pkey on launch (cost=0.29..2.31 rows=1 width=36) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (id = launch_defect.launch_id)
6. 0.023 0.336 ↑ 1.0 1 1

Aggregate (cost=906.78..906.79 rows=1 width=32) (actual time=0.332..0.336 rows=1 loops=1)

7. 0.132 0.313 ↑ 2.5 2 1

HashAggregate (cost=906.66..906.72 rows=5 width=36) (actual time=0.300..0.313 rows=2 loops=1)

  • Group Key: tr.status
8. 0.181 0.181 ↑ 19.2 41 1

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

  • Index Cond: (launch_id = launch.id)
  • Filter: (hidden IS FALSE)
Planning time : 0.817 ms
Execution time : 0.540 ms