explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9MmV

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 883.168 ↓ 0.0 0 1

Sort (cost=150,289.52..150,290.04 rows=210 width=1,709) (actual time=883.168..883.168 rows=0 loops=1)

  • Sort Key: dvc.sequence
  • Sort Method: quicksort Memory: 25kB
2.          

Initplan (for Sort)

3. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..10.81 rows=1 width=0) (never executed)

  • Join Filter: ((persons_func.func_id = role.role_id) AND (org_func.org_id = role.org_id))
4. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..10.49 rows=1 width=24) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..8.84 rows=5 width=24) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..6.89 rows=1 width=8) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using persons_func_pk on persons_func (cost=0.42..3.44 rows=1 width=16) (never executed)

  • Index Cond: (person_id = 7731412)
  • Heap Fetches: 0
8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_persons_person_id_not_deleted on persons persons_1 (cost=0.42..3.44 rows=1 width=8) (never executed)

  • Index Cond: (person_id = 7731412)
  • Heap Fetches: 0
9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using role_func_pk on role_func (cost=0.29..1.89 rows=6 width=16) (never executed)

  • Index Cond: (role_id = persons_func.func_id)
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Index Scan using org_func_pk on org_func (cost=0.28..0.33 rows=1 width=16) (never executed)

  • Index Cond: (org_func_id = role_func.org_func_id)
  • Filter: ((name)::text = 'COMPANY'::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using role_pk on role (cost=0.28..0.31 rows=1 width=16) (never executed)

  • Index Cond: (role_id = role_func.role_id)
12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.26..16.26 rows=1 width=0) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.11..13.22 rows=18 width=8) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..12.12 rows=1 width=16) (never executed)

  • Join Filter: ((persons_func_1.func_id = role_1.role_id) AND (org_func_1.org_id = role_1.org_id))
15. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..10.47 rows=5 width=40) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..8.84 rows=5 width=24) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..6.89 rows=1 width=8) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using persons_func_pk on persons_func persons_func_1 (cost=0.42..3.44 rows=1 width=16) (never executed)

  • Index Cond: (person_id = 7731412)
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_persons_person_id_not_deleted on persons persons_2 (cost=0.42..3.44 rows=1 width=8) (never executed)

  • Index Cond: (person_id = 7731412)
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Index Only Scan using role_func_pk on role_func role_func_1 (cost=0.29..1.89 rows=6 width=16) (never executed)

  • Index Cond: (role_id = persons_func_1.func_id)
  • Heap Fetches: 0
21. 0.000 0.000 ↓ 0.0 0

Index Scan using org_func_pk on org_func org_func_1 (cost=0.28..0.33 rows=1 width=16) (never executed)

  • Index Cond: (org_func_id = role_func_1.org_func_id)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using role_pk on role role_1 (cost=0.28..0.31 rows=1 width=16) (never executed)

  • Index Cond: (role_id = role_func_1.role_id)
23. 0.000 0.000 ↓ 0.0 0

Index Only Scan using org_func_perms_pk on org_func_perms (cost=0.42..0.88 rows=22 width=16) (never executed)

  • Index Cond: (org_func_id = role_func_1.org_func_id)
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.0 0

Index Scan using perms_pk on perms (cost=0.15..0.17 rows=1 width=8) (never executed)

  • Index Cond: (perm_id = org_func_perms.perm_id)
  • Filter: ((name)::text = 'view.screen.UserDevices'::text)
25. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.26..16.30 rows=1 width=0) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.11..13.22 rows=18 width=8) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..12.12 rows=1 width=16) (never executed)

  • Join Filter: ((persons_func_2.func_id = role_2.role_id) AND (org_func_2.org_id = role_2.org_id))
28. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..10.47 rows=5 width=40) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..8.84 rows=5 width=24) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..6.89 rows=1 width=8) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Index Only Scan using persons_func_pk on persons_func persons_func_2 (cost=0.42..3.44 rows=1 width=16) (never executed)

  • Index Cond: (person_id = 7731412)
  • Heap Fetches: 0
32. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_persons_person_id_not_deleted on persons persons_3 (cost=0.42..3.44 rows=1 width=8) (never executed)

  • Index Cond: (person_id = 7731412)
  • Heap Fetches: 0
33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using role_func_pk on role_func role_func_2 (cost=0.29..1.89 rows=6 width=16) (never executed)

  • Index Cond: (role_id = persons_func_2.func_id)
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0

