explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ybrm

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3,235.932 ↓ 0.0 0 1

GroupAggregate (cost=13,957.92..13,957.99 rows=4 width=12) (actual time=3,235.932..3,235.932 rows=0 loops=1)

  • Group Key: runfileres0_.status
2. 0.000 3,235.931 ↓ 0.0 0 1

Sort (cost=13,957.92..13,957.93 rows=4 width=12) (actual time=3,235.930..3,235.931 rows=0 loops=1)

  • Sort Key: runfileres0_.status
  • Sort Method: quicksort Memory: 25kB
3. 220.098 3,237.237 ↓ 0.0 0 1

Gather (cost=2,216.88..13,957.88 rows=4 width=12) (actual time=3,235.918..3,237.237 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 2,127.119 3,017.139 ↓ 0.0 0 3

Nested Loop (cost=1,216.88..12,957.48 rows=2 width=12) (actual time=3,017.139..3,017.139 rows=0 loops=3)

5. 873.077 889.031 ↓ 1.8 2,149 3

Nested Loop (cost=1,216.44..7,893.31 rows=1,171 width=20) (actual time=16.251..889.031 rows=2,149 loops=3)

  • -> Index Scan using idx_run_file_result_file_id on run_file_result runfileres0_ (cost=0.43..299.64 rows=160 width=28) (actual time=0.312..21.259 rows=52
6. 1.604 15.954 ↓ 4.6 41 3

Hash Join (cost=1,216.01..5,182.13 rows=9 width=8) (actual time=14.546..15.954 rows=41 loops=3)

  • Hash Cond: (file2_.master_file_id = masterfile3_.id)
  • Index Cond: (file_id = file2_.id)
7. 4.394 4.394 ↑ 1.3 8,653 3

Parallel Seq Scan on file file2_ (cost=0.00..3,937.68 rows=10,830 width=16) (actual time=0.005..4.394 rows=8,653 loops=3)

  • Filter: (test_type_id = 2)
  • Rows Removed by Filter: 8862
8. 0.021 9.956 ↓ 3.3 49 3

Hash (cost=1,215.83..1,215.83 rows=15 width=8) (actual time=9.956..9.956 rows=49 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 9.935 9.935 ↓ 3.3 49 3

Seq Scan on master_file masterfile3_ (cost=0.00..1,215.83 rows=15 width=8) (actual time=0.161..9.935 rows=49 loops=3)

  • Filter: (owner_component_id = 216)
  • Rows Removed by Filter: 17599
10. 0.989 0.989 ↓ 0.0 0 6,446

Index Scan using run_pkey on run run1_ (cost=0.43..4.32 rows=1 width=8) (actual time=0.989..0.989 rows=0 loops=6,446)

  • Index Cond: (id = runfileres0_.run_id)
  • Filter: ((NOT run_by_investigation) AND (build_id = 3863))
  • Rows Removed by Filter: 1