explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jxuY

Settings
# exclusive inclusive rows x rows loops node
1. 0.360 45.376 ↓ 1.3 240 1

Seq Scan on hr_employee (cost=1,165,257.62..1,165,290.39 rows=190 width=24) (actual time=45.148..45.376 rows=240 loops=1)

  • Filter: (NOT (hashed SubPlan 59))
  • Rows Removed by Filter: 141
2.          

SubPlan (for Seq Scan)

3. 2.822 45.016 ↑ 2.7 141 1

Seq Scan on hr_employee emp (cost=0.00..1,165,256.67 rows=381 width=4) (actual time=0.151..45.016 rows=141 loops=1)

  • Filter: ((SubPlan 2) OR (SubPlan 4) OR (SubPlan 6) OR (SubPlan 8) OR (SubPlan 10) OR (SubPlan 12) OR (SubPlan 14) OR (SubPlan 16) OR (SubPlan 18) OR (SubPlan 20) OR (SubPlan 22) OR (SubPlan 24) OR (SubPlan 26) OR (SubPlan 28) OR (SubPlan 30) OR ( (...)
  • Rows Removed by Filter: 240
4.          

SubPlan (for Seq Scan)

5. 0.381 2.286 ↓ 0.0 0 381

Limit (cost=0.27..12.58 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=381)

6. 1.061 1.905 ↓ 0.0 0 381

Index Scan using idx_assignment_assignment_employee on assignment_assignment assign (cost=0.27..12.58 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=381)

  • Index Cond: (hr_employee_id = emp.id)
  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 1
7.          

SubPlan (for Index Scan)

8. 0.000 0.844 ↓ 0.0 0 422

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=422)

9. 0.844 0.844 ↓ 0.0 0 422

Index Only Scan using ir_attachment_res_idx on ir_attachment (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=422)

  • Index Cond: ((res_model = 'assignment.assignment'::text) AND (res_id = assign.id))
  • Heap Fetches: 7
10. 0.374 0.748 ↓ 0.0 0 374

Limit (cost=0.00..1,688.46 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=374)

11. 0.368 0.374 ↓ 0.0 0 374

Seq Scan on record_record rec (cost=0.00..1,688.46 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=374)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 3))
  • Rows Removed by Filter: 2
12.          

SubPlan (for Seq Scan)

13. 0.001 0.006 ↑ 1.0 1 1

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

14. 0.005 0.005 ↑ 1.0 1 1

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_1 (cost=0.28..8.30 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: ((res_model = 'record.record'::text) AND (res_id = rec.id))
  • Heap Fetches: 1
15. 0.373 0.746 ↓ 0.0 0 373

Limit (cost=0.00..5.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=373)

16. 0.369 0.373 ↓ 0.0 0 373

Seq Scan on other_other oth (cost=0.00..5.30 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=373)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 5))
  • Rows Removed by Filter: 1
17.          

SubPlan (for Seq Scan)

18. 0.001 0.004 ↑ 1.0 1 1

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

19. 0.003 0.003 ↑ 1.0 1 1

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_2 (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: ((res_model = 'other.other'::text) AND (res_id = oth.id))
  • Heap Fetches: 1
20. 0.372 0.744 ↓ 0.0 0 372

Limit (cost=0.00..9.61 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=372)

21. 0.362 0.372 ↓ 0.0 0 372

Seq Scan on supplies_equipment equip (cost=0.00..9.61 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=372)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 7))
  • Rows Removed by Filter: 2
22.          

SubPlan (for Seq Scan)

23. 0.002 0.010 ↓ 0.0 0 2

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=2)

24. 0.008 0.008 ↓ 0.0 0 2

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_3 (cost=0.28..8.30 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=2)

  • Index Cond: ((res_model = 'supplies.equipment'::text) AND (res_id = equip.id))
  • Heap Fetches: 0
25. 0.000 0.744 ↓ 0.0 0 372

Limit (cost=0.14..12.45 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=372)

26. 0.555 0.744 ↓ 0.0 0 372

Index Scan using idx_education_education_hr_multi_col on education_education edu (cost=0.14..12.45 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=372)

  • Index Cond: (hr_employee_id = emp.id)
  • Filter: (SubPlan 9)
  • Rows Removed by Filter: 0
27.          

SubPlan (for Index Scan)

28. 0.000 0.189 ↑ 1.0 1 63

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=63)

29. 0.189 0.189 ↑ 1.0 1 63

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_4 (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=63)

  • Index Cond: ((res_model = 'education.education'::text) AND (res_id = edu.id))
  • Heap Fetches: 45
30. 0.327 3.924 ↓ 0.0 0 327

Limit (cost=0.00..253.62 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=327)

31. 3.532 3.597 ↓ 0.0 0 327

