explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2MB2

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 86.885 ↑ 103.5 2 1

Sort (cost=2,089,493.02..2,089,493.53 rows=207 width=436) (actual time=86.885..86.885 rows=2 loops=1)

  • Sort Key: (min(pn.device_delivered_date_min))
  • Sort Method: quicksort Memory: 29kB
2.          

CTE get_event

3. 0.001 0.094 ↑ 1.0 1 1

Append (cost=0.42..4.97 rows=1 width=88) (actual time=0.093..0.094 rows=1 loops=1)

4. 0.093 0.093 ↑ 1.0 1 1

Index Scan using events_org_part_210_event_uuid_idx on events_org_part_210 e (cost=0.42..4.96 rows=1 width=88) (actual time=0.093..0.093 rows=1 loops=1)

  • Index Cond: (event_uuid = '8a9b2068-2a3d-4032-8bdd-f6393024d0ea'::uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> '2019-09-25 16:38:28.488+00'::timestamp with time zone) AND (organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid))
  • Rows Removed by Filter: 1
5.          

CTE get_event_created_min

6. 0.004 0.005 ↑ 1.0 1 1

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

7. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event e_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.001 rows=1 loops=1)

8.          

CTE get_event_created_max

9. 0.003 0.004 ↑ 1.0 1 1

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

10. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event e_2 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.001 rows=1 loops=1)

11.          

CTE get_event_closing_max

12. 0.011 0.012 ↑ 1.0 1 1

Aggregate (cost=0.02..0.04 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=1)

13. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event e_3 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

14.          

CTE get_response_choices

15. 0.002 0.228 ↑ 6,666.7 3 1

Append (cost=0.42..1,008.53 rows=20,000 width=128) (actual time=0.207..0.228 rows=3 loops=1)

16. 0.010 0.224 ↑ 3,333.3 3 1

Nested Loop (cost=0.42..355.99 rows=10,000 width=128) (actual time=0.206..0.224 rows=3 loops=1)

17. 0.004 0.082 ↑ 1.0 1 1

Nested Loop (cost=0.42..3.47 rows=1 width=993) (actual time=0.080..0.082 rows=1 loops=1)

18. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on get_event e_4 (cost=0.00..0.02 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=1)

  • Filter: (choices IS NULL)
19. 0.076 0.076 ↑ 1.0 1 1

Index Scan using forms_org_seq_vrange_uidx on forms f (cost=0.42..3.44 rows=1 width=1,028) (actual time=0.075..0.076 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (form_uuid = e_4.form_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> e_4.created))
  • Rows Removed by Filter: 3
20. 0.075 0.132 ↑ 3,333.3 3 1

ProjectSet (cost=0.00..52.52 rows=10,000 width=64) (actual time=0.117..0.132 rows=3 loops=1)

21. 0.057 0.057 ↑ 33.3 3 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.056..0.057 rows=3 loops=1)

22. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=1)

23. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.00..352.54 rows=10,000 width=128) (actual time=0.002..0.002 rows=0 loops=1)

24. 0.002 0.002 ↓ 0.0 0 1

CTE Scan on get_event e_5 (cost=0.00..0.02 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (choices IS NOT NULL)
  • Rows Removed by Filter: 1
25. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..52.52 rows=10,000 width=64) (never executed)

26. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..0.52 rows=100 width=32) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

28.          

CTE get_response_matchers

29. 0.028 0.372 ↑ 666.7 3 1

HashAggregate (cost=800.00..845.00 rows=2,000 width=96) (actual time=0.356..0.372 rows=3 loops=1)

  • Group Key: lower(COALESCE(rc.translated_response, rc.text_response)), lower((replace(replace(COALESCE(rc.translated_response, rc.text_response), '%'::text, '\%'::text), '_'::text, '\_'::text) || ' %'::text)), rc.text_response
30. 0.344 0.344 ↑ 6,666.7 3 1

CTE Scan on get_response_choices rc (cost=0.00..650.00 rows=20,000 width=96) (actual time=0.317..0.344 rows=3 loops=1)

31.          

CTE get_lowered_responses_pattern_array

32. 0.042 0.416 ↑ 1.0 1 1

Aggregate (cost=45.00..45.01 rows=1 width=32) (actual time=0.416..0.416 rows=1 loops=1)

33. 0.374 0.374 ↑ 666.7 3 1

CTE Scan on get_response_matchers rc_1 (cost=0.00..40.00 rows=2,000 width=32) (actual time=0.358..0.374 rows=3 loops=1)

34.          

CTE get_person_device_notifications

35. 0.182 30.837 ↑ 4,148.8 5 1

