explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NWIL

Settings
# exclusive inclusive rows x rows loops node
1. 302.928 5,921.711 ↑ 10.1 15 1

GroupAggregate (cost=205,102.79..205,390.33 rows=152 width=33) (actual time=5,795.586..5,921.711 rows=15 loops=1)

  • Group Key: hiring_plan_interview_stages.name
2. 546.131 5,618.783 ↓ 2.9 41,398 1

Sort (cost=205,102.79..205,138.49 rows=14,282 width=33) (actual time=5,358.696..5,618.783 rows=41,398 loops=1)

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

Nested Loop (cost=9.46..204,117.19 rows=14,282 width=33) (actual time=1.763..5,072.652 rows=41,398 loops=1)

4. 957.778 3,862.851 ↓ 2.8 41,398 1

Nested Loop (cost=9.03..196,542.82 rows=15,020 width=24) (actual time=1.722..3,862.851 rows=41,398 loops=1)

5. 709.599 1,913.033 ↓ 2.4 33,068 1

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

6. 502.687 806.103 ↓ 1.7 36,121 1

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

7. 0.989 1.496 ↑ 1.0 60 1

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

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

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

9. 297.000 301.920 ↓ 1.7 602 60

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

  • Recheck Cond: (hiring_plan_id = "*VALUES*".column1)
  • Heap Blocks: exact=34725
10. 4.920 4.920 ↓ 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.082..0.082 rows=602 loops=60)

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

Index Scan using people_pkey on people (cost=0.43..0.64 rows=1 width=8) (actual time=0.011..0.011 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. 372.582 372.582 ↑ 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.009..0.009 rows=1 loops=41,398)

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