explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mldb

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 31,175.504 ↑ 103.5 2 1

Sort (cost=2,089,493.01..2,089,493.53 rows=207 width=436) (actual time=31,175.503..31,175.504 rows=2 loops=1)

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

CTE get_event

3. 0.001 18.007 ↑ 1.0 1 1

Append (cost=0.42..4.97 rows=1 width=88) (actual time=18.006..18.007 rows=1 loops=1)

4. 18.006 18.006 ↑ 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=18.005..18.006 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.010 0.011 ↑ 1.0 1 1

Aggregate (cost=0.02..0.03 rows=1 width=8) (actual time=0.011..0.011 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.001..0.001 rows=1 loops=1)

8.          

CTE get_event_created_max

9. 0.007 0.009 ↑ 1.0 1 1

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

10. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on get_event e_2 (cost=0.00..0.02 rows=1 width=8) (actual time=0.002..0.002 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.000..0.001 rows=1 loops=1)

14.          

CTE get_response_choices

15. 0.002 41.095 ↑ 6,666.7 3 1

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

16. 0.015 41.090 ↑ 3,333.3 3 1

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

17. 0.006 40.897 ↑ 1.0 1 1

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

18. 0.004 0.004 ↑ 1.0 1 1

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

  • Filter: (choices IS NULL)
19. 40.887 40.887 ↑ 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=40.886..40.887 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.178 ↑ 3,333.3 3 1

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

21. 0.102 0.103 ↑ 33.3 3 1

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

22. 0.001 0.001 ↑ 1.0 1 1

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

