explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gHOQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 26.438 ↑ 13.8 4 1

Nested Loop (cost=71,873.46..87,804.82 rows=55 width=28) (actual time=26.386..26.438 rows=4 loops=1)

2. 0.000 26.369 ↓ 7.0 7 1

HashAggregate (cost=71,872.89..71,872.90 rows=1 width=8) (actual time=26.368..26.369 rows=7 loops=1)

  • Group Key: u0.id
3. 2.466 27.277 ↓ 7.0 7 1

Gather (cost=1,001.13..71,872.89 rows=1 width=8) (actual time=0.368..27.277 rows=7 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 17.712 24.811 ↓ 4.0 4 2

Nested Loop (cost=1.13..70,872.79 rows=1 width=8) (actual time=0.897..24.811 rows=4 loops=2)

5. 7.097 7.097 ↓ 1.0 7,910 2

Parallel Index Scan using idx_run_build_id on run u1 (cost=0.56..5,006.01 rows=7,696 width=16) (actual time=0.014..7.097 rows=7,910 loops=2)

  • Index Cond: (build_id = 3575)
  • Filter: (status = 5)
  • Rows Removed by Filter: 4
6. 0.002 0.002 ↓ 0.0 0 15,820

Index Scan using idx_run_file_result_run_id on run_file_result u0 (cost=0.56..8.55 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=15,820)

  • Index Cond: (run_id = u1.id)
  • Filter: (((u1.triggered_run_id = 29658808) OR (id = 29395660)) AND (status = ANY ('{0,1,2,10,25,26,11}'::integer[])))
  • Rows Removed by Filter: 1
7. 0.063 0.063 ↑ 55.0 1 7

Index Scan using idx_test_case_result_file_result_file_test_case on run_test_case_result (cost=0.57..15,931.37 rows=55 width=28) (actual time=0.009..0.009 rows=1 loops=7)

  • Index Cond: (run_file_result_id = u0.id)
  • Filter: (status = 10)
  • Rows Removed by Filter: 21
Planning time : 0.402 ms
Execution time : 27.394 ms