explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1AG7

Settings
# exclusive inclusive rows x rows loops node
1. 2.360 615.066 ↑ 2,820.0 1 1

Nested Loop Left Join (cost=3,611.84..512,497.88 rows=2,820 width=448) (actual time=614.831..615.066 rows=1 loops=1)

  • Join Filter: ((device_response.response_uuid IS NULL) AND (device_response2.notification_uuid = device_ntfn.notification_uuid) AND (device_ntfn.responded_date <= now()) AND (device_ntfn.responded_date <= now()))
  • Rows Removed by Join Filter: 28,503
2.          

CTE get_event

3. 0.065 0.065 ↑ 1.0 1 1

Index Scan using events_org_part_default_evn_seq_vrange_uidx on events_org_part_default e (cost=0.56..3.58 rows=1 width=706) (actual time=0.065..0.065 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = '56643e83-cc8e-4442-910b-b80b4adfe63d'::uuid))
  • Filter: (is_visible AND upper_inf(valid_range))
  • Rows Removed by Filter: 1
4.          

CTE get_event_created_min

5. 0.002 0.002 ↑ 1.0 1 1

Aggregate (cost=0.03..0.04 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1)

6. 0.000 0.000 ↑ 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.000 rows=1 loops=1)

7.          

CTE get_event_closing_max

8. 0.011 0.079 ↑ 1.0 1 1

Aggregate (cost=0.03..0.04 rows=1 width=8) (actual time=0.078..0.079 rows=1 loops=1)

9. 0.068 0.068 ↑ 1.0 1 1

CTE Scan on get_event e_2 (cost=0.00..0.02 rows=1 width=16) (actual time=0.067..0.068 rows=1 loops=1)

10.          

CTE get_response_matchers

11. 0.021 0.335 ↑ 1,000.0 2 1

HashAggregate (cost=1,516.98..1,561.98 rows=2,000 width=96) (actual time=0.324..0.335 rows=2 loops=1)

  • Group Key: lower(COALESCE("*SELECT* 1".translated_response, "*SELECT* 1".text_response)), lower((replace(replace(COALESCE("*SELECT* 1".translated_response, "*SELECT* 1".text_response), '%'::text, '\%'::text), '_'::text, '\_'::text) || ' %'::text)), "*SELECT* 1".text_response
12. 0.105 0.314 ↑ 10,000.0 2 1

Result (cost=3.87..1,366.98 rows=20,000 width=96) (actual time=0.274..0.314 rows=2 loops=1)

13. 0.001 0.209 ↑ 10,000.0 2 1

Append (cost=3.87..916.98 rows=20,000 width=64) (actual time=0.171..0.209 rows=2 loops=1)

14. 0.001 0.206 ↑ 5,000.0 2 1

Subquery Scan on *SELECT* 1 (cost=3.87..411.94 rows=10,000 width=64) (actual time=0.171..0.206 rows=2 loops=1)

15. 0.007 0.205 ↑ 5,000.0 2 1

Nested Loop Left Join (cost=3.87..311.94 rows=10,000 width=128) (actual time=0.170..0.205 rows=2 loops=1)

16. 0.002 0.110 ↑ 50.0 2 1

Nested Loop (cost=3.87..9.44 rows=100 width=32) (actual time=0.107..0.110 rows=2 loops=1)

17. 0.003 0.072 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.42..3.48 rows=1 width=999) (actual time=0.070..0.072 rows=1 loops=1)

18. 0.001 0.001 ↑ 1.0 1 1

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

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

Index Scan using forms_org_seq_vrange_uidx on forms f (cost=0.42..3.45 rows=1 width=1,019) (actual time=0.067..0.068 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (form_uuid = e_3.form_uuid))
  • Filter: (is_visible AND (valid_range @> e_3.created))
  • Rows Removed by Filter: 5
20. 0.036 0.036 ↑ 50.0 2 1

ProjectSet (cost=3.45..3.97 rows=100 width=32) (actual time=0.035..0.036 rows=2 loops=1)

21.          

Initplan (for ProjectSet)

22. 0.000 0.000 ↓ 0.0 0

Index Scan using forms_org_seq_vrange_uidx on forms f2 (cost=0.42..3.45 rows=1 width=983) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (form_uuid = $3))
  • Filter: (is_visible AND (valid_range @> now()))
23. 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)

24. 0.088 0.088 ↑ 100.0 1 2

ProjectSet (cost=0.00..0.53 rows=100 width=32) (actual time=0.043..0.044 rows=1 loops=2)

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

26. 0.000 0.002 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.00..405.04 rows=10,000 width=64) (actual time=0.002..0.002 rows=0 loops=1)

27. 0.001 0.002 ↓ 0.0 0 1

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

28. 0.000 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.54 rows=100 width=32) (actual time=0.001..0.001 rows=0 loops=1)

29. 0.001 0.001 ↓ 0.0 0 1

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

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

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

31. 0.000 0.000 ↓ 0.0 0

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

32. 0.000 0.000 ↓ 0.0 0

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

33. 0.000 0.000 ↓ 0.0 0

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

34.          

CTE get_lowered_responses_pattern_array

35. 0.058 0.394 ↑ 1.0 1 1

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

36. 0.336 0.336 ↑ 1,000.0 2 1

CTE Scan on get_response_matchers rc (cost=0.00..40.00 rows=2,000 width=32) (actual time=0.325..0.336 rows=2 loops=1)

37.          

Initplan (for Nested Loop Left Join)

38. 0.000 0.000 ↑ 1.0 1 1

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

39. 0.000 0.000 ↑ 1.0 1 1

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

40. 0.000 0.000 ↑ 1.0 1 1

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

41. 0.002 0.002 ↑ 1.0 1 1

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

42. 0.001 0.001 ↑ 1.0 1 1

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