23. 0.001 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.00..352.54 rows=10,000 width=128) (actual time=0.003..0.003 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.034 41.259 ↑ 666.7 3 1

HashAggregate (cost=800.00..845.00 rows=2,000 width=96) (actual time=41.241..41.259 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. 41.225 41.225 ↑ 6,666.7 3 1

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

31.          

CTE get_lowered_responses_pattern_array

32. 0.037 41.299 ↑ 1.0 1 1

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

33. 41.262 41.262 ↑ 666.7 3 1

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

34.          

CTE get_person_device_notifications

35. 0.180 24,484.012 ↑ 4,148.8 5 1

HashAggregate (cost=15,872.33..16,079.77 rows=20,744 width=360) (actual time=24,483.861..24,484.012 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.005 24,483.832 ↑ 4,148.8 5 1

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

37. 0.015 24,469.528 ↑ 5,185.8 4 1

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

38.          

Initplan (for Nested Loop)

39. 41.301 41.301 ↑ 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=41.301..41.301 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.001..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.001..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.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

46. 0.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

47. 0.014 0.014 ↑ 1.0 1 1

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

48. 0.050 24,425.181 ↑ 583.0 4 1

Hash Left Join (cost=4,122.90..5,042.42 rows=2,332 width=127) (actual time=24,422.815..24,425.181 rows=4 loops=1)

  • Hash Cond: (device_ntfn.notification_uuid = device_response.notification_uuid)
49. 0.009 23.611 ↑ 583.0 4 1

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

50. 0.006 20.874 ↑ 58.0 4 1

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

51. 0.011 18.022 ↑ 1.0 1 1

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

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

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

53. 0.007 2.846 ↓ 4.0 4 1

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

54. 2.024 2.839 ↓ 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=1.625..2.839 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.815 0.815 ↑ 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.815..0.815 rows=39 loops=1)

  • Index Cond: (event_uuid = get_event.event_uuid)
56. 0.008 2.728 ↑ 1.0 1 4

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

57. 2.720 2.720 ↑ 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.680..0.680 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. 10.633 24,401.520 ↓ 1.4 3,842 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 381kB
59. 23,398.348 24,390.887 ↓ 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=1,017.385..24,390.887 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. 992.539 992.539 ↓ 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=992.538..992.539 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.008 2.996 ↑ 1.0 1 4

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

62. 2.988 2.988 ↑ 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.746..0.747 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.008 14.299 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.13..119.43 rows=1 width=319) (actual time=14.280..14.299 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.089 ↑ 1.0 1 1

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

69. 0.007 0.009 ↑ 1.0 1 1

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

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

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

71. 0.004 0.076 ↑ 1.0 1 1

Append (cost=2.49..115.72 rows=1 width=88) (actual time=0.059..0.076 rows=1 loops=1)

72. 0.044 0.072 ↑ 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.056..0.072 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.028 0.028 ↑ 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.028..0.028 rows=39 loops=1)

  • Index Cond: (event_uuid = get_event_1.event_uuid)
74. 14.200 14.200 ↓ 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=14.200..14.200 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.018 1.306 ↑ 1,471.0 1 1

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

  • Group Key: team_ntfn.notification_uuid, team_ntfn.parent_ntfn_uuid
77. 0.087 1.288 ↑ 7,354.0 2 1

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

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

GroupAggregate (cost=69,216.30..73,996.24 rows=147,075 width=128) (actual time=1.200..1.201 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.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

82. 0.013 1.191 ↑ 73,537.5 2 1

Sort (cost=69,216.26..69,583.95 rows=147,075 width=96) (actual time=1.191..1.191 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.006 1.178 ↑ 73,537.5 2 1

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

84. 0.002 0.002 ↑ 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.002 rows=5 loops=1)

85. 0.005 1.170 ↓ 0.0 0 5

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

86. 1.165 1.165 ↓ 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.233..0.233 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.008 0.177 ↑ 149,777.2 4 1

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

89. 0.002 0.041 ↑ 709.0 1 1

Nested Loop (cost=33.57..707.82 rows=709 width=74) (actual time=0.039..0.041 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.001..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.018 ↑ 200.0 1 1

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

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

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

95. 0.002 0.019 ↑ 1.0 1 1

Append (cost=0.43..3.35 rows=1 width=54) (actual time=0.018..0.019 rows=1 loops=1)

96. 0.017 0.017 ↑ 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.017..0.017 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.006 0.128 ↑ 59,840.0 1 4

Nested Loop (cost=0.47..21,711.97 rows=59,840 width=74) (actual time=0.032..0.032 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.001..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.000 0.116 ↑ 1.0 1 4

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

103. 0.116 0.116 ↑ 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.029..0.029 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 12.946 ↑ 20.0 1 1

Nested Loop (cost=13,793.16..13,900.56 rows=20 width=168) (actual time=12.943..12.946 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.001..0.001 rows=1 loops=1)

108. 0.002 0.002 ↑ 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.002..0.002 rows=1 loops=1)

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

110. 0.005 12.890 ↑ 15.0 1 1

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

111. 0.009 1.584 ↑ 15.0 1 1

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

  • Group Key: team_group.notification_uuid, team_group.recipient_uuid
112. 0.009 1.575 ↑ 110.0 1 1

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

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

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

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

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

115. 0.008 0.235 ↑ 15.0 1 1

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

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

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

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

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

118. 0.014 0.201 ↑ 1,498.0 2 1

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

  • Sort Key: tg_2.root_uuid, tg_2.group_level DESC
  • Sort Method: quicksort Memory: 25kB
119. 0.187 0.187 ↑ 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.113..0.187 rows=2 loops=1)

  • Filter: (category = 'GROUP'::text)
  • Rows Removed by Filter: 2
120. 11.301 11.301 ↑ 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=11.301..11.301 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.003 0.047 ↑ 1.0 1 1

Append (cost=0.43..3.46 rows=1 width=40) (actual time=0.045..0.047 rows=1 loops=1)

122. 0.044 0.044 ↑ 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.043..0.044 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.012 0.168 ↑ 66.7 3 1

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

  • Group Key: en.person_uuid
125. 0.156 0.156 ↑ 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.156 rows=5 loops=1)

126.          

CTE get_total_person_count

127. 0.007 0.009 ↑ 1.0 1 1

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

128. 0.002 0.002 ↑ 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.002 rows=3 loops=1)

129.          

CTE get_person_uuids

130. 0.002 0.193 ↑ 33.3 3 1

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

131. 0.017 0.191 ↑ 66.7 3 1

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

  • Sort Key: en_agg.delivered_date_min
  • Sort Method: quicksort Memory: 25kB
132. 0.174 0.174 ↑ 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.168..0.174 rows=3 loops=1)

133.          

CTE get_person_notifications

134. 0.008 30,371.186 ↑ 691.3 3 1

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

135. 0.281 30,371.178 ↑ 691.3 3 1