HashAggregate (cost=15,872.33..16,079.77 rows=20,744 width=360) (actual time=30.674..30.837 rows=5 loops=1)

  • Group Key: person_ntfn.recipient_uuid, person_ntfn.notification_uuid, person_ntfn.event_uuid, person_ntfn.parent_ntfn_uuid, (CASE WHEN (person_ntfn.delinked_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) THEN person_ntfn.delinked_date ELSE NULL::timestamp with time zone END), device_ntfn.recipient_uuid, device_ntfn.notification_uuid, (CASE WHEN (device_ntfn.failed_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) THEN device_ntfn.failed_date ELSE NULL::timestamp with time zone END), (CASE WHEN (device_ntfn.delivered_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) THEN device_ntfn.delivered_date ELSE NULL::timestamp with time zone END), (CASE WHEN ((device_response.received <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) AND (((device_response.response)::text || ' '::text) ~~* ANY ($11))) THEN device_ntfn.responded_date ELSE NULL::timestamp with time zone END), (CASE WHEN ((device_response.received <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) AND (((device_response.response)::text || ' '::text) ~~* ANY ($12))) THEN 'RESPONDED'::text WHEN (device_ntfn.delivered_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) THEN 'DELIVERED'::text WHEN (device_ntfn.failed_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) THEN 'FAILED'::text WHEN (live_ntfn.pending_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) THEN 'PENDING'::text ELSE ''::text END), (CASE WHEN (live_ntfn.pending_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) THEN live_ntfn.pending_date ELSE NULL::timestamp with time zone END), device_response.response_uuid, (CASE WHEN ((device_response.received <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) AND (((device_response.response)::text || ' '::text) ~~* ANY ($13))) THEN device_response.response ELSE NULL::character varying END), (CASE WHEN (device_response.received <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) THEN device_response.received ELSE NULL::timestamp with time zone END), device_response.recipient_type, (NULL::uuid), (NULL::character varying), (NULL::timestamp with time zone), (NULL::character varying), (NULL::timestamp with time zone), (NULL::timestamp with time zone)
36. 0.003 30.655 ↑ 4,148.8 5 1

Append (cost=4,123.51..14,731.41 rows=20,744 width=360) (actual time=30.358..30.655 rows=5 loops=1)

37. 0.000 30.534 ↑ 5,185.8 4 1

Nested Loop (cost=4,123.51..14,300.82 rows=20,743 width=335) (actual time=30.356..30.534 rows=4 loops=1)

38.          

Initplan (for Nested Loop)

39. 0.418 0.418 ↑ 1.0 1 1

CTE Scan on get_lowered_responses_pattern_array rc_2 (cost=0.00..0.02 rows=1 width=32) (actual time=0.418..0.418 rows=1 loops=1)

40. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_lowered_responses_pattern_array rc_3 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.001 rows=1 loops=1)

41. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_lowered_responses_pattern_array rc_4 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.001 rows=1 loops=1)

42. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_6 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=1)

43. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_created_min e_7 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.001 rows=1 loops=1)

44. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_8 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

45. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on get_event_created_min e_9 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=1)

46. 0.013 0.013 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_10 (cost=0.00..0.02 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

47. 0.007 0.007 ↑ 1.0 1 1

CTE Scan on get_event_created_min (cost=0.00..0.02 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

48. 0.037 29.987 ↑ 583.0 4 1

Hash Left Join (cost=4,122.90..5,042.43 rows=2,332 width=127) (actual time=29.857..29.987 rows=4 loops=1)

  • Hash Cond: (device_ntfn.notification_uuid = device_response.notification_uuid)
  • Join Filter: (device_ntfn.responded_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone)
49. 0.007 0.424 ↑ 583.0 4 1

Nested Loop (cost=2.94..913.71 rows=2,332 width=80) (actual time=0.296..0.424 rows=4 loops=1)

50. 0.004 0.269 ↑ 58.0 4 1

Nested Loop (cost=2.51..115.57 rows=232 width=24) (actual time=0.233..0.269 rows=4 loops=1)

51. 0.006 0.103 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=16) (actual time=0.102..0.103 rows=1 loops=1)

  • Group Key: get_event.event_uuid
52. 0.097 0.097 ↑ 1.0 1 1

CTE Scan on get_event (cost=0.00..0.02 rows=1 width=16) (actual time=0.095..0.097 rows=1 loops=1)

53. 0.005 0.162 ↓ 4.0 4 1

Append (cost=2.49..115.53 rows=1 width=40) (actual time=0.127..0.162 rows=4 loops=1)

54. 0.089 0.157 ↓ 4.0 4 1

Bitmap Heap Scan on notifications_summary_org_part_146 live_ntfn (cost=2.49..115.52 rows=1 width=40) (actual time=0.124..0.157 rows=4 loops=1)

  • Recheck Cond: (event_uuid = get_event.event_uuid)
  • Filter: ((created_date >= $19) AND (pending_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) AND (organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-09-24 16:38:28.488+00'::timestamp with time zone, $18)))
  • Rows Removed by Filter: 35
  • Heap Blocks: exact=4
55. 0.068 0.068 ↑ 1.9 39 1

Bitmap Index Scan on notifications_summary_org_part_146_event_uuid_idx (cost=0.00..2.49 rows=75 width=0) (actual time=0.067..0.068 rows=39 loops=1)

  • Index Cond: (event_uuid = get_event.event_uuid)
56. 0.004 0.148 ↑ 1.0 1 4

Append (cost=0.43..3.43 rows=1 width=72) (actual time=0.036..0.037 rows=1 loops=4)

57. 0.144 0.144 ↑ 1.0 1 4

Index Scan using notifications_summary_org_part_146_pkey on notifications_summary_org_part_146 device_ntfn (cost=0.43..3.43 rows=1 width=72) (actual time=0.036..0.036 rows=1 loops=4)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid))
  • Filter: ((created_date >= $15) AND (category = 'DEVICE'::text) AND (created_date <= LEAST('2019-09-24 16:38:28.488+00'::timestamp with time zone, $14)))
58. 1.208 29.526 ↓ 1.4 3,842 1

Hash (cost=4,085.99..4,085.99 rows=2,718 width=63) (actual time=29.526..29.526 rows=3,842 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 381kB
59. 16.754 28.318 ↓ 1.4 3,842 1

Bitmap Heap Scan on responses device_response (cost=91.50..4,085.99 rows=2,718 width=63) (actual time=11.784..28.318 rows=3,842 loops=1)

  • Recheck Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (valid_range @> '2019-09-24 16:38:28.488+00'::timestamp with time zone))
  • Filter: (is_visible IS TRUE)
  • Heap Blocks: exact=1,859
60. 11.564 11.564 ↓ 1.4 3,842 1

Bitmap Index Scan on responses_org_valid_range_gist (cost=0.00..90.82 rows=2,740 width=0) (actual time=11.564..11.564 rows=3,842 loops=1)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (valid_range @> '2019-09-24 16:38:28.488+00'::timestamp with time zone))
61. 0.004 0.104 ↑ 1.0 1 4

