explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V8nI

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 515.373 1,734.120 ↓ 1.1 94,364 1

HashAggregate (cost=26,128.36..27,008.83 rows=88,047 width=28) (actual time=1,639.913..1,734.120 rows=94,364 loops=1)

  • Group Key: tblvacancyrolemembers.interviewroundid
2. 362.351 1,218.747 ↑ 1.1 197,554 1

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

  • Hash Cond: (tblvacancyrolemembers.adminuserid = users.adminuserid)
3. 620.253 620.253 ↑ 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.945..620.253 rows=197,554 loops=1)

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

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

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

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

Planning time : 4.811 ms
Execution time : 1,799.312 ms