explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cnbg

Settings
# exclusive inclusive rows x rows loops node
1. 22.608 1,575,485.102 ↓ 0.0 0 1

Nested Loop Semi Join (cost=2,261.66..19,294,110.15 rows=1 width=561) (actual time=1,575,485.102..1,575,485.102 rows=0 loops=1)

  • Join Filter: (cbn_log_encerramento.lgr_dvcid = uat_device_1.dvc_id)
  • Rows Removed by Join Filter: 18575
2. 3.591 1,575,413.456 ↓ 743.0 743 1

Nested Loop (cost=2,219.44..19,281,722.90 rows=1 width=567) (actual time=1,544,626.158..1,575,413.456 rows=743 loops=1)

3. 17,908.911 1,575,310.303 ↓ 743.0 743 1

Nested Loop (cost=2,219.02..19,281,714.63 rows=1 width=519) (actual time=1,544,601.070..1,575,310.303 rows=743 loops=1)

  • Join Filter: (uat_cus_environment.cus_env_rolid = role_dpe.rol_id)
  • Rows Removed by Join Filter: 13586498
4. 135.333 135.333 ↑ 1.6 18,287 1

Index Scan using idx_rol_owner_empid on uat_role role_dpe (cost=0.29..109,998.40 rows=29,156 width=38) (actual time=0.009..135.333 rows=18,287 loops=1)

5. 12,930.647 1,557,266.059 ↓ 743.0 743 18,287

Materialize (cost=2,218.73..19,171,278.89 rows=1 width=493) (actual time=3.644..85.157 rows=743 loops=18,287)

6. 4.276 1,544,335.412 ↓ 743.0 743 1

Nested Loop Left Join (cost=2,218.73..19,171,278.89 rows=1 width=493) (actual time=66,622.225..1,544,335.412 rows=743 loops=1)

7. 4.111 1,544,314.047 ↓ 743.0 743 1

Nested Loop (cost=2,218.31..19,171,270.44 rows=1 width=477) (actual time=66,622.202..1,544,314.047 rows=743 loops=1)

8. 4.612 1,544,304.735 ↓ 743.0 743 1

Nested Loop (cost=2,218.04..19,171,263.03 rows=1 width=465) (actual time=66,622.187..1,544,304.735 rows=743 loops=1)

9. 7.168 1,544,294.922 ↓ 743.0 743 1

Nested Loop Left Join (cost=2,217.89..19,171,258.85 rows=1 width=461) (actual time=66,622.174..1,544,294.922 rows=743 loops=1)

10. 4.272 1,543,924.427 ↓ 743.0 743 1

Nested Loop (cost=2,209.30..19,171,247.15 rows=1 width=429) (actual time=66,622.071..1,543,924.427 rows=743 loops=1)

11. 4.212 1,543,914.954 ↓ 743.0 743 1

Nested Loop (cost=2,209.03..19,171,239.52 rows=1 width=418) (actual time=66,622.055..1,543,914.954 rows=743 loops=1)

12. 4.536 1,543,904.055 ↓ 743.0 743 1

Nested Loop (cost=2,208.75..19,171,231.51 rows=1 width=388) (actual time=66,622.039..1,543,904.055 rows=743 loops=1)

13. 4.012 1,543,873.269 ↓ 750.0 750 1

Nested Loop Left Join (cost=2,208.32..19,171,223.06 rows=1 width=357) (actual time=66,622.021..1,543,873.269 rows=750 loops=1)

14. 4.564 1,543,856.507 ↓ 750.0 750 1

Nested Loop Left Join (cost=2,207.90..19,171,214.78 rows=1 width=323) (actual time=66,622.000..1,543,856.507 rows=750 loops=1)

15. 5.071 1,543,620.943 ↓ 750.0 750 1

Nested Loop Left Join (cost=2,207.33..19,171,195.55 rows=1 width=280) (actual time=66,621.926..1,543,620.943 rows=750 loops=1)

16. 8.295 1,543,596.372 ↓ 750.0 750 1

