explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y0lb

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.874 ↑ 1.0 1 1

Result (cost=17,658.36..17,658.37 rows=1 width=40) (actual time=0.874..0.874 rows=1 loops=1)

2.          

CTE matches

3. 0.009 0.839 ↓ 0.0 0 1

Nested Loop (cost=4.20..15.78 rows=1 width=48) (actual time=0.839..0.839 rows=0 loops=1)

  • Join Filter: (media.id = user_media_offline.media_id)
4. 0.006 0.474 ↓ 2.0 2 1

Nested Loop (cost=0.00..2.04 rows=1 width=64) (actual time=0.466..0.474 rows=2 loops=1)

  • Join Filter: (media.id = media_1.id)
  • Rows Removed by Join Filter: 2
5. 0.460 0.460 ↓ 2.0 2 1

Seq Scan on media (cost=0.00..1.01 rows=1 width=48) (actual time=0.459..0.460 rows=2 loops=1)

  • Filter: ((state = 'ACTIVE'::text) AND (lifecycle_status = 'ACTIVE'::text))
6. 0.008 0.008 ↓ 2.0 2 2

Seq Scan on media media_1 (cost=0.00..1.01 rows=1 width=16) (actual time=0.004..0.004 rows=2 loops=2)

7. 0.002 0.356 ↓ 0.0 0 2

Bitmap Heap Scan on user_media_offline (cost=4.20..13.67 rows=6 width=16) (actual time=0.178..0.178 rows=0 loops=2)

  • Recheck Cond: (user_id = '3b634574-260d-4d74-880d-075c1be5a8cf'::uuid)
8. 0.354 0.354 ↓ 0.0 0 2

Bitmap Index Scan on user_media_offline_pkey (cost=0.00..4.20 rows=6 width=0) (actual time=0.177..0.177 rows=0 loops=2)

  • Index Cond: (user_id = '3b634574-260d-4d74-880d-075c1be5a8cf'::uuid)
9.          

CTE view

10. 0.014 0.015 ↓ 0.0 0 1

Sort (cost=0.03..0.04 rows=1 width=48) (actual time=0.015..0.015 rows=0 loops=1)

  • Sort Key: matches.name, matches.id
  • Sort Method: quicksort Memory: 25kB
11. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on matches (cost=0.00..0.02 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=1)

12.          

Initplan (forResult)

13. 0.002 0.841 ↑ 1.0 1 1

Aggregate (cost=0.02..0.03 rows=1 width=8) (actual time=0.841..0.841 rows=1 loops=1)

14. 0.839 0.839 ↓ 0.0 0 1

CTE Scan on matches matches_1 (cost=0.00..0.02 rows=1 width=0) (actual time=0.839..0.839 rows=0 loops=1)

15. 0.013 0.030 ↑ 1.0 1 1

Aggregate (cost=17,642.50..17,642.51 rows=1 width=32) (actual time=0.030..0.030 rows=1 loops=1)

16. 0.001 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=17,603.37..17,642.50 rows=1 width=80) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: (vm.id = view.id)
17. 0.016 0.016 ↓ 0.0 0 1

CTE Scan on view (cost=0.00..0.02 rows=1 width=48) (actual time=0.016..0.016 rows=0 loops=1)

18. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=17,603.37..17,642.46 rows=1 width=48) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=16,983.28..17,021.84 rows=1 width=577) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=16,937.09..16,975.62 rows=1 width=545) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=16,877.51..16,916.00 rows=1 width=513) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=16,431.88..16,470.35 rows=1 width=481) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=4,503.08..4,541.52 rows=1 width=449) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=536.31..574.72 rows=1 width=417) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=276.88..301.15 rows=1 width=401) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=17.45..27.58 rows=1 width=385) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.19..12.29 rows=1 width=349) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.04..4.11 rows=1 width=329) (never executed)

  • Join Filter: (media_4.id = media_2.id)
29. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.04..3.09 rows=1 width=313) (never executed)

  • Join Filter: (media_2.id = vm.id)
30. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=2.04..2.06 rows=1 width=48) (never executed)

  • Merge Cond: (media_2.id = media_3.id)
31. 0.000 0.000 ↓ 0.0 0

Sort (cost=1.02..1.02 rows=1 width=16) (never executed)

  • Sort Key: media_2.id
32. 0.000 0.000 ↓ 0.0 0

Seq Scan on media media_2 (cost=0.00..1.01 rows=1 width=16) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Sort (cost=1.02..1.02 rows=1 width=48) (never executed)

  • Sort Key: media_3.id
34. 0.000 0.000 ↓ 0.0 0

Seq Scan on media media_3 (cost=0.00..1.01 rows=1 width=48) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Seq Scan on media vm (cost=0.00..1.01 rows=1 width=265) (never executed)

  • Filter: (state <> 'DELETED'::text)
36. 0.000 0.000 ↓ 0.0 0