43. 0.395 0.395 ↑ 1.0 1 1

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

44. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on get_event_closing_max (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_lowered_responses_pattern_array rc_2 (cost=0.00..0.02 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

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

47. 0.080 0.080 ↑ 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.080..0.080 rows=1 loops=1)

48. 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.002..0.003 rows=1 loops=1)

49. 0.866 106.066 ↑ 2,820.0 1 1

Nested Loop Left Join (cost=1,087.34..508,949.14 rows=2,820 width=179) (actual time=105.833..106.066 rows=1 loops=1)

  • Join Filter: (device_ntfn.parent_ntfn_uuid = person_ntfn.notification_uuid)
  • Rows Removed by Join Filter: 6,885
50. 0.092 0.163 ↑ 101.0 1 1

Append (cost=0.56..358.74 rows=101 width=72) (actual time=0.157..0.163 rows=1 loops=1)

51. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 person_ntfn (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx1 on notifications_summary_weekly_partitioned_2019_w6 person_ntfn_1 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
53. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx2 on notifications_summary_weekly_partitioned_2019_w7 person_ntfn_2 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx3 on notifications_summary_weekly_partitioned_2019_w8 person_ntfn_3 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
55. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx4 on notifications_summary_weekly_partitioned_2019_w9 person_ntfn_4 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
56. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx5 on notifications_summary_weekly_partitioned_2019_w10 person_ntfn_5 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
57. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx6 on notifications_summary_weekly_partitioned_2019_w11 person_ntfn_6 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
58. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx7 on notifications_summary_weekly_partitioned_2019_w12 person_ntfn_7 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
59. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 person_ntfn_8 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
60. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx9 on notifications_summary_weekly_partitioned_2019_w14 person_ntfn_9 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
61. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 person_ntfn_10 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
62. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx11 on notifications_summary_weekly_partitioned_2019_w16 person_ntfn_11 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
63. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx12 on notifications_summary_weekly_partitioned_2019_w17 person_ntfn_12 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
64. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx13 on notifications_summary_weekly_partitioned_2019_w18 person_ntfn_13 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
65. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx14 on notifications_summary_weekly_partitioned_2019_w19 person_ntfn_14 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
66. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx15 on notifications_summary_weekly_partitioned_2019_w20 person_ntfn_15 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
67. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx16 on notifications_summary_weekly_partitioned_2019_w21 person_ntfn_16 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx17 on notifications_summary_weekly_partitioned_2019_w22 person_ntfn_17 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
69. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx18 on notifications_summary_weekly_partitioned_2019_w23 person_ntfn_18 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx19 on notifications_summary_weekly_partitioned_2019_w24 person_ntfn_19 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
71. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx20 on notifications_summary_weekly_partitioned_2019_w25 person_ntfn_20 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
72. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 person_ntfn_21 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
73. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx22 on notifications_summary_weekly_partitioned_2019_w27 person_ntfn_22 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx23 on notifications_summary_weekly_partitioned_2019_w28 person_ntfn_23 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
75. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx24 on notifications_summary_weekly_partitioned_2019_w29 person_ntfn_24 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
76. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx25 on notifications_summary_weekly_partitioned_2019_w30 person_ntfn_25 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
77. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx26 on notifications_summary_weekly_partitioned_2019_w31 person_ntfn_26 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx27 on notifications_summary_weekly_partitioned_2019_w32 person_ntfn_27 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
79. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx28 on notifications_summary_weekly_partitioned_2019_w33 person_ntfn_28 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx29 on notifications_summary_weekly_partitioned_2019_w34 person_ntfn_29 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
81. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 person_ntfn_30 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
82. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 person_ntfn_31 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
83. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 person_ntfn_32 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
84. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 person_ntfn_33 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
85. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 person_ntfn_34 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
86. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx35 on notifications_summary_weekly_partitioned_2019_w40 person_ntfn_35 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
87. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx36 on notifications_summary_weekly_partitioned_2019_w41 person_ntfn_36 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx37 on notifications_summary_weekly_partitioned_2019_w42 person_ntfn_37 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
89. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 person_ntfn_38 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
90. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 person_ntfn_39 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
91. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx40 on notifications_summary_weekly_partitioned_2019_w45 person_ntfn_40 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
92. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 person_ntfn_41 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
93. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 person_ntfn_42 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx43 on notifications_summary_weekly_partitioned_2019_w48 person_ntfn_43 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
95. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 person_ntfn_44 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx45 on notifications_summary_weekly_partitioned_2019_w50 person_ntfn_45 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
97. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 person_ntfn_46 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
98. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx47 on notifications_summary_weekly_partitioned_2019_w52 person_ntfn_47 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
99. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx49 on notifications_summary_weekly_partitioned_2020_w1 person_ntfn_48 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
100. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 person_ntfn_49 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
101. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx51 on notifications_summary_weekly_partitioned_2020_w3 person_ntfn_50 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
102. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx52 on notifications_summary_weekly_partitioned_2020_w4 person_ntfn_51 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx53 on notifications_summary_weekly_partitioned_2020_w5 person_ntfn_52 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
104. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx54 on notifications_summary_weekly_partitioned_2020_w6 person_ntfn_53 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
105. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx55 on notifications_summary_weekly_partitioned_2020_w7 person_ntfn_54 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
106. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx56 on notifications_summary_weekly_partitioned_2020_w8 person_ntfn_55 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
107. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx57 on notifications_summary_weekly_partitioned_2020_w9 person_ntfn_56 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
108. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx58 on notifications_summary_weekly_partitioned_2020_w10 person_ntfn_57 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
109. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx59 on notifications_summary_weekly_partitioned_2020_w11 person_ntfn_58 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
110. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx60 on notifications_summary_weekly_partitioned_2020_w12 person_ntfn_59 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
111. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx61 on notifications_summary_weekly_partitioned_2020_w13 person_ntfn_60 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
112. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx62 on notifications_summary_weekly_partitioned_2020_w14 person_ntfn_61 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
113. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx63 on notifications_summary_weekly_partitioned_2020_w15 person_ntfn_62 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
114. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx64 on notifications_summary_weekly_partitioned_2020_w16 person_ntfn_63 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
115. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx65 on notifications_summary_weekly_partitioned_2020_w17 person_ntfn_64 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
116. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx66 on notifications_summary_weekly_partitioned_2020_w18 person_ntfn_65 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
117. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx67 on notifications_summary_weekly_partitioned_2020_w19 person_ntfn_66 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
118. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx68 on notifications_summary_weekly_partitioned_2020_w20 person_ntfn_67 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
119. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx69 on notifications_summary_weekly_partitioned_2020_w21 person_ntfn_68 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
120. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx70 on notifications_summary_weekly_partitioned_2020_w22 person_ntfn_69 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
121. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx71 on notifications_summary_weekly_partitioned_2020_w23 person_ntfn_70 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
122. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx72 on notifications_summary_weekly_partitioned_2020_w24 person_ntfn_71 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
123. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx73 on notifications_summary_weekly_partitioned_2020_w25 person_ntfn_72 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
124. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx74 on notifications_summary_weekly_partitioned_2020_w26 person_ntfn_73 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
125. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx75 on notifications_summary_weekly_partitioned_2020_w27 person_ntfn_74 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
126. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx76 on notifications_summary_weekly_partitioned_2020_w28 person_ntfn_75 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
127. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx77 on notifications_summary_weekly_partitioned_2020_w29 person_ntfn_76 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
128. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx78 on notifications_summary_weekly_partitioned_2020_w30 person_ntfn_77 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
129. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx79 on notifications_summary_weekly_partitioned_2020_w31 person_ntfn_78 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
130. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx80 on notifications_summary_weekly_partitioned_2020_w32 person_ntfn_79 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
131. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx81 on notifications_summary_weekly_partitioned_2020_w33 person_ntfn_80 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
132. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx82 on notifications_summary_weekly_partitioned_2020_w34 person_ntfn_81 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
133. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx83 on notifications_summary_weekly_partitioned_2020_w35 person_ntfn_82 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
134. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx84 on notifications_summary_weekly_partitioned_2020_w36 person_ntfn_83 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
135. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx85 on notifications_summary_weekly_partitioned_2020_w37 person_ntfn_84 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
136. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx86 on notifications_summary_weekly_partitioned_2020_w38 person_ntfn_85 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
137. 0.071 0.071 ↑ 1.0 1 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx87 on notifications_summary_weekly_partitioned_2020_w39 person_ntfn_86 (cost=0.56..3.59 rows=1 width=72) (actual time=0.066..0.071 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
138. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx88 on notifications_summary_weekly_partitioned_2020_w40 person_ntfn_87 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
139. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx89 on notifications_summary_weekly_partitioned_2020_w41 person_ntfn_88 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
140. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx90 on notifications_summary_weekly_partitioned_2020_w42 person_ntfn_89 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((event_uuid = $21) AND (category = 'PERSON'::text))
141. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w43_pkey on notifications_summary_weekly_partitioned_2020_w43 person_ntfn_90 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
142. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w44_pkey on notifications_summary_weekly_partitioned_2020_w44 person_ntfn_91 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
143. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w45_pkey on notifications_summary_weekly_partitioned_2020_w45 person_ntfn_92 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
144. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w46_pkey on notifications_summary_weekly_partitioned_2020_w46 person_ntfn_93 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
145. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w47_pkey on notifications_summary_weekly_partitioned_2020_w47 person_ntfn_94 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
146. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w48_pkey on notifications_summary_weekly_partitioned_2020_w48 person_ntfn_95 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
147. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w49_pkey on notifications_summary_weekly_partitioned_2020_w49 person_ntfn_96 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
148. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w50_pkey on notifications_summary_weekly_partitioned_2020_w50 person_ntfn_97 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
149. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w51_pkey on notifications_summary_weekly_partitioned_2020_w51 person_ntfn_98 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
150. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w52_pkey on notifications_summary_weekly_partitioned_2020_w52 person_ntfn_99 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
151. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_part_default_pkey on notifications_summary_weekly_part_default person_ntfn_100 (cost=0.14..3.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $22) AND (created_date >= $23))
  • Filter: ((recipient_uuid = 'c72b6902-83d2-4549-a511-0396d1b7ba46'::uuid) AND (event_uuid = $21) AND (category = 'PERSON'::text))
152. 3.557 105.037 ↓ 2.4 6,886 1

Materialize (cost=1,086.78..504,325.15 rows=2,820 width=123) (actual time=74.091..105.037 rows=6,886 loops=1)

153. 3.307 101.480 ↓ 2.4 6,886 1

Hash Right Join (cost=1,086.78..504,311.05 rows=2,820 width=123) (actual time=74.086..101.480 rows=6,886 loops=1)

  • Hash Cond: (live_ntfn.parent_ntfn_uuid = device_ntfn.notification_uuid)
154. 0.716 24.213 ↓ 1.3 7,151 1

Append (cost=0.56..503,175.69 rows=5,585 width=24) (actual time=0.067..24.213 rows=7,151 loops=1)

155. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 live_ntfn (cost=0.56..1,855.41 rows=26 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
156. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx1 on notifications_summary_weekly_partitioned_2019_w6 live_ntfn_1 (cost=0.56..2,084.53 rows=30 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
157. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx2 on notifications_summary_weekly_partitioned_2019_w7 live_ntfn_2 (cost=0.56..2,065.54 rows=30 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
158. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx3 on notifications_summary_weekly_partitioned_2019_w8 live_ntfn_3 (cost=0.56..2,259.93 rows=30 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
159. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx4 on notifications_summary_weekly_partitioned_2019_w9 live_ntfn_4 (cost=0.56..7,832.68 rows=107 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
160. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx5 on notifications_summary_weekly_partitioned_2019_w10 live_ntfn_5 (cost=0.56..1,399.41 rows=18 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
161. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx6 on notifications_summary_weekly_partitioned_2019_w11 live_ntfn_6 (cost=0.56..12,711.90 rows=173 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
162. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx7 on notifications_summary_weekly_partitioned_2019_w12 live_ntfn_7 (cost=0.56..1,858.06 rows=25 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
163. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 live_ntfn_8 (cost=0.56..2,822.16 rows=38 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
164. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx9 on notifications_summary_weekly_partitioned_2019_w14 live_ntfn_9 (cost=0.56..3,359.60 rows=46 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
165. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 live_ntfn_10 (cost=0.56..1,396.01 rows=17 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
166. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx11 on notifications_summary_weekly_partitioned_2019_w16 live_ntfn_11 (cost=0.56..955.28 rows=12 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
167. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx12 on notifications_summary_weekly_partitioned_2019_w17 live_ntfn_12 (cost=0.56..1,720.41 rows=21 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
168. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx13 on notifications_summary_weekly_partitioned_2019_w18 live_ntfn_13 (cost=0.56..1,469.90 rows=19 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
169. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx14 on notifications_summary_weekly_partitioned_2019_w19 live_ntfn_14 (cost=0.56..4,527.93 rows=56 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
170. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx15 on notifications_summary_weekly_partitioned_2019_w20 live_ntfn_15 (cost=0.56..5,409.96 rows=71 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
171. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx16 on notifications_summary_weekly_partitioned_2019_w21 live_ntfn_16 (cost=0.56..2,783.81 rows=35 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
172. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx17 on notifications_summary_weekly_partitioned_2019_w22 live_ntfn_17 (cost=0.56..6,147.48 rows=78 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
173. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx18 on notifications_summary_weekly_partitioned_2019_w23 live_ntfn_18 (cost=0.56..8,671.53 rows=105 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
174. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx19 on notifications_summary_weekly_partitioned_2019_w24 live_ntfn_19 (cost=0.56..5,551.52 rows=67 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
175. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx20 on notifications_summary_weekly_partitioned_2019_w25 live_ntfn_20 (cost=0.56..7,468.07 rows=85 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
176. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 live_ntfn_21 (cost=0.56..154.95 rows=2 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
177. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx22 on notifications_summary_weekly_partitioned_2019_w27 live_ntfn_22 (cost=0.56..11,626.94 rows=145 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
178. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx23 on notifications_summary_weekly_partitioned_2019_w28 live_ntfn_23 (cost=0.56..2,628.61 rows=31 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
179. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx24 on notifications_summary_weekly_partitioned_2019_w29 live_ntfn_24 (cost=0.56..2,600.08 rows=32 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
180. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx25 on notifications_summary_weekly_partitioned_2019_w30 live_ntfn_25 (cost=0.56..10,203.37 rows=128 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
181. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx26 on notifications_summary_weekly_partitioned_2019_w31 live_ntfn_26 (cost=0.56..582.01 rows=7 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
182. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx27 on notifications_summary_weekly_partitioned_2019_w32 live_ntfn_27 (cost=0.56..1,293.21 rows=16 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
183. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx28 on notifications_summary_weekly_partitioned_2019_w33 live_ntfn_28 (cost=0.56..2,096.03 rows=25 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
184. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx29 on notifications_summary_weekly_partitioned_2019_w34 live_ntfn_29 (cost=0.56..1,176.80 rows=13 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
185. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 live_ntfn_30 (cost=0.56..7,230.28 rows=90 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
186. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 live_ntfn_31 (cost=0.56..4,090.99 rows=47 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
187. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 live_ntfn_32 (cost=0.56..1,102.83 rows=11 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
188. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 live_ntfn_33 (cost=0.56..1,974.91 rows=20 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
189. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 live_ntfn_34 (cost=0.56..1,727.68 rows=16 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
190. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx35 on notifications_summary_weekly_partitioned_2019_w40 live_ntfn_35 (cost=0.56..6,161.11 rows=62 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
191. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx36 on notifications_summary_weekly_partitioned_2019_w41 live_ntfn_36 (cost=0.56..3,436.08 rows=34 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
192. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w42_pkey on notifications_summary_weekly_partitioned_2019_w42 live_ntfn_37 (cost=0.56..1,823.47 rows=17 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
193. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 live_ntfn_38 (cost=0.56..5,698.25 rows=59 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
194. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 live_ntfn_39 (cost=0.56..1,097.41 rows=12 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
195. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx40 on notifications_summary_weekly_partitioned_2019_w45 live_ntfn_40 (cost=0.56..4,847.08 rows=51 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
196. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 live_ntfn_41 (cost=0.56..8,165.96 rows=84 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
197. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 live_ntfn_42 (cost=0.56..12,732.37 rows=133 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
198. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx43 on notifications_summary_weekly_partitioned_2019_w48 live_ntfn_43 (cost=0.56..16,449.96 rows=177 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
199. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 live_ntfn_44 (cost=0.56..3,037.52 rows=28 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
200. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx45 on notifications_summary_weekly_partitioned_2019_w50 live_ntfn_45 (cost=0.56..2,829.62 rows=27 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
201. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 live_ntfn_46 (cost=0.56..6,056.93 rows=61 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
202. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx47 on notifications_summary_weekly_partitioned_2019_w52 live_ntfn_47 (cost=0.56..91.15 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
203. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx49 on notifications_summary_weekly_partitioned_2020_w1 live_ntfn_48 (cost=0.56..1,345.20 rows=13 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
204. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 live_ntfn_49 (cost=0.56..2,982.86 rows=32 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
205. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx51 on notifications_summary_weekly_partitioned_2020_w3 live_ntfn_50 (cost=0.56..5,082.52 rows=53 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
206. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx52 on notifications_summary_weekly_partitioned_2020_w4 live_ntfn_51 (cost=0.56..881.51 rows=9 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
207. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx53 on notifications_summary_weekly_partitioned_2020_w5 live_ntfn_52 (cost=0.56..1,966.56 rows=19 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
208. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx54 on notifications_summary_weekly_partitioned_2020_w6 live_ntfn_53 (cost=0.56..2,245.95 rows=23 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
209. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx55 on notifications_summary_weekly_partitioned_2020_w7 live_ntfn_54 (cost=0.56..9,257.70 rows=95 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
210. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx56 on notifications_summary_weekly_partitioned_2020_w8 live_ntfn_55 (cost=0.56..2,686.23 rows=24 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
211. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx57 on notifications_summary_weekly_partitioned_2020_w9 live_ntfn_56 (cost=0.56..7,331.14 rows=83 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
212. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx58 on notifications_summary_weekly_partitioned_2020_w10 live_ntfn_57 (cost=0.56..6,684.25 rows=71 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
213. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx59 on notifications_summary_weekly_partitioned_2020_w11 live_ntfn_58 (cost=0.56..14,739.15 rows=158 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
214. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx60 on notifications_summary_weekly_partitioned_2020_w12 live_ntfn_59 (cost=0.56..16,553.54 rows=209 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
215. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx61 on notifications_summary_weekly_partitioned_2020_w13 live_ntfn_60 (cost=0.56..5,899.60 rows=64 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
216. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx62 on notifications_summary_weekly_partitioned_2020_w14 live_ntfn_61 (cost=0.56..12,894.12 rows=152 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
217. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx63 on notifications_summary_weekly_partitioned_2020_w15 live_ntfn_62 (cost=0.56..5,570.12 rows=65 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
218. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx64 on notifications_summary_weekly_partitioned_2020_w16 live_ntfn_63 (cost=0.56..4,700.24 rows=52 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
219. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx65 on notifications_summary_weekly_partitioned_2020_w17 live_ntfn_64 (cost=0.56..50,548.14 rows=586 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
220. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx66 on notifications_summary_weekly_partitioned_2020_w18 live_ntfn_65 (cost=0.56..2,585.28 rows=29 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
221. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx67 on notifications_summary_weekly_partitioned_2020_w19 live_ntfn_66 (cost=0.56..2,239.63 rows=25 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
222. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx68 on notifications_summary_weekly_partitioned_2020_w20 live_ntfn_67 (cost=0.56..11,207.55 rows=128 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
223. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w21_pkey on notifications_summary_weekly_partitioned_2020_w21 live_ntfn_68 (cost=0.56..3,766.32 rows=35 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
224. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w22_pkey on notifications_summary_weekly_partitioned_2020_w22 live_ntfn_69 (cost=0.56..12,097.08 rows=101 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
225. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w23_pkey on notifications_summary_weekly_partitioned_2020_w23 live_ntfn_70 (cost=0.56..3,497.34 rows=33 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
226. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w24_pkey on notifications_summary_weekly_partitioned_2020_w24 live_ntfn_71 (cost=0.56..3,412.52 rows=32 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
227. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w25_pkey on notifications_summary_weekly_partitioned_2020_w25 live_ntfn_72 (cost=0.56..4,759.52 rows=48 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
228. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w26_pkey on notifications_summary_weekly_partitioned_2020_w26 live_ntfn_73 (cost=0.56..11,618.77 rows=111 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
229. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w27_pkey on notifications_summary_weekly_partitioned_2020_w27 live_ntfn_74 (cost=0.56..1,741.79 rows=17 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
230. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w28_pkey on notifications_summary_weekly_partitioned_2020_w28 live_ntfn_75 (cost=0.56..1,976.86 rows=19 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
231. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w29_pkey on notifications_summary_weekly_partitioned_2020_w29 live_ntfn_76 (cost=0.56..944.98 rows=9 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
232. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w30_pkey on notifications_summary_weekly_partitioned_2020_w30 live_ntfn_77 (cost=0.56..2,870.13 rows=27 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
233. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w31_pkey on notifications_summary_weekly_partitioned_2020_w31 live_ntfn_78 (cost=0.56..3,496.31 rows=33 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
234. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w32_pkey on notifications_summary_weekly_partitioned_2020_w32 live_ntfn_79 (cost=0.56..5,666.40 rows=58 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
235. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w33_pkey on notifications_summary_weekly_partitioned_2020_w33 live_ntfn_80 (cost=0.56..8,516.05 rows=81 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
236. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w34_pkey on notifications_summary_weekly_partitioned_2020_w34 live_ntfn_81 (cost=0.56..15,208.51 rows=146 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
237. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w35_pkey on notifications_summary_weekly_partitioned_2020_w35 live_ntfn_82 (cost=0.56..3,657.79 rows=36 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
238. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w36_pkey on notifications_summary_weekly_partitioned_2020_w36 live_ntfn_83 (cost=0.56..18,263.35 rows=187 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
239. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w37_pkey on notifications_summary_weekly_partitioned_2020_w37 live_ntfn_84 (cost=0.56..3,367.62 rows=35 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
240. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w38_pkey on notifications_summary_weekly_partitioned_2020_w38 live_ntfn_85 (cost=0.56..3,453.02 rows=34 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
241. 23.497 23.497 ↓ 340.5 7,151 1

Index Scan using notifications_summary_weekly_partitioned_2020_w39_pkey on notifications_summary_weekly_partitioned_2020_w39 live_ntfn_86 (cost=0.56..2,160.10 rows=21 width=24) (actual time=0.052..23.497 rows=7,151 loops=1)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
  • Rows Removed by Filter: 9,825
242. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w40_pkey on notifications_summary_weekly_partitioned_2020_w40 live_ntfn_87 (cost=0.56..6,121.83 rows=62 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
243. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w41_pkey on notifications_summary_weekly_partitioned_2020_w41 live_ntfn_88 (cost=0.56..12,639.34 rows=129 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
244. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w42_pkey on notifications_summary_weekly_partitioned_2020_w42 live_ntfn_89 (cost=0.56..1,209.22 rows=12 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
245. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx91 on notifications_summary_weekly_partitioned_2020_w43 live_ntfn_90 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
246. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx92 on notifications_summary_weekly_partitioned_2020_w44 live_ntfn_91 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
247. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx93 on notifications_summary_weekly_partitioned_2020_w45 live_ntfn_92 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
248. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx94 on notifications_summary_weekly_partitioned_2020_w46 live_ntfn_93 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
249. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx95 on notifications_summary_weekly_partitioned_2020_w47 live_ntfn_94 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
250. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx96 on notifications_summary_weekly_partitioned_2020_w48 live_ntfn_95 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
251. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx97 on notifications_summary_weekly_partitioned_2020_w49 live_ntfn_96 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
252. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx98 on notifications_summary_weekly_partitioned_2020_w50 live_ntfn_97 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
253. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx99 on notifications_summary_weekly_partitioned_2020_w51 live_ntfn_98 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
254. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient_idx100 on notifications_summary_weekly_partitioned_2020_w52 live_ntfn_99 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
255. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx48 on notifications_summary_weekly_part_default live_ntfn_100 (cost=0.14..3.18 rows=1 width=24) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $16) AND (created_date >= $17))
  • Filter: ((category = 'LIVE'::text) AND (pending_date <= now()))
256. 2.683 73.960 ↓ 66.1 6,679 1

Hash (cost=1,084.95..1,084.95 rows=101 width=115) (actual time=73.960..73.960 rows=6,679 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 790kB
257. 1.865 71.277 ↓ 66.1 6,679 1

Nested Loop Left Join (cost=0.99..1,084.95 rows=101 width=115) (actual time=0.511..71.277 rows=6,679 loops=1)

  • Join Filter: ((device_ntfn.responded_date <= now()) AND (device_ntfn.responded_date <= now()))
258. 0.710 16.988 ↓ 64.9 6,553 1

Append (cost=0.56..732.72 rows=101 width=72) (actual time=0.064..16.988 rows=6,553 loops=1)

259. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx5 on notifications_summary_weekly_partitioned_2019_w5 device_ntfn (cost=0.56..4.28 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
260. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx6 on notifications_summary_weekly_partitioned_2019_w6 device_ntfn_1 (cost=0.56..4.27 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
261. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx7 on notifications_summary_weekly_partitioned_2019_w7 device_ntfn_2 (cost=0.56..4.27 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
262. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx8 on notifications_summary_weekly_partitioned_2019_w8 device_ntfn_3 (cost=0.56..4.27 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
263. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx9 on notifications_summary_weekly_partitioned_2019_w9 device_ntfn_4 (cost=0.56..8.39 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
264. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx10 on notifications_summary_weekly_partitioned_2019_w10 device_ntfn_5 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
265. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx11 on notifications_summary_weekly_partitioned_2019_w11 device_ntfn_6 (cost=0.56..12.48 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
266. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx12 on notifications_summary_weekly_partitioned_2019_w12 device_ntfn_7 (cost=0.56..4.27 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
267. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx13 on notifications_summary_weekly_partitioned_2019_w13 device_ntfn_8 (cost=0.56..4.96 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
268. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx14 on notifications_summary_weekly_partitioned_2019_w14 device_ntfn_9 (cost=0.56..4.97 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
269. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx15 on notifications_summary_weekly_partitioned_2019_w15 device_ntfn_10 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
270. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx16 on notifications_summary_weekly_partitioned_2019_w16 device_ntfn_11 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
271. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx17 on notifications_summary_weekly_partitioned_2019_w17 device_ntfn_12 (cost=0.56..4.29 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
272. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx18 on notifications_summary_weekly_partitioned_2019_w18 device_ntfn_13 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
273. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx19 on notifications_summary_weekly_partitioned_2019_w19 device_ntfn_14 (cost=0.56..5.67 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
274. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx20 on notifications_summary_weekly_partitioned_2019_w20 device_ntfn_15 (cost=0.56..6.33 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
275. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx21 on notifications_summary_weekly_partitioned_2019_w21 device_ntfn_16 (cost=0.56..4.99 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
276. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx22 on notifications_summary_weekly_partitioned_2019_w22 device_ntfn_17 (cost=0.56..7.06 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
277. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx23 on notifications_summary_weekly_partitioned_2019_w23 device_ntfn_18 (cost=0.56..8.38 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
278. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx24 on notifications_summary_weekly_partitioned_2019_w24 device_ntfn_19 (cost=0.56..6.33 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
279. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx25 on notifications_summary_weekly_partitioned_2019_w25 device_ntfn_20 (cost=0.56..8.38 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
280. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx26 on notifications_summary_weekly_partitioned_2019_w26 device_ntfn_21 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
281. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx27 on notifications_summary_weekly_partitioned_2019_w27 device_ntfn_22 (cost=0.56..11.11 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
282. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx28 on notifications_summary_weekly_partitioned_2019_w28 device_ntfn_23 (cost=0.56..4.29 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
283. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx29 on notifications_summary_weekly_partitioned_2019_w29 device_ntfn_24 (cost=0.56..4.28 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
284. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx30 on notifications_summary_weekly_partitioned_2019_w30 device_ntfn_25 (cost=0.56..9.74 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
285. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx31 on notifications_summary_weekly_partitioned_2019_w31 device_ntfn_26 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
286. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx32 on notifications_summary_weekly_partitioned_2019_w32 device_ntfn_27 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
287. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx33 on notifications_summary_weekly_partitioned_2019_w33 device_ntfn_28 (cost=0.56..4.27 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
288. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx34 on notifications_summary_weekly_partitioned_2019_w34 device_ntfn_29 (cost=0.56..3.58 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
289. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx35 on notifications_summary_weekly_partitioned_2019_w35 device_ntfn_30 (cost=0.56..7.07 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
290. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx36 on notifications_summary_weekly_partitioned_2019_w36 device_ntfn_31 (cost=0.56..4.98 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
291. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx37 on notifications_summary_weekly_partitioned_2019_w37 device_ntfn_32 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
292. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx38 on notifications_summary_weekly_partitioned_2019_w38 device_ntfn_33 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
293. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx39 on notifications_summary_weekly_partitioned_2019_w39 device_ntfn_34 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
294. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx40 on notifications_summary_weekly_partitioned_2019_w40 device_ntfn_35 (cost=0.56..9.69 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
295. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx41 on notifications_summary_weekly_partitioned_2019_w41 device_ntfn_36 (cost=0.56..6.64 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
296. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx42 on notifications_summary_weekly_partitioned_2019_w42 device_ntfn_37 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
297. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx43 on notifications_summary_weekly_partitioned_2019_w43 device_ntfn_38 (cost=0.56..8.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
298. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx44 on notifications_summary_weekly_partitioned_2019_w44 device_ntfn_39 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
299. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx45 on notifications_summary_weekly_partitioned_2019_w45 device_ntfn_40 (cost=0.56..6.64 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
300. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx46 on notifications_summary_weekly_partitioned_2019_w46 device_ntfn_41 (cost=0.56..9.70 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
301. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx47 on notifications_summary_weekly_partitioned_2019_w47 device_ntfn_42 (cost=0.56..14.25 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
302. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx48 on notifications_summary_weekly_partitioned_2019_w48 device_ntfn_43 (cost=0.56..18.72 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
303. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx49 on notifications_summary_weekly_partitioned_2019_w49 device_ntfn_44 (cost=0.56..5.07 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
304. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx50 on notifications_summary_weekly_partitioned_2019_w50 device_ntfn_45 (cost=0.56..5.11 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
305. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx51 on notifications_summary_weekly_partitioned_2019_w51 device_ntfn_46 (cost=0.56..8.14 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
306. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx52 on notifications_summary_weekly_partitioned_2019_w52 device_ntfn_47 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
307. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_p_organization_uuid_event_uuid_idx on notifications_summary_weekly_partitioned_2020_w1 device_ntfn_48 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
308. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx1 on notifications_summary_weekly_partitioned_2020_w2 device_ntfn_49 (cost=0.56..5.11 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
309. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx2 on notifications_summary_weekly_partitioned_2020_w3 device_ntfn_50 (cost=0.56..6.64 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
310. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx3 on notifications_summary_weekly_partitioned_2020_w4 device_ntfn_51 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
311. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 device_ntfn_52 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
312. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx54 on notifications_summary_weekly_partitioned_2020_w6 device_ntfn_53 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
313. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx55 on notifications_summary_weekly_partitioned_2020_w7 device_ntfn_54 (cost=0.56..11.22 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
314. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx56 on notifications_summary_weekly_partitioned_2020_w8 device_ntfn_55 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
315. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx57 on notifications_summary_weekly_partitioned_2020_w9 device_ntfn_56 (cost=0.56..9.69 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
316. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx58 on notifications_summary_weekly_partitioned_2020_w10 device_ntfn_57 (cost=0.56..11.22 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
317. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx59 on notifications_summary_weekly_partitioned_2020_w11 device_ntfn_58 (cost=0.56..18.86 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
318. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx60 on notifications_summary_weekly_partitioned_2020_w12 device_ntfn_59 (cost=0.56..24.96 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
319. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx61 on notifications_summary_weekly_partitioned_2020_w13 device_ntfn_60 (cost=0.56..11.18 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
320. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx62 on notifications_summary_weekly_partitioned_2020_w14 device_ntfn_61 (cost=0.56..17.34 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
321. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx63 on notifications_summary_weekly_partitioned_2020_w15 device_ntfn_62 (cost=0.56..8.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
322. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx64 on notifications_summary_weekly_partitioned_2020_w16 device_ntfn_63 (cost=0.56..6.64 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
323. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx65 on notifications_summary_weekly_partitioned_2020_w17 device_ntfn_64 (cost=0.56..76.88 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
324. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx66 on notifications_summary_weekly_partitioned_2020_w18 device_ntfn_65 (cost=0.56..5.11 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
325. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx67 on notifications_summary_weekly_partitioned_2020_w19 device_ntfn_66 (cost=0.56..5.12 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
326. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx68 on notifications_summary_weekly_partitioned_2020_w20 device_ntfn_67 (cost=0.56..14.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
327. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx69 on notifications_summary_weekly_partitioned_2020_w21 device_ntfn_68 (cost=0.56..5.11 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
328. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx70 on notifications_summary_weekly_partitioned_2020_w22 device_ntfn_69 (cost=0.56..14.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
329. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx71 on notifications_summary_weekly_partitioned_2020_w23 device_ntfn_70 (cost=0.56..5.11 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
330. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx72 on notifications_summary_weekly_partitioned_2020_w24 device_ntfn_71 (cost=0.56..5.12 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
331. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx73 on notifications_summary_weekly_partitioned_2020_w25 device_ntfn_72 (cost=0.56..6.64 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
332. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx74 on notifications_summary_weekly_partitioned_2020_w26 device_ntfn_73 (cost=0.56..12.74 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
333. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx75 on notifications_summary_weekly_partitioned_2020_w27 device_ntfn_74 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
334. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx76 on notifications_summary_weekly_partitioned_2020_w28 device_ntfn_75 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
335. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx77 on notifications_summary_weekly_partitioned_2020_w29 device_ntfn_76 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
336. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx78 on notifications_summary_weekly_partitioned_2020_w30 device_ntfn_77 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
337. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx79 on notifications_summary_weekly_partitioned_2020_w31 device_ntfn_78 (cost=0.56..5.12 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
338. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx80 on notifications_summary_weekly_partitioned_2020_w32 device_ntfn_79 (cost=0.56..6.64 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
339. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx81 on notifications_summary_weekly_partitioned_2020_w33 device_ntfn_80 (cost=0.56..8.16 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
340. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx82 on notifications_summary_weekly_partitioned_2020_w34 device_ntfn_81 (cost=0.56..12.73 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
341. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx83 on notifications_summary_weekly_partitioned_2020_w35 device_ntfn_82 (cost=0.56..5.12 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
342. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx84 on notifications_summary_weekly_partitioned_2020_w36 device_ntfn_83 (cost=0.56..17.32 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
343. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx85 on notifications_summary_weekly_partitioned_2020_w37 device_ntfn_84 (cost=0.56..5.11 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
344. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx86 on notifications_summary_weekly_partitioned_2020_w38 device_ntfn_85 (cost=0.56..5.12 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
345. 16.278 16.278 ↓ 6,553.0 6,553 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx87 on notifications_summary_weekly_partitioned_2020_w39 device_ntfn_86 (cost=0.56..3.59 rows=1 width=72) (actual time=0.052..16.278 rows=6,553 loops=1)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
  • Rows Removed by Filter: 9,406
346. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx88 on notifications_summary_weekly_partitioned_2020_w40 device_ntfn_87 (cost=0.56..6.64 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
347. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx89 on notifications_summary_weekly_partitioned_2020_w41 device_ntfn_88 (cost=0.56..12.75 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
348. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx90 on notifications_summary_weekly_partitioned_2020_w42 device_ntfn_89 (cost=0.56..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (event_uuid = $13))
  • Filter: ((created_date <= $14) AND (created_date >= $15) AND (category = 'DEVICE'::text))
349. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx91 on notifications_summary_weekly_partitioned_2020_w43 device_ntfn_90 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
350. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx92 on notifications_summary_weekly_partitioned_2020_w44 device_ntfn_91 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
351. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx93 on notifications_summary_weekly_partitioned_2020_w45 device_ntfn_92 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
352. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx94 on notifications_summary_weekly_partitioned_2020_w46 device_ntfn_93 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
353. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx95 on notifications_summary_weekly_partitioned_2020_w47 device_ntfn_94 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
354. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx96 on notifications_summary_weekly_partitioned_2020_w48 device_ntfn_95 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
355. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx97 on notifications_summary_weekly_partitioned_2020_w49 device_ntfn_96 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
356. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx98 on notifications_summary_weekly_partitioned_2020_w50 device_ntfn_97 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
357. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx99 on notifications_summary_weekly_partitioned_2020_w51 device_ntfn_98 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
358. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient_idx100 on notifications_summary_weekly_partitioned_2020_w52 device_ntfn_99 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
359. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx48 on notifications_summary_weekly_part_default device_ntfn_100 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (created_date <= $14) AND (created_date >= $15))
  • Filter: ((event_uuid = $13) AND (category = 'DEVICE'::text))
360. 52.424 52.424 ↓ 0.0 0 6,553

Index Scan using responses_org_part_default_notification_uuid_idx on responses_org_part_default device_response (cost=0.43..3.47 rows=1 width=59) (actual time=0.008..0.008 rows=0 loops=6,553)

  • Index Cond: (notification_uuid = device_ntfn.notification_uuid)
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid) AND (((response)::text || ' '::text) ~~* ANY ($18)))
361. 11.973 506.155 ↓ 3,562.9 28,503 1

Materialize (cost=913.63..1,169.44 rows=8 width=59) (actual time=444.549..506.155 rows=28,503 loops=1)

362. 50.299 494.182 ↓ 3,562.9 28,503 1

Bitmap Heap Scan on responses_org_part_default device_response2 (cost=913.63..1,169.40 rows=8 width=59) (actual time=444.545..494.182 rows=28,503 loops=1)

  • Recheck Cond: ((valid_range @> $19) AND (organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid))
  • Filter: (is_visible AND (((response)::text || ' '::text) ~~* ANY ($20)))
  • Rows Removed by Filter: 1,549
  • Heap Blocks: exact=2,757
363. 3.193 443.883 ↓ 0.0 0 1

BitmapAnd (cost=913.63..913.63 rows=170 width=0) (actual time=443.883..443.883 rows=0 loops=1)

364. 437.315 437.315 ↓ 181.0 2,553,714 1

Bitmap Index Scan on responses_org_part_default_valid_range_idx (cost=0.00..265.25 rows=14,111 width=0) (actual time=437.315..437.315 rows=2,553,714 loops=1)

  • Index Cond: (valid_range @> $19)
365. 3.375 3.375 ↑ 1.1 30,054 1

Bitmap Index Scan on responses_org_part_default_organization_uuid_response_uuid_idx (cost=0.00..648.13 rows=33,960 width=0) (actual time=3.375..3.375 rows=30,054 loops=1)

  • Index Cond: (organization_uuid = 'a2423b29-4fcb-44c4-88b8-bd2d86d56369'::uuid)
Planning time : 132.333 ms
Execution time : 624.137 ms