Append (cost=0.43..3.32 rows=1 width=72) (actual time=0.026..0.026 rows=1 loops=4)

62. 0.100 0.100 ↑ 1.0 1 4

Index Scan using notifications_summary_org_part_146_pkey on notifications_summary_org_part_146 person_ntfn (cost=0.43..3.31 rows=1 width=72) (actual time=0.025..0.025 rows=1 loops=4)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid))
  • Filter: ((created_date >= $17) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-09-24 16:38:28.488+00'::timestamp with time zone, $16)))
63. 0.004 0.118 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.13..119.43 rows=1 width=319) (actual time=0.115..0.118 rows=1 loops=1)

64.          

Initplan (for Nested Loop Left Join)

65. 0.000 0.000 ↓ 0.0 0

CTE Scan on get_lowered_responses_pattern_array rc_5 (cost=0.00..0.02 rows=1 width=32) (never executed)

66. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_11 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

67. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_created_min e_12 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

68. 0.004 0.065 ↑ 1.0 1 1

Nested Loop (cost=2.51..115.76 rows=1 width=88) (actual time=0.062..0.065 rows=1 loops=1)

69. 0.003 0.004 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=1)

  • Group Key: get_event_1.event_uuid
70. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event get_event_1 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1)

71. 0.005 0.057 ↑ 1.0 1 1

Append (cost=2.49..115.72 rows=1 width=88) (actual time=0.054..0.057 rows=1 loops=1)

72. 0.023 0.052 ↑ 1.0 1 1