Nested Loop Left Join (cost=2,206.90..19,171,187.27 rows=1 width=246) (actual time=66,621.896..1,543,596.372 rows=750 loops=1)

17. 1,533,818.577 1,533,818.577 ↓ 750.0 750 1

Index Scan using uat_log_revalidation_lgr_userid_type_lgr_date_idx on uat_log_revalidation cbn_log_encerramento (cost=0.57..19,168,972.88 rows=1 width=170) (actual time=66,609.976..1,533,818.577 rows=750 loops=1)

  • Index Cond: ((lgr_date >= '2019-10-01'::date) AND (lgr_date <= '2019-10-02'::date))
  • Filter: (((lgr_business_need)::text = ANY ('{"Business Need Rejected - Positive Confirmation","Business Need Approved - Exhausted Escalation Process"}'::text[])) AND ((lgr_action)::text = 'Revalidation Finished'::text) AND (lgr_rev_svcid = '53'::numeric))
  • Rows Removed by Filter: 4411365
18. 993.750 9,769.500 ↑ 1.0 1 750

Bitmap Heap Scan on uat_log_revalidation cbn_log_encerramento_manager (cost=2,206.33..2,214.38 rows=1 width=110) (actual time=12.991..13.026 rows=1 loops=750)

  • Recheck Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket))
  • Filter: (((lgr_responsable_role_type)::text = 'Manager'::text) AND ((lgr_action)::text = 'Revalidation Finished'::text) AND ((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text))
  • Rows Removed by Filter: 423
  • Heap Blocks: exact=59367
19. 548.250 8,775.750 ↓ 0.0 0 750

BitmapAnd (cost=2,206.33..2,206.33 rows=2 width=0) (actual time=11.701..11.701 rows=0 loops=750)

20. 8,139.750 8,139.750 ↓ 2.1 67,505 750

Bitmap Index Scan on idx_lgr_rev_svcid_dvcid (cost=0.00..868.95 rows=31,516 width=0) (actual time=10.853..10.853 rows=67,505 loops=750)

  • Index Cond: (lgr_dvcid = cbn_log_encerramento.lgr_dvcid)
21. 87.750 87.750 ↑ 138.5 424 750

Bitmap Index Scan on idx_lgr_ticket (cost=0.00..1,337.13 rows=58,741 width=0) (actual time=0.117..0.117 rows=424 loops=750)

  • Index Cond: (lgr_ticket = cbn_log_encerramento.lgr_ticket)
22. 19.500 19.500 ↑ 1.0 1 750

Index Scan using unique_emp_cnum on uat_emp manager (cost=0.42..8.27 rows=1 width=54) (actual time=0.025..0.026 rows=1 loops=750)

  • Index Cond: ((emp_cnum)::text = (cbn_log_encerramento_manager.lgr_responsable_role_owner_cnum)::text)
23. 231.000 231.000 ↑ 1.0 1 750

Index Scan using idx_lgr_ticket on uat_log_revalidation cbn_log_encerramento_owner (cost=0.57..19.22 rows=1 width=77) (actual time=0.064..0.308 rows=1 loops=750)

  • Index Cond: ((lgr_ticket = cbn_log_encerramento.lgr_ticket) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket))
  • Filter: (((lgr_responsable_role_type)::text = 'Privilege Owner'::text) AND ((lgr_action)::text = 'Revalidation Finished'::text) AND (lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND ((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text))
  • Rows Removed by Filter: 423
24. 12.750 12.750 ↑ 1.0 1 750

Index Scan using unique_emp_cnum on uat_emp privilege_owner (cost=0.42..8.27 rows=1 width=54) (actual time=0.016..0.017 rows=1 loops=750)

  • Index Cond: ((emp_cnum)::text = (cbn_log_encerramento_owner.lgr_responsable_role_owner_cnum)::text)
25. 26.250 26.250 ↑ 1.0 1 750

Index Scan using pk_dvc_id on uat_device (cost=0.42..8.44 rows=1 width=31) (actual time=0.034..0.035 rows=1 loops=750)

  • Index Cond: (dvc_id = cbn_log_encerramento.lgr_dvcid)
26. 6.687 6.687 ↑ 1.0 1 743

Index Scan using pk_cus_env_id on uat_cus_environment (cost=0.28..8.00 rows=1 width=40) (actual time=0.007..0.009 rows=1 loops=743)

  • Index Cond: (cus_env_id = uat_device.dvc_cusenvid)
27. 5.201 5.201 ↑ 1.0 1 743

Index Scan using pk_cus_id on uat_customer (cost=0.28..7.63 rows=1 width=21) (actual time=0.006..0.007 rows=1 loops=743)

  • Index Cond: (cus_id = uat_cus_environment.cus_env_cusid)
28. 71.677 363.327 ↑ 1.0 1 743

Hash Right Join (cost=8.59..11.69 rows=1 width=48) (actual time=0.338..0.489 rows=1 loops=743)

  • Hash Cond: (acc_status.sts_id = uat_account.acc_device_stsid)
29. 56.862 56.862 ↓ 1.0 80 702

Seq Scan on uat_status acc_status (cost=0.00..2.79 rows=79 width=29) (actual time=0.004..0.081 rows=80 loops=702)

30. 3.715 234.788 ↑ 1.0 1 743

Hash (cost=8.58..8.58 rows=1 width=28) (actual time=0.316..0.316 rows=1 loops=743)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
31. 231.073 231.073 ↑ 1.0 1 743

Index Scan using unique_dvcid_username on uat_account (cost=0.56..8.58 rows=1 width=28) (actual time=0.307..0.311 rows=1 loops=743)

  • Index Cond: ((acc_dvcid = uat_device.dvc_id) AND ((cbn_log_encerramento.lgr_userid)::text = (acc_username)::text))
32. 5.201 5.201 ↑ 1.0 1 743

Index Scan using pk_ctr_id on uat_country (cost=0.14..4.16 rows=1 width=14) (actual time=0.006..0.007 rows=1 loops=743)

  • Index Cond: (ctr_id = uat_cus_environment.cus_env_ctrid)
33. 5.201 5.201 ↑ 1.0 1 743

Index Scan using pk_pla_id on uat_platform (cost=0.27..7.40 rows=1 width=22) (actual time=0.006..0.007 rows=1 loops=743)

  • Index Cond: (pla_id = uat_device.dvc_plaid)
34. 17.089 17.089 ↑ 1.0 1 743

Index Scan using idx_emp_cnum on uat_emp user_owner (cost=0.42..8.44 rows=1 width=36) (actual time=0.021..0.023 rows=1 loops=743)

  • Index Cond: ((emp_cnum)::text = (cbn_log_encerramento.lgr_userid_role_owner_cnum)::text)
35. 99.562 99.562 ↑ 1.0 1 743

Index Scan using pk_emp_id on uat_emp dpe (cost=0.42..8.27 rows=1 width=60) (actual time=0.133..0.134 rows=1 loops=743)

  • Index Cond: (emp_id = role_dpe.rol_owner_empid)
36. 19.962 49.038 ↑ 1.0 25 743

Materialize (cost=42.22..229.29 rows=25 width=6) (actual time=0.020..0.066 rows=25 loops=743)

37. 0.049 29.076 ↑ 1.0 25 1

Limit (cost=42.22..228.91 rows=25 width=6) (actual time=14.381..29.076 rows=25 loops=1)

38. 0.088 29.027 ↑ 49.0 25 1

Nested Loop (cost=42.22..9,182.71 rows=1,224 width=6) (actual time=14.376..29.027 rows=25 loops=1)

39. 9.626 9.626 ↑ 1.4 7 1

Seq Scan on uat_cus_environment uat_cus_environment_1 (cost=0.00..223.80 rows=10 width=5) (actual time=1.423..9.626 rows=7 loops=1)

  • Filter: (cus_env_cusid = '555'::numeric)
  • Rows Removed by Filter: 1764
40. 2.205 19.313 ↑ 58.0 4 7

Bitmap Heap Scan on uat_device uat_device_1 (cost=42.22..893.57 rows=232 width=11) (actual time=2.457..2.759 rows=4 loops=7)

  • Recheck Cond: (dvc_cusenvid = uat_cus_environment_1.cus_env_id)
  • Filter: (dvc_id <> ALL ('{188369,187874,495459,187878,675007,675006,495457,675013,675014}'::numeric[]))
  • Heap Blocks: exact=19
41. 17.108 17.108 ↑ 6.6 35 7

Bitmap Index Scan on idx_dvc_cusenvid (cost=0.00..42.16 rows=232 width=0) (actual time=2.444..2.444 rows=35 loops=7)

  • Index Cond: (dvc_cusenvid = uat_cus_environment_1.cus_env_id)
42.          

SubPlan (for Nested Loop Semi Join)

43. 0.000 0.000 ↓ 0.0 0

Limit (cost=2,214.38..2,214.39 rows=1 width=4) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Sort (cost=2,214.38..2,214.39 rows=1 width=4) (never executed)

  • Sort Key: log_inicio.lgr_date
45. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uat_log_revalidation log_inicio (cost=2,206.33..2,214.37 rows=1 width=4) (never executed)

  • Recheck Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket))
  • Filter: (((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text) AND ((lgr_action)::text = 'Starting Revalidation'::text))
46. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=2,206.33..2,206.33 rows=2 width=0) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_rev_svcid_dvcid (cost=0.00..868.95 rows=31,516 width=0) (never executed)

  • Index Cond: (lgr_dvcid = cbn_log_encerramento.lgr_dvcid)
48. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_ticket (cost=0.00..1,337.13 rows=58,741 width=0) (never executed)

  • Index Cond: (lgr_ticket = cbn_log_encerramento.lgr_ticket)
49. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uat_log_revalidation cbn_manager_action (cost=1,426.26..1,430.29 rows=1 width=33) (never executed)

  • Recheck Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_rev_svcid = '57'::numeric) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket))
  • Filter: (((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text) AND ((lgr_responsable_role_type)::text = 'Manager'::text))
50. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=1,426.26..1,426.26 rows=1 width=0) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_rev_svcid_dvcid (cost=0.00..88.88 rows=2,830 width=0) (never executed)

  • Index Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_rev_svcid = '57'::numeric))
52. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_ticket (cost=0.00..1,337.13 rows=58,741 width=0) (never executed)

  • Index Cond: (lgr_ticket = cbn_log_encerramento.lgr_ticket)
53. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_lgr_rev_svcid_dvcid on uat_log_revalidation cbn_manager_action_1 (cost=0.57..215.48 rows=1 width=33) (never executed)

  • Index Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_rev_svcid = '58'::numeric))
  • Filter: (((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text) AND ((lgr_responsable_role_type)::text = 'Manager'::text))
54. 0.000 0.000 ↓ 0.0 0

Limit (cost=2,214.38..2,214.39 rows=1 width=10) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Sort (cost=2,214.38..2,214.39 rows=1 width=10) (never executed)

  • Sort Key: (CASE WHEN ((log_inicio_1.lgr_responsable_role_owner_cnum)::text <> (cbn_log_encerramento.lgr_responsable_role_owner_cnum)::text) THEN true ELSE false END)
56. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uat_log_revalidation log_inicio_1 (cost=2,206.33..2,214.37 rows=1 width=10) (never executed)

  • Recheck Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket))
  • Filter: (((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text) AND ((lgr_action)::text = 'Starting Revalidation'::text))
57. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=2,206.33..2,206.33 rows=2 width=0) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_rev_svcid_dvcid (cost=0.00..868.95 rows=31,516 width=0) (never executed)

  • Index Cond: (lgr_dvcid = cbn_log_encerramento.lgr_dvcid)
59. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_ticket (cost=0.00..1,337.13 rows=58,741 width=0) (never executed)

  • Index Cond: (lgr_ticket = cbn_log_encerramento.lgr_ticket)
60. 0.000 0.000 ↓ 0.0 0

Limit (cost=2,214.39..2,214.39 rows=1 width=23) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Sort (cost=2,214.39..2,214.39 rows=1 width=23) (never executed)

  • Sort Key: log_inicio_2.lgr_responsable_role_owner_name
62. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uat_log_revalidation log_inicio_2 (cost=2,206.33..2,214.38 rows=1 width=23) (never executed)

  • Recheck Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket))
  • Filter: (((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text) AND ((lgr_action)::text = 'Starting Revalidation'::text) AND ((lgr_responsable_role_type)::text = 'Privilege Owner'::text))
63. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=2,206.33..2,206.33 rows=2 width=0) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_rev_svcid_dvcid (cost=0.00..868.95 rows=31,516 width=0) (never executed)

  • Index Cond: (lgr_dvcid = cbn_log_encerramento.lgr_dvcid)
65. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_ticket (cost=0.00..1,337.13 rows=58,741 width=0) (never executed)

  • Index Cond: (lgr_ticket = cbn_log_encerramento.lgr_ticket)
66. 0.000 0.000 ↓ 0.0 0

