explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nepf

Settings
# exclusive inclusive rows x rows loops node
1. 214.081 3,046.479 ↑ 10.1 15 1

HashAggregate (cost=83,237.16..83,239.06 rows=152 width=33) (actual time=3,046.307..3,046.479 rows=15 loops=1)

  • Group Key: hiring_plan_interview_stages.name
2. 257.585 2,832.398 ↓ 2.9 41,398 1

Gather (cost=1,003.35..82,987.24 rows=14,281 width=33) (actual time=15.572..2,832.398 rows=41,398 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 375.648 2,574.813 ↓ 2.5 20,699 2 / 2

Nested Loop (cost=3.35..80,559.14 rows=8,401 width=33) (actual time=26.892..2,574.813 rows=20,699 loops=2)

4. 444.429 2,054.272 ↓ 2.3 20,699 2 / 2

Nested Loop (cost=2.93..75,917.25 rows=8,835 width=24) (actual time=26.835..2,054.272 rows=20,699 loops=2)

5. 319.940 1,163.425 ↓ 2.1 16,534 2 / 2

Nested Loop (cost=2.36..12,227.95 rows=8,029 width=8) (actual time=26.781..1,163.425 rows=16,534 loops=2)

6. 215.539 699.001 ↓ 1.5 18,060 2 / 2

Nested Loop (cost=1.93..4,057.37 rows=12,331 width=16) (actual time=26.674..699.001 rows=18,060 loops=2)

7. 180.886 362.112 ↑ 1.2 30 2 / 2

Hash Semi Join (cost=1.50..1,839.76 rows=35 width=16) (actual time=25.293..362.112 rows=30 loops=2)

  • Hash Cond: (hiring_plans.id = "*VALUES*".column1)
8. 180.280 180.280 ↑ 1.2 29,010 2 / 2

Parallel Seq Scan on hiring_plans (cost=0.00..1,748.28 rows=34,128 width=8) (actual time=1.106..180.280 rows=29,010 loops=2)

9. 0.471 0.946 ↑ 1.0 60 2 / 2

Hash (cost=0.75..0.75 rows=60 width=8) (actual time=0.941..0.946 rows=60 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
10. 0.475 0.475 ↑ 1.0 60 2 / 2

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

11. 121.350 121.350 ↓ 1.7 602 60 / 2

Index Scan using index_applications_on_hiring_plan_id on applications (cost=0.43..59.87 rows=349 width=24) (actual time=0.058..4.045 rows=602 loops=60)

  • Index Cond: (hiring_plan_id = hiring_plans.id)
12. 144.484 144.484 ↑ 1.0 1 36,121 / 2

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

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

Index Scan using index_application_stages_on_application_id on application_stages (cost=0.56..7.92 rows=1 width=32) (actual time=0.015..0.027 rows=1 loops=33,068)

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

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

  • Index Cond: (id = application_stages.hiring_plan_interview_stage_id)
  • Filter: active
Planning time : 32.692 ms
Execution time : 3,100.975 ms