explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oZ3G

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 11.270 ↓ 1.7 5 1

Sort (cost=481.53..481.54 rows=3 width=1,605) (actual time=11.269..11.270 rows=5 loops=1)

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

CTE period_hours

3. 2.447 2.702 ↑ 1.0 1,257 1

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

  • Hash Cond: (adp.duty_type_id = adtd.duty_type_id)
4. 0.174 0.174 ↑ 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.007..0.174 rows=1,257 loops=1)

5. 0.014 0.081 ↑ 1.0 62 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
6. 0.035 0.067 ↑ 1.0 62 1

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

  • Hash Cond: (adtd.dcc_svc = sd.dcc_id)
7. 0.013 0.013 ↑ 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.013 rows=62 loops=1)

8. 0.007 0.019 ↑ 1.0 33 1

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

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

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

10.          

CTE period_hours_sum

11. 1.559 4.893 ↓ 4.1 817 1

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

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

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

13. 0.034 11.255 ↓ 1.7 5 1

GroupAggregate (cost=336.75..337.02 rows=3 width=1,605) (actual time=11.240..11.255 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
14. 0.038 11.221 ↓ 2.3 7 1

Sort (cost=336.75..336.75 rows=3 width=1,517) (actual time=11.220..11.221 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
  • Sort Method: quicksort Memory: 28kB
15. 0.007 11.183 ↓ 2.3 7 1

Nested Loop Left Join (cost=115.43..336.72 rows=3 width=1,517) (actual time=10.913..11.183 rows=7 loops=1)

16. 0.009 11.169 ↓ 2.3 7 1

Nested Loop Left Join (cost=115.15..332.62 rows=3 width=1,493) (actual time=10.906..11.169 rows=7 loops=1)

17. 0.018 11.146 ↓ 2.3 7 1

Nested Loop Left Join (cost=114.88..316.12 rows=3 width=1,474) (actual time=10.895..11.146 rows=7 loops=1)

  • Join Filter: (req_qualification.qualification_id = aux_value_1.aux_value_id)
  • Rows Removed by Join Filter: 37
18. 0.007 10.799 ↓ 2.3 7 1

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

19. 0.008 10.757 ↓ 1.7 5 1

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

20. 0.005 10.729 ↓ 1.7 5 1

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

21. 0.005 10.704 ↓ 1.7 5 1

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

22. 0.011 10.679 ↓ 1.7 5 1

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

23. 0.014 10.648 ↓ 1.7 5 1

Hash Left Join (cost=96.72..214.27 rows=3 width=1,256) (actual time=10.491..10.648 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))
24. 0.009 4.999 ↑ 1.0 3 1

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

25. 0.006 4.951 ↑ 1.0 3 1

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

26. 0.004 4.945 ↑ 1.0 3 1

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

27. 0.007 4.938 ↑ 1.0 3 1

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

28. 0.007 4.931 ↑ 1.0 3 1

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

  • Join Filter: (req.reason_av_id = aux_value.aux_value_id)
  • Rows Removed by Join Filter: 21
29. 0.010 4.621 ↑ 1.0 3 1

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

  • Hash Cond: (req.br_id = br_link_cluster.br_id)
30. 0.006 4.600 ↑ 1.0 3 1

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

31. 0.005 4.582 ↑ 1.0 3 1

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

32. 0.009 4.574 ↑ 1.0 3 1

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

  • Join Filter: (request_br.pool_id = p.pool_id)
  • Rows Removed by Join Filter: 15
33. 0.008 4.556 ↑ 1.0 3 1

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

  • Hash Cond: (req.br_id = request_br.br_id)
34. 0.084 0.168 ↑ 3.3 3 1

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

  • Hash Cond: (flex_asked_employee.flex_request_id = req.flex_request_id)
35. 0.059 0.059 ↑ 1.0 387 1

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

36. 0.004 0.025 ↑ 3.3 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 0.021 0.021 ↑ 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.016..0.021 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))
38. 0.102 4.380 ↓ 35.1 527 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
39. 0.113 4.278 ↓ 35.1 527 1

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

40. 2.950 4.165 ↓ 35.1 527 1

HashAggregate (cost=59.49..59.64 rows=15 width=7,830) (actual time=3.562..4.165 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
41. 0.128 1.215 ↓ 70.3 1,055 1

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

42. 0.003 0.065 ↑ 1.0 1 1

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

43. 0.008 0.056 ↓ 3.0 3 1

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

44. 0.014 0.014 ↑ 1.0 1 1

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

  • Filter: (((type)::text = 'DATA'::text) AND ((name)::text = 'COST_CENTER'::text))
  • Rows Removed by Filter: 82
45. 0.003 0.034 ↓ 3.0 3 1

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

46. 0.011 0.011 ↓ 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.006..0.011 rows=5 loops=1)

  • Index Cond: (account_id = (current_setting('aysist.uid'::text))::bigint)
  • Filter: ""overlaps""(now(), now(), valid_from, valid_to)
