explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rL3J : Optimization for: plan #V8nI

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 484.807 1,273.858 ↓ 1.1 94,364 1

HashAggregate (cost=27,192.29..28,072.76 rows=88,047 width=28) (actual time=1,189.747..1,273.858 rows=94,364 loops=1)

  • Group Key: tblvacancyrolemembers.interviewroundid
2. 331.691 789.051 ↑ 1.1 197,554 1

Hash Join (cost=8,232.32..20,808.74 rows=212,785 width=9) (actual time=220.449..789.051 rows=197,554 loops=1)

  • Hash Cond: (tblvacancyrolemembers.adminuserid = users.adminuserid)
3. 237.242 237.242 ↑ 1.1 197,554 1

Index Scan using tblvacancyrolemembers_roleid_idx on tblvacancyrolemembers (cost=0.42..12,018.26 rows=212,785 width=9) (actual time=0.047..237.242 rows=197,554 loops=1)

  • Index Cond: (roleid = 'INTERVIEWER'::nn_vacancyrole)
4. 95.953 220.118 ↑ 1.0 97,194 1

Hash (cost=7,015.84..7,015.84 rows=97,284 width=8) (actual time=220.117..220.118 rows=97,194 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4454kB
5. 124.165 124.165 ↑ 1.0 97,194 1

Seq Scan on users (cost=0.00..7,015.84 rows=97,284 width=8) (actual time=0.018..124.165 rows=97,194 loops=1)

Planning time : 0.735 ms
Execution time : 1,327.974 ms