explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PbgD

Settings
# exclusive inclusive rows x rows loops node
1. 279.947 5,939.541 ↑ 10.1 15 1

GroupAggregate (cost=205,102.21..205,389.73 rows=152 width=33) (actual time=5,813.270..5,939.541 rows=15 loops=1)

  • Group Key: hiring_plan_interview_stages.name
2. 527.684 5,659.594 ↓ 2.9 41,398 1

Sort (cost=205,102.21..205,137.91 rows=14,281 width=33) (actual time=5,420.353..5,659.594 rows=41,398 loops=1)

  • Sort Key: hiring_plan_interview_stages.name
  • Sort Method: quicksort Memory: 4770kB
3. 804.678 5,131.910 ↓ 2.9 41,398 1

Nested Loop (cost=9.46..204,116.69 rows=14,281 width=33) (actual time=1.561..5,131.910 rows=41,398 loops=1)

4. 983.118 3,913.252 ↓ 2.8 41,398 1

Nested Loop (cost=9.03..196,542.82 rows=15,019 width=24) (actual time=1.519..3,913.252 rows=41,398 loops=1)

5. 689.464 1,938.094 ↓ 2.4 33,068 1

Nested Loop (cost=8.47..89,249.19 rows=13,650 width=8) (actual time=1.468..1,938.094 rows=33,068 loops=1)

6. 505.463 815.178 ↓ 1.7 36,121 1

Nested Loop (cost=8.04..75,784.65 rows=20,963 width=16) (actual time=1.426..815.178 rows=36,121 loops=1)

7. 0.973 1.435 ↑ 1.0 60 1

HashAggregate (cost=0.90..1.50 rows=60 width=8) (actual time=0.925..1.435 rows=60 loops=1)

  • Group Key: "*VALUES*".column1
8. 0.462 0.462 ↑ 1.0 60 1

Values Scan on "*VALUES*" (cost=0.00..0.75 rows=60 width=8) (actual time=0.011..0.462 rows=60 loops=1)

9. 303.060 308.280 ↓ 1.7 602 60

Bitmap Heap Scan on applications (cost=7.14..1,259.56 rows=349 width=24) (actual time=0.163..5.138 rows=602 loops=60)

  • Recheck Cond: (hiring_plan_id = "*VALUES*".column1)
  • Heap Blocks: exact=34725
10. 5.220 5.220 ↓ 1.7 602 60

Bitmap Index Scan on index_applications_on_hiring_plan_id (cost=0.00..7.05 rows=349 width=0) (actual time=0.087..0.087 rows=602 loops=60)

  • Index Cond: (hiring_plan_id = "*VALUES*".column1)
11. 433.452 433.452 ↑ 1.0 1 36,121

Index Scan using people_pkey on people (cost=0.43..0.64 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=36,121)

  • Index Cond: (id = applications.person_id)
  • Filter: (import_hash IS NULL)
  • Rows Removed by Filter: 0
12. 992.040 992.040 ↑ 1.0 1 33,068

Index Scan using index_application_stages_on_application_id on application_stages (cost=0.56..7.85 rows=1 width=32) (actual time=0.016..0.030 rows=1 loops=33,068)

  • Index Cond: (application_id = applications.id)
  • Filter: (entered_date IS NOT NULL)
  • Rows Removed by Filter: 9
13. 413.980 413.980 ↑ 1.0 1 41,398

Index Scan using hiring_plan_interview_stages_pkey on hiring_plan_interview_stages (cost=0.42..0.50 rows=1 width=25) (actual time=0.010..0.010 rows=1 loops=41,398)

  • Index Cond: (id = application_stages.hiring_plan_interview_stage_id)
  • Filter: active
Planning time : 17.666 ms
Execution time : 5,940.832 ms