Index Scan using org_func_pk on org_func org_func_2 (cost=0.28..0.33 rows=1 width=16) (never executed)

  • Index Cond: (org_func_id = role_func_2.org_func_id)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using role_pk on role role_2 (cost=0.28..0.31 rows=1 width=16) (never executed)

  • Index Cond: (role_id = role_func_2.role_id)
36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using org_func_perms_pk on org_func_perms org_func_perms_1 (cost=0.42..0.88 rows=22 width=16) (never executed)

  • Index Cond: (org_func_id = role_func_2.org_func_id)
  • Heap Fetches: 0
37. 0.000 0.000 ↓ 0.0 0

Index Scan using perms_pk on perms perms_1 (cost=0.15..0.17 rows=1 width=8) (never executed)

  • Index Cond: (perm_id = org_func_perms_1.perm_id)
  • Filter: (((name)::text = 'view.screen.MyDevices'::text) OR ((name)::text = 'view.screen.UserDevices'::text))
38. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.26..16.26 rows=1 width=0) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.11..13.22 rows=18 width=8) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..12.12 rows=1 width=16) (never executed)

  • Join Filter: ((persons_func_3.func_id = role_3.role_id) AND (org_func_3.org_id = role_3.org_id))
41. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..10.47 rows=5 width=40) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..8.84 rows=5 width=24) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..6.89 rows=1 width=8) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using persons_func_pk on persons_func persons_func_3 (cost=0.42..3.44 rows=1 width=16) (never executed)

  • Index Cond: (person_id = 7731412)
  • Heap Fetches: 0
45. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_persons_person_id_not_deleted on persons persons_4 (cost=0.42..3.44 rows=1 width=8) (never executed)

  • Index Cond: (person_id = 7731412)
  • Heap Fetches: 0
46. 0.000 0.000 ↓ 0.0 0

Index Only Scan using role_func_pk on role_func role_func_3 (cost=0.29..1.89 rows=6 width=16) (never executed)

  • Index Cond: (role_id = persons_func_3.func_id)
  • Heap Fetches: 0
47. 0.000 0.000 ↓ 0.0 0

Index Scan using org_func_pk on org_func org_func_3 (cost=0.28..0.33 rows=1 width=16) (never executed)

  • Index Cond: (org_func_id = role_func_3.org_func_id)
48. 0.000 0.000 ↓ 0.0 0

Index Scan using role_pk on role role_3 (cost=0.28..0.31 rows=1 width=16) (never executed)

  • Index Cond: (role_id = role_func_3.role_id)
49. 0.000 0.000 ↓ 0.0 0

Index Only Scan using org_func_perms_pk on org_func_perms org_func_perms_2 (cost=0.42..0.88 rows=22 width=16) (never executed)

  • Index Cond: (org_func_id = role_func_3.org_func_id)
  • Heap Fetches: 0
50. 0.000 0.000 ↓ 0.0 0

Index Scan using perms_pk on perms perms_2 (cost=0.15..0.17 rows=1 width=8) (never executed)

  • Index Cond: (perm_id = org_func_perms_2.perm_id)
  • Filter: ((name)::text = 'view.screen.UserDevices'::text)
51. 0.001 883.141 ↓ 0.0 0 1

Hash Left Join (cost=2,222.26..150,221.80 rows=210 width=1,709) (actual time=883.140..883.141 rows=0 loops=1)

  • Hash Cond: ((voiceivr.country_code)::text = (voiceivr_c.country_code)::text)
52. 0.001 883.140 ↓ 0.0 0 1

Hash Left Join (cost=2,211.68..150,186.50 rows=210 width=1,992) (actual time=883.140..883.140 rows=0 loops=1)

  • Hash Cond: ((numpage.country_code)::text = (numpage_c.country_code)::text)
53. 0.001 883.139 ↓ 0.0 0 1

Hash Left Join (cost=2,201.10..150,175.36 rows=210 width=2,001) (actual time=883.139..883.139 rows=0 loops=1)

  • Hash Cond: ((txtph.country_code)::text = (txtph_c.country_code)::text)
54. 0.000 883.138 ↓ 0.0 0 1

Hash Left Join (cost=2,190.52..150,164.22 rows=210 width=1,998) (actual time=883.138..883.138 rows=0 loops=1)

  • Hash Cond: (rp.recipient_id = person_sups.person_id)
  • Filter: ($3 OR ((person_sups.sup_id IS NOT NULL) AND (dvc.person_id <> 7731412) AND $9) OR ((dvc.person_id = 7731412) AND $15) OR ($21 AND ((person_sups.sup_id IS NOT NULL) OR (SubPlan 5))))
55. 0.001 883.138 ↓ 0.0 0 1

