explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XBS1

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 79.489 ↑ 5.0 1 1

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

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

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

  • Sort Key: runfileres0_.status
  • Sort Method: quicksort Memory: 25kB
3. 3.643 80.590 ↑ 1.5 2 1

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

  • Workers Planned: 1
  • Workers Launched: 1
4. 0.007 76.947 ↑ 3.0 1 2

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

  • Group Key: runfileres0_.status
5. 0.027 76.940 ↓ 6.7 20 2

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

  • Sort Key: runfileres0_.status
  • Sort Method: quicksort Memory: 25kB
6. 5.299 76.913 ↓ 6.7 20 2

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

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

Nested Loop (cost=1,231.65..35,090.35 rows=7,994 width=20) (actual time=9.342..52.890 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.008..0
8. 1.427 10.873 ↓ 4.8 62 2

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

  • Hash Cond: (file2_.master_file_id = masterfile3_.id)
  • Index Cond: (file_id = file2_.id)
9. 5.651 5.651 ↑ 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.004..5.651 rows=12,987 loops=2)

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

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

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

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

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

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

  • Buckets: 16384 Batches: 1 Memory Usage: 747kB
13. 15.953 15.953 ↓ 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.055..15.953 rows=15,833 loops=2)

  • Index Cond: (build_id = 3863)
  • Filter: (NOT run_by_investigation)
  • Rows Removed by Filter: 552
Planning time : 0.549 ms
Execution time : 80.728 ms