explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vE2u

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 12.499 ↑ 1.6 5 1

Sort (cost=528.17..528.19 rows=8 width=2,397) (actual time=12.498..12.499 rows=5 loops=1)

  • Sort Key: request_br.br_id, req.function_id
  • Sort Method: quicksort Memory: 27kB
2.          

CTE period_hours

3. 2.188 2.510 ↑ 1.0 1,257 1

Hash Left Join (cost=5.32..98.00 rows=1,257 width=72) (actual time=0.135..2.510 rows=1,257 loops=1)

  • Hash Cond: (adp.duty_type_id = adtd.duty_type_id)
4. 0.216 0.216 ↑ 1.0 1,257 1

Seq Scan on aux_duty_period adp (cost=0.00..23.57 rows=1,257 width=32) (actual time=0.005..0.216 rows=1,257 loops=1)

5. 0.018 0.106 ↑ 1.0 62 1

Hash (cost=4.55..4.55 rows=62 width=32) (actual time=0.106..0.106 rows=62 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
6. 0.041 0.088 ↑ 1.0 62 1

Hash Left Join (cost=1.74..4.55 rows=62 width=32) (actual time=0.049..0.088 rows=62 loops=1)

  • Hash Cond: (adtd.dcc_svc = sd.dcc_id)
7. 0.018 0.018 ↑ 1.0 62 1

Seq Scan on aux_duty_type_dyn adtd (cost=0.00..2.62 rows=62 width=32) (actual time=0.005..0.018 rows=62 loops=1)

8. 0.010 0.029 ↑ 1.0 33 1

Hash (cost=1.33..1.33 rows=33 width=16) (actual time=0.028..0.029 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.019 0.019 ↑ 1.0 33 1

Seq Scan on sys_dcc sd (cost=0.00..1.33 rows=33 width=16) (actual time=0.013..0.019 rows=33 loops=1)

10.          

CTE period_hours_sum

11. 1.399 4.541 ↓ 4.1 817 1

HashAggregate (cost=44.00..46.50 rows=200 width=72) (actual time=4.139..4.541 rows=817 loops=1)

  • Group Key: period_hours.duty_id, period_hours.valid_from, period_hours.valid_to
12. 3.142 3.142 ↑ 1.0 1,257 1

CTE Scan on period_hours (cost=0.00..25.14 rows=1,257 width=72) (actual time=0.136..3.142 rows=1,257 loops=1)

13.          

CTE agencies

14. 0.246 0.246 ↑ 1.0 515 1

Seq Scan on br_dyn (cost=0.00..21.72 rows=516 width=25) (actual time=0.006..0.246 rows=515 loops=1)

  • Filter: ((now() >= valid_from) AND (now() <= valid_to))
  • Rows Removed by Filter: 21
15. 0.026 12.462 ↑ 1.6 5 1

GroupAggregate (cost=360.98..361.84 rows=8 width=2,397) (actual time=12.449..12.462 rows=5 loops=1)

  • Group Key: req.flex_request_id, planner.account_id, req_qualification.qualification_id, aux_value_1.code, (COALESCE(requested_translation_1.name, default_translation_1.name)), pref_employee.nr, pref_employee.name_informal, req_pref_employee.created_by, (COALESCE(requested_translation.name, default_translation.name)), aux_note.note_id, req_pref_employee.emp_id, request_br_dyn.br_dyn_id, request_br.br_id, p.pool_id, request_br_link_duty.code, request_br_link_duty.color_code, request_duty.duty_id, request_function.function_id, employee.emp_id, emp_function.function_id, asked_employees.emp_id, br_link_cluster.cluster_id, request_br.remarks, flex_request_agency_notification.br_id, flex_request_agency_notification.sent_user_id, flex_request_agency_notification.sent_time, flex_request_agency_notification.email_address, flex_request_agency_notification.retract_user_id, flex_request_agency_notification.retract_time, agencies.agency_name
16. 0.060 12.436 ↑ 1.1 7 1

Sort (cost=360.98..361.00 rows=8 width=2,191) (actual time=12.436..12.436 rows=7 loops=1)

  • Sort Key: req.flex_request_id, planner.account_id, req_qualification.qualification_id, aux_value_1.code, (COALESCE(requested_translation_1.name, default_translation_1.name)), pref_employee.nr, pref_employee.name_informal, req_pref_employee.created_by, (COALESCE(requested_translation.name, default_translation.name)), aux_note.note_id, req_pref_employee.emp_id, request_br_dyn.br_dyn_id, request_br.br_id, p.pool_id, request_br_link_duty.code, request_br_link_duty.color_code, request_duty.duty_id, request_function.function_id, employee.emp_id, emp_function.function_id, asked_employees.emp_id, br_link_cluster.cluster_id, request_br.remarks, flex_request_agency_notification.br_id, flex_request_agency_notification.sent_user_id, flex_request_agency_notification.sent_time, flex_request_agency_notification.email_address, flex_request_agency_notification.retract_user_id, flex_request_agency_notification.retract_time, agencies.agency_name
  • Sort Method: quicksort Memory: 28kB
17. 0.013 12.376 ↑ 1.1 7 1

Nested Loop Left Join (cost=338.35..360.86 rows=8 width=2,191) (actual time=12.288..12.376 rows=7 loops=1)

  • Join Filter: (req_qualification.qualification_id = aux_value_1.aux_value_id)
  • Rows Removed by Join Filter: 37
18. 0.078 12.062 ↑ 1.1 7 1

Hash Right Join (cost=321.57..333.90 rows=8 width=2,069) (actual time=12.055..12.062 rows=7 loops=1)

  • Hash Cond: (agencies.agency_br_id = flex_request_agency_notification.br_id)
19. 0.420 0.420 ↑ 1.0 515 1

CTE Scan on agencies (cost=0.00..10.32 rows=516 width=126) (actual time=0.007..0.420 rows=515 loops=1)

20. 0.015 11.564 ↓ 2.3 7 1

Hash (cost=321.53..321.53 rows=3 width=1,951) (actual time=11.564..11.564 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
21. 0.009 11.549 ↓ 2.3 7 1

Nested Loop Left Join (cost=98.80..321.53 rows=3 width=1,951) (actual time=11.235..11.549 rows=7 loops=1)

22. 0.004 11.526 ↓ 2.3 7 1

Nested Loop Left Join (cost=98.65..310.21 rows=3 width=1,395) (actual time=11.222..11.526 rows=7 loops=1)

23. 0.010 11.515 ↓ 2.3 7 1

Nested Loop Left Join (cost=98.37..306.11 rows=3 width=1,371) (actual time=11.216..11.515 rows=7 loops=1)

24. 0.006 11.491 ↓ 2.3 7 1

Nested Loop Left Join (cost=98.10..289.60 rows=3 width=1,352) (actual time=11.203..11.491 rows=7 loops=1)

25. 0.003 11.460 ↓ 1.7 5 1

Nested Loop Left Join (cost=97.82..280.30 rows=3 width=1,344) (actual time=11.193..11.460 rows=5 loops=1)

26. 0.009 11.432 ↓ 1.7 5 1

Nested Loop Left Join (cost=97.55..261.38 rows=3 width=1,324) (actual time=11.173..11.432 rows=5 loops=1)

27. 0.007 11.368 ↓ 1.7 5 1

Nested Loop Left Join (cost=97.27..247.26 rows=3 width=1,275) (actual time=11.145..11.368 rows=5 loops=1)

28. 0.010 10.996 ↓ 1.7 5 1

Nested Loop Left Join (cost=96.99..229.56 rows=3 width=1,276) (actual time=10.797..10.996 rows=5 loops=1)

29. 0.021 10.941 ↓ 1.7 5 1

Hash Left Join (cost=96.72..214.27 rows=3 width=1,256) (actual time=10.788..10.941 rows=5 loops=1)

  • Hash Cond: (req.duty_id = period_hours_sum.duty_id)
  • Join Filter: (((period_hours_sum.valid_from <= req.date) AND (period_hours_sum.valid_to >= req.date)) OR (period_hours_sum.valid_from IS NULL))
30. 0.008 5.761 ↑ 1.0 3 1

Nested Loop Left Join (cost=90.22..207.64 rows=3 width=1,208) (actual time=5.613..5.761 rows=3 loops=1)

31. 0.004 5.117 ↑ 1.0 3 1

Nested Loop Left Join (cost=90.08..191.52 rows=3 width=1,170) (actual time=5.006..5.117 rows=3 loops=1)

32. 0.005 5.110 ↑ 1.0 3 1

Nested Loop Left Join (cost=89.80..190.61 rows=3 width=1,145) (actual time=5.000..5.110 rows=3 loops=1)

33. 0.003 5.102 ↑ 1.0 3 1

Nested Loop Left Join (cost=89.52..168.05 rows=3 width=1,137) (actual time=4.995..5.102 rows=3 loops=1)

34. 0.007 5.093 ↑ 1.0 3 1

Nested Loop Left Join (cost=89.24..138.34 rows=3 width=1,108) (actual time=4.989..5.093 rows=3 loops=1)

  • Join Filter: (req.reason_av_id = aux_value.aux_value_id)
  • Rows Removed by Join Filter: 21
35. 0.025 4.750 ↑ 1.0 3 1

Hash Left Join (cost=72.39..111.66 rows=3 width=998) (actual time=4.719..4.750 rows=3 loops=1)

  • Hash Cond: (req.br_id = br_link_cluster.br_id)
36. 0.003 4.705 ↑ 1.0 3 1

Nested Loop Left Join (cost=70.97..110.21 rows=3 width=990) (actual time=4.675..4.705 rows=3 loops=1)

37. 0.003 4.669 ↑ 1.0 3 1

Nested Loop Left Join (cost=70.69..87.72 rows=3 width=966) (actual time=4.658..4.669 rows=3 loops=1)

38. 0.003 4.663 ↑ 1.0 3 1

Nested Loop Left Join (cost=70.41..79.88 rows=3 width=946) (actual time=4.655..4.663 rows=3 loops=1)

  • Join Filter: (request_br.pool_id = p.pool_id)
  • Rows Removed by Join Filter: 15
39. 0.017 4.633 ↑ 1.0 3 1

Hash Join (cost=70.41..78.36 rows=3 width=728) (actual time=4.628..4.633 rows=3 loops=1)

  • Hash Cond: (req.br_id = request_br.br_id)
40. 0.061 0.135 ↑ 3.3 3 1

Hash Right Join (cost=10.43..18.32 rows=10 width=196) (actual time=0.132..0.135 rows=3 loops=1)

  • Hash Cond: (flex_asked_employee.flex_request_id = req.flex_request_id)
41. 0.045 0.045 ↑ 1.0 387 1

Seq Scan on flex_asked_employee (cost=0.00..6.87 rows=387 width=16) (actual time=0.007..0.045 rows=387 loops=1)

42. 0.005 0.029 ↑ 3.3 3 1

Hash (cost=10.31..10.31 rows=10 width=188) (actual time=0.029..0.029 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
43. 0.024 0.024 ↑ 3.3 3 1

Index Scan using flex_request_date on flex_request req (cost=0.28..10.31 rows=10 width=188) (actual time=0.021..0.024 rows=3 loops=1)

  • Index Cond: ((date >= '2019-12-29 23:00:00+00'::timestamp with time zone) AND (date <= '2020-01-26 22:59:00+00'::timestamp with time zone))
44. 0.100 4.481 ↓ 35.1 527 1

Hash (cost=59.79..59.79 rows=15 width=532) (actual time=4.481..4.481 rows=527 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
45. 0.097 4.381 ↓ 35.1 527 1

Subquery Scan on request_br (cost=59.49..59.79 rows=15 width=532) (actual time=3.768..4.381 rows=527 loops=1)

46. 2.572 4.284 ↓ 35.1 527 1

HashAggregate (cost=59.49..59.64 rows=15 width=7,830) (actual time=3.768..4.284 rows=527 loops=1)

  • Group Key: br_business_relation.location, br_business_relation.adr_res_street, br_business_relation.issues, br_business_relation.com_phone, br_business_relation.budget_keeper, br_business_relation.br_type_svc, br_business_relation.emp_pool_id, br_business_relation.adr_res_postal_code, br_business_relation.com_email_cc, br_business_relation.com_email, br_business_relation.com_telefax, br_business_relation.location_id, br_business_relation.target_group, br_business_relation.remarks, br_business_relation.adr_res_country_code, br_business_relation.wca_description, br_business_relation.code_temp, br_business_relation.br_category_svc, br_business_relation.pool_id, br_business_relation.br_id, br_business_relation.flags, br_business_relation.adr_res_city, br_business_relation.manager, br_business_relation.target_group_av_id, br_business_relation.sort_order_agency, br_business_relation.roster_changed_timestamp, br_business_relation.com_sms, br_business_relation.color_code, br_business_relation.act_insignificant_plan_period, br_business_relation.rcr_com_email, br_business_relation.rcr_com_phone, br_business_relation.act_default_show_rule_def, br_business_relation.rcr_name, br_business_relation.act_plan_horizon_days, br_business_relation.rcr_issues, br_business_relation.rcr_com_sms, br_business_relation.ros_view_emp_name, br_business_relation.ros_sort_emp_name, br_business_relation.privileged_email_address, br_business_relation.visible_until
47. 0.109 1.712 ↓ 70.3 1,055 1

Append (cost=0.85..57.99 rows=15 width=7,830) (actual time=0.416..1.712 rows=1,055 loops=1)

48. 0.003 0.673 ↑ 1.0 1 1

Nested Loop (cost=0.85..19.19 rows=1 width=2,362) (actual time=0.416..0.673 rows=1 loops=1)

49. 0.006 0.652 ↓ 3.0 3 1

Nested Loop (cost=0.57..18.88 rows=1 width=8) (actual time=0.396..0.652 rows=3 loops=1)

50. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on acc_grant_catalog (cost=0.00..2.25 rows=1 width=8) (actual time=0.007..0.013 rows=1 loops=1)

  • Filter: (((type)::text = 'DATA'::text) AND ((name)::text = 'COST_CENTER'::text))
  • Rows Removed by Filter: 82
51. 0.005 0.633 ↓ 3.0 3 1

Nested Loop (cost=0.57..16.63 rows=1 width=16) (actual time=0.384..0.633 rows=3 loops=1)

52. 0.068 0.068 ↓ 5.0 5 1

Index Scan using acc_account_group_idx on acc_account_group (cost=0.29..8.31 rows=1 width=8) (actual time=0.044..0.068 rows=5 loops=1)

  • Index Cond: (account_id = (current_setting('aysist.uid'::text))::bigint)
  • Filter: ""overlaps""(now(), now(), valid_from, valid_to)
53. 0.560 0.560 ↑ 1.0 1 5

Index Only Scan using acc_grant_unique_group_grant_catalog_access_code on acc_grant (cost=0.28..8.30 rows=1 width=24) (actual time=0.110..0.112 rows=1 loops=5)

  • Index Cond: ((group_id = acc_account_group.group_id) AND (grant_catalog_id = acc_grant_catalog.grant_catalog_id))
  • Heap Fetches: 3
54. 0.018 0.018 ↓ 0.0 0 3

Index Scan using pk_br_business_relation on br_business_relation (cost=0.28..0.30 rows=1 width=2,362) (actual time=0.006..0.006 rows=0 loops=3)

  • Index Cond: (br_id = acc_grant.access_code)
55. 0.573 0.930 ↓ 75.3 1,054 1

Nested Loop (cost=0.72..38.57 rows=14 width=2,362) (actual time=0.178..0.930 rows=1,054 loops=1)

56. 0.018 0.183 ↓ 2.0 2 1

Nested Loop (cost=0.72..17.03 rows=1 width=0) (actual time=0.173..0.183 rows=2 loops=1)

57. 0.013 0.097 ↓ 34.0 68 1

Nested Loop (cost=0.57..16.66 rows=2 width=8) (actual time=0.026..0.097 rows=68 loops=1)

58. 0.019 0.019 ↓ 5.0 5 1

Index Scan using acc_account_group_idx on acc_account_group acc_account_group_1 (cost=0.29..8.31 rows=1 width=8) (actual time=0.015..0.019 rows=5 loops=1)

  • Index Cond: (account_id = (current_setting('aysist.uid'::text))::bigint)
  • Filter: ""overlaps""(now(), now(), valid_from, valid_to)
59. 0.065 0.065 ↓ 14.0 14 5

Index Only Scan using acc_grant_unique_group_grant_catalog_access_code on acc_grant acc_grant_1 (cost=0.28..8.33 rows=1 width=16) (actual time=0.004..0.013 rows=14 loops=5)

  • Index Cond: ((group_id = acc_account_group_1.group_id) AND (access_code IS NULL))
  • Heap Fetches: 68
60. 0.068 0.068 ↓ 0.0 0 68

Index Scan using pk_acc_grant_catalog on acc_grant_catalog acc_grant_catalog_1 (cost=0.14..0.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=68)

  • Index Cond: (grant_catalog_id = acc_grant_1.grant_catalog_id)
  • Filter: (((type)::text = 'DATA'::text) AND ((name)::text = 'COST_CENTER'::text))
  • Rows Removed by Filter: 1
61. 0.174 0.174 ↑ 1.0 527 2

Seq Scan on br_business_relation br_business_relation_1 (cost=0.00..16.27 rows=527 width=2,362) (actual time=0.003..0.087 rows=527 loops=2)

62. 0.009 0.027 ↑ 1.5 6 3

Materialize (cost=0.00..1.14 rows=9 width=226) (actual time=0.008..0.009 rows=6 loops=3)

63. 0.018 0.018 ↑ 1.5 6 1

Seq Scan on aux_pool p (cost=0.00..1.09 rows=9 width=226) (actual time=0.017..0.018 rows=6 loops=1)

64. 0.003 0.003 ↓ 0.0 0 3

Index Scan using pk_emp_employee on emp_employee asked_employees (cost=0.28..2.61 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=3)

  • Index Cond: (flex_asked_employee.emp_id = emp_id)
65. 0.033 0.033 ↑ 1.0 1 3

Index Scan using acc_account_c94df7 on acc_account planner (cost=0.28..7.50 rows=1 width=32) (actual time=0.011..0.011 rows=1 loops=3)

  • Index Cond: (req.planner_id = account_id)
66. 0.007 0.020 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=16) (actual time=0.020..0.020 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
67. 0.013 0.013 ↑ 1.0 19 1

Seq Scan on br_link_cluster (cost=0.00..1.19 rows=19 width=16) (actual time=0.011..0.013 rows=19 loops=1)

68. 0.007 0.336 ↑ 1.0 8 3

Materialize (cost=16.84..26.34 rows=8 width=126) (actual time=0.089..0.112 rows=8 loops=3)

69. 0.015 0.329 ↑ 1.0 8 1

Hash Left Join (cost=16.84..26.30 rows=8 width=126) (actual time=0.262..0.329 rows=8 loops=1)

  • Hash Cond: (aux_value.aux_value_id = requested_translation.aux_value_id)
70. 0.051 0.163 ↑ 1.0 8 1

Hash Right Join (cost=7.41..16.84 rows=8 width=21) (actual time=0.099..0.163 rows=8 loops=1)

  • Hash Cond: (default_translation.aux_value_id = aux_value.aux_value_id)
71. 0.061 0.061 ↑ 1.0 355 1

Seq Scan on aux_value_translation default_translation (cost=0.00..8.49 rows=355 width=21) (actual time=0.005..0.061 rows=355 loops=1)

  • Filter: ((language_code)::text = 'nl'::text)
  • Rows Removed by Filter: 4
72. 0.004 0.051 ↑ 1.0 8 1

Hash (cost=7.31..7.31 rows=8 width=16) (actual time=0.051..0.051 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
73. 0.013 0.047 ↑ 1.0 8 1

Bitmap Heap Scan on aux_value (cost=4.21..7.31 rows=8 width=16) (actual time=0.037..0.047 rows=8 loops=1)

  • Recheck Cond: (aux_value_group_id = 3)
  • Heap Blocks: exact=2
74. 0.034 0.034 ↑ 1.0 8 1

Bitmap Index Scan on "aux_value_98FB6B" (cost=0.00..4.21 rows=8 width=0) (actual time=0.034..0.034 rows=8 loops=1)

  • Index Cond: (aux_value_group_id = 3)
75. 0.006 0.151 ↑ 1.0 4 1

Hash (cost=9.38..9.38 rows=4 width=21) (actual time=0.151..0.151 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
76. 0.145 0.145 ↑ 1.0 4 1

Seq Scan on aux_value_translation requested_translation (cost=0.00..9.38 rows=4 width=21) (actual time=0.023..0.145 rows=4 loops=1)

  • Filter: ((language_code)::text = current_setting('aysist.language'::text))
  • Rows Removed by Filter: 355
77. 0.006 0.006 ↓ 0.0 0 3

Index Scan using emp_employee_f78e0e on emp_employee employee (cost=0.28..7.50 rows=1 width=37) (actual time=0.002..0.002 rows=0 loops=3)

  • Index Cond: (emp_id = req.emp_id)
78. 0.003 0.003 ↓ 0.0 0 3

Index Scan using emp_benefit_dbc89b on emp_benefit (cost=0.28..7.51 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3)

  • Index Cond: (req.emp_wa_id = wa_id)
  • Filter: ((valid_from <= req.date) AND (valid_to > req.date) AND ((flags & 4) <> 4))
79. 0.003 0.003 ↓ 0.0 0 3

Index Scan using pk_aux_function on aux_function emp_function (cost=0.28..0.31 rows=1 width=33) (actual time=0.001..0.001 rows=0 loops=3)

  • Index Cond: (emp_benefit.function_id = function_id)
80. 0.636 0.636 ↑ 1.0 1 3

Index Scan using unique_br_dyn on br_dyn request_br_dyn (cost=0.14..5.36 rows=1 width=62) (actual time=0.212..0.212 rows=1 loops=3)

  • Index Cond: (br_id = req.br_id)
  • Filter: ""overlaps""(req.date, req.date, valid_from, valid_to)
81. 0.184 5.159 ↓ 4.1 817 1

Hash (cost=4.00..4.00 rows=200 width=72) (actual time=5.159..5.159 rows=817 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
82. 4.975 4.975 ↓ 4.1 817 1

CTE Scan on period_hours_sum (cost=0.00..4.00 rows=200 width=72) (actual time=4.141..4.975 rows=817 loops=1)

83. 0.045 0.045 ↑ 1.0 1 5

Index Scan using aux_duty_25df75 on aux_duty request_duty (cost=0.28..5.09 rows=1 width=20) (actual time=0.009..0.009 rows=1 loops=5)

  • Index Cond: (duty_id = req.duty_id)
84. 0.365 0.365 ↓ 0.0 0 5

Index Scan using br_link_duty_412512 on br_link_duty request_br_link_duty (cost=0.28..5.90 rows=1 width=23) (actual time=0.073..0.073 rows=0 loops=5)

  • Index Cond: ((br_id = req.br_id) AND (duty_id = req.duty_id))
85. 0.055 0.055 ↑ 1.0 1 5

Index Scan using pk_aux_function on aux_function request_function (cost=0.28..4.70 rows=1 width=65) (actual time=0.011..0.011 rows=1 loops=5)

  • Index Cond: (function_id = req.function_id)
  • Filter: ((valid_from <= req.date) AND (valid_to >= req.date))
86. 0.025 0.025 ↓ 0.0 0 5

Index Scan using aux_note_idx on aux_note (cost=0.28..6.30 rows=1 width=28) (actual time=0.005..0.005 rows=0 loops=5)

  • Index Cond: ((ref_id = req.request_id) AND ((type)::text = 'REQ_REQUEST'::text))
87. 0.025 0.025 ↑ 1.0 1 5

Index Only Scan using pk_req_qualification on req_qualification (cost=0.27..3.09 rows=1 width=16) (actual time=0.004..0.005 rows=1 loops=5)

  • Index Cond: (request_id = req.request_id)
  • Heap Fetches: 5
88. 0.014 0.014 ↓ 0.0 0 7

Index Only Scan using pk_req_pref_employee on req_pref_employee (cost=0.28..5.49 rows=1 width=27) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (request_id = req.request_id)
  • Heap Fetches: 0
89. 0.007 0.007 ↓ 0.0 0 7

Index Scan using pk_emp_employee on emp_employee pref_employee (cost=0.28..1.37 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (req_pref_employee.emp_id = emp_id)
90. 0.014 0.014 ↓ 0.0 0 7

Index Scan using flex_request_agency_notification_flex_request_id on flex_request_agency_notification (cost=0.14..3.76 rows=1 width=564) (actual time=0.002..0.002 rows=0 loops=7)

  • Index Cond: (flex_request_id = req.flex_request_id)
91. 0.007 0.301 ↑ 1.0 6 7

Materialize (cost=16.78..26.26 rows=6 width=130) (actual time=0.031..0.043 rows=6 loops=7)

92. 0.016 0.294 ↑ 1.0 6 1

Hash Left Join (cost=16.78..26.23 rows=6 width=130) (actual time=0.214..0.294 rows=6 loops=1)

  • Hash Cond: (aux_value_1.aux_value_id = requested_translation_1.aux_value_id)
93. 0.053 0.141 ↑ 1.0 6 1

Hash Right Join (cost=7.34..16.77 rows=6 width=25) (actual time=0.062..0.141 rows=6 loops=1)

  • Hash Cond: (default_translation_1.aux_value_id = aux_value_1.aux_value_id)
94. 0.058 0.058 ↑ 1.0 355 1

Seq Scan on aux_value_translation default_translation_1 (cost=0.00..8.49 rows=355 width=21) (actual time=0.005..0.058 rows=355 loops=1)

  • Filter: ((language_code)::text = 'nl'::text)
  • Rows Removed by Filter: 4
95. 0.005 0.030 ↑ 1.0 6 1

Hash (cost=7.27..7.27 rows=6 width=20) (actual time=0.030..0.030 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
96. 0.016 0.025 ↑ 1.0 6 1

Bitmap Heap Scan on aux_value aux_value_1 (cost=4.19..7.27 rows=6 width=20) (actual time=0.012..0.025 rows=6 loops=1)

  • Recheck Cond: (aux_value_group_id = 5)
  • Heap Blocks: exact=3
97. 0.009 0.009 ↑ 1.0 6 1

Bitmap Index Scan on "aux_value_98FB6B" (cost=0.00..4.19 rows=6 width=0) (actual time=0.009..0.009 rows=6 loops=1)

  • Index Cond: (aux_value_group_id = 5)
98. 0.003 0.137 ↑ 1.0 4 1

Hash (cost=9.38..9.38 rows=4 width=21) (actual time=0.137..0.137 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
99. 0.134 0.134 ↑ 1.0 4 1

Seq Scan on aux_value_translation requested_translation_1 (cost=0.00..9.38 rows=4 width=21) (actual time=0.026..0.134 rows=4 loops=1)

  • Filter: ((language_code)::text = current_setting('aysist.language'::text))
  • Rows Removed by Filter: 355
Planning time : 30.084 ms
Execution time : 13.828 ms