GroupAggregate (cost=520,863.17..1,664,133.14 rows=2,074 width=280) (actual time=30,371.104..30,371.178 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.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

138. 0.033 30,370.868 ↑ 2,593.0 4 1

Sort (cost=520,863.15..520,889.08 rows=10,372 width=336) (actual time=30,370.867..30,370.868 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.048 30,370.835 ↑ 2,593.0 4 1

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

  • Hash Cond: (get_person_device_notifications.device_uuid = d.recipient_uuid)
140. 0.031 24,484.101 ↑ 2,593.0 4 1

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

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

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

142. 0.006 0.202 ↑ 50.0 2 1

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

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

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

144. 0.870 5,886.594 ↓ 40.2 523 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 53kB
145. 0.163 5,885.724 ↓ 40.2 523 1

Append (cost=111.14..133.72 rows=13 width=64) (actual time=3,889.224..5,885.724 rows=523 loops=1)

146. 2,008.825 5,885.561 ↓ 40.2 523 1

Bitmap Heap Scan on devices_org_part_default d (cost=111.14..133.66 rows=13 width=64) (actual time=3,889.222..5,885.561 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.254 3,876.736 ↓ 0.0 0 1

BitmapAnd (cost=111.14..111.14 rows=15 width=0) (actual time=3,876.736..3,876.736 rows=0 loops=1)

148. 66.718 66.718 ↑ 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=66.718..66.718 rows=2,802 loops=1)

  • Index Cond: (organization_uuid = 'c4544f42-9f53-42e7-add8-3b99b0042aef'::uuid)
149. 3,809.764 3,809.764 ↓ 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=3,809.764..3,809.764 rows=270,500 loops=1)

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

SubPlan (for Hash Left Join)

151. 0.004 0.092 ↓ 0.0 0 4

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

152. 0.084 0.088 ↓ 0.0 0 4

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

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

CTE Scan on get_response_matchers rm (cost=0.00..50.02 rows=10 width=36) (actual time=0.001..0.001 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.004 0.016 ↓ 0.0 0 4

Limit (cost=50.07..50.08 rows=1 width=36) (actual time=0.004..0.004 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.011 0.011 ↑ 1.0 1 1

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

163. 0.003 0.005 ↑ 1.0 1 1

Limit (cost=0.00..0.02 rows=1 width=16) (actual time=0.004..0.005 rows=1 loops=1)

164. 0.002 0.002 ↑ 1.0 1 1

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

165. 0.009 0.013 ↑ 1.0 1 1

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

166. 0.004 0.004 ↑ 1.0 1 1

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

167. 0.006 0.008 ↑ 1.0 1 1

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

168. 0.002 0.002 ↑ 1.0 1 1

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

169. 0.048 31,175.444 ↑ 103.5 2 1

Nested Loop Left Join (cost=563.01..84,533.85 rows=207 width=436) (actual time=30,955.596..31,175.444 rows=2 loops=1)

170. 0.045 30,923.488 ↑ 103.5 2 1

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

  • Hash Cond: (person.site_uuid = site.site_uuid)
171. 0.012 30,878.732 ↑ 103.5 2 1

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

172. 0.010 30,384.702 ↑ 103.5 2 1

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

173. 0.009 30,371.616 ↑ 103.5 2 1

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

174. 0.011 30,371.585 ↑ 103.5 2 1

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

175. 0.159 30,371.390 ↑ 103.5 2 1

GroupAggregate (cost=155.74..253.73 rows=207 width=248) (actual time=30,371.295..30,371.390 rows=2 loops=1)

  • Group Key: pn.person_uuid, pn.event_uuid
176. 0.030 30,371.231 ↑ 691.3 3 1

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

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

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

178. 0.120 0.184 ↑ 1.0 1 2

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

179. 0.032 0.064 ↑ 5,000.0 2 2

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

180. 0.030 0.032 ↑ 50.0 2 2

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.016..0.016 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.004 0.022 ↑ 1.0 1 2

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

183. 0.002 0.018 ↓ 0.0 0 2

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

184. 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)

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.054 13.076 ↑ 1.0 1 2

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

187. 13.022 13.022 ↓ 0.0 0 2

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

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

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

189. 494.012 494.012 ↑ 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=231.129..247.006 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.023 44.711 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
191. 44.688 44.688 ↑ 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=30.919..44.688 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.106 251.908 ↑ 1.0 1 2

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

193. 0.034 251.802 ↑ 100.0 1 2

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

194. 0.008 198.242 ↑ 1.0 1 2

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

195. 198.234 198.234 ↑ 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=99.114..99.117 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.057 53.526 ↓ 0.0 0 2

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

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

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

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

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

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

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

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

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

201. 0.028 0.030 ↓ 0.0 0 2

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

202. 0.002 0.002 ↑ 1.0 1 2

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

Planning time : 835.752 ms
Execution time : 31,181.555 ms