Hash Left Join (cost=1,097.15..149,070.22 rows=240 width=1,998) (actual time=883.138..883.138 rows=0 loops=1)

  • Hash Cond: ((voc.country_code)::text = (voc_c.country_code)::text)
56. 0.001 883.137 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,086.57..149,059.00 rows=240 width=1,995) (actual time=883.137..883.137 rows=0 loops=1)

57. 0.000 883.136 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,086.29..148,988.15 rows=240 width=1,812) (actual time=883.136..883.136 rows=0 loops=1)

  • Join Filter: ((dvc.dvc_type)::text = 'VOICE_IVR'::text)
58. 0.001 883.136 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,086.14..148,946.15 rows=240 width=1,646) (actual time=883.136..883.136 rows=0 loops=1)

59. 0.000 883.135 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,086.00..148,907.15 rows=240 width=1,428) (actual time=883.135..883.135 rows=0 loops=1)

  • Join Filter: (((dvc.dvc_type)::text = 'TEXT_PAGER'::text) AND (dvc.dvc_id = txtpage.dvc_id))
60. 0.001 883.135 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,086.00..148,868.23 rows=240 width=1,417) (actual time=883.134..883.135 rows=0 loops=1)

  • Join Filter: ((dvc.dvc_type)::text = 'IM'::text)
61. 0.001 883.134 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,085.85..148,826.23 rows=240 width=1,199) (actual time=883.134..883.134 rows=0 loops=1)

  • Join Filter: ((dvc.dvc_type)::text = 'APPLE_PUSH'::text)
62. 0.000 883.133 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,085.57..148,751.78 rows=240 width=1,073) (actual time=883.133..883.133 rows=0 loops=1)

  • Join Filter: ((dvc.dvc_type)::text = 'NUMERIC_PAGER'::text)
63. 0.000 883.133 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,085.43..148,710.38 rows=240 width=407) (actual time=883.133..883.133 rows=0 loops=1)

  • Join Filter: ((dvc.dvc_type)::text = 'FAX'::text)
64. 46.672 915.094 ↓ 0.0 0 1