Bitmap Heap Scan on notifications_summary_org_part_146 person_resp_ntfn (cost=2.49..115.71 rows=1 width=88) (actual time=0.049..0.052 rows=1 loops=1)

  • Recheck Cond: (event_uuid = get_event_1.event_uuid)
  • Filter: ((created_date >= $22) AND (organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-09-24 16:38:28.488+00'::timestamp with time zone, $21)) AND ((responded_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone) OR (failed_date <= '2019-09-24 16:38:28.488+00'::timestamp with time zone)))
  • Rows Removed by Filter: 38
  • Heap Blocks: exact=4
73. 0.029 0.029 ↑ 1.9 39 1

Bitmap Index Scan on notifications_summary_org_part_146_event_uuid_idx (cost=0.00..2.49 rows=75 width=0) (actual time=0.029..0.029 rows=39 loops=1)

  • Index Cond: (event_uuid = get_event_1.event_uuid)
74. 0.047 0.047 ↓ 0.0 0 1

Index Scan using responses_notification_uuid_idx on responses pr_1 (cost=0.56..3.60 rows=1 width=63) (actual time=0.047..0.047 rows=0 loops=1)

  • Index Cond: (notification_uuid = person_resp_ntfn.notification_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> '2019-09-24 16:38:28.488+00'::timestamp with time zone) AND (organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (((response)::text || ' '::text) ~~* ANY ($20)))
75.          

CTE get_teams

76. 0.014 0.207 ↑ 1,471.0 1 1

HashAggregate (cost=78,518.81..78,533.52 rows=1,471 width=56) (actual time=0.199..0.207 rows=1 loops=1)

  • Group Key: team_ntfn.notification_uuid, team_ntfn.parent_ntfn_uuid
77. 0.081 0.193 ↑ 7,354.0 2 1

HashAggregate (cost=78,040.80..78,187.88 rows=14,708 width=72) (actual time=0.159..0.193 rows=2 loops=1)

  • Group Key: n.person_ntfn_uuid, team_ntfn.notification_uuid, team_ntfn.parent_ntfn_uuid
78. 0.006 0.112 ↑ 73,537.5 2 1

GroupAggregate (cost=69,216.30..73,996.24 rows=147,075 width=128) (actual time=0.111..0.112 rows=2 loops=1)

  • Group Key: n.person_uuid, n.person_ntfn_uuid, team_ntfn.notification_uuid, team_ntfn.parent_ntfn_uuid
79.          

Initplan (for GroupAggregate)

80. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_13 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

81. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_created_min e_14 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

82. 0.010 0.104 ↑ 73,537.5 2 1

Sort (cost=69,216.26..69,583.95 rows=147,075 width=96) (actual time=0.103..0.104 rows=2 loops=1)

  • Sort Key: n.person_uuid, n.person_ntfn_uuid, team_ntfn.notification_uuid, team_ntfn.parent_ntfn_uuid
  • Sort Method: quicksort Memory: 25kB
83. 0.008 0.094 ↑ 73,537.5 2 1

Nested Loop (cost=0.43..51,743.92 rows=147,075 width=96) (actual time=0.054..0.094 rows=2 loops=1)

84. 0.001 0.001 ↑ 4,148.8 5 1

CTE Scan on get_person_device_notifications n (cost=0.00..414.88 rows=20,744 width=80) (actual time=0.001..0.001 rows=5 loops=1)

85. 0.000 0.085 ↓ 0.0 0 5

Append (cost=0.43..2.46 rows=1 width=32) (actual time=0.017..0.017 rows=0 loops=5)

86. 0.085 0.085 ↓ 0.0 0 5

Index Scan using notifications_summary_org_part_146_pkey on notifications_summary_org_part_146 team_ntfn (cost=0.43..2.46 rows=1 width=32) (actual time=0.017..0.017 rows=0 loops=5)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (notification_uuid = n.team_uuid))
  • Filter: ((created_date >= $30) AND (category = 'TEAM'::text) AND (created_date <= LEAST('2019-09-24 16:38:28.488+00'::timestamp with time zone, $29)))
  • Rows Removed by Filter: 0
87.          

CTE get_team_groups

88. 0.023 0.165 ↑ 149,777.2 4 1

Recursive Union (cost=33.57..229,809.65 rows=599,109 width=74) (actual time=0.041..0.165 rows=4 loops=1)

89. 0.001 0.042 ↑ 709.0 1 1

Nested Loop (cost=33.57..707.82 rows=709 width=74) (actual time=0.039..0.042 rows=1 loops=1)

90.          

Initplan (for Nested Loop)

91. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_15 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.001 rows=1 loops=1)

92. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_created_min e_16 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

93. 0.007 0.015 ↑ 200.0 1 1

HashAggregate (cost=33.10..35.10 rows=200 width=16) (actual time=0.013..0.015 rows=1 loops=1)

  • Group Key: get_teams.team_ntfn_uuid
94. 0.008 0.008 ↑ 1,471.0 1 1

CTE Scan on get_teams (cost=0.00..29.42 rows=1,471 width=16) (actual time=0.000..0.008 rows=1 loops=1)

95. 0.001 0.024 ↑ 1.0 1 1

Append (cost=0.43..3.35 rows=1 width=54) (actual time=0.023..0.024 rows=1 loops=1)

96. 0.023 0.023 ↑ 1.0 1 1

Index Scan using notifications_summary_org_part_146_pkey on notifications_summary_org_part_146 team_ntfn_1 (cost=0.43..3.35 rows=1 width=54) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (notification_uuid = get_teams.team_ntfn_uuid))
  • Filter: ((created_date >= $35) AND (category = 'TEAM'::text) AND (created_date <= LEAST('2019-09-24 16:38:28.488+00'::timestamp with time zone, $34)))
97. 0.002 0.100 ↑ 59,840.0 1 4

Nested Loop (cost=0.47..21,711.97 rows=59,840 width=74) (actual time=0.025..0.025 rows=1 loops=4)

98.          

Initplan (for Nested Loop)

99. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_17 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.001 rows=1 loops=1)

100. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_created_min e_18 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

101. 0.004 0.004 ↑ 7,090.0 1 4

WorkTable Scan on get_team_groups tg_1 (cost=0.00..141.80 rows=7,090 width=36) (actual time=0.001..0.001 rows=1 loops=4)

102. 0.004 0.092 ↑ 1.0 1 4

Append (cost=0.43..3.01 rows=1 width=54) (actual time=0.022..0.023 rows=1 loops=4)

103. 0.088 0.088 ↑ 1.0 1 4

Index Scan using notifications_summary_org_part_146_pkey on notifications_summary_org_part_146 n_1 (cost=0.43..3.01 rows=1 width=54) (actual time=0.022..0.022 rows=1 loops=4)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (notification_uuid = tg_1.parent_ntfn_uuid))
  • Filter: ((created_date >= $37) AND (category = ANY ('{TEAM,GROUP}'::text[])) AND (created_date <= LEAST('2019-09-24 16:38:28.488+00'::timestamp with time zone, $36)))
  • Rows Removed by Filter: 0