Limit (cost=2,222.84..2,222.84 rows=1 width=20) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Sort (cost=2,222.84..2,222.84 rows=1 width=20) (never executed)

  • Sort Key: privilege_old_owner.emp_mail
68. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2,206.75..2,222.83 rows=1 width=20) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uat_log_revalidation log_inicio_3 (cost=2,206.33..2,214.38 rows=1 width=10) (never executed)

  • Recheck Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket))
  • Filter: (((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text) AND ((lgr_action)::text = 'Starting Revalidation'::text) AND ((lgr_responsable_role_type)::text = 'Privilege Owner'::text))
70. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=2,206.33..2,206.33 rows=2 width=0) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_rev_svcid_dvcid (cost=0.00..868.95 rows=31,516 width=0) (never executed)

  • Index Cond: (lgr_dvcid = cbn_log_encerramento.lgr_dvcid)
72. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_ticket (cost=0.00..1,337.13 rows=58,741 width=0) (never executed)

  • Index Cond: (lgr_ticket = cbn_log_encerramento.lgr_ticket)
73. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_emp_cnum on uat_emp privilege_old_owner (cost=0.42..8.44 rows=1 width=30) (never executed)

  • Index Cond: ((emp_cnum)::text = (log_inicio_3.lgr_responsable_role_owner_cnum)::text)
74. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uat_log_revalidation cbn_owner_action (cost=1,426.26..1,430.29 rows=1 width=33) (never executed)

  • Recheck Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_rev_svcid = '57'::numeric) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket))
  • Filter: (((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text) AND ((lgr_responsable_role_type)::text = 'Privilege Owner'::text))
75. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=1,426.26..1,426.26 rows=1 width=0) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_rev_svcid_dvcid (cost=0.00..88.88 rows=2,830 width=0) (never executed)

  • Index Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_rev_svcid = '57'::numeric))
77. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_lgr_ticket (cost=0.00..1,337.13 rows=58,741 width=0) (never executed)

  • Index Cond: (lgr_ticket = cbn_log_encerramento.lgr_ticket)
78. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_lgr_rev_svcid_dvcid on uat_log_revalidation cbn_owner_action_1 (cost=0.57..215.48 rows=1 width=33) (never executed)

  • Index Cond: ((lgr_dvcid = cbn_log_encerramento.lgr_dvcid) AND (lgr_rev_svcid = '58'::numeric))
  • Filter: (((lgr_userid)::text = (cbn_log_encerramento.lgr_userid)::text) AND (lgr_ticket = cbn_log_encerramento.lgr_ticket) AND ((lgr_privilege)::text = (cbn_log_encerramento.lgr_privilege)::text) AND ((lgr_responsable_role_type)::text = 'Privilege Owner'::text))
Planning time : 13.370 ms
Execution time : 1,575,485.800 ms