Seq Scan on media media_4 (cost=0.00..1.01 rows=1 width=48) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Index Scan using user_media_offline_pkey on user_media_offline user_media_offline_1 (cost=0.15..8.17 rows=1 width=20) (never executed)

  • Index Cond: ((user_id = '3b634574-260d-4d74-880d-075c1be5a8cf'::uuid) AND (media_id = vm.id))
38. 0.000 0.000 ↓ 0.0 0

Limit (cost=15.26..15.26 rows=1 width=52) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Sort (cost=15.26..15.27 rows=2 width=52) (never executed)

  • Sort Key: media_version.version DESC
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on media_version (cost=0.00..15.25 rows=2 width=52) (never executed)

  • Filter: (media_id = vm.id)
41. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=259.43..273.56 rows=1 width=48) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_document on document (cost=0.42..8.44 rows=1 width=104) (never executed)

  • Index Cond: (media_version.media_document_id = id)
43. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=259.01..264.86 rows=1 width=48) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_user on sec_user (cost=0.28..0.31 rows=1 width=32) (never executed)

  • Index Cond: (id = document.owner_id)
  • Filter: (state <> 'DELETED'::text)
45. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=258.73..264.55 rows=1 width=48) (never executed)

46. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person on person (cost=0.42..5.77 rows=1 width=16) (never executed)

  • Index Cond: (id = sec_user.person_id)
  • Filter: (state <> 'DELETED'::text)
47. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=258.30..258.77 rows=1 width=48) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=218.93..219.12 rows=1 width=109) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=207.92..208.08 rows=1 width=77) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person on person person_1 (cost=0.42..0.56 rows=1 width=45) (never executed)

  • Index Cond: (id = person.id)
51. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=207.50..207.51 rows=1 width=32) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=188.00..207.49 rows=1 width=261) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=144.12..163.58 rows=1 width=253) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=130.31..149.74 rows=1 width=221) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=109.57..128.98 rows=1 width=189) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=74.70..94.08 rows=1 width=157) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.34..31.68 rows=1 width=125) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.92..23.23 rows=1 width=141) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=11.50..14.79 rows=1 width=123) (never executed)

  • Hash Cond: (employee_function.id = employee.function_id)
60. 0.000 0.000 ↓ 0.0 0

Seq Scan on employee_function (cost=0.00..2.93 rows=93 width=37) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.48..11.48 rows=1 width=102) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=8.46..11.48 rows=1 width=102) (never executed)

  • Hash Cond: (employee_department.id = employee.department_id)
63. 0.000 0.000 ↓ 0.0 0

Seq Scan on employee_department (cost=0.00..2.74 rows=74 width=34) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.45..8.45 rows=1 width=84) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Index Scan using employee_person_id_state_idx on employee (cost=0.42..8.45 rows=1 width=84) (never executed)

  • Index Cond: ((person_id = person_1.id) AND (state = 'ACTIVE'::text))
66. 0.000 0.000 ↓ 0.0 0

Index Scan using organization_id_state_idx on organization (cost=0.42..8.44 rows=1 width=34) (never executed)

  • Index Cond: (id = employee.organization_id)
67. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_id_state_idx on person person_4 (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (id = person_1.id)
  • Heap Fetches: 0
68. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=62.36..62.37 rows=1 width=32) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=6.11..62.36 rows=2 width=32) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.69..61.13 rows=2 width=64) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on employee_address (cost=4.16..9.50 rows=2 width=48) (never executed)

  • Recheck Cond: (employee_id = employee.id)
72. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_employee_address (cost=0.00..4.16 rows=2 width=0) (never executed)

  • Index Cond: (employee_id = employee.id)
73. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.53..25.80 rows=1 width=48) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (id = employee_address.address_id)
  • Filter: (state <> 'DELETED'::text)
75. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.11..17.35 rows=1 width=48) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..9.05 rows=1 width=84) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address addr (cost=0.42..8.44 rows=1 width=84) (never executed)

  • Index Cond: (id = address.id)
  • Filter: (state <> 'DELETED'::text)
78. 0.000 0.000 ↓ 0.0 0

Index Only Scan using address_pkey on address address_2 (cost=0.42..0.60 rows=1 width=16) (never executed)

  • Index Cond: (id = addr.id)
  • Heap Fetches: 0
79. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_country on country (cost=0.27..8.29 rows=1 width=28) (never executed)

  • Index Cond: (id = addr.country_id)
80. 0.000 0.000 ↓ 0.0 0

Index Only Scan using address_pkey on address address_1 (cost=0.42..0.60 rows=1 width=16) (never executed)

  • Index Cond: (id = address.id)
  • Heap Fetches: 0
81. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=34.87..34.88 rows=1 width=32) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.37..34.86 rows=1 width=32) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.95..34.25 rows=1 width=64) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_organization_address on organization_address (cost=0.42..8.44 rows=1 width=25) (never executed)

  • Index Cond: (organization_id = employee.organization_id)
85. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.53..25.80 rows=1 width=48) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address address_3 (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (id = organization_address.address_id)
  • Filter: (state <> 'DELETED'::text)
87. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.11..17.35 rows=1 width=48) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..9.05 rows=1 width=84) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address addr_1 (cost=0.42..8.44 rows=1 width=84) (never executed)

  • Index Cond: (id = address_3.id)
  • Filter: (state <> 'DELETED'::text)
90. 0.000 0.000 ↓ 0.0 0

Index Only Scan using address_pkey on address address_5 (cost=0.42..0.60 rows=1 width=16) (never executed)

  • Index Cond: (id = addr_1.id)
  • Heap Fetches: 0
91. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_country on country country_1 (cost=0.27..8.29 rows=1 width=28) (never executed)

  • Index Cond: (id = addr_1.country_id)
92. 0.000 0.000 ↓ 0.0 0

Index Only Scan using address_pkey on address address_4 (cost=0.42..0.60 rows=1 width=16) (never executed)

  • Index Cond: (id = address_3.id)
  • Heap Fetches: 0
93. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=20.74..20.75 rows=1 width=32) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1.32..20.73 rows=4 width=128) (never executed)

  • Hash Cond: (employee_communication_data.communication_data_type_id = communication_data_type.id)
95. 0.000 0.000 ↓ 0.0 0

Seq Scan on employee_communication_data (cost=0.00..19.38 rows=4 width=64) (never executed)

  • Filter: (employee_id = employee.id)
96. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.20..1.20 rows=10 width=80) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Seq Scan on communication_data_type (cost=0.00..1.20 rows=10 width=80) (never executed)

  • Filter: employee_usable
98. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=13.81..13.82 rows=1 width=32) (never executed)

99. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1.75..13.80 rows=2 width=108) (never executed)

  • Hash Cond: (organization_communication_data.communication_data_type_id = communication_data_type_1.id)
100. 0.000 0.000 ↓ 0.0 0

Index Scan using organization_communication_data_organization_id_idx on organization_communication_data (cost=0.42..12.46 rows=2 width=44) (never executed)

  • Index Cond: (organization_id = employee.organization_id)
101. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.20..1.20 rows=10 width=80) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Seq Scan on communication_data_type communication_data_type_1 (cost=0.00..1.20 rows=10 width=80) (never executed)

  • Filter: organization_usable
103. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=43.88..43.89 rows=1 width=8) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on employee org_emp (cost=4.53..43.85 rows=10 width=0) (never executed)

  • Recheck Cond: ((organization_id = employee.organization_id) AND (state = 'ACTIVE'::text))
105. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on employee_organization_id_state_idx (cost=0.00..4.52 rows=10 width=0) (never executed)

  • Index Cond: ((organization_id = employee.organization_id) AND (state = 'ACTIVE'::text))
106. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=11.01..11.02 rows=1 width=32) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=8.73..11.00 rows=1 width=87) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.59..10.45 rows=1 width=71) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.46..9.89 rows=1 width=32) (never executed)

  • Hash Cond: (person_type_1.id = person_to_person_type.person_type_id)
110. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_type person_type_1 (cost=0.00..1.31 rows=31 width=16) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.44..8.44 rows=1 width=16) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_person_to_person_type on person_to_person_type (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (person_id = person_1.id)
  • Heap Fetches: 0
113. 0.000 0.000 ↓ 0.0 0

Index Scan using person_type_pkey on person_type (cost=0.14..0.54 rows=1 width=55) (never executed)

  • Index Cond: (id = person_type_1.id)
  • Filter: (state <> 'DELETED'::text)
114. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_type_pkey on person_type person_type_2 (cost=0.14..0.54 rows=1 width=48) (never executed)

  • Index Cond: (id = person_type_1.id)
  • Heap Fetches: 0
115. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=39.37..39.38 rows=1 width=32) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=23.26..39.37 rows=1 width=88) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=10.39..26.47 rows=1 width=56) (never executed)

118. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.76 rows=1 width=24) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_person on person person_5 (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (id = person_1.id)
  • Heap Fetches: 0
120. 0.000 0.000 ↓ 0.0 0

Index Scan using speaker_speaker_person_id_idx on speaker (cost=0.28..8.30 rows=1 width=40) (never executed)

  • Index Cond: (speaker_person_id = person_1.id)
  • Filter: (state = ANY ('{ACTIVE,LIMBO}'::text[]))
121. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=9.68..9.69 rows=1 width=32) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.31..9.68 rows=1 width=112) (never executed)

  • Hash Cond: (indication_area.id = speaker_indication_area.indication_area_id)
123. 0.000 0.000 ↓ 0.0 0

Seq Scan on indication_area (cost=0.00..1.26 rows=26 width=112) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.30..8.30 rows=1 width=16) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Index Only Scan using speaker_indication_area_pk on speaker_indication_area (cost=0.28..8.30 rows=1 width=16) (never executed)

  • Index Cond: (speaker_id = speaker.id)
  • Heap Fetches: 0
126. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=12.87..12.88 rows=1 width=32) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.48..12.86 rows=2 width=112) (never executed)

  • Hash Cond: (speaker_speaker_request_reason.speaker_request_reason_id = speaker_request_reason.id)
128. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on speaker_speaker_request_reason (cost=4.30..11.66 rows=2 width=16) (never executed)

  • Recheck Cond: (speaker_id = speaker.id)
129. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on speaker_speaker_request_reason_pk (cost=0.00..4.30 rows=2 width=0) (never executed)

  • Index Cond: (speaker_id = speaker.id)
130. 0.000 0.000 ↓ 0.0 0

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

131. 0.000 0.000 ↓ 0.0 0

Seq Scan on speaker_request_reason (cost=0.00..1.08 rows=8 width=112) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=259.43..273.56 rows=1 width=48) (never executed)

133. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_document on document document_1 (cost=0.42..8.44 rows=1 width=104) (never executed)

  • Index Cond: (vm.thumbnail_document_id = id)
134. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=259.01..264.86 rows=1 width=48) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_user on sec_user sec_user_1 (cost=0.28..0.31 rows=1 width=32) (never executed)

  • Index Cond: (id = document_1.owner_id)
  • Filter: (state <> 'DELETED'::text)
136. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=258.73..264.55 rows=1 width=48) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person on person person_2 (cost=0.42..5.77 rows=1 width=16) (never executed)

  • Index Cond: (id = sec_user_1.person_id)
  • Filter: (state <> 'DELETED'::text)
138. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=258.30..258.77 rows=1 width=48) (never executed)

139. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=218.93..219.12 rows=1 width=109) (never executed)

140. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=207.92..208.08 rows=1 width=77) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person on person person_3 (cost=0.42..0.56 rows=1 width=45) (never executed)

  • Index Cond: (id = person_2.id)
142. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=207.50..207.51 rows=1 width=32) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=188.00..207.49 rows=1 width=261) (never executed)

144. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=144.12..163.58 rows=1 width=253) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=130.31..149.74 rows=1 width=221) (never executed)

146. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=109.57..128.98 rows=1 width=189) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=74.70..94.08 rows=1 width=157) (never executed)

148. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.34..31.68 rows=1 width=125) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.92..23.23 rows=1 width=141) (never executed)

150. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=11.50..14.79 rows=1 width=123) (never executed)

  • Hash Cond: (employee_function_1.id = employee_1.function_id)
151. 0.000 0.000 ↓ 0.0 0

Seq Scan on employee_function employee_function_1 (cost=0.00..2.93 rows=93 width=37) (never executed)

152. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.48..11.48 rows=1 width=102) (never executed)

153. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=8.46..11.48 rows=1 width=102) (never executed)

  • Hash Cond: (employee_department_1.id = employee_1.department_id)
154. 0.000 0.000 ↓ 0.0 0

Seq Scan on employee_department employee_department_1 (cost=0.00..2.74 rows=74 width=34) (never executed)

155. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.45..8.45 rows=1 width=84) (never executed)

156. 0.000 0.000 ↓ 0.0 0

Index Scan using employee_person_id_state_idx on employee employee_1 (cost=0.42..8.45 rows=1 width=84) (never executed)

  • Index Cond: ((person_id = person_3.id) AND (state = 'ACTIVE'::text))
157. 0.000 0.000 ↓ 0.0 0

Index Scan using organization_id_state_idx on organization organization_1 (cost=0.42..8.44 rows=1 width=34) (never executed)

  • Index Cond: (id = employee_1.organization_id)
158. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_id_state_idx on person person_6 (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (id = person_3.id)
  • Heap Fetches: 0
159. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=62.36..62.37 rows=1 width=32) (never executed)

160. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=6.11..62.36 rows=2 width=32) (never executed)

161. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.69..61.13 rows=2 width=64) (never executed)

162. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on employee_address employee_address_1 (cost=4.16..9.50 rows=2 width=48) (never executed)

  • Recheck Cond: (employee_id = employee_1.id)
163. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_employee_address (cost=0.00..4.16 rows=2 width=0) (never executed)

  • Index Cond: (employee_id = employee_1.id)
164. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.53..25.80 rows=1 width=48) (never executed)

165. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address address_6 (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (id = employee_address_1.address_id)
  • Filter: (state <> 'DELETED'::text)
166. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.11..17.35 rows=1 width=48) (never executed)

167. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..9.05 rows=1 width=84) (never executed)

168. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address addr_2 (cost=0.42..8.44 rows=1 width=84) (never executed)

  • Index Cond: (id = address_6.id)
  • Filter: (state <> 'DELETED'::text)
169. 0.000 0.000 ↓ 0.0 0

Index Only Scan using address_pkey on address address_8 (cost=0.42..0.60 rows=1 width=16) (never executed)

  • Index Cond: (id = addr_2.id)
  • Heap Fetches: 0
170. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_country on country country_2 (cost=0.27..8.29 rows=1 width=28) (never executed)

  • Index Cond: (id = addr_2.country_id)
