explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cwhql

Settings
# exclusive inclusive rows x rows loops node
1. 278.739 3,082.055 ↑ 10.1 15 1

GroupAggregate (cost=68,459.04..68,529.62 rows=152 width=33) (actual time=2,961.083..3,082.055 rows=15 loops=1)

  • Group Key: hiring_plan_interview_stages.name
2. 486.669 2,803.316 ↓ 12.1 41,398 1

Sort (cost=68,459.04..68,467.63 rows=3,434 width=33) (actual time=2,562.827..2,803.316 rows=41,398 loops=1)

  • Sort Key: hiring_plan_interview_stages.name
  • Sort Method: quicksort Memory: 4770kB
3. 142.681 2,316.647 ↓ 12.1 41,398 1

Gather (cost=1,008.56..68,257.37 rows=3,434 width=33) (actual time=2.666..2,316.647 rows=41,398 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 359.081 2,173.966 ↓ 10.2 20,699 2 / 2

Nested Loop (cost=8.56..66,913.97 rows=2,020 width=33) (actual time=1.959..2,173.966 rows=20,699 loops=2)

5. 427.433 1,669.992 ↓ 9.7 20,699 2 / 2

Nested Loop (cost=8.13..65,797.50 rows=2,125 width=24) (actual time=1.904..1,669.992 rows=20,699 loops=2)

6. 304.686 812.675 ↓ 8.6 16,534 2 / 2

Nested Loop (cost=7.57..50,480.02 rows=1,931 width=8) (actual time=1.829..812.675 rows=16,534 loops=2)

7. 230.266 363.505 ↓ 6.1 18,060 2 / 2

Nested Loop (cost=7.14..48,514.74 rows=2,966 width=16) (actual time=1.757..363.505 rows=18,060 loops=2)

8. 9.729 9.729 ↑ 1.2 30 2 / 2

Parallel Seq Scan on hiring_plans (cost=0.00..4,307.90 rows=35 width=8) (actual time=0.999..9.729 rows=30 loops=2)

  • Filter: (id = ANY ('{4012069002,4012545002,4012549002,4012555002,4012556002,4012558002,4012560002,4012561002,4014078002,4014295002,4015191002,4023074002,4024496002,4031584002,4043446002,4049482002,4056771002,4056861002,4067319002,4086501002,4093350002,4102605002,4114489002,4119247002,4165802002,4165806002,4165809002,4167339002,4171443002,4174065002,4204675002,4208204002,4217962002,4220060002,4221472002,4231655002,4240444002,4245499002,4255708002,4263479002,4266854002,4271751002,4276979002,4279239002,4279877002,4309992002,4310457002,4314635002,4334623002,4347388002,4362589002,4365580002,4377719002,4382357002,4385356002,4399718002,4401854002,4403250002,4406326002,4413283002}'::bigint[]))
  • Rows Removed by Filter: 28980
9. 121.140 123.510 ↓ 1.7 602 60 / 2

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

  • Recheck Cond: (hiring_plan_id = hiring_plans.id)
  • Heap Blocks: exact=15666
10. 2.370 2.370 ↓ 1.7 602 60 / 2

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

  • Index Cond: (hiring_plan_id = hiring_plans.id)
11. 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
12. 429.884 429.884 ↑ 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.014..0.026 rows=1 loops=33,068)

  • Index Cond: (application_id = applications.id)
  • Filter: (entered_date IS NOT NULL)
  • Rows Removed by Filter: 9
13. 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 : 18.500 ms
Execution time : 3,083.409 ms