104.          

CTE get_targeted_groups

105. 0.002 0.556 ↑ 20.0 1 1

Nested Loop (cost=13,793.16..13,900.56 rows=20 width=168) (actual time=0.554..0.556 rows=1 loops=1)

106.          

Initplan (for Nested Loop)

107. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_19 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.001 rows=1 loops=1)

108. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_created_min e_20 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

109. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_created_max e_21 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

110. 0.004 0.536 ↑ 15.0 1 1

Nested Loop Left Join (cost=13,792.68..13,848.27 rows=15 width=136) (actual time=0.536..0.536 rows=1 loops=1)

111. 0.015 0.456 ↑ 15.0 1 1

GroupAggregate (cost=13,792.12..13,794.23 rows=15 width=88) (actual time=0.456..0.456 rows=1 loops=1)

  • Group Key: team_group.notification_uuid, team_group.recipient_uuid
112. 0.006 0.441 ↑ 110.0 1 1

Sort (cost=13,792.12..13,792.39 rows=110 width=72) (actual time=0.441..0.441 rows=1 loops=1)

  • Sort Key: team_group.notification_uuid, team_group.recipient_uuid
  • Sort Method: quicksort Memory: 25kB
113. 0.022 0.435 ↑ 110.0 1 1

Hash Join (cost=13,750.51..13,788.39 rows=110 width=72) (actual time=0.434..0.435 rows=1 loops=1)

  • Hash Cond: (team.team_ntfn_uuid = team_group.root_uuid)
114. 0.202 0.202 ↑ 1,471.0 1 1

CTE Scan on get_teams team (cost=0.00..29.42 rows=1,471 width=40) (actual time=0.202..0.202 rows=1 loops=1)

115. 0.007 0.211 ↑ 15.0 1 1

Hash (cost=13,750.32..13,750.32 rows=15 width=48) (actual time=0.211..0.211 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
116. 0.003 0.204 ↑ 15.0 1 1

Subquery Scan on team_group (cost=13,652.95..13,750.32 rows=15 width=48) (actual time=0.202..0.204 rows=1 loops=1)

  • Filter: (team_group.""row"" = 1)
  • Rows Removed by Filter: 1
117. 0.020 0.201 ↑ 1,498.0 2 1

WindowAgg (cost=13,652.95..13,712.87 rows=2,996 width=60) (actual time=0.200..0.201 rows=2 loops=1)

118. 0.010 0.181 ↑ 1,498.0 2 1

Sort (cost=13,652.95..13,660.44 rows=2,996 width=52) (actual time=0.181..0.181 rows=2 loops=1)

  • Sort Key: tg_2.root_uuid, tg_2.group_level DESC
  • Sort Method: quicksort Memory: 25kB
119. 0.171 0.171 ↑ 1,498.0 2 1

CTE Scan on get_team_groups tg_2 (cost=0.00..13,479.95 rows=2,996 width=52) (actual time=0.109..0.171 rows=2 loops=1)

  • Filter: (category = 'GROUP'::text)
  • Rows Removed by Filter: 2
120. 0.076 0.076 ↑ 1.0 1 1

Index Scan using groups_org_seq_vrange_uidx on groups g (cost=0.56..3.58 rows=1 width=64) (actual time=0.076..0.076 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (group_uuid = team_group.recipient_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> $43))
  • Rows Removed by Filter: 1
121. 0.001 0.015 ↑ 1.0 1 1

Append (cost=0.43..3.46 rows=1 width=40) (actual time=0.014..0.015 rows=1 loops=1)

122. 0.014 0.014 ↑ 1.0 1 1

Index Scan using notifications_summary_org_part_146_pkey on notifications_summary_org_part_146 gn (cost=0.43..3.46 rows=1 width=40) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (notification_uuid = team_group.notification_uuid))
  • Filter: ((created_date >= $42) AND (category = 'GROUP'::text) AND (created_date <= LEAST('2019-09-24 16:38:28.488+00'::timestamp with time zone, $41)))
123.          

CTE get_total_person_uuids

124. 0.029 0.197 ↑ 66.7 3 1

HashAggregate (cost=518.60..520.60 rows=200 width=24) (actual time=0.195..0.197 rows=3 loops=1)

  • Group Key: en.person_uuid
125. 0.168 0.168 ↑ 4,148.8 5 1

CTE Scan on get_person_device_notifications en (cost=0.00..414.88 rows=20,744 width=24) (actual time=0.001..0.168 rows=5 loops=1)

126.          

CTE get_total_person_count

127. 0.003 0.004 ↑ 1.0 1 1

