explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qSq3

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.295 ↑ 9.0 1 1

Nested Loop Left Join (cost=907.23..8,205.30 rows=9 width=68) (actual time=0.288..0.295 rows=1 loops=1)

2. 0.011 0.055 ↑ 9.0 1 1

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

3. 0.025 0.025 ↑ 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.022..0.025 rows=1 loops=1)

  • Index Cond: (defect_id = 1)
  • Heap Fetches: 1
4. 0.019 0.019 ↑ 1.0 1 1

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

  • Index Cond: (id = launch_defect.launch_id)
5. 0.010 0.232 ↑ 1.0 1 1

Aggregate (cost=906.78..906.79 rows=1 width=32) (actual time=0.231..0.232 rows=1 loops=1)

6. 0.082 0.222 ↑ 2.5 2 1

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

  • Group Key: tr.status
7. 0.140 0.140 ↑ 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.028..0.140 rows=41 loops=1)

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