explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YSO93

Settings
# exclusive inclusive rows x rows loops node
1. 1.886 4,747.655 ↓ 652.0 652 1

Sort (cost=1,961.21..1,961.21 rows=1 width=168) (actual time=4,747.533..4,747.655 rows=652 loops=1)

  • Sort Key: pns.recipient_uuid
  • Sort Method: quicksort Memory: 195kB
2.          

CTE get_event

3. 1,115.523 1,115.523 ↑ 1.0 1 1

Index Scan using events_org_part_252_event_uuid_idx on events_org_part_252 e (cost=0.41..6.48 rows=1 width=105) (actual time=58.913..1,115.523 rows=1 loops=1)

  • Index Cond: (event_uuid = '74df44bf-38c1-4f60-88c8-f562d407a112'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid))
  • Rows Removed by Filter: 261
4.          

CTE get_event_created_min

5. 0.004 0.005 ↑ 1.0 1 1

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

6. 0.001 0.001 ↑ 1.0 1 1

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

7.          

CTE get_event_closing_max

8. 0.023 0.025 ↑ 1.0 1 1

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

9. 0.002 0.002 ↑ 1.0 1 1

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

10.          

CTE get_response_matchers

11. 0.030 93.318 ↑ 2,000.0 1 1

HashAggregate (cost=1,513.53..1,558.53 rows=2,000 width=96) (actual time=93.307..93.318 rows=1 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.193 93.288 ↑ 20,000.0 1 1

Result (cost=0.42..1,363.53 rows=20,000 width=96) (actual time=93.263..93.288 rows=1 loops=1)

13. 0.003 93.095 ↑ 20,000.0 1 1

Append (cost=0.42..913.53 rows=20,000 width=64) (actual time=93.070..93.095 rows=1 loops=1)

14. 0.003 93.087 ↑ 10,000.0 1 1

Subquery Scan on *SELECT* 1 (cost=0.42..408.49 rows=10,000 width=64) (actual time=93.069..93.087 rows=1 loops=1)

15. 0.009 93.084 ↑ 10,000.0 1 1

Nested Loop Left Join (cost=0.42..308.49 rows=10,000 width=128) (actual time=93.067..93.084 rows=1 loops=1)

16. 0.006 92.992 ↑ 100.0 1 1

Nested Loop (cost=0.42..5.99 rows=100 width=32) (actual time=92.977..92.992 rows=1 loops=1)

17. 0.006 49.064 ↑ 1.0 1 1

Nested Loop (cost=0.42..3.47 rows=1 width=983) (actual time=49.051..49.064 rows=1 loops=1)

18. 0.005 0.005 ↑ 1.0 1 1

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

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

Index Scan using forms_org_seq_vrange_uidx on forms f (cost=0.42..3.44 rows=1 width=1,018) (actual time=49.042..49.053 rows=1 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (form_uuid = e_3.form_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> e_3.created))
  • Rows Removed by Filter: 2
20. 43.921 43.922 ↑ 100.0 1 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=43.921..43.922 rows=1 loops=1)

21. 0.001 0.001 ↑ 1.0 1 1

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

22. 0.082 0.083 ↑ 100.0 1 1

ProjectSet (cost=0.00..0.53 rows=100 width=32) (actual time=0.081..0.083 rows=1 loops=1)

23. 0.001 0.001 ↑ 1.0 1 1

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

24. 0.001 0.005 ↓ 0.0 0 1

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

25. 0.001 0.004 ↓ 0.0 0 1

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

26. 0.001 0.003 ↓ 0.0 0 1

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

27. 0.002 0.002 ↓ 0.0 0 1

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

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

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

29. 0.000 0.000 ↓ 0.0 0

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

30. 0.000 0.000 ↓ 0.0 0

ProjectSet (cost=0.00..0.53 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.          

CTE get_lowered_responses_pattern_array

33. 0.149 93.469 ↑ 1.0 1 1

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

34. 93.320 93.320 ↑ 2,000.0 1 1

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

35.          

CTE get_all_event_notifications

36. 1.739 1,410.327 ↓ 335.2 5,028 1

Nested Loop (cost=0.62..345.75 rows=15 width=121) (actual time=1,216.230..1,410.327 rows=5,028 loops=1)

37.          

Initplan (for Nested Loop)

38. 0.031 0.031 ↑ 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.030..0.031 rows=1 loops=1)

39. 0.006 0.006 ↑ 1.0 1 1

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

40. 0.012 1,115.542 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=16) (actual time=1,115.541..1,115.542 rows=1 loops=1)

  • Group Key: get_event.event_uuid
41. 1,115.530 1,115.530 ↑ 1.0 1 1

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

42. 0.693 293.009 ↓ 49.8 5,028 1

Append (cost=0.56..344.29 rows=101 width=121) (actual time=100.536..293.009 rows=5,028 loops=1)