Aggregate (cost=4.50..4.51 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

128. 0.001 0.001 ↑ 66.7 3 1

CTE Scan on get_total_person_uuids (cost=0.00..4.00 rows=200 width=0) (actual time=0.001..0.001 rows=3 loops=1)

129.          

CTE get_person_uuids

130. 0.001 0.216 ↑ 33.3 3 1

Limit (cost=11.64..11.89 rows=100 width=24) (actual time=0.215..0.216 rows=3 loops=1)

131. 0.015 0.215 ↑ 66.7 3 1

Sort (cost=11.64..12.14 rows=200 width=24) (actual time=0.214..0.215 rows=3 loops=1)

  • Sort Key: en_agg.delivered_date_min
  • Sort Method: quicksort Memory: 25kB
132. 0.200 0.200 ↑ 66.7 3 1

CTE Scan on get_total_person_uuids en_agg (cost=0.00..4.00 rows=200 width=24) (actual time=0.197..0.200 rows=3 loops=1)

133.          

CTE get_person_notifications

134. 0.005 83.222 ↑ 691.3 3 1

Subquery Scan on p (cost=520,863.17..1,664,184.99 rows=2,074 width=312) (actual time=83.148..83.222 rows=3 loops=1)

135. 0.232 83.217 ↑ 691.3 3 1

GroupAggregate (cost=520,863.17..1,664,133.14 rows=2,074 width=280) (actual time=83.143..83.217 rows=3 loops=1)

  • Group Key: get_person_device_notifications.person_uuid, get_person_device_notifications.person_ntfn_uuid, get_person_device_notifications.person_delinked_date, get_person_device_notifications.team_uuid, get_person_device_notifications.event_uuid, ((SubPlan 36)), get_person_device_notifications.person_response_received, get_person_device_notifications.person_response_recipient_type, get_person_device_notifications.person_responded_date
136.          

Initplan (for GroupAggregate)

137. 0.006 0.006 ↑ 1.0 1 1

CTE Scan on get_event_created_max e_22 (cost=0.00..0.02 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

138. 0.037 82.967 ↑ 2,593.0 4 1

Sort (cost=520,863.15..520,889.08 rows=10,372 width=336) (actual time=82.967..82.967 rows=4 loops=1)

  • Sort Key: get_person_device_notifications.person_uuid, get_person_device_notifications.person_ntfn_uuid, get_person_device_notifications.person_delinked_date, get_person_device_notifications.team_uuid, get_person_device_notifications.event_uuid, ((SubPlan 36)), get_person_device_notifications.person_response_received, get_person_device_notifications.person_response_recipient_type, get_person_device_notifications.person_responded_date
  • Sort Method: quicksort Memory: 26kB
139. 0.045 82.930 ↑ 2,593.0 4 1

Hash Left Join (cost=137.13..520,171.32 rows=10,372 width=336) (actual time=82.906..82.930 rows=4 loops=1)

  • Hash Cond: (get_person_device_notifications.device_uuid = d.recipient_uuid)
140. 0.023 30.930 ↑ 2,593.0 4 1

Hash Semi Join (cost=3.25..587.97 rows=10,372 width=288) (actual time=30.919..30.930 rows=4 loops=1)

  • Hash Cond: (get_person_device_notifications.person_uuid = get_person_uuids.person_uuid)
141. 30.683 30.683 ↑ 4,148.8 5 1

CTE Scan on get_person_device_notifications (cost=0.00..414.88 rows=20,744 width=288) (actual time=30.679..30.683 rows=5 loops=1)

142. 0.004 0.224 ↑ 50.0 2 1

Hash (cost=2.00..2.00 rows=100 width=16) (actual time=0.224..0.224 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
143. 0.220 0.220 ↑ 33.3 3 1

CTE Scan on get_person_uuids (cost=0.00..2.00 rows=100 width=16) (actual time=0.218..0.220 rows=3 loops=1)

144. 0.145 51.875 ↓ 40.2 523 1

Hash (cost=133.72..133.72 rows=13 width=64) (actual time=51.875..51.875 rows=523 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 53kB
145. 0.055 51.730 ↓ 40.2 523 1

Append (cost=111.14..133.72 rows=13 width=64) (actual time=49.915..51.730 rows=523 loops=1)

146. 1.804 51.675 ↓ 40.2 523 1

Bitmap Heap Scan on devices_org_part_default d (cost=111.14..133.66 rows=13 width=64) (actual time=49.914..51.675 rows=523 loops=1)

  • Recheck Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (valid_range @> $53))
  • Filter: (is_visible IS TRUE)
  • Heap Blocks: exact=194
147. 0.237 49.871 ↓ 0.0 0 1

BitmapAnd (cost=111.14..111.14 rows=15 width=0) (actual time=49.871..49.871 rows=0 loops=1)

148. 0.369 0.369 ↑ 1.1 2,802 1

Bitmap Index Scan on devices_org_part_default_pkey (cost=0.00..51.34 rows=2,989 width=0) (actual time=0.369..0.369 rows=2,802 loops=1)

  • Index Cond: (organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid)
149. 49.265 49.265 ↓ 100.1 270,500 1

Bitmap Index Scan on devices_org_part_default_valid_range_idx (cost=0.00..59.54 rows=2,701 width=0) (actual time=49.264..49.265 rows=270,500 loops=1)

  • Index Cond: (valid_range @> $53)
150.          

SubPlan (for Hash Left Join)

151. 0.004 0.080 ↓ 0.0 0 4

Limit (cost=50.07..50.08 rows=1 width=36) (actual time=0.020..0.020 rows=0 loops=4)

152. 0.068 0.076 ↓ 0.0 0 4

Sort (cost=50.07..50.10 rows=10 width=36) (actual time=0.019..0.019 rows=0 loops=4)

  • Sort Key: (length(rm.response)) DESC
  • Sort Method: quicksort Memory: 25kB
153. 0.008 0.008 ↓ 0.0 0 4

CTE Scan on get_response_matchers rm (cost=0.00..50.02 rows=10 width=36) (actual time=0.002..0.002 rows=0 loops=4)

  • Filter: (((get_person_device_notifications.person_response)::text || ' '::text) ~~* response_pattern)
  • Rows Removed by Filter: 3
154.          

SubPlan (for GroupAggregate)

155. 0.000 0.012 ↓ 0.0 0 4

Limit (cost=50.07..50.08 rows=1 width=36) (actual time=0.003..0.003 rows=0 loops=4)

156. 0.008 0.012 ↓ 0.0 0 4

Sort (cost=50.07..50.10 rows=10 width=36) (actual time=0.003..0.003 rows=0 loops=4)

  • Sort Key: (length(rm_2.response)) DESC
  • Sort Method: quicksort Memory: 25kB
157. 0.004 0.004 ↓ 0.0 0 4

CTE Scan on get_response_matchers rm_2 (cost=0.00..50.02 rows=10 width=36) (actual time=0.001..0.001 rows=0 loops=4)

  • Filter: (((get_person_device_notifications.device_response)::text || ' '::text) ~~* response_pattern)
  • Rows Removed by Filter: 3
158. 0.000 0.000 ↓ 0.0 0

Limit (cost=50.07..50.08 rows=1 width=36) (never executed)

159. 0.000 0.000 ↓ 0.0 0

Sort (cost=50.07..50.10 rows=10 width=36) (never executed)

  • Sort Key: (length(rm_1.response)) DESC
160. 0.000 0.000 ↓ 0.0 0

CTE Scan on get_response_matchers rm_1 (cost=0.00..50.02 rows=10 width=36) (never executed)

  • Filter: (((get_person_device_notifications.device_response)::text || ' '::text) ~~* response_pattern)
161.          

Initplan (for Sort)

162. 0.005 0.005 ↑ 1.0 1 1

CTE Scan on get_total_person_count (cost=0.00..0.02 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

163. 0.001 0.002 ↑ 1.0 1 1

Limit (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=1)

164. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event get_event_2 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1)

165. 0.003 0.004 ↑ 1.0 1 1

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

166. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event e_23 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

167. 0.003 0.004 ↑ 1.0 1 1

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

168. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event e_24 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

169. 0.023 86.828 ↑ 103.5 2 1

Nested Loop Left Join (cost=563.01..84,533.85 rows=207 width=436) (actual time=86.479..86.828 rows=2 loops=1)

170. 0.027 86.501 ↑ 103.5 2 1

Hash Left Join (cost=514.36..74,453.41 rows=207 width=448) (actual time=86.243..86.501 rows=2 loops=1)

  • Hash Cond: (person.site_uuid = site.site_uuid)
171. 0.006 86.350 ↑ 103.5 2 1

Nested Loop Left Join (cost=511.04..74,449.31 rows=207 width=437) (actual time=86.094..86.350 rows=2 loops=1)

172. 0.006 84.142 ↑ 103.5 2 1

Nested Loop Left Join (cost=510.49..73,707.16 rows=207 width=232) (actual time=83.982..84.142 rows=2 loops=1)

173. 0.006 83.532 ↑ 103.5 2 1

Nested Loop Left Join (cost=510.03..73,606.25 rows=207 width=232) (actual time=83.412..83.532 rows=2 loops=1)

174. 0.015 83.520 ↑ 103.5 2 1

Nested Loop Left Join (cost=332.26..36,801.65 rows=207 width=232) (actual time=83.405..83.520 rows=2 loops=1)

175. 0.124 83.379 ↑ 103.5 2 1

GroupAggregate (cost=155.74..253.73 rows=207 width=248) (actual time=83.324..83.379 rows=2 loops=1)

  • Group Key: pn.person_uuid, pn.event_uuid
176. 0.023 83.255 ↑ 691.3 3 1

Sort (cost=155.74..160.92 rows=2,074 width=296) (actual time=83.255..83.255 rows=3 loops=1)

  • Sort Key: pn.person_uuid, pn.event_uuid
  • Sort Method: quicksort Memory: 27kB
177. 83.232 83.232 ↑ 691.3 3 1

CTE Scan on get_person_notifications pn (cost=0.00..41.48 rows=2,074 width=296) (actual time=83.154..83.232 rows=3 loops=1)

178. 0.088 0.126 ↑ 1.0 1 2

Aggregate (cost=176.52..176.53 rows=1 width=32) (actual time=0.063..0.063 rows=1 loops=2)

179. 0.020 0.038 ↑ 5,000.0 2 2

ProjectSet (cost=0.00..51.52 rows=10,000 width=32) (actual time=0.017..0.019 rows=2 loops=2)

180. 0.016 0.018 ↑ 50.0 2 2

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.009..0.009 rows=2 loops=2)

181. 0.002 0.002 ↑ 1.0 1 2

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=2)

182. 0.002 0.006 ↑ 1.0 1 2

Aggregate (cost=177.77..177.78 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=2)

183. 0.002 0.004 ↓ 0.0 0 2

ProjectSet (cost=0.00..52.77 rows=10,000 width=32) (actual time=0.002..0.002 rows=0 loops=2)

184. 0.002 0.002 ↓ 0.0 0 2

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=2)

