| Time |
Node |
| Node (ms) |
Percent |
| 1125.517 |
100.00% |
¶ |
Limit (cost=176643.83..176643.83 rows=2 width=296) (actual time=1125.517..1125.517 rows=0 loops=1)
|
| 1125.515 |
100.00% |
¶ |
-> Sort (cost=176643.83..176643.83 rows=2 width=296) (actual time=1125.515..1125.515 rows=0 loops=1)
Sort Key: e.last_name, e.first_name, j.org_job_code, d.department_name, j.employee_job_profile_id, CASE WHEN (((cp_evaluations.status)::text = 'Acknowledged by HR'::text ) OR ((cp_evaluations.status)::text = 'Submitted to HR'::text)) THEN 1 ELSE 0 END, cp_evaluations.evaluation_id, cp_evaluations.date_received, cp_evaluations.status
|
| 1125.500 |
100.00% |
¶ |
-> Nested Loop (cost=175420.99..176643.82 rows=2 width=296) (actual time=1125.500..1125.500 rows=0 loops=1)
|
| 1125.499 |
100.00% |
¶ |
-> Hash Join (cost=58682.07..59813.27 rows=20 width=277) (actual time=1125.499..1125.499 rows=0 loops=1)
Hash Cond: ("outer".employee_job_profile_id = "inner".employee_job_profile_id)
|
| 945.812 |
84.03% |
¶ |
-> Merge Left Join (cost=47346.27..48176.55 rows=60144 width=48) (actual time=850.021..945.812 rows=35539 loops=1)
Merge Cond: ("outer".cp_evaluation_due_date_id = "inner".due_date_id)
|
| 294.159 |
26.14% |
¶ |
-> Sort (cost=25655.68..25806.04 rows=60144 width=16) (actual time=278.992..294.159 rows=35128 loops=1)
Sort Key: due.cp_evaluation_due_date_id
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Heap Scan on cp_evaluation_due_dates due (never executed)
Recheck Cond: ((("type")::text = 'annual'::text) AND (due_date >= '2008-10-12'::date) AND (due_date <= '2009-02-12'::date))
Filter: jcaho_required_p
|
| 126.340 |
11.23% |
¶ |
-> Bitmap Index Scan on cp_eval_dd_unq (cost=0.0..11850.72 rows=70098 width=0) (actual time=126.340..126.340 rows=70101 loops=1)
Index Cond: ((("type")::text = 'annual'::text) AND (due_date >= '2008-10-12'::date) AND (due_date <= '2009-02-12'::date))
|
| 611.627 |
54.34% |
¶ |
-> Sort (cost=21690.58..21921.6 rows=92406 width=36) (actual time=570.737..611.627 rows=92077 loops=1)
Sort Key: cp_evaluations.due_date_id
|
| 207.336 |
18.42% |
¶ |
-> Seq Scan on cp_evaluations (cost=0.0..11637.02 rows=92406 width=36) (actual time=0.039..207.336 rows=92077 loops=1)
Filter: (active_p AND ((eval_type)::text = 'Manager'::text))
|
| 109.550 |
9.73% |
¶ |
-> Hash (cost=11335.47..11335.47 rows=137 width=233) (actual time=109.550..109.550 rows=16062 loops=1)
|
| 78.132 |
6.94% |
¶ |
-> Nested Loop (cost=13.62..11335.47 rows=137 width=233) (actual time=1.700..78.132 rows=16062 loops=1)
|
| 4.579 |
0.41% |
¶ |
-> Bitmap Heap Scan on org_employees e (cost=13.62..3254.36 rows=1426 width=44) (actual time=0.770..4.579 rows=3281 loops=1)
Recheck Cond: (organization_id = 498587)
Filter: active_p
|
| 0.555 |
0.05% |
¶ |
-> Bitmap Index Scan on org_emp_app_user_type_idx (cost=0.0..13.62 rows=1892 width=0) (actual time=0.555..0.555 rows=4219 loops=1)
Index Cond: (organization_id = 498587)
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_employee_job_profiles_org_org_emp_idx on cp_employee_job_profiles j (never executed)
Index Cond: ((498587 = j.organization_id) AND ("outer".org_employee_id = j.org_employee_id))
Filter: eval_required
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_dept_id_fk on cp_departments d (never executed)
Index Cond: ("outer".department_id = d.department_id)
Filter: (498587 = organization_id)
SubPlan
|
| 0.000 |
0.00% |
¶ |
-> HashAggregate (never executed)
Filter: (count(employee_job_profile_id) > 1)
|
| 0.000 |
0.00% |
¶ |
-> Nested Loop (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Hash Join (never executed)
Hash Cond: ("outer".employee_job_profile_id = "inner".employee_job_profile_id)
|
| 0.000 |
0.00% |
¶ |
-> Merge Left Join (never executed)
Merge Cond: ("outer".cp_evaluation_due_date_id = "inner".due_date_id)
|
| 0.000 |
0.00% |
¶ |
-> Sort (never executed)
Sort Key: due.cp_evaluation_due_date_id
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Heap Scan on cp_evaluation_due_dates due (never executed)
Recheck Cond: ((("type")::text = 'annual'::text) AND (due_date >= '2008-10-12'::date) AND (due_date <= '2009-02-12'::date))
|
| 0.000 |
0.00% |
¶ |
-> Filter: jcaho_required_p -> Bitmap Index Scan on cp_eval_dd_unq (never executed)
Index Cond: ((("type")::text = 'annual'::text) AND (due_date >= '2008-10-12'::date) AND (due_date <= '2009-02-12'::date ))
|
| 0.000 |
0.00% |
¶ |
-> Sort (never executed)
Sort Key: cp_evaluations.due_date_id
|
| 0.000 |
0.00% |
¶ |
-> Seq Scan on cp_evaluations (never executed)
Filter: (active_p AND ((eval_type)::text = 'Manager'::text))
|
| 0.000 |
0.00% |
¶ |
-> Hash (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Nested Loop (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Heap Scan on org_employees e (never executed)
Recheck Cond: (organization_id = 498587)
Filter: active_p
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Index Scan on org_emp_app_user_type_idx (never executed)
Index Cond: (organization_id = 498587)
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_employee_job_profiles_org_org_emp_idx on cp_employee_job_profiles j (never executed)
Index Cond: ((498587 = j.organization_id) AND ("outer".org_employee_id = j.org_employee_id))
Filter: eval_required
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_dept_id_fk on cp_departments d (never executed)
Index Cond: ("outer".department_id = d.department_id)
Filter: (498587 = organization_id)
|
| 0.000 |
0.00% |
¶ |
-> HashAggregate (never executed)
Filter: (count(employee_job_profile_id) > 1)
|
| 0.000 |
0.00% |
¶ |
-> Nested Loop (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Hash Join (never executed)
Hash Cond: ("outer".employee_job_profile_id = "inner".employee_job_profile_id)
|
| 0.000 |
0.00% |
¶ |
-> Merge Left Join (never executed)
Merge Cond: ("outer".cp_evaluation_due_date_id = "inner".due_date_id)
|
| 0.000 |
0.00% |
¶ |
-> Sort (never executed)
Sort Key: due.cp_evaluation_due_date_id
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Heap Scan on cp_evaluation_due_dates due (never executed)
Recheck Cond: ((("type")::text = 'annual'::text) AND (due_date >= '2008-10-12'::date) AND (due_date <= '2009-02-12'::date))
Filter: jcaho_required_p
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Index Scan on cp_eval_dd_unq (never executed)
Index Cond: ((("type")::text = 'annual'::text) AND (due_date >= '2008-10-12'::date) AND (due_date <= '2009-02-12'::date ))
|
| 0.000 |
0.00% |
¶ |
-> Sort (never executed)
Sort Key: cp_evaluations.due_date_id
|
| 0.000 |
0.00% |
¶ |
-> Seq Scan on cp_evaluations (never executed)
Filter: (active_p AND ((eval_type)::text = 'Manager'::text))
|
| 0.000 |
0.00% |
¶ |
-> Hash (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Nested Loop (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Heap Scan on org_employees e (never executed)
Recheck Cond: (organization_id = 498587)
Filter: active_p
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Index Scan on org_emp_app_user_type_idx (never executed)
Index Cond: (organization_id = 498587)
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_employee_job_profiles_org_org_emp_idx on cp_employee_job_profiles j (never executed)
Index Cond: ((498587 = j.organization_id) AND ("outer".org_employee_id = j.org_employee_id))
Filter: eval_required
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_dept_id_fk on cp_departments d (cost=0.00..4.56 rows=1 width=8) (never executed) -> Seq Scan on cp_evaluations (never executed)
Filter: (active_p AND ((eval_type)::text = 'Manager'::text))
|
| 0.000 |
0.00% |
¶ |
-> Hash (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Nested Loop (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Heap Scan on org_employees e (never executed)
Recheck Cond: (organization_id = 498587)
Filter: active_p
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Index Scan on org_emp_app_user_type_idx (never executed)
Index Cond: (organization_id = 498587)
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_employee_job_profiles_org_org_emp_idx on cp_employee_job_profiles j (never executed)
Index Cond: ((498587 = j.organization_id) AND ("outer".org_employee_id = j.org_employee_id))
Filter: eval_required
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_dept_id_fk on cp_departments d (never executed)
Index Cond: ("outer".department_id = d.department_id)
Filter: (498587 = organization_id)
|
| 0.000 |
0.00% |
¶ |
-> HashAggregate (never executed)
Filter: (count(employee_job_profile_id) > 1)
|
| 0.000 |
0.00% |
¶ |
-> Nested Loop (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Hash Join (never executed)
Hash Cond: ("outer".employee_job_profile_id = "inner".employee_job_profile_id)
|
| 0.000 |
0.00% |
¶ |
-> Merge Left Join (never executed)
Merge Cond: ("outer".cp_evaluation_due_date_id = "inner".due_date_id)
|
| 0.000 |
0.00% |
¶ |
-> Sort (never executed)
Sort Key: due.cp_evaluation_due_date_id
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Heap Scan on cp_evaluation_due_dates due (never executed)
Recheck Cond: ((("type")::text = 'annual'::text) AND (due_date >= '2008-10-12'::date) AND (due_date <= '2009-02-12'::date))
Filter: jcaho_required_p
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Index Scan on cp_eval_dd_unq (never executed)
Index Cond: ((("type")::text = 'annual'::text) AND (due_date >= '2008-10-12'::date) AND (due_date <= '2009-02-12'::date ))
|
| 0.000 |
0.00% |
¶ |
-> Sort (never executed)
Sort Key: cp_evaluations.due_date_id
|
| 0.000 |
0.00% |
¶ |
-> Seq Scan on cp_evaluations (never executed)
Filter: (active_p AND ((eval_type)::text = 'Manager'::text))
|
| 0.000 |
0.00% |
¶ |
-> Hash (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Nested Loop (never executed)
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Heap Scan on org_employees e (never executed)
Recheck Cond: (organization_id = 498587)
Filter: active_p
|
| 0.000 |
0.00% |
¶ |
-> Bitmap Index Scan on org_emp_app_user_type_idx (never executed)
Index Cond: (organization_id = 498587)
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_employee_job_profiles_org_org_emp_idx on cp_employee_job_profiles j (never executed)
Index Cond: ((498587 = j.organization_id) AND ("outer".org_employee_id = j.org_employee_id))
Filter: eval_required
|
| 0.000 |
0.00% |
¶ |
-> Index Scan using cp_dept_id_fk on cp_departments d (never executed)
Index Cond: ("outer".department_id = d.department_id)
Filter: (498587 = organization_id)
|
ANALYZEto update the server's statistics.EXPLAINand interpreting its output, see the Postgres documentation, in particular theEXPLAINandANALYZEreferences pages, and Using Explain.