Gather (cost=1,085.17..148,640.77 rows=240 width=394) (actual time=883.129..915.094 rows=0 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
65. 0.000 868.422 ↓ 0.0 0 4 / 4

Nested Loop Left Join (cost=85.17..147,616.77 rows=77 width=394) (actual time=868.422..868.422 rows=0 loops=4)

  • Join Filter: ((dvc.dvc_type)::text = 'EMAIL'::text)
66. 0.001 868.422 ↓ 0.0 0 4 / 4

Nested Loop Left Join (cost=84.75..147,576.47 rows=77 width=369) (actual time=868.422..868.422 rows=0 loops=4)

  • Join Filter: ((dvc.dvc_type)::text = 'TEXT_PHONE'::text)
67. 0.001 868.421 ↓ 0.0 0 4 / 4

Nested Loop Left Join (cost=84.32..147,538.85 rows=77 width=354) (actual time=868.421..868.421 rows=0 loops=4)

  • Join Filter: ((dvc.dvc_type)::text = 'VOICE'::text)
68. 0.170 868.420 ↓ 0.0 0 4 / 4

Hash Join (cost=83.89..147,496.38 rows=77 width=335) (actual time=868.420..868.420 rows=0 loops=4)

  • Hash Cond: (addresses.country_id = site_c.country_id)
69. 0.001 868.084 ↓ 0.0 0 4 / 4

Nested Loop (cost=73.31..147,485.60 rows=77 width=337) (actual time=868.084..868.084 rows=0 loops=4)

70. 0.000 868.083 ↓ 0.0 0 4 / 4

Nested Loop (cost=72.90..147,427.09 rows=77 width=337) (actual time=868.083..868.083 rows=0 loops=4)

71. 0.910 868.083 ↓ 0.0 0 4 / 4

Hash Join (cost=72.62..147,404.56 rows=77 width=315) (actual time=868.083..868.083 rows=0 loops=4)

  • Hash Cond: (rd.org_dvc_name_id = odn.org_dvc_name_id)
  • Join Filter: (((rd.uuid)::text = 'd20ad205-108f-4e3c-badb-a8e032daed44'::text) OR ((((rd.target_name_lower)::text || '|'::text) || (odn.name_lower)::text) = 'd20ad205-108f-4e3c-badb-a8e032daed44'::text))
  • Rows Removed by Join Filter: 1879
72. 1.111 866.245 ↑ 8.2 1,879 4 / 4

Merge Join (cost=1.99..147,293.37 rows=15,451 width=317) (actual time=108.213..866.245 rows=1,879 loops=4)

  • Merge Cond: (persons.site_id = sites.site_id)
73. 1.680 859.971 ↑ 8.2 1,879 4 / 4

Nested Loop (cost=1.71..344,116.34 rows=15,451 width=317) (actual time=107.939..859.971 rows=1,879 loops=4)

74. 0.981 852.653 ↑ 26.8 1,879 4 / 4

Nested Loop (cost=1.28..310,731.02 rows=50,319 width=202) (actual time=107.916..852.653 rows=1,879 loops=4)

75. 56.986 846.952 ↑ 80.4 472 4 / 4

Nested Loop (cost=0.85..240,494.57 rows=37,952 width=87) (actual time=107.863..846.952 rows=472 loops=4)

76. 171.638 171.638 ↑ 1.3 206,110 4 / 4

Parallel Index Scan using idx_persons4 on persons (cost=0.42..43,840.29 rows=266,769 width=30) (actual time=0.038..171.638 rows=206,110 loops=4)

77. 618.328 618.328 ↓ 0.0 0 824,438 / 4

Index Scan using recipients_rid_when_updated_desc_pidx on recipients rp (cost=0.43..0.74 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=824,438)

  • Index Cond: (recipient_id = persons.person_id)
  • Filter: (org_id = 200029)
  • Rows Removed by Filter: 0
78. 4.720 4.720 ↑ 10.5 4 1,888 / 4

Index Scan using idx_dvc_person_id_not_deleted on dvc (cost=0.43..1.43 rows=42 width=123) (actual time=0.006..0.010 rows=4 loops=1,888)

  • Index Cond: (person_id = rp.recipient_id)
79. 5.638 5.638 ↑ 1.0 1 7,517 / 4

Index Scan using recipients_rid_when_updated_desc_pidx on recipients rd (cost=0.43..0.66 rows=1 width=115) (actual time=0.003..0.003 rows=1 loops=7,517)

  • Index Cond: (recipient_id = dvc.dvc_id)
80. 5.163 5.163 ↑ 1.5 9,029 4 / 4

Index Scan using sites_pk on sites (cost=0.29..965.38 rows=13,120 width=16) (actual time=0.035..5.163 rows=9,029 loops=4)

81. 0.388 0.928 ↑ 1.0 1,539 4 / 4

Hash (cost=51.39..51.39 rows=1,539 width=28) (actual time=0.928..0.928 rows=1,539 loops=4)

  • Buckets: 2048 Batches: 1 Memory Usage: 113kB
82. 0.540 0.540 ↑ 1.0 1,539 4 / 4

Seq Scan on org_dvc_names odn (cost=0.00..51.39 rows=1,539 width=28) (actual time=0.027..0.540 rows=1,539 loops=4)

83. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using org_svc_provs_pk on org_svc_provs osp (cost=0.28..0.29 rows=1 width=38) (never executed)

  • Index Cond: (org_svc_prov_id = dvc.org_svc_prov_id)
84. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using addresses_pk on addresses (cost=0.42..0.76 rows=1 width=16) (never executed)

  • Index Cond: (address_id = sites.address_id)
85. 0.054 0.166 ↑ 1.0 248 4 / 4

Hash (cost=7.48..7.48 rows=248 width=14) (actual time=0.166..0.166 rows=248 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
86. 0.112 0.112 ↑ 1.0 248 4 / 4

Seq Scan on countries site_c (cost=0.00..7.48 rows=248 width=14) (actual time=0.024..0.112 rows=248 loops=4)

87. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using voc_dvc_dtl_pk on voc_dvc_dtl voc (cost=0.43..0.54 rows=1 width=27) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
88. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using txt_phone_dvc_dtl_pk on txt_phone_dvc_dtl txtph (cost=0.42..0.48 rows=1 width=23) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
89. 0.000 0.000 ↓ 0.0 0 / 4

Index Scan using email_dvc_dtl_pk on email_dvc_dtl edd (cost=0.43..0.51 rows=1 width=33) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using fax_dvc_dtl_pk on fax_dvc_dtl fax (cost=0.26..0.28 rows=1 width=21) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
91. 0.000 0.000 ↓ 0.0 0

Index Scan using num_page_dvc_dtl_pk on num_page_dvc_dtl numpage (cost=0.14..0.16 rows=1 width=674) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using apple_push_dvc_dtl_pk on apple_push_dvc_dtl push (cost=0.28..0.30 rows=1 width=134) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
93. 0.000 0.000 ↓ 0.0 0

Index Scan using im_dvc_dtl_pk on im_dvc_dtl im (cost=0.14..0.16 rows=1 width=226) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
94. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.14 rows=9 width=19) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Seq Scan on txt_page_dvc_dtl txtpage (cost=0.00..1.09 rows=9 width=19) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Index Scan using gen_dvc_dtl_pk on gen_dvc_dtl gen (cost=0.14..0.16 rows=1 width=226) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using voice_ivr_dvc_dtl_pk on voice_ivr_dvc_dtl voiceivr (cost=0.14..0.16 rows=1 width=174) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using gcm_push_dvc_dtl_pk on gcm_push_dvc_dtl gcm (cost=0.28..0.30 rows=1 width=191) (never executed)

  • Index Cond: (dvc.dvc_id = dvc_id)
99. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.48..7.48 rows=248 width=6) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Seq Scan on countries voc_c (cost=0.00..7.48 rows=248 width=6) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,074.28..1,074.28 rows=1,527 width=16) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_person_sups2 on person_sups (cost=0.42..1,074.28 rows=1,527 width=16) (never executed)

  • Index Cond: (sup_id = 7731412)
