explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T2d5

Settings
# exclusive inclusive rows x rows loops node
1. 19,956.892 21,176.404 ↓ 0.0 0 1

Bitmap Heap Scan on ir_attachment (cost=26,168.95..532,807.56 rows=287,676 width=4) (actual time=21,176.404..21,176.404 rows=0 loops=1)

  • Recheck Cond: ((((res_model)::text = 'assignment.assignment'::text) AND ((res_field)::text = 'assignment_attachment_ids'::text)) OR (((res_model)::text = 'letter.lett
  • Filter: (active AND ((((res_model)::text = 'assignment.assignment'::text) AND ((res_field)::text = 'assignment_attachment_ids'::text) AND (hashed SubPlan 1)) OR (((re
  • Rows Removed by Filter: 4678962
  • Heap Blocks: exact=316182
2. 0.035 1,218.808 ↓ 0.0 0 1

BitmapOr (cost=25,784.87..25,784.87 rows=586,483 width=0) (actual time=1,218.808..1,218.808 rows=0 loops=1)

3. 98.451 98.451 ↓ 13.2 381,663 1

Bitmap Index Scan on temp_idx_attachment (cost=0.00..1,190.43 rows=28,987 width=0) (actual time=98.451..98.451 rows=381,663 loops=1)

  • Index Cond: (((res_model)::text = 'assignment.assignment'::text) AND ((res_field)::text = 'assignment_attachment_ids'::text))
4. 211.035 211.035 ↓ 8.8 599,943 1

Bitmap Index Scan on temp_ir_attachment_res_model2 (cost=0.00..2,660.98 rows=68,455 width=0) (actual time=211.035..211.035 rows=599,943 loops=1)

  • Index Cond: (((res_model)::text = 'letter.letter'::text) AND ((res_field)::text = 'letter_attachment_ids'::text))
5. 0.058 0.058 ↓ 42.0 42 1

Bitmap Index Scan on temp_ir_attachment_res_model3 (cost=0.00..4.15 rows=1 width=0) (actual time=0.058..0.058 rows=42 loops=1)

  • Index Cond: (((res_model)::text = 'adso.adso'::text) AND ((res_field)::text = 'adso_attachment_ids'::text))
6. 27.962 27.962 ↓ 31.8 157,018 1

Bitmap Index Scan on temp_idx_attachment (cost=0.00..205.91 rows=4,935 width=0) (actual time=27.962..27.962 rows=157,018 loops=1)

  • Index Cond: (((res_model)::text = 'vaccination.vaccination'::text) AND ((res_field)::text = 'vaccination_attachment_ids'::text))
7. 326.293 326.293 ↓ 4.1 1,269,584 1

Bitmap Index Scan on temp_ir_attachment_res_model5 (cost=0.00..11,975.49 rows=308,306 width=0) (actual time=326.293..326.293 rows=1,269,584 loops=1)

  • Index Cond: (((res_model)::text = 'record.record'::text) AND ((res_field)::text = 'record_attachment_ids'::text))
8. 4.056 4.056 ↓ 370.9 13,353 1

Bitmap Index Scan on temp_ir_attachment_res_model6 (cost=0.00..4.77 rows=36 width=0) (actual time=4.056..4.056 rows=13,353 loops=1)

  • Index Cond: (((res_model)::text = 'reprimand.reprimand'::text) AND ((res_field)::text = 'reprimand_attachment_ids'::text))
9. 15.460 15.460 ↓ 3.0 3 1

Bitmap Index Scan on temp_ir_attachment_res_model7 (cost=0.00..4.14 rows=1 width=0) (actual time=15.460..15.460 rows=3 loops=1)

  • Index Cond: (((res_model)::text = 'previous.travel'::text) AND ((res_field)::text = 'attachments_ids'::text))
10. 0.246 0.246 ↓ 3.0 3 1

Bitmap Index Scan on temp_ir_attachment_res_model8 (cost=0.00..4.14 rows=1 width=0) (actual time=0.246..0.246 rows=3 loops=1)

  • Index Cond: (((res_model)::text = 'employee.language'::text) AND ((res_field)::text = 'attachments_ids'::text))
11. 98.584 98.584 ↓ 9.9 519,724 1

Bitmap Index Scan on temp_idx_attachment (cost=0.00..2,163.04 rows=52,648 width=0) (actual time=98.584..98.584 rows=519,724 loops=1)

  • Index Cond: (((res_model)::text = 'request.request'::text) AND ((res_field)::text = 'request_attachment_ids'::text))
12. 0.288 0.288 ↓ 3.0 3 1

Bitmap Index Scan on temp_ir_attachment_res_model10 (cost=0.00..4.14 rows=1 width=0) (actual time=0.288..0.288 rows=3 loops=1)

  • Index Cond: (((res_model)::text = 'reference.reference'::text) AND ((res_field)::text = 'attachments_ids'::text))
13. 14.686 14.686 ↓ 379.0 379 1

Bitmap Index Scan on temp_ir_attachment_res_model11 (cost=0.00..4.28 rows=1 width=0) (actual time=14.686..14.686 rows=379 loops=1)

  • Index Cond: (((res_model)::text = 'weapon.weapon'::text) AND ((res_field)::text = 'weapon_attachment_ids'::text))
14. 2.009 2.009 ↓ 7,646.0 7,646 1

Bitmap Index Scan on temp_ir_attachment_res_model12 (cost=0.00..4.29 rows=1 width=0) (actual time=2.009..2.009 rows=7,646 loops=1)

  • Index Cond: (((res_model)::text = 'supplies.equipment'::text) AND ((res_field)::text = 'equip_supply_attachment_ids'::text))
15. 50.735 50.735 ↓ 90.1 56,829 1

Bitmap Index Scan on temp_ir_attachment_res_model13 (cost=0.00..26.73 rows=631 width=0) (actual time=50.735..50.735 rows=56,829 loops=1)

  • Index Cond: (((res_model)::text = 'award.award'::text) AND ((res_field)::text = 'award_attachment_ids'::text))
16. 18.529 18.529 ↓ 249.0 249 1

Bitmap Index Scan on temp_ir_attachment_res_model14 (cost=0.00..4.28 rows=1 width=0) (actual time=18.529..18.529 rows=249 loops=1)

  • Index Cond: (((res_model)::text = 'injuries.injuries'::text) AND ((res_field)::text = 'injury_attachment_ids'::text))
17. 34.100 34.100 ↓ 46.4 119,617 1

Bitmap Index Scan on temp_idx_attachment (cost=0.00..106.32 rows=2,576 width=0) (actual time=34.100..34.100 rows=119,617 loops=1)

  • Index Cond: (((res_model)::text = 'education.education'::text) AND ((res_field)::text = 'education_attachment_ids'::text))
18. 0.400 0.400 ↓ 1,211.0 1,211 1

Bitmap Index Scan on temp_ir_attachment_res_model16 (cost=0.00..4.29 rows=1 width=0) (actual time=0.400..0.400 rows=1,211 loops=1)

  • Index Cond: (((res_model)::text = 'escape.escape'::text) AND ((res_field)::text = 'escape_attachment_ids'::text))
19. 59.053 59.053 ↓ 21.8 223,710 1

Bitmap Index Scan on temp_idx_attachment (cost=0.00..423.40 rows=10,284 width=0) (actual time=59.053..59.053 rows=223,710 loops=1)

  • Index Cond: (((res_model)::text = 'training.training'::text) AND ((res_field)::text = 'training_attachment_ids'::text))
20. 110.038 110.038 ↓ 8.1 624,387 1

Bitmap Index Scan on temp_ir_attachment_res_model18 (cost=0.00..2,984.20 rows=76,778 width=0) (actual time=110.038..110.038 rows=624,387 loops=1)

  • Index Cond: (((res_model)::text = 'other.other'::text) AND ((res_field)::text = 'other_attachment_ids'::text))
21. 57.059 57.059 ↓ 16.7 300,316 1

Bitmap Index Scan on temp_idx_attachment (cost=0.00..740.06 rows=17,950 width=0) (actual time=57.059..57.059 rows=300,316 loops=1)

  • Index Cond: (((res_model)::text = 'medical.history'::text) AND ((res_field)::text = 'medical_attachment_ids'::text))
22. 0.146 0.146 ↓ 533.0 533 1

Bitmap Index Scan on temp_ir_attachment_res_model20 (cost=0.00..4.29 rows=1 width=0) (actual time=0.146..0.146 rows=533 loops=1)

  • Index Cond: (((res_model)::text = 'casualty.casualty'::text) AND ((res_field)::text = 'casualty_attachment_ids'::text))
23. 0.012 0.012 ↓ 4.0 4 1

Bitmap Index Scan on temp_ir_attachment_res_model21 (cost=0.00..4.14 rows=1 width=0) (actual time=0.012..0.012 rows=4 loops=1)

  • Index Cond: (((res_model)::text = 'benificiaries.benificiaries'::text) AND ((res_field)::text = 'attachments_ids'::text))
24. 0.011 0.011 ↓ 3.0 3 1

Bitmap Index Scan on temp_ir_attachment_res_model22 (cost=0.00..4.14 rows=1 width=0) (actual time=0.011..0.011 rows=3 loops=1)

  • Index Cond: (((res_model)::text = 'previous.occupation'::text) AND ((res_field)::text = 'attachments_ids'::text))
25. 27.742 27.742 ↓ 33.9 158,152 1

Bitmap Index Scan on temp_idx_attachment (cost=0.00..195.25 rows=4,669 width=0) (actual time=27.742..27.742 rows=158,152 loops=1)

  • Index Cond: (((res_model)::text = 'physical.exam'::text) AND ((res_field)::text = 'physical_exam_attachment_ids'::text))
26. 0.289 0.289 ↓ 821.0 821 1

Bitmap Index Scan on temp_ir_attachment_res_model24 (cost=0.00..4.29 rows=1 width=0) (actual time=0.289..0.289 rows=821 loops=1)

  • Index Cond: (((res_model)::text = 'sickness.sickness'::text) AND ((res_field)::text = 'sickness_attachment_ids'::text))
27. 0.017 0.017 ↓ 3.0 3 1

Bitmap Index Scan on temp_ir_attachment_res_model25 (cost=0.00..4.14 rows=1 width=0) (actual time=0.017..0.017 rows=3 loops=1)

  • Index Cond: (((res_model)::text = 'relative.relative'::text) AND ((res_field)::text = 'attachments_ids'::text))
28. 0.015 0.015 ↓ 3.0 3 1

Bitmap Index Scan on temp_ir_attachment_res_model26 (cost=0.00..4.14 rows=1 width=0) (actual time=0.015..0.015 rows=3 loops=1)

  • Index Cond: (((res_model)::text = 'physical.fitness.test'::text) AND ((res_field)::text = 'attachment_ids'::text))
29. 58.327 58.327 ↓ 22.7 232,209 1

Bitmap Index Scan on temp_idx_attachment (cost=0.00..422.71 rows=10,215 width=0) (actual time=58.327..58.327 rows=232,209 loops=1)

  • Index Cond: (((res_model)::text = 'promotion.promotion'::text) AND ((res_field)::text = 'promotion_attachment_ids'::text))
30. 0.289 0.289 ↓ 945.0 945 1

Bitmap Index Scan on temp_ir_attachment_res_model28 (cost=0.00..4.29 rows=1 width=0) (actual time=0.289..0.289 rows=945 loops=1)

  • Index Cond: (((res_model)::text = 'leave.leave'::text) AND ((res_field)::text = 'leave_attachment_ids'::text))
31. 0.012 0.012 ↓ 4.0 4 1

Bitmap Index Scan on temp_ir_attachment_res_model29 (cost=0.00..4.14 rows=1 width=0) (actual time=0.012..0.012 rows=4 loops=1)

  • Index Cond: (((res_model)::text = 'personnel.separation.termination'::text) AND ((res_field)::text = 'separation_attachment_ids'::text))
32. 2.785 2.785 ↓ 10,550.0 10,550 1

Bitmap Index Scan on temp_ir_attachment_res_model30 (cost=0.00..4.42 rows=1 width=0) (actual time=2.785..2.785 rows=10,550 loops=1)

  • Index Cond: (((res_model)::text = 'evaluation.evaluation'::text) AND ((res_field)::text = 'evaluation_attachment_ids'::text))
33. 0.029 0.029 ↓ 4.0 4 1

Bitmap Index Scan on temp_ir_attachment_res_model31 (cost=0.00..4.14 rows=1 width=0) (actual time=0.029..0.029 rows=4 loops=1)

  • Index Cond: (((res_model)::text = 'remark.remark'::text) AND ((res_field)::text = 'attachments_ids'::text))
34. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on temp_ir_attachment_res_model32 (cost=0.00..4.13 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (((res_model)::text = 'extraordinary.promotion'::text) AND ((res_field)::text = 'extra_ordinary_promotion_attachment_ids'::text))
35. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on temp_ir_attachment_res_model33 (cost=0.00..4.13 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((res_model)::text = 'demotion.demotion'::text) AND ((res_field)::text = 'demotion_attachment_ids'::text))
36. 0.026 0.026 ↓ 32.0 32 1

Bitmap Index Scan on temp_ir_attachment_res_model34 (cost=0.00..4.15 rows=1 width=0) (actual time=0.026..0.026 rows=32 loops=1)

  • Index Cond: (((res_model)::text = 'icid.allocation'::text) AND ((res_field)::text = 'attachment_ids'::text))
37. 0.017 0.017 ↓ 19.0 19 1

Bitmap Index Scan on temp_ir_attachment_res_model35 (cost=0.00..4.15 rows=1 width=0) (actual time=0.017..0.017 rows=19 loops=1)

  • Index Cond: (((res_model)::text = 'hr.msc.docs'::text) AND ((res_field)::text = 'attachments_ids'::text))
38. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on temp_ir_attachment_res_model36 (cost=0.00..4.13 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (((res_model)::text = 'legal.attorney.disabled'::text) AND ((res_field)::text = 'lgl_attorney_attachment_ids'::text))
39.          

SubPlan (forBitmap Heap Scan)

40. 0.019 0.019 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model37 on assignment_assignment (cost=0.43..17.30 rows=6 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
41. 0.023 0.023 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model38 on letter_letter (cost=0.42..20.83 rows=8 width=4) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
42. 0.030 0.030 ↓ 0.0 0 1

Seq Scan on adso_adso (cost=0.00..3.80 rows=1 width=4) (actual time=0.030..0.030 rows=0 loops=1)

  • Filter: (active AND (hr_employee_id = 1))
  • Rows Removed by Filter: 64
43. 0.021 0.021 ↓ 0.0 0 1

Index Scan using vaccination_vaccination_hr_employee_id_idx on vaccination_vaccination (cost=0.42..9.80 rows=7 width=4) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
44. 0.039 0.039 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model41 on record_record (cost=0.43..24.38 rows=10 width=4) (actual time=0.039..0.039 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
45. 0.013 0.013 ↓ 0.0 0 1

Index Scan using reprimand_reprimand_hr_employee_id_idx on reprimand_reprimand (cost=0.29..8.30 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
46. 0.015 0.015 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model43 on previous_travel (cost=0.29..10.08 rows=2 width=4) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
47. 0.018 0.018 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model44 on employee_language (cost=0.42..10.21 rows=2 width=4) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
48. 0.021 0.021 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model45 on request_request (cost=0.42..15.53 rows=5 width=4) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
49. 0.031 0.031 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model46 on reference_reference (cost=0.42..10.21 rows=2 width=4) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
50. 0.013 0.013 ↓ 0.0 0 1

Index Scan using weapon_weapon_hr_employee_id_idx on weapon_weapon (cost=0.27..8.29 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
51. 0.023 0.023 ↓ 0.0 0 1

Index Scan using supplies_equipment_hr_employee_id_idx on supplies_equipment (cost=0.42..28.14 rows=15 width=4) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
52. 0.014 0.014 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model49 on award_award (cost=0.29..10.08 rows=2 width=4) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
53. 0.020 0.020 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model50 on injuries_injuries (cost=0.15..8.17 rows=1 width=4) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
54. 0.018 0.018 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model51 on education_education (cost=0.42..10.21 rows=2 width=4) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
55. 0.012 0.012 ↓ 0.0 0 1

Index Scan using escape_escape_hr_employee_id_idx on escape_escape (cost=0.28..8.29 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
56. 0.017 0.017 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model53 on training_training (cost=0.42..10.21 rows=2 width=4) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
57. 0.023 0.023 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model54 on other_other (cost=0.42..11.99 rows=3 width=4) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
58. 0.035 0.035 ↓ 0.0 0 1

Index Scan using medical_history_hr_employee_id_idx on medical_history (cost=0.43..25.15 rows=17 width=4) (actual time=0.035..0.035 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
59. 0.014 0.014 ↓ 0.0 0 1

Index Scan using casualty_casualty_hr_employee_id_idx on casualty_casualty (cost=0.28..8.29 rows=1 width=4) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
60. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on benificiaries_benificiaries (cost=0.00..1.06 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (active AND (hr_employee_id = 1))
  • Rows Removed by Filter: 5
61. 0.014 0.014 ↓ 0.0 0 1

Index Scan using previous_occupation_hr_employee_id_idx on previous_occupation (cost=0.28..8.29 rows=1 width=4) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
62. 0.016 0.016 ↓ 0.0 0 1

Index Scan using physical_exam_hr_employee_id_idx on physical_exam (cost=0.43..11.73 rows=17 width=4) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
63. 0.012 0.012 ↓ 0.0 0 1

Index Scan using sickness_sickness_hr_employee_id_idx on sickness_sickness (cost=0.28..8.29 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
64. 0.041 0.041 ↓ 0.0 0 1

Index Scan using relative_relative_hr_employee_id_idx1 on relative_relative (cost=0.42..9.99 rows=3 width=4) (actual time=0.041..0.041 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
65. 0.029 0.029 ↓ 0.0 0 1

Seq Scan on physical_fitness_test (cost=0.00..7.09 rows=1 width=4) (actual time=0.029..0.029 rows=0 loops=1)

  • Filter: (active AND (hr_employee_id = 1))
  • Rows Removed by Filter: 167
66. 0.021 0.021 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model63 on promotion_promotion (cost=0.42..10.21 rows=2 width=4) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
67. 0.019 0.019 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model64 on leave_leave (cost=0.43..17.30 rows=6 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
68. 0.053 0.053 ↓ 0.0 0 1

Seq Scan on personnel_separation_termination (cost=0.00..5.36 rows=1 width=4) (actual time=0.053..0.053 rows=0 loops=1)

  • Filter: (active AND (hr_employee_id = 1))
  • Rows Removed by Filter: 109
69. 0.017 0.017 ↓ 0.0 0 1

Index Scan using temp_ir_attachment_res_model66 on evaluation_evaluation (cost=0.29..10.07 rows=2 width=4) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
70. 0.037 0.037 ↓ 0.0 0 1

Index Scan using remark_remark_hr_employee_id_idx on remark_remark (cost=0.29..8.31 rows=1 width=4) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
71. 0.000 0.000 ↓ 0.0 0

Index Scan using temp_ir_attachment_res_model68 on extraordinary_promotion (cost=0.15..8.17 rows=1 width=4) (never executed)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
72. 0.000 0.000 ↓ 0.0 0

Index Scan using temp_ir_attachment_res_model69 on demotion_demotion (cost=0.15..8.17 rows=1 width=4) (never executed)

  • Index Cond: ((active = true) AND (hr_employee_id = 1))
  • Filter: active
73. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on icid_allocation (cost=0.00..1.05 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (active AND (hr_employee_id = 1))
  • Rows Removed by Filter: 4
74. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on hr_msc_docs (cost=0.00..1.24 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (active AND (hr_employee_id = 1))
  • Rows Removed by Filter: 19
75. 0.000 0.000 ↓ 0.0 0

Index Scan using legal_attorney_disabled_hr_employee_id_idx on legal_attorney_disabled (cost=0.14..8.16 rows=1 width=4) (never executed)

  • Index Cond: (hr_employee_id = 1)
  • Filter: active
Planning time : 133.328 ms
Execution time : 21,178.014 ms