explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 860F

Settings
# exclusive inclusive rows x rows loops node
1. 55.792 8,925.929 ↑ 4.0 26,801 1

GroupAggregate (cost=2,559,832.01..2,561,954.07 rows=106,103 width=20) (actual time=8,846.064..8,925.929 rows=26,801 loops=1)

  • Group Key: tblvacancyrolerequirements.vacancyid
2. 151.216 8,870.137 ↓ 2.2 234,223 1

Sort (cost=2,559,832.01..2,560,097.27 rows=106,103 width=12) (actual time=8,846.051..8,870.137 rows=234,223 loops=1)

  • Sort Key: tblvacancyrolerequirements.vacancyid
  • Sort Method: quicksort Memory: 17,124kB
3. 323.595 8,718.921 ↓ 2.2 234,223 1

Hash Join (cost=27,989.80..2,550,975.01 rows=106,103 width=12) (actual time=67.067..8,718.921 rows=234,223 loops=1)

  • Hash Cond: (tblvacancyrolerequirements.vacancyid = tblvacancy.vacancyid)
4. 2,265.164 8,328.383 ↑ 36.1 1,191,271 1

Result (cost=2.43..1,980,454.74 rows=42,972,900 width=12) (actual time=0.084..8,328.383 rows=1,191,271 loops=1)

5. 4,924.100 6,063.219 ↑ 36.1 1,191,271 1

ProjectSet (cost=2.43..261,538.74 rows=42,972,900 width=68) (actual time=0.075..6,063.219 rows=1,191,271 loops=1)

6. 293.304 1,139.119 ↓ 1.0 430,338 1

Merge Join (cost=2.43..38,079.66 rows=429,729 width=448) (actual time=0.043..1,139.119 rows=430,338 loops=1)

  • Merge Cond: (tblrolerequirements.rolerequirementid = tblvacancyrolerequirements.rolerequirementid)
7. 195.885 195.885 ↑ 1.0 229,383 1

Index Scan using tblrolerequirements_pkey on tblrolerequirements (cost=0.42..23,640.78 rows=229,383 width=448) (actual time=0.028..195.885 rows=229,383 loops=1)

8. 649.930 649.930 ↓ 1.0 430,338 1

Index Scan using fk_tblvacancyrolerequirements_rolerequirementid_autoidx on tblvacancyrolerequirements (cost=0.42..9,994.78 rows=429,729 width=8) (actual time=0.010..649.930 rows=430,338 loops=1)

9. 8.682 66.943 ↓ 1.0 30,371 1

Hash (cost=27,608.09..27,608.09 rows=30,343 width=4) (actual time=66.943..66.943 rows=30,371 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,324kB
10. 58.261 58.261 ↓ 1.0 30,371 1

Index Scan using tblvacancy_vacstage_idx on tblvacancy (cost=0.42..27,608.09 rows=30,343 width=4) (actual time=0.032..58.261 rows=30,371 loops=1)

  • Index Cond: (vacstage = 'Offer'::nn_stage)
Planning time : 1.246 ms
Execution time : 8,930.297 ms