explain.depesz.com

PostgreSQL's explain analyze made readable

Result: icdF

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 2,734.119 ↑ 5.0 1 1

Finalize GroupAggregate (cost=41,426.26..41,426.33 rows=5 width=12) (actual time=2,734.119..2,734.119 rows=1 loops=1)

  • Group Key: runfileres0_.status
2. 0.000 2,734.115 ↑ 1.5 2 1

Sort (cost=41,426.26..41,426.27 rows=3 width=12) (actual time=2,734.115..2,734.115 rows=2 loops=1)

  • Sort Key: runfileres0_.status
  • Sort Method: quicksort Memory: 25kB
3. 9.688 2,735.254 ↑ 1.5 2 1

Gather (cost=41,425.88..41,426.23 rows=3 width=12) (actual time=2,720.381..2,735.254 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 0.006 2,725.566 ↑ 3.0 1 2

Partial GroupAggregate (cost=40,425.88..40,425.93 rows=3 width=12) (actual time=2,725.566..2,725.566 rows=1 loops=2)

  • Group Key: runfileres0_.status
5. 0.051 2,725.560 ↓ 6.7 20 2

Sort (cost=40,425.88..40,425.89 rows=3 width=12) (actual time=2,725.559..2,725.560 rows=20 loops=2)

  • Sort Key: runfileres0_.status
  • Sort Method: quicksort Memory: 26kB
6. 9.155 2,725.509 ↓ 6.7 20 2

Hash Join (cost=6,546.18..40,425.86 rows=3 width=12) (actual time=1,536.712..2,725.509 rows=20 loops=2)

  • Hash Cond: (runfileres0_.run_id = run1_.id)
7. 2,684.282 2,692.195 ↓ 3.8 30,330 2

Nested Loop (cost=1,231.65..35,090.35 rows=7,994 width=20) (actual time=6.301..2,692.195 rows=30,330 loops=2)

  • -> Index Scan using idx_run_file_result_file_id on run_file_result runfileres0_ (cost=0.56..2361.96 rows=732 width=28) (actual time=0.027..4
8. 1.051 7.913 ↓ 4.8 62 2

Hash Join (cost=1,231.09..4,289.70 rows=13 width=8) (actual time=6.269..7.913 rows=62 loops=2)

  • Hash Cond: (file2_.master_file_id = masterfile3_.id)
  • Index Cond: (file_id = file2_.id)
9. 4.025 4.025 ↑ 1.2 12,987 2

Parallel Seq Scan on file file2_ (cost=0.00..3,018.54 rows=15,260 width=16) (actual time=0.003..4.025 rows=12,987 loops=2)

  • Filter: (test_type_id = 2)
  • Rows Removed by Filter: 13298
10. 0.011 2.837 ↓ 3.3 49 2

Hash (cost=1,230.90..1,230.90 rows=15 width=8) (actual time=2.837..2.837 rows=49 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
11. 2.826 2.826 ↓ 3.3 49 2

Seq Scan on master_file masterfile3_ (cost=0.00..1,230.90 rows=15 width=8) (actual time=0.060..2.826 rows=49 loops=2)

  • Filter: (owner_component_id = 216)
  • Rows Removed by Filter: 17623
12. 2.575 24.159 ↓ 1.2 15,833 2

Hash (cost=5,148.34..5,148.34 rows=13,295 width=8) (actual time=24.159..24.159 rows=15,833 loops=2)

  • Buckets: 16384 Batches: 1 Memory Usage: 747kB
13. 21.584 21.584 ↓ 1.2 15,833 2

Index Scan using idx_run_build_id on run run1_ (cost=0.56..5,148.34 rows=13,295 width=8) (actual time=0.189..21.584 rows=15,833 loops=2)

  • Index Cond: (build_id = 3863)
  • Filter: (NOT run_by_investigation)
  • Rows Removed by Filter: 552