43. 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 ns (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
44. 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 ns_1 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
45. 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 ns_2 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
46. 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 ns_3 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
47. 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 ns_4 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
48. 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 ns_5 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
49. 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 ns_6 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
50. 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 ns_7 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
51. 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 ns_8 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
52. 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 ns_9 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
53. 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 ns_10 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
54. 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 ns_11 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
55. 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 ns_12 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
56. 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 ns_13 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
57. 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 ns_14 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
58. 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 ns_15 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
59. 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 ns_16 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
60. 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 ns_17 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
61. 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 ns_18 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
62. 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 ns_19 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
63. 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 ns_20 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
64. 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 ns_21 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
65. 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 ns_22 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
66. 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 ns_23 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
67. 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 ns_24 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
68. 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 ns_25 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
69. 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 ns_26 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
70. 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 ns_27 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
71. 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 ns_28 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
72. 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 ns_29 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
73. 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 ns_30 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
74. 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 ns_31 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
75. 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 ns_32 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
76. 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 ns_33 (cost=0.56..4.30 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
77. 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 ns_34 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
78. 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 ns_35 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
79. 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 ns_36 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
80. 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 ns_37 (cost=0.56..3.59 rows=1 width=120) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
81. 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 ns_38 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
82. 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 ns_39 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
83. 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 ns_40 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
84. 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 ns_41 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
85. 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 ns_42 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
86. 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 ns_43 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
87. 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 ns_44 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
88. 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 ns_45 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
89. 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 ns_46 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
90. 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 ns_47 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
91. 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 ns_48 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
92. 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 ns_49 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
93. 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 ns_50 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
94. 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 ns_51 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
95. 292.316 292.316 ↓ 5,028.0 5,028 1

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 ns_52 (cost=0.56..3.59 rows=1 width=119) (actual time=100.414..292.316 rows=5,028 loops=1)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
  • Rows Removed by Filter: 9
96. 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 ns_53 (cost=0.56..3.59 rows=1 width=119) (never executed)

  • Index Cond: ((organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
97. 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 ns_54 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
98. 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 ns_55 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
99. 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 ns_56 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
100. 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 ns_57 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
101. 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 ns_58 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
102. 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 ns_59 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
103. 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 ns_60 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
104. 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 ns_61 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
105. 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 ns_62 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
106. 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 ns_63 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
107. 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 ns_64 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
108. 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 ns_65 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
109. 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 ns_66 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
110. 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 ns_67 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
111. 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 ns_68 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
112. 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 ns_69 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
113. 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 ns_70 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
114. 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 ns_71 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
115. 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 ns_72 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
116. 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 ns_73 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
117. 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 ns_74 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
118. 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 ns_75 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
119. 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 ns_76 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
120. 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 ns_77 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
121. 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 ns_78 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
122. 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 ns_79 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
123. 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 ns_80 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
124. 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 ns_81 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
125. 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 ns_82 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
126. 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 ns_83 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
127. 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 ns_84 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
128. 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 ns_85 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
129. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx87 on notifications_summary_weekly_partitioned_2020_w39 ns_86 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
130. 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 ns_87 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
131. 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 ns_88 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
132. 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 ns_89 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
133. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx91 on notifications_summary_weekly_partitioned_2020_w43 ns_90 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
134. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx92 on notifications_summary_weekly_partitioned_2020_w44 ns_91 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
135. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx93 on notifications_summary_weekly_partitioned_2020_w45 ns_92 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
136. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx94 on notifications_summary_weekly_partitioned_2020_w46 ns_93 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
137. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx95 on notifications_summary_weekly_partitioned_2020_w47 ns_94 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
138. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx96 on notifications_summary_weekly_partitioned_2020_w48 ns_95 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
139. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx97 on notifications_summary_weekly_partitioned_2020_w49 ns_96 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
140. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx98 on notifications_summary_weekly_partitioned_2020_w50 ns_97 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
141. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx99 on notifications_summary_weekly_partitioned_2020_w51 ns_98 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
142. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uui_idx100 on notifications_summary_weekly_partitioned_2020_w52 ns_99 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
143. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx53 on notifications_summary_weekly_part_default ns_100 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid)
  • Filter: ((created_date <= $11) AND (created_date >= $12) AND (get_event.event_uuid = event_uuid) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
144.          

CTE get_person_device_ntfn_responses

145. 0.000 562.659 ↓ 72.4 362 1

Nested Loop (cost=0.43..3.92 rows=5 width=298) (actual time=135.040..562.659 rows=362 loops=1)

146.          

Initplan (for Nested Loop)

147. 93.474 93.474 ↑ 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=93.474..93.474 rows=1 loops=1)

148. 200.456 200.456 ↓ 519.0 519 1

CTE Scan on get_all_event_notifications ns_101 (cost=0.00..0.41 rows=1 width=64) (actual time=0.003..200.456 rows=519 loops=1)

  • Filter: ((category = ANY ('{DEVICE,PERSON}'::text[])) AND (responded_date <= now()))
  • Rows Removed by Filter: 4509
149. 361.224 361.224 ↑ 1.0 1 519

Index Scan using responses_org_part_72_notification_uuid_idx on responses_org_part_72 r (cost=0.41..3.45 rows=1 width=250) (actual time=0.696..0.696 rows=1 loops=519)

  • Index Cond: (notification_uuid = ns_101.notification_uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = '8d3a618b-96c0-4af3-a2fb-d10df4e12b6e'::uuid) AND (((response)::text || ' '::text) ~~* ANY ($15)))
150. 18.132 4,745.769 ↓ 652.0 652 1

Nested Loop Left Join (cost=0.98..1.43 rows=1 width=168) (actual time=4,079.727..4,745.769 rows=652 loops=1)

  • Join Filter: (dns.parent_ntfn_uuid = pns.notification_uuid)
  • Rows Removed by Join Filter: 214834
  • Filter: ((dns.parent_ntfn_uuid IS NOT NULL) OR (pns.failed_date IS NOT NULL) OR (CASE WHEN ((min(get_person_device_ntfn_responses.response_received)) IS NOT NULL) THEN pns.responded_date ELSE NULL::timestamp with time zone END IS NOT NULL))
  • Rows Removed by Filter: 4
151. 4.502 1,795.317 ↓ 656.0 656 1

Nested Loop Left Join (cost=0.13..0.50 rows=1 width=80) (actual time=1,779.675..1,795.317 rows=656 loops=1)

  • Join Filter: (get_person_device_ntfn_responses.person_ntfn_uuid = pns.notification_uuid)
  • Rows Removed by Join Filter: 62212
152. 1,218.127 1,218.127 ↓ 656.0 656 1

CTE Scan on get_all_event_notifications pns (cost=0.00..0.34 rows=1 width=72) (actual time=1,216.240..1,218.127 rows=656 loops=1)

  • Filter: (category = 'PERSON'::text)
  • Rows Removed by Filter: 4372
153. 9.481 572.688 ↓ 95.0 95 656

HashAggregate (cost=0.13..0.14 rows=1 width=24) (actual time=0.859..0.873 rows=95 loops=656)

  • Group Key: get_person_device_ntfn_responses.person_ntfn_uuid
154. 563.207 563.207 ↓ 103.0 103 1

CTE Scan on get_person_device_ntfn_responses (cost=0.00..0.11 rows=1 width=352) (actual time=135.047..563.207 rows=103 loops=1)

  • Filter: (category = 'PERSON'::text)
  • Rows Removed by Filter: 259
155. 572.032 2,932.320 ↓ 328.0 328 656

GroupAggregate (cost=0.86..0.89 rows=1 width=160) (actual time=3.508..4.470 rows=328 loops=656)

  • Group Key: dns.parent_ntfn_uuid
156. 68.000 2,360.288 ↓ 1,102.0 1,102 656

Sort (cost=0.86..0.86 rows=1 width=56) (actual time=3.504..3.598 rows=1,102 loops=656)

  • Sort Key: dns.parent_ntfn_uuid
  • Sort Method: quicksort Memory: 268kB
157. 41.781 2,292.288 ↓ 2,201.0 2,201 1

Nested Loop Left Join (cost=0.13..0.85 rows=1 width=56) (actual time=0.595..2,292.288 rows=2,201 loops=1)

  • Join Filter: (get_person_device_ntfn_responses_1.device_ntfn_uuid = dns.notification_uuid)
  • Rows Removed by Join Filter: 535978
158. 328.314 2,164.668 ↓ 2,201.0 2,201 1

Nested Loop (cost=0.00..0.69 rows=1 width=64) (actual time=0.010..2,164.668 rows=2,201 loops=1)

  • Join Filter: (dns.notification_uuid = lns.parent_ntfn_uuid)
  • Rows Removed by Join Filter: 4776170
159. 1.859 1.859 ↓ 2,171.0 2,171 1

CTE Scan on get_all_event_notifications dns (cost=0.00..0.34 rows=1 width=56) (actual time=0.004..1.859 rows=2,171 loops=1)

  • Filter: (category = 'DEVICE'::text)
  • Rows Removed by Filter: 2857
160. 1,834.495 1,834.495 ↓ 2,201.0 2,201 2,171

CTE Scan on get_all_event_notifications lns (cost=0.00..0.34 rows=1 width=24) (actual time=0.001..0.845 rows=2,201 loops=2,171)

  • Filter: ((pending_date IS NOT NULL) AND (category = 'LIVE'::text))
  • Rows Removed by Filter: 2827
161. 85.624 85.839 ↓ 244.0 244 2,201

HashAggregate (cost=0.13..0.14 rows=1 width=24) (actual time=0.001..0.039 rows=244 loops=2,201)

  • Group Key: get_person_device_ntfn_responses_1.device_ntfn_uuid
162. 0.215 0.215 ↓ 259.0 259 1

CTE Scan on get_person_device_ntfn_responses get_person_device_ntfn_responses_1 (cost=0.00..0.11 rows=1 width=352) (actual time=0.006..0.215 rows=259 loops=1)

  • Filter: (category = 'DEVICE'::text)
  • Rows Removed by Filter: 103
Planning time : 113.402 ms
Execution time : 4,754.023 ms