103.          

SubPlan (for Hash Left Join)

104. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.22..26.72 rows=1 width=0) (never executed)

  • Join Filter: (target_role.role_id = t_pf.func_id)
105. 0.000 0.000 ↓ 0.0 0

Index Only Scan using persons_func_pk on persons_func t_pf (cost=0.42..3.44 rows=1 width=16) (never executed)

  • Index Cond: (person_id = dvc.person_id)
  • Heap Fetches: 0
106. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.79..23.11 rows=14 width=24) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_person_id_desc_ufn_uln_fbi on persons target_p (cost=0.42..3.44 rows=1 width=8) (never executed)

  • Index Cond: (person_id = dvc.person_id)
  • Heap Fetches: 0
108. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.37..19.52 rows=14 width=16) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3.09..15.35 rows=14 width=8) (never executed)

  • Hash Cond: (role_perm_grants.role_perm_id = role_perms.role_perm_id)
110. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.97..14.12 rows=27 width=16) (never executed)

  • Join Filter: (persons_func_4.func_id = role_perm_grants.src_role_id)
111. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.55..12.15 rows=1 width=16) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..10.35 rows=1 width=8) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Index Only Scan using persons_func_pk on persons_func persons_func_4 (cost=0.42..3.44 rows=1 width=16) (never executed)

  • Index Cond: (person_id = '7731412'::bigint)
  • Heap Fetches: 0
114. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..6.90 rows=1 width=8) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Index Only Scan using recipients_rid_when_updated_desc_pidx on recipients r (cost=0.43..3.45 rows=1 width=8) (never executed)

  • Index Cond: (recipient_id = '7731412'::bigint)
  • Heap Fetches: 0
116. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_person_id_desc_ufn_uln_fbi on persons p (cost=0.42..3.44 rows=1 width=8) (never executed)

  • Index Cond: (person_id = '7731412'::bigint)
  • Heap Fetches: 0
117. 0.000 0.000 ↓ 0.0 0

Index Only Scan using role_pk on role viewer_role (cost=0.28..1.80 rows=1 width=8) (never executed)

  • Index Cond: (role_id = persons_func_4.func_id)
  • Heap Fetches: 0
118. 0.000 0.000 ↓ 0.0 0

Index Only Scan using role_perm_grants_pk on role_perm_grants (cost=0.41..1.55 rows=34 width=24) (never executed)

  • Index Cond: (src_role_id = viewer_role.role_id)
  • Heap Fetches: 0
119. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.08..1.08 rows=3 width=8) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Seq Scan on role_perms (cost=0.00..1.08 rows=3 width=8) (never executed)

  • Filter: ((name)::text = ANY ('{"Use Person","Edit Person","View Person"}'::text[]))
121. 0.000 0.000 ↓ 0.0 0

Index Only Scan using role_pk on role target_role (cost=0.28..0.30 rows=1 width=8) (never executed)

  • Index Cond: (role_id = role_perm_grants.target_role_id)
  • Heap Fetches: 0
122. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.48..7.48 rows=248 width=6) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Seq Scan on countries txtph_c (cost=0.00..7.48 rows=248 width=6) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.48..7.48 rows=248 width=6) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Seq Scan on countries numpage_c (cost=0.00..7.48 rows=248 width=6) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.48..7.48 rows=248 width=6) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Seq Scan on countries voiceivr_c (cost=0.00..7.48 rows=248 width=6) (never executed)

Planning time : 56.344 ms
Execution time : 916.741 ms