Seq Scan on training_training train (cost=0.00..253.62 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=327)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 11))
  • Rows Removed by Filter: 59
32.          

SubPlan (for Seq Scan)

33. 0.013 0.065 ↑ 1.0 1 13

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=13)

34. 0.052 0.052 ↑ 1.0 1 13

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_5 (cost=0.28..8.30 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=13)

  • Index Cond: ((res_model = 'training.training'::text) AND (res_id = train.id))
  • Heap Fetches: 10
35. 0.000 0.317 ↓ 0.0 0 317

Limit (cost=0.14..12.44 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=317)

36. 0.278 0.317 ↓ 0.0 0 317

Index Scan using idx_promotion_promotion_multi_col on promotion_promotion promo (cost=0.14..12.44 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=317)

  • Index Cond: (hr_employee_id = emp.id)
  • Filter: (SubPlan 13)
  • Rows Removed by Filter: 0
37.          

SubPlan (for Index Scan)

38. 0.000 0.039 ↓ 0.0 0 13

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=13)

39. 0.039 0.039 ↓ 0.0 0 13

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_6 (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=13)

  • Index Cond: ((res_model = 'promotion.promotion'::text) AND (res_id = promo.id))
  • Heap Fetches: 0
40. 0.317 0.634 ↓ 0.0 0 317

Limit (cost=0.00..1,688.46 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=317)

41. 0.317 0.317 ↓ 0.0 0 317

Seq Scan on record_record rec_1 (cost=0.00..1,688.46 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=317)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 15))
  • Rows Removed by Filter: 2
42.          

SubPlan (for Seq Scan)

43. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_7 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'record.record'::text) AND (res_id = rec_1.id))
  • Heap Fetches: 0
45. 0.317 0.634 ↓ 0.0 0 317

Limit (cost=0.00..9.61 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=317)

46. 0.317 0.317 ↓ 0.0 0 317

Seq Scan on evaluation_evaluation evalu (cost=0.00..9.61 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=317)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 17))
  • Rows Removed by Filter: 2
47.          

SubPlan (for Seq Scan)

48. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_8 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'evaluation.evaluation'::text) AND (res_id = evalu.id))
  • Heap Fetches: 0
50. 0.317 0.951 ↓ 0.0 0 317

Limit (cost=0.00..22.52 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=317)

51. 0.634 0.634 ↓ 0.0 0 317

Seq Scan on vaccination_vaccination vac (cost=0.00..22.52 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=317)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 19))
  • Rows Removed by Filter: 6
52.          

SubPlan (for Seq Scan)

53. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Unique (cost=0.28..8.30 rows=1 width=4) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_9 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'vaccination.vaccination'::text) AND (res_id = vac.id))
  • Heap Fetches: 0
56. 0.317 0.634 ↓ 0.0 0 317

Limit (cost=0.00..13.91 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=317)

57. 0.317 0.317 ↓ 0.0 0 317

Seq Scan on physical_exam phye (cost=0.00..13.91 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=317)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 21))
  • Rows Removed by Filter: 3
58.          

SubPlan (for Seq Scan)

59. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_10 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'physical.exam'::text) AND (res_id = phye.id))
  • Heap Fetches: 0
61. 0.317 3.804 ↓ 0.0 0 317

Limit (cost=0.00..236.40 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=317)

62. 3.477 3.487 ↓ 0.0 0 317

Seq Scan on medical_history med (cost=0.00..236.40 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=317)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 23))
  • Rows Removed by Filter: 55
63.          

SubPlan (for Seq Scan)

64. 0.002 0.010 ↓ 0.0 0 2

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=2)

65. 0.008 0.008 ↓ 0.0 0 2

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_11 (cost=0.28..8.30 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=2)

  • Index Cond: ((res_model = 'medical.history'::text) AND (res_id = med.id))
  • Heap Fetches: 0
66. 0.317 0.634 ↓ 0.0 0 317

Limit (cost=0.00..5.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=317)

67. 0.317 0.317 ↓ 0.0 0 317

Seq Scan on casualty_casualty cas (cost=0.00..5.30 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=317)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 25))
  • Rows Removed by Filter: 1
68.          

SubPlan (for Seq Scan)

69. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_12 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'casualty.casualty'::text) AND (res_id = cas.id))
  • Heap Fetches: 0
71. 0.000 0.317 ↓ 0.0 0 317

Limit (cost=0.00..5.30 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=317)

72. 0.317 0.317 ↓ 0.0 0 317

Seq Scan on injuries_injuries inj (cost=0.00..5.30 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=317)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 27))
  • Rows Removed by Filter: 1
73.          

SubPlan (for Seq Scan)

74. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_13 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'injuries.injuries'::text) AND (res_id = inj.id))
  • Heap Fetches: 0