171. 0.000 0.000 ↓ 0.0 0

Index Only Scan using address_pkey on address address_7 (cost=0.42..0.60 rows=1 width=16) (never executed)

  • Index Cond: (id = address_6.id)
  • Heap Fetches: 0
172. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=34.87..34.88 rows=1 width=32) (never executed)

173. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.37..34.86 rows=1 width=32) (never executed)

174. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.95..34.25 rows=1 width=64) (never executed)

175. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_organization_address on organization_address organization_address_1 (cost=0.42..8.44 rows=1 width=25) (never executed)

  • Index Cond: (organization_id = employee_1.organization_id)
176. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.53..25.80 rows=1 width=48) (never executed)

177. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address address_9 (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (id = organization_address_1.address_id)
  • Filter: (state <> 'DELETED'::text)
178. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.11..17.35 rows=1 width=48) (never executed)

179. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..9.05 rows=1 width=84) (never executed)

180. 0.000 0.000 ↓ 0.0 0

Index Scan using address_pkey on address addr_3 (cost=0.42..8.44 rows=1 width=84) (never executed)

  • Index Cond: (id = address_9.id)
  • Filter: (state <> 'DELETED'::text)
181. 0.000 0.000 ↓ 0.0 0

Index Only Scan using address_pkey on address address_11 (cost=0.42..0.60 rows=1 width=16) (never executed)

  • Index Cond: (id = addr_3.id)
  • Heap Fetches: 0
182. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_country on country country_3 (cost=0.27..8.29 rows=1 width=28) (never executed)

  • Index Cond: (id = addr_3.country_id)
183. 0.000 0.000 ↓ 0.0 0

Index Only Scan using address_pkey on address address_10 (cost=0.42..0.60 rows=1 width=16) (never executed)

  • Index Cond: (id = address_9.id)
  • Heap Fetches: 0
184. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=20.74..20.75 rows=1 width=32) (never executed)

185. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1.32..20.73 rows=4 width=128) (never executed)

  • Hash Cond: (employee_communication_data_1.communication_data_type_id = communication_data_type_2.id)
186. 0.000 0.000 ↓ 0.0 0

Seq Scan on employee_communication_data employee_communication_data_1 (cost=0.00..19.38 rows=4 width=64) (never executed)

  • Filter: (employee_id = employee_1.id)
187. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.20..1.20 rows=10 width=80) (never executed)

188. 0.000 0.000 ↓ 0.0 0

Seq Scan on communication_data_type communication_data_type_2 (cost=0.00..1.20 rows=10 width=80) (never executed)

  • Filter: employee_usable
189. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=13.81..13.82 rows=1 width=32) (never executed)

190. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1.75..13.80 rows=2 width=108) (never executed)

  • Hash Cond: (organization_communication_data_1.communication_data_type_id = communication_data_type_3.id)
191. 0.000 0.000 ↓ 0.0 0

Index Scan using organization_communication_data_organization_id_idx on organization_communication_data organization_communication_data_1 (cost=0.42..12.46 rows=2 width=44) (never executed)

  • Index Cond: (organization_id = employee_1.organization_id)
192. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.20..1.20 rows=10 width=80) (never executed)

193. 0.000 0.000 ↓ 0.0 0

Seq Scan on communication_data_type communication_data_type_3 (cost=0.00..1.20 rows=10 width=80) (never executed)

  • Filter: organization_usable
194. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=43.88..43.89 rows=1 width=8) (never executed)

195. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on employee org_emp_1 (cost=4.53..43.85 rows=10 width=0) (never executed)

  • Recheck Cond: ((organization_id = employee_1.organization_id) AND (state = 'ACTIVE'::text))
196. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on employee_organization_id_state_idx (cost=0.00..4.52 rows=10 width=0) (never executed)

  • Index Cond: ((organization_id = employee_1.organization_id) AND (state = 'ACTIVE'::text))
197. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=11.01..11.02 rows=1 width=32) (never executed)

198. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=8.73..11.00 rows=1 width=87) (never executed)

199. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.59..10.45 rows=1 width=71) (never executed)

200. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.46..9.89 rows=1 width=32) (never executed)

  • Hash Cond: (person_type_4.id = person_to_person_type_1.person_type_id)
201. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_type person_type_4 (cost=0.00..1.31 rows=31 width=16) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.44..8.44 rows=1 width=16) (never executed)

203. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_person_to_person_type on person_to_person_type person_to_person_type_1 (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (person_id = person_3.id)
  • Heap Fetches: 0
204. 0.000 0.000 ↓ 0.0 0

Index Scan using person_type_pkey on person_type person_type_3 (cost=0.14..0.54 rows=1 width=55) (never executed)

  • Index Cond: (id = person_type_4.id)
  • Filter: (state <> 'DELETED'::text)
205. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_type_pkey on person_type person_type_5 (cost=0.14..0.54 rows=1 width=48) (never executed)

  • Index Cond: (id = person_type_4.id)
  • Heap Fetches: 0
206. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=39.37..39.38 rows=1 width=32) (never executed)

207. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=23.26..39.37 rows=1 width=88) (never executed)

208. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=10.39..26.47 rows=1 width=56) (never executed)

209. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.76 rows=1 width=24) (never executed)

210. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_person on person person_7 (cost=0.42..8.44 rows=1 width=16) (never executed)

  • Index Cond: (id = person_3.id)
  • Heap Fetches: 0
211. 0.000 0.000 ↓ 0.0 0

Index Scan using speaker_speaker_person_id_idx on speaker speaker_1 (cost=0.28..8.30 rows=1 width=40) (never executed)

  • Index Cond: (speaker_person_id = person_3.id)
  • Filter: (state = ANY ('{ACTIVE,LIMBO}'::text[]))
212. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=9.68..9.69 rows=1 width=32) (never executed)

213. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.31..9.68 rows=1 width=112) (never executed)

  • Hash Cond: (indication_area_1.id = speaker_indication_area_1.indication_area_id)
214. 0.000 0.000 ↓ 0.0 0

Seq Scan on indication_area indication_area_1 (cost=0.00..1.26 rows=26 width=112) (never executed)

215. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.30..8.30 rows=1 width=16) (never executed)

216. 0.000 0.000 ↓ 0.0 0

Index Only Scan using speaker_indication_area_pk on speaker_indication_area speaker_indication_area_1 (cost=0.28..8.30 rows=1 width=16) (never executed)

  • Index Cond: (speaker_id = speaker_1.id)
  • Heap Fetches: 0
217. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=12.87..12.88 rows=1 width=32) (never executed)

218. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.48..12.86 rows=2 width=112) (never executed)

  • Hash Cond: (speaker_speaker_request_reason_1.speaker_request_reason_id = speaker_request_reason_1.id)
219. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on speaker_speaker_request_reason speaker_speaker_request_reason_1 (cost=4.30..11.66 rows=2 width=16) (never executed)

  • Recheck Cond: (speaker_id = speaker_1.id)
220. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on speaker_speaker_request_reason_pk (cost=0.00..4.30 rows=2 width=0) (never executed)

  • Index Cond: (speaker_id = speaker_1.id)
221. 0.000 0.000 ↓ 0.0 0

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

222. 0.000 0.000 ↓ 0.0 0

Seq Scan on speaker_request_reason speaker_request_reason_1 (cost=0.00..1.08 rows=8 width=112) (never executed)

223. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=3,966.77..3,966.78 rows=1 width=32) (never executed)

224. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1,314.29..3,966.76 rows=3 width=46) (never executed)

225. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.32..20.51 rows=3 width=30) (never executed)

  • Hash Cond: (topic.id = media_topic.topic_id)
226. 0.000 0.000 ↓ 0.0 0

Seq Scan on topic (cost=0.00..8.20 rows=256 width=30) (never executed)

  • Filter: (state <> 'DELETED'::text)
227. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.28..11.28 rows=3 width=16) (never executed)

228. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on media_topic (cost=4.17..11.28 rows=3 width=16) (never executed)

  • Recheck Cond: (media_id = vm.id)
229. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on media_topic_pkey (cost=0.00..4.17 rows=3 width=0) (never executed)

  • Index Cond: (media_id = vm.id)
230. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1,302.97..1,315.41 rows=1 width=48) (never executed)

231. 0.000 0.000 ↓ 0.0 0

Index Scan using topic_pkey on topic t (cost=0.14..0.27 rows=1 width=41) (never executed)

  • Index Cond: (id = topic.id)
  • Filter: (state <> 'DELETED'::text)
232. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=1,302.83..1,302.84 rows=1 width=32) (never executed)

233. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=434.43..1,302.82 rows=3 width=63) (never executed)

234. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=434.16..1,301.00 rows=3 width=95) (never executed)

235. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=17.78..44.32 rows=3 width=63) (never executed)

  • Hash Cond: (activity_type.id = topic_activity_type.activity_type_id)
236. 0.000 0.000 ↓ 0.0 0

Seq Scan on activity_type (cost=0.00..25.54 rows=65 width=47) (never executed)

  • Filter: (state <> 'DELETED'::text)
237. 0.000 0.000 ↓ 0.0 0

Hash (cost=17.65..17.65 rows=10 width=16) (never executed)

238. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on topic_activity_type (cost=4.36..17.65 rows=10 width=16) (never executed)

  • Recheck Cond: (topic_id = t.id)
239. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on topic_activity_type_topic_id_idx (cost=0.00..4.35 rows=10 width=0) (never executed)

  • Index Cond: (topic_id = t.id)
240. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=416.38..418.88 rows=1 width=48) (never executed)

241. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=382.79..385.25 rows=1 width=275) (never executed)

242. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=271.75..274.19 rows=1 width=243) (never executed)

243. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=263.58..265.99 rows=1 width=211) (never executed)

244. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=260.61..262.99 rows=1 width=179) (never executed)

245. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=260.34..262.59 rows=1 width=163) (never executed)

246. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=260.07..262.19 rows=1 width=131) (never executed)

247. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=259.80..261.80 rows=1 width=115) (never executed)

248. 0.000 0.000 ↓ 0.0 0

Index Scan using activity_type_pkey on activity_type at (cost=0.27..2.01 rows=1 width=99) (never executed)

  • Index Cond: (id = activity_type.id)
249. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=259.53..259.78 rows=1 width=48) (never executed)

  • Hash Cond: (touch_point_group_1.id = touch_point_group.id)
250. 0.000 0.000 ↓ 0.0 0

Group (cost=259.30..259.40 rows=10 width=52) (never executed)

  • Group Key: touch_point_group_1.id, (array_length(COALESCE(array_agg(activity_type_5.id), '{}'::uuid[]), 1))
251. 0.000 0.000 ↓ 0.0 0

Sort (cost=259.30..259.33 rows=10 width=34) (never executed)

  • Sort Key: touch_point_group_1.id, (array_length(COALESCE(array_agg(activity_type_5.id), '{}'::uuid[]), 1))
252. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=25.77..259.14 rows=10 width=34) (never executed)

253. 0.000 0.000 ↓ 0.0 0

Seq Scan on touch_point_group touch_point_group_1 (cost=0.00..1.12 rows=10 width=30) (never executed)

  • Filter: (state <> 'DELETED'::text)
254. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=25.77..25.78 rows=1 width=4) (never executed)

255. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on activity_type activity_type_5 (cost=4.38..25.76 rows=1 width=16) (never executed)

  • Recheck Cond: (state = 'ACTIVE'::text)
  • Filter: (touch_point_group_id = touch_point_group_1.id)
256. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on activity_type_state_base_type_index (cost=0.00..4.38 rows=14 width=0) (never executed)

  • Index Cond: (state = 'ACTIVE'::text)
257. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.21..0.21 rows=1 width=16) (never executed)

258. 0.000 0.000 ↓ 0.0 0

Index Scan using touch_point_group_pkey on touch_point_group (cost=0.14..0.21 rows=1 width=16) (never executed)

  • Index Cond: (id = at.touch_point_group_id)
  • Filter: (state <> 'DELETED'::text)
259. 0.000 0.000 ↓ 0.0 0

Index Only Scan using activity_type_pkey on activity_type activity_type_2 (cost=0.27..0.39 rows=1 width=16) (never executed)

  • Index Cond: (id = at.id)
  • Heap Fetches: 0
260. 0.000 0.000 ↓ 0.0 0

Index Only Scan using activity_type_pkey on activity_type activity_type_3 (cost=0.27..0.39 rows=1 width=48) (never executed)

  • Index Cond: (id = activity_type_2.id)
  • Heap Fetches: 0
261. 0.000 0.000 ↓ 0.0 0

Index Only Scan using activity_type_pkey on activity_type activity_type_4 (cost=0.27..0.39 rows=1 width=48) (never executed)

  • Index Cond: (id = activity_type_2.id)
  • Heap Fetches: 0
262. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=2.97..2.98 rows=1 width=32) (never executed)

263. 0.000 0.000 ↓ 0.0 0

Seq Scan on activity_type_rule (cost=0.00..1.46 rows=3 width=56) (never executed)

  • Filter: (activity_type_id = at.id)
264. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.17..8.18 rows=1 width=32) (never executed)

265. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_activity_type_dispatch_type on activity_type_dispatch_type (cost=0.14..8.16 rows=1 width=7) (never executed)

  • Index Cond: (activity_type_id = at.id)
  • Heap Fetches: 0
266. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=111.04..111.05 rows=1 width=32) (never executed)

267. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=39.22..111.03 rows=2 width=90) (never executed)

268. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=16.71..65.95 rows=2 width=58) (never executed)

269. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..32.50 rows=2 width=42) (never executed)

270. 0.000 0.000 ↓ 0.0 0

Seq Scan on activity_type_assignment (cost=0.00..15.88 rows=2 width=33) (never executed)

  • Filter: (activity_type_id = at.id)
271. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_organizational_unit on organizational_unit (cost=0.28..8.30 rows=1 width=25) (never executed)

  • Index Cond: (id = activity_type_assignment.organizational_unit_id)
  • Filter: (state <> 'DELETED'::text)
272. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=16.43..16.71 rows=1 width=48) (never executed)

273. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.54..0.80 rows=1 width=266) (never executed)

274. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.41..0.63 rows=1 width=170) (never executed)

275. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_organizational_unit on organizational_unit ou (cost=0.28..0.48 rows=1 width=186) (never executed)

  • Index Cond: (id = organizational_unit.id)
  • Filter: (state <> 'DELETED'::text)
276. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_organizational_hierarchy on organizational_hierarchy (cost=0.12..0.15 rows=1 width=16) (never executed)

  • Index Cond: (id = ou.organizational_hierarchy_id)
  • Filter: (state = 'ACTIVE'::text)
277. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_organizational_unit_type on organizational_unit_type (cost=0.14..0.16 rows=1 width=112) (never executed)

  • Index Cond: (id = ou.organizational_unit_type_id)
  • Filter: (state = 'ACTIVE'::text)
278. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=15.88..15.89 rows=1 width=32) (never executed)

279. 0.000 0.000 ↓ 0.0 0

Seq Scan on organizational_unit_tag (cost=0.00..15.88 rows=2 width=32) (never executed)

  • Filter: (organizational_unit_id = ou.id)
280. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=22.51..22.52 rows=1 width=32) (never executed)

281. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.14..22.51 rows=1 width=96) (never executed)

282. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..17.00 rows=1 width=64) (never executed)

  • Join Filter: (activity_type_assignment_consent_item.consent_item_id = consent_item.id)
283. 0.000 0.000 ↓ 0.0 0

Seq Scan on consent_item (cost=0.00..1.03 rows=3 width=64) (never executed)

284. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..15.88 rows=2 width=16) (never executed)

285. 0.000 0.000 ↓ 0.0 0

Seq Scan on activity_type_assignment_consent_item (cost=0.00..15.88 rows=2 width=16) (never executed)

  • Filter: (activity_type_assignment_id = activity_type_assignment.id)
286. 0.000 0.000 ↓ 0.0 0

Index Scan using consent_type_pkey on consent_type (cost=0.14..5.50 rows=1 width=48) (never executed)

  • Index Cond: (id = consent_item.consent_type_id)
287. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=33.60..33.61 rows=1 width=32) (never executed)

288. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=12.05..33.59 rows=1 width=36) (never executed)

289. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=11.46..26.44 rows=1 width=20) (never executed)

290. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=11.32..25.47 rows=3 width=36) (never executed)

  • Hash Cond: (comment_type_1.id = activity_type_comment_type.comment_type_id)
291. 0.000 0.000 ↓ 0.0 0

Seq Scan on comment_type comment_type_1 (cost=0.00..13.00 rows=300 width=16) (never executed)

292. 0.000 0.000 ↓ 0.0 0

Hash (cost=11.28..11.28 rows=3 width=20) (never executed)

293. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on activity_type_comment_type (cost=4.17..11.28 rows=3 width=20) (never executed)

  • Recheck Cond: (activity_type_id = at.id)
294. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_activity_type_comment_type (cost=0.00..4.17 rows=3 width=0) (never executed)

  • Index Cond: (activity_type_id = at.id)
295. 0.000 0.000 ↓ 0.0 0

Index Scan using comment_type_pkey on comment_type (cost=0.15..0.31 rows=1 width=16) (never executed)

  • Index Cond: (id = comment_type_1.id)
  • Filter: (state = 'ACTIVE'::text)
296. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.59..7.14 rows=1 width=48) (never executed)

297. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.44..6.81 rows=1 width=192) (never executed)

298. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..6.49 rows=1 width=160) (never executed)

299. 0.000 0.000 ↓ 0.0 0

Index Scan using comment_type_pkey on comment_type act_com_type (cost=0.15..6.17 rows=1 width=144) (never executed)

  • Index Cond: (id = comment_type.id)
  • Filter: (state <> 'DELETED'::text)
300. 0.000 0.000 ↓ 0.0 0

Index Only Scan using comment_type_pkey on comment_type comment_type_2 (cost=0.15..0.31 rows=1 width=16) (never executed)

  • Index Cond: (id = act_com_type.id)
  • Heap Fetches: 0
301. 0.000 0.000 ↓ 0.0 0

Index Only Scan using comment_type_pkey on comment_type comment_type_3 (cost=0.15..0.31 rows=1 width=48) (never executed)

  • Index Cond: (id = comment_type_2.id)
  • Heap Fetches: 0
302. 0.000 0.000 ↓ 0.0 0

Index Only Scan using comment_type_pkey on comment_type comment_type_4 (cost=0.15..0.31 rows=1 width=48) (never executed)

  • Index Cond: (id = comment_type_2.id)
  • Heap Fetches: 0
303. 0.000 0.000 ↓ 0.0 0

Index Only Scan using activity_type_pkey on activity_type activity_type_1 (cost=0.27..0.60 rows=1 width=16) (never executed)

  • Index Cond: (id = activity_type.id)
  • Heap Fetches: 0
304.          

SubPlan (forNested Loop Left Join)

305. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..156.21 rows=13 width=0) (never executed)

306. 0.000 0.000 ↓ 0.0 0

Seq Scan on template_topic (cost=0.00..26.99 rows=30 width=16) (never executed)

  • Filter: (t.id = topic_id)
307. 0.000 0.000 ↓ 0.0 0

Index Scan using template_pkey on template (cost=0.28..4.30 rows=1 width=16) (never executed)