47. 0.020 0.020 ↑ 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.003..0.004 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
48. 0.006 0.006 ↓ 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.002..0.002 rows=0 loops=3)

  • Index Cond: (br_id = acc_grant.access_code)
49. 0.698 1.022 ↓ 75.3 1,054 1

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

50. 0.027 0.160 ↓ 2.0 2 1

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

51. 0.016 0.065 ↓ 34.0 68 1

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

52. 0.009 0.009 ↓ 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.005..0.009 rows=5 loops=1)

  • Index Cond: (account_id = (current_setting('aysist.uid'::text))::bigint)
  • Filter: ""overlaps""(now(), now(), valid_from, valid_to)
53. 0.040 0.040 ↓ 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.003..0.008 rows=14 loops=5)

  • Index Cond: ((group_id = acc_account_group_1.group_id) AND (access_code IS NULL))
  • Heap Fetches: 68
54. 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
55. 0.164 0.164 ↑ 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.082 rows=527 loops=2)

56. 0.003 0.009 ↑ 1.5 6 3

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

57. 0.006 0.006 ↑ 1.5 6 1

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

58. 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)
59. 0.012 0.012 ↑ 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.004..0.004 rows=1 loops=3)

  • Index Cond: (req.planner_id = account_id)
60. 0.004 0.011 ↑ 1.0 19 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
61. 0.007 0.007 ↑ 1.0 19 1

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

62. 0.005 0.303 ↑ 1.0 8 3

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

63. 0.008 0.298 ↑ 1.0 8 1

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

  • Hash Cond: (aux_value.aux_value_id = requested_translation.aux_value_id)
64. 0.050 0.135 ↑ 1.0 8 1

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

  • Hash Cond: (default_translation.aux_value_id = aux_value.aux_value_id)
65. 0.069 0.069 ↑ 1.0 355 1

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

  • Filter: ((language_code)::text = 'nl'::text)
  • Rows Removed by Filter: 4
66. 0.003 0.016 ↑ 1.0 8 1

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

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

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

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

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

  • Index Cond: (aux_value_group_id = 3)
69. 0.002 0.155 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
70. 0.153 0.153 ↑ 1.0 4 1

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

  • Filter: ((language_code)::text = current_setting('aysist.language'::text))
  • Rows Removed by Filter: 355
71. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=3)

  • Index Cond: (emp_id = req.emp_id)
72. 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))
73. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=3)

  • Index Cond: (emp_benefit.function_id = function_id)
74. 0.039 0.039 ↑ 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.012..0.013 rows=1 loops=3)

  • Index Cond: (br_id = req.br_id)
  • Filter: ""overlaps""(req.date, req.date, valid_from, valid_to)
75. 0.249 5.635 ↓ 4.1 817 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
76. 5.386 5.386 ↓ 4.1 817 1

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

77. 0.020 0.020 ↑ 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.004..0.004 rows=1 loops=5)

  • Index Cond: (duty_id = req.duty_id)
78. 0.020 0.020 ↓ 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.004..0.004 rows=0 loops=5)

  • Index Cond: ((br_id = req.br_id) AND (duty_id = req.duty_id))
79. 0.020 0.020 ↑ 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.004..0.004 rows=1 loops=5)

  • Index Cond: (function_id = req.function_id)
  • Filter: ((valid_from <= req.date) AND (valid_to >= req.date))
80. 0.020 0.020 ↓ 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.004..0.004 rows=0 loops=5)

  • Index Cond: ((ref_id = req.request_id) AND ((type)::text = 'REQ_REQUEST'::text))
81. 0.035 0.035 ↑ 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.006..0.007 rows=1 loops=5)

  • Index Cond: (request_id = req.request_id)
  • Heap Fetches: 5
82. 0.005 0.329 ↑ 1.0 6 7

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

83. 0.016 0.324 ↑ 1.0 6 1

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

  • Hash Cond: (aux_value_1.aux_value_id = requested_translation_1.aux_value_id)
84. 0.062 0.153 ↑ 1.0 6 1

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

  • Hash Cond: (default_translation_1.aux_value_id = aux_value_1.aux_value_id)
85. 0.068 0.068 ↑ 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.009..0.068 rows=355 loops=1)

  • Filter: ((language_code)::text = 'nl'::text)
  • Rows Removed by Filter: 4
86. 0.004 0.023 ↑ 1.0 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
87. 0.009 0.019 ↑ 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.015..0.019 rows=6 loops=1)

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

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

  • Index Cond: (aux_value_group_id = 5)
89. 0.004 0.155 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
90. 0.151 0.151 ↑ 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.027..0.151 rows=4 loops=1)

  • Filter: ((language_code)::text = current_setting('aysist.language'::text))
  • Rows Removed by Filter: 355
91. 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
92. 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)
Planning time : 18.217 ms
Execution time : 11.923 ms