185. 0.000 0.000 ↑ 1.0 1 2

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=2)

186. 0.038 0.604 ↑ 1.0 1 2

Aggregate (cost=0.46..0.47 rows=1 width=32) (actual time=0.302..0.302 rows=1 loops=2)

187. 0.566 0.566 ↓ 0.0 0 2

CTE Scan on get_targeted_groups tg (cost=0.00..0.45 rows=1 width=120) (actual time=0.283..0.283 rows=0 loops=2)

  • Filter: (team_ntfn_uuids && (array_agg(pn.team_uuid)))
  • Rows Removed by Filter: 0
188. 0.002 2.202 ↑ 1.0 1 2

Append (cost=0.56..3.58 rows=1 width=205) (actual time=1.086..1.101 rows=1 loops=2)

189. 2.200 2.200 ↑ 1.0 1 2

Index Scan using persons_org_part_default_organization_uuid_person_uuid_sequ_idx on persons_org_part_default person (cost=0.56..3.57 rows=1 width=205) (actual time=1.085..1.100 rows=1 loops=2)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (person_uuid = pn.person_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> $57))
  • Rows Removed by Filter: 140
190. 0.009 0.124 ↑ 1.0 1 1

Hash (cost=3.30..3.30 rows=1 width=27) (actual time=0.124..0.124 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
191. 0.115 0.115 ↑ 1.0 1 1

Index Scan using sites_org_valid_range_gist on sites site (cost=0.28..3.30 rows=1 width=27) (actual time=0.095..0.115 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (valid_range @> $58))
  • Filter: (is_visible IS TRUE)
192. 0.034 0.304 ↑ 1.0 1 2

Aggregate (cost=48.65..48.66 rows=1 width=32) (actual time=0.152..0.152 rows=1 loops=2)

193. 0.016 0.270 ↑ 100.0 1 2

Nested Loop Left Join (cost=6.90..44.15 rows=100 width=57) (actual time=0.132..0.135 rows=1 loops=2)

194. 0.002 0.130 ↑ 1.0 1 2

Append (cost=0.42..3.45 rows=1 width=56) (actual time=0.064..0.065 rows=1 loops=2)

195. 0.128 0.128 ↑ 1.0 1 2

Index Scan using person_roles_org_part_default_organization_uuid_person_uuid_idx on person_roles_org_part_default pr (cost=0.42..3.45 rows=1 width=56) (actual time=0.063..0.064 rows=1 loops=2)

  • Index Cond: ((organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid) AND (person_uuid = person.person_uuid))
  • Filter: upper_inf(valid_range)
  • Rows Removed by Filter: 4
196. 0.024 0.124 ↓ 0.0 0 2

Hash Right Join (cost=6.48..39.70 rows=100 width=57) (actual time=0.061..0.062 rows=0 loops=2)

  • Hash Cond: (role.role_uuid = (((jsonb_array_elements_text(pr.roles)))::uuid))
197. 0.037 0.074 ↓ 3.2 26 1

Bitmap Heap Scan on roles role (cost=1.96..35.14 rows=8 width=57) (actual time=0.049..0.074 rows=26 loops=1)

  • Recheck Cond: (organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid)
  • Filter: upper_inf(valid_range)
  • Heap Blocks: exact=3
198. 0.037 0.037 ↓ 1.1 26 1

Bitmap Index Scan on roles_organization_uuid_idx (cost=0.00..1.96 rows=23 width=0) (actual time=0.037..0.037 rows=26 loops=1)

  • Index Cond: (organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid)
199. 0.004 0.026 ↓ 0.0 0 2

Hash (cost=3.27..3.27 rows=100 width=16) (actual time=0.013..0.013 rows=0 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
200. 0.006 0.022 ↓ 0.0 0 2

Result (cost=0.00..2.27 rows=100 width=16) (actual time=0.010..0.011 rows=0 loops=2)

201. 0.016 0.016 ↓ 0.0 0 2

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.008..0.008 rows=0 loops=2)

202. 0.000 0.000 ↑ 1.0 1 2

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=2)

Planning time : 808.586 ms
Execution time : 92.873 ms