76. 0.000 4.121 ↓ 0.0 0 317

Limit (cost=0.28..18.16 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=317)

77. 1.261 4.121 ↓ 0.0 0 317

Index Scan using leave_leave_hr_employee_id_index on leave_leave leave (cost=0.28..53.92 rows=3 width=4) (actual time=0.013..0.013 rows=0 loops=317)

  • Index Cond: (hr_employee_id = emp.id)
  • Filter: (SubPlan 29)
  • Rows Removed by Filter: 4
78.          

SubPlan (for Index Scan)

79. 1.430 2.860 ↓ 0.0 0 1,430

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1,430)

80. 1.430 1.430 ↓ 0.0 0 1,430

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_14 (cost=0.28..8.30 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1,430)

  • Index Cond: ((res_model = 'leave.leave'::text) AND (res_id = leave.id))
  • Heap Fetches: 4
81. 0.313 4.382 ↓ 0.0 0 313

Limit (cost=0.00..294.65 rows=1 width=4) (actual time=0.014..0.014 rows=0 loops=313)

82. 4.027 4.069 ↓ 0.0 0 313

Seq Scan on reference_reference ref (cost=0.00..294.65 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=313)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 31))
  • Rows Removed by Filter: 71
83.          

SubPlan (for Seq Scan)

84. 0.000 0.042 ↓ 0.0 0 14

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=14)

85. 0.042 0.042 ↓ 0.0 0 14

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_15 (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=14)

  • Index Cond: ((res_model = 'reference.reference'::text) AND (res_id = ref.id))
  • Heap Fetches: 1
86. 0.000 1.248 ↓ 0.0 0 312

Limit (cost=0.00..52.64 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=312)

87. 1.233 1.248 ↓ 0.0 0 312

Seq Scan on previous_occupation pro (cost=0.00..52.64 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=312)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 33))
  • Rows Removed by Filter: 13
88.          

SubPlan (for Seq Scan)

89. 0.005 0.015 ↓ 0.0 0 5

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=5)

90. 0.010 0.010 ↓ 0.0 0 5

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_16 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=5)

  • Index Cond: ((res_model = 'previous.occupation'::text) AND (res_id = pro.id))
  • Heap Fetches: 1
91. 0.311 0.622 ↓ 0.0 0 311

Limit (cost=0.00..18.21 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=311)

92. 0.311 0.311 ↓ 0.0 0 311

Seq Scan on previous_travel prt (cost=0.00..18.21 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=311)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 35))
  • Rows Removed by Filter: 4
93.          

SubPlan (for Seq Scan)

94. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_17 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'previous.travel'::text) AND (res_id = prt.id))
  • Heap Fetches: 0
96. 0.311 1.244 ↓ 0.0 0 311

Limit (cost=0.00..61.25 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=311)

97. 0.923 0.933 ↓ 0.0 0 311

Seq Scan on relative_relative rel (cost=0.00..61.25 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=311)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 37))
  • Rows Removed by Filter: 17
98.          

SubPlan (for Seq Scan)

99. 0.002 0.010 ↓ 0.0 0 2

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=2)

100. 0.008 0.008 ↓ 0.0 0 2

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_18 (cost=0.28..8.30 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=2)

  • Index Cond: ((res_model = 'relative.relative'::text) AND (res_id = rel.id))
  • Heap Fetches: 1
101. 0.310 1.240 ↓ 0.0 0 310

Limit (cost=0.00..78.47 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=310)

102. 0.918 0.930 ↓ 0.0 0 310

Seq Scan on employee_language eml (cost=0.00..78.47 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=310)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 39))
  • Rows Removed by Filter: 18
103.          

SubPlan (for Seq Scan)

104. 0.000 0.012 ↓ 0.0 0 6

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=6)

105. 0.012 0.012 ↓ 0.0 0 6

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_19 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=6)

  • Index Cond: ((res_model = 'employee.language'::text) AND (res_id = eml.id))
  • Heap Fetches: 0
106. 0.310 0.310 ↓ 0.0 0 310

Limit (cost=0.00..870.75 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=310)

107. 0.000 0.000 ↓ 0.0 0 310

Seq Scan on remark_remark rer (cost=0.00..870.75 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=310)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 41))
108.          

SubPlan (for Seq Scan)

109. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_20 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'remark.remark'::text) AND (res_id = rer.id))
  • Heap Fetches: 0
111. 0.310 1.240 ↓ 0.0 0 310

Limit (cost=0.00..56.95 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=310)

112. 0.897 0.930 ↓ 0.0 0 310

Seq Scan on extraordinary_promotion exp (cost=0.00..56.95 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=310)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 43))
  • Rows Removed by Filter: 13
113.          

SubPlan (for Seq Scan)

114. 0.011 0.033 ↓ 0.0 0 11

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=11)

115. 0.022 0.022 ↓ 0.0 0 11

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_21 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=11)

  • Index Cond: ((res_model = 'extraordinary.promotion'::text) AND (res_id = exp.id))
  • Heap Fetches: 0
116. 0.310 1.860 ↓ 0.0 0 310

Limit (cost=0.00..208.58 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=310)

117. 1.484 1.550 ↓ 0.0 0 310

Seq Scan on demotion_demotion demo (cost=0.00..208.58 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=310)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 45))
  • Rows Removed by Filter: 24
118.          

SubPlan (for Seq Scan)

119. 0.022 0.066 ↓ 0.0 0 22

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=22)

120. 0.044 0.044 ↓ 0.0 0 22

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_22 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=22)

  • Index Cond: ((res_model = 'demotion.demotion'::text) AND (res_id = demo.id))
  • Heap Fetches: 1
121. 0.309 3.399 ↓ 0.0 0 309

Limit (cost=0.00..227.79 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=309)

122. 3.090 3.090 ↓ 0.0 0 309

Seq Scan on benificiaries_benificiaries beb (cost=0.00..227.79 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=309)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 47))
  • Rows Removed by Filter: 53
123.          

SubPlan (for Seq Scan)

124. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_23 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'benificiaries.benificiaries'::text) AND (res_id = beb.id))
  • Heap Fetches: 0
126. 0.309 2.163 ↓ 0.0 0 309

Limit (cost=0.00..150.33 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=309)

127. 1.767 1.854 ↓ 0.0 0 309

Seq Scan on legal_attorney_disabled lega (cost=0.00..150.33 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=309)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 49))
  • Rows Removed by Filter: 35
128.          

SubPlan (for Seq Scan)

129. 0.000 0.087 ↓ 0.0 0 29

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=29)

130. 0.087 0.087 ↓ 0.0 0 29

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_24 (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=29)

  • Index Cond: ((res_model = 'legal.attorney.disabled'::text) AND (res_id = lega.id))
  • Heap Fetches: 1
131. 0.000 1.540 ↓ 0.0 0 308

Limit (cost=0.27..25.42 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=308)

132. 1.184 1.540 ↓ 0.0 0 308

Index Scan using idx_personnel_separation_termination_multi_col on personnel_separation_termination pst (cost=0.27..25.42 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=308)

  • Index Cond: (hr_employee_id = emp.id)
  • Filter: (SubPlan 51)
  • Rows Removed by Filter: 0
133.          

SubPlan (for Index Scan)

134. 0.089 0.356 ↑ 1.0 1 89

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=89)

135. 0.267 0.267 ↑ 1.0 1 89

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_25 (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=89)

  • Index Cond: ((res_model = 'personnel.separation.termination'::text) AND (res_id = pst.id))
  • Heap Fetches: 64
136. 0.244 0.732 ↓ 0.0 0 244

Limit (cost=0.00..31.13 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=244)

137. 0.485 0.488 ↓ 0.0 0 244

Seq Scan on icid_allocation icid (cost=0.00..31.13 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=244)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 53))
  • Rows Removed by Filter: 7
138.          

SubPlan (for Seq Scan)

139. 0.001 0.003 ↓ 0.0 0 1

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=1)

140. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_26 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((res_model = 'icid.allocation'::text) AND (res_id = icid.id))
  • Heap Fetches: 0
141. 0.244 0.488 ↓ 0.0 0 244

Limit (cost=0.00..22.52 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=244)

142. 0.244 0.244 ↓ 0.0 0 244

Seq Scan on hr_msc_docs hmd (cost=0.00..22.52 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=244)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 55))
  • Rows Removed by Filter: 5
143.          

SubPlan (for Seq Scan)

144. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=4) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_27 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((res_model = 'hr.msc.docs'::text) AND (res_id = hmd.id))
  • Heap Fetches: 0
146. 0.000 0.488 ↓ 0.0 0 244

Limit (cost=0.00..22.52 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=244)

147. 0.468 0.488 ↓ 0.0 0 244

Seq Scan on physical_fitness_test pft (cost=0.00..22.52 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=244)

  • Filter: ((hr_employee_id = emp.id) AND (SubPlan 57))
  • Rows Removed by Filter: 5
148.          

SubPlan (for Seq Scan)

149. 0.005 0.020 ↑ 1.0 1 5

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=5)

150. 0.015 0.015 ↑ 1.0 1 5

Index Only Scan using ir_attachment_res_idx on ir_attachment ir_attachment_28 (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=5)

  • Index Cond: ((res_model = 'physical.fitness.test'::text) AND (res_id = pft.id))
  • Heap Fetches: 4
Planning time : 3.679 ms
Execution time : 46.023 ms