explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9A6h

Settings
# exclusive inclusive rows x rows loops node
1. 1.104 2,203.682 ↑ 3,357.1 2,383 1

Subquery Scan on n (cost=1,021,916,703.02..1,174,939,285.72 rows=8,000,000 width=168) (actual time=2,197.697..2,203.682 rows=2,383 loops=1)

2.          

CTE get_event

3. 0.023 188.396 ↑ 25.0 1 1

Append (cost=0.42..86.03 rows=25 width=158) (actual time=188.186..188.396 rows=1 loops=1)

4. 17.856 17.856 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_2018_event_uuid_idx on events_org_part_12_l3_t_2018 e (cost=0.42..3.44 rows=1 width=105) (actual time=17.855..17.856 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
5. 0.082 0.082 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201901_event_uuid_idx on events_org_part_12_l3_t_201901 e_1 (cost=0.29..3.31 rows=1 width=106) (actual time=0.082..0.082 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
6. 0.046 0.046 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201902_event_uuid_idx on events_org_part_12_l3_t_201902 e_2 (cost=0.29..3.31 rows=1 width=106) (actual time=0.046..0.046 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
7. 0.093 0.093 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201903_event_uuid_idx on events_org_part_12_l3_t_201903 e_3 (cost=0.42..3.44 rows=1 width=106) (actual time=0.093..0.093 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
8. 0.051 0.051 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201904_event_uuid_idx on events_org_part_12_l3_t_201904 e_4 (cost=0.42..3.44 rows=1 width=106) (actual time=0.051..0.051 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
9. 0.059 0.059 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201905_event_uuid_idx on events_org_part_12_l3_t_201905 e_5 (cost=0.42..3.44 rows=1 width=1,188) (actual time=0.059..0.059 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
10. 0.050 0.050 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201906_event_uuid_idx on events_org_part_12_l3_t_201906 e_6 (cost=0.42..3.44 rows=1 width=106) (actual time=0.050..0.050 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
11. 11.092 11.092 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201907_event_uuid_idx on events_org_part_12_l3_t_201907 e_7 (cost=0.42..4.96 rows=1 width=106) (actual time=11.092..11.092 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
12. 0.190 0.190 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201908_event_uuid_idx on events_org_part_12_l3_t_201908 e_8 (cost=0.42..4.96 rows=1 width=106) (actual time=0.190..0.190 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
13. 0.114 0.114 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201909_event_uuid_idx on events_org_part_12_l3_t_201909 e_9 (cost=0.42..3.44 rows=1 width=106) (actual time=0.114..0.114 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
14. 44.963 44.963 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201910_event_uuid_idx on events_org_part_12_l3_t_201910 e_10 (cost=0.42..3.44 rows=1 width=106) (actual time=44.963..44.963 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
15. 31.598 31.598 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201911_event_uuid_idx on events_org_part_12_l3_t_201911 e_11 (cost=0.42..3.44 rows=1 width=106) (actual time=31.598..31.598 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
16. 0.143 0.143 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_201912_event_uuid_idx on events_org_part_12_l3_t_201912 e_12 (cost=0.42..3.44 rows=1 width=107) (actual time=0.143..0.143 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
17. 81.848 81.848 ↑ 1.0 1 1

Index Scan using events_org_part_12_l3_t_202001_org_seq_vrange_uidx on events_org_part_12_l3_t_202001 e_13 (cost=0.42..3.44 rows=1 width=107) (actual time=81.835..81.848 rows=1 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
18. 0.065 0.065 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202002_org_seq_vrange_uidx on events_org_part_12_l3_t_202002 e_14 (cost=0.29..3.31 rows=1 width=107) (actual time=0.065..0.065 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
19. 0.029 0.029 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202003_org_seq_vrange_uidx on events_org_part_12_l3_t_202003 e_15 (cost=0.14..3.17 rows=1 width=128) (actual time=0.028..0.029 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
20. 0.010 0.010 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202004_org_seq_vrange_uidx on events_org_part_12_l3_t_202004 e_16 (cost=0.14..3.17 rows=1 width=128) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
21. 0.010 0.010 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202005_org_seq_vrange_uidx on events_org_part_12_l3_t_202005 e_17 (cost=0.14..3.17 rows=1 width=128) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
22. 0.011 0.011 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202006_org_seq_vrange_uidx on events_org_part_12_l3_t_202006 e_18 (cost=0.14..3.17 rows=1 width=128) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
23. 0.015 0.015 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202007_org_seq_vrange_uidx on events_org_part_12_l3_t_202007 e_19 (cost=0.14..3.17 rows=1 width=128) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
24. 0.010 0.010 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202008_org_seq_vrange_uidx on events_org_part_12_l3_t_202008 e_20 (cost=0.14..3.17 rows=1 width=128) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
25. 0.011 0.011 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202009_org_seq_vrange_uidx on events_org_part_12_l3_t_202009 e_21 (cost=0.14..3.17 rows=1 width=128) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
26. 0.009 0.009 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202010_org_seq_vrange_uidx on events_org_part_12_l3_t_202010 e_22 (cost=0.14..3.17 rows=1 width=128) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
27. 0.009 0.009 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202011_org_seq_vrange_uidx on events_org_part_12_l3_t_202011 e_23 (cost=0.14..3.17 rows=1 width=128) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
28. 0.009 0.009 ↓ 0.0 0 1

Index Scan using events_org_part_12_l3_t_202012_org_seq_vrange_uidx on events_org_part_12_l3_t_202012 e_24 (cost=0.14..3.17 rows=1 width=128) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (event_uuid = 'bc838b72-97ef-4f81-b9f9-e2a07caeb65d'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
29.          

CTE get_event_created_min

30. 0.003 0.004 ↑ 1.0 1 1

Aggregate (cost=0.56..0.57 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

31. 0.001 0.001 ↑ 25.0 1 1

CTE Scan on get_event e_25 (cost=0.00..0.50 rows=25 width=8) (actual time=0.001..0.001 rows=1 loops=1)

32.          

CTE get_event_closing_max

33. 0.020 188.422 ↑ 1.0 1 1

Aggregate (cost=0.75..0.76 rows=1 width=8) (actual time=188.421..188.422 rows=1 loops=1)

34. 188.402 188.402 ↑ 25.0 1 1

CTE Scan on get_event e_26 (cost=0.00..0.50 rows=25 width=16) (actual time=188.191..188.402 rows=1 loops=1)

35.          

CTE get_response_matchers

36. 0.161 109.496 ↓ 0.0 0 1

HashAggregate (cost=19,634.91..20,219.91 rows=26,000 width=96) (actual time=109.496..109.496 rows=0 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
37. 0.001 109.335 ↓ 0.0 0 1

Result (cost=0.42..17,684.91 rows=260,000 width=96) (actual time=109.335..109.335 rows=0 loops=1)

38. 0.002 109.334 ↓ 0.0 0 1

Append (cost=0.42..11,834.91 rows=260,000 width=64) (actual time=109.334..109.334 rows=0 loops=1)

39. 0.001 109.327 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=0.42..408.97 rows=10,000 width=64) (actual time=109.327..109.327 rows=0 loops=1)

40. 0.002 109.326 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.42..308.97 rows=10,000 width=128) (actual time=109.326..109.326 rows=0 loops=1)

41. 0.004 109.324 ↓ 0.0 0 1

Nested Loop (cost=0.42..6.47 rows=100 width=32) (actual time=109.324..109.324 rows=0 loops=1)

42. 0.004 109.317 ↑ 1.0 1 1

Nested Loop (cost=0.42..3.95 rows=1 width=983) (actual time=109.314..109.317 rows=1 loops=1)

43. 0.006 0.006 ↑ 1.0 1 1

CTE Scan on get_event e_27 (cost=0.00..0.50 rows=1 width=24) (actual time=0.004..0.006 rows=1 loops=1)

  • Filter: (choices IS NULL)
44. 109.307 109.307 ↑ 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=109.306..109.307 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (form_uuid = e_27.form_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> e_27.created))
  • Rows Removed by Filter: 9
45. 0.002 0.003 ↓ 0.0 0 1

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

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

47. 0.000 0.000 ↓ 0.0 0

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

48. 0.000 0.000 ↓ 0.0 0

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

49. 0.001 0.005 ↓ 0.0 0 1

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

50. 0.000 0.004 ↓ 0.0 0 1

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

51. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.00..63.44 rows=2,500 width=32) (actual time=0.004..0.004 rows=0 loops=1)

52. 0.003 0.003 ↓ 0.0 0 1

CTE Scan on get_event e_28 (cost=0.00..0.50 rows=25 width=32) (actual time=0.003..0.003 rows=0 loops=1)

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

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

54. 0.000 0.000 ↓ 0.0 0

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

55. 0.000 0.000 ↓ 0.0 0

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

56. 0.000 0.000 ↓ 0.0 0

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

57.          

CTE get_lowered_responses_pattern_array

58. 0.031 109.528 ↑ 1.0 1 1

Aggregate (cost=585.00..585.01 rows=1 width=32) (actual time=109.527..109.528 rows=1 loops=1)

59. 109.497 109.497 ↓ 0.0 0 1

CTE Scan on get_response_matchers rc (cost=0.00..520.00 rows=26,000 width=32) (actual time=109.497..109.497 rows=0 loops=1)

60. 3.149 2,202.578 ↑ 3,357.1 2,383 1

GroupAggregate (cost=1,021,895,810.73..1,174,718,393.43 rows=8,000,000 width=168) (actual time=2,197.679..2,202.578 rows=2,383 loops=1)

  • Group Key: person_ntfn.recipient_uuid, person_ntfn.notification_uuid, person_ntfn.event_uuid
61. 1.341 2,199.429 ↑ 591,948.0 2,580 1

Unique (cost=1,021,895,810.73..1,109,711,295.78 rows=1,527,225,827 width=360) (actual time=2,197.638..2,199.429 rows=2,580 loops=1)

62. 5.279 2,198.088 ↑ 591,948.0 2,580 1

Sort (cost=1,021,895,810.73..1,025,713,875.30 rows=1,527,225,827 width=360) (actual time=2,197.635..2,198.088 rows=2,580 loops=1)

  • Sort Key: person_ntfn.recipient_uuid, person_ntfn.notification_uuid, person_ntfn.event_uuid, person_ntfn.parent_ntfn_uuid, (CASE WHEN (person_ntfn.delinked_date <= now()) THEN person_ntfn.delinked_date ELSE NULL::timestamp with time zone END), device_ntfn.recipient_uuid, device_ntfn.notification_uuid, (CASE WHEN (device_ntfn.failed_date <= now()) THEN device_ntfn.failed_date ELSE NULL::timestamp with time zone END), (CASE WHEN (device_ntfn.delivered_date <= now()) THEN device_ntfn.delivered_date ELSE NULL::timestamp with time zone END), (CASE WHEN (device_response.received <= now()) THEN device_ntfn.responded_date ELSE NULL::timestamp with time zone END), (CASE WHEN (device_response.received <= now()) THEN 'RESPONDED'::text WHEN ((device_ntfn.delivered_date <= now()) AND ((device_ntfn.failed_date IS NULL) OR (device_ntfn.failed_date <= device_ntfn.delivered_date) OR (device_ntfn.failed_date > now()))) THEN 'DELIVERED'::text WHEN (device_ntfn.failed_date <= now()) THEN 'FAILED'::text WHEN (live_ntfn.pending_date <= now()) THEN 'PENDING'::text ELSE ''::text END), (CASE WHEN (live_ntfn.pending_date <= now()) THEN live_ntfn.pending_date ELSE NULL::timestamp with time zone END), device_response.response_uuid, (CASE WHEN (device_response.received <= now()) THEN device_response.response ELSE NULL::character varying END), (CASE WHEN (device_response.received <= now()) THEN device_response.received ELSE NULL::timestamp with time zone END), device_response.recipient_type, (NULL::uuid), (NULL::character varying), (NULL::timestamp with time zone), (NULL::character varying), (NULL::timestamp with time zone), (NULL::timestamp with time zone)
  • Sort Method: quicksort Memory: 781kB
63. 0.679 2,192.809 ↑ 591,948.0 2,580 1

Append (cost=1,669,354.30..144,632,350.89 rows=1,527,225,827 width=360) (actual time=1,501.813..2,192.809 rows=2,580 loops=1)

64. 0.000 2,154.541 ↑ 593,326.9 2,574 1

Merge Join (cost=1,669,354.30..121,686,003.18 rows=1,527,223,557 width=335) (actual time=1,501.811..2,154.541 rows=2,574 loops=1)

  • Merge Cond: (person_ntfn.notification_uuid = device_ntfn.parent_ntfn_uuid)
65.          

Initplan (for Merge Join)

66. 0.003 0.003 ↑ 1.0 1 1

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

67. 0.001 0.001 ↑ 1.0 1 1

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

68. 188.425 188.425 ↑ 1.0 1 1

CTE Scan on get_event_closing_max e_31 (cost=0.00..0.02 rows=1 width=8) (actual time=188.424..188.425 rows=1 loops=1)

69. 0.005 0.005 ↑ 1.0 1 1

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

70. 109.531 109.531 ↑ 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=109.531..109.531 rows=1 loops=1)

71. 0.001 0.001 ↑ 1.0 1 1

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

72. 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.000..0.001 rows=1 loops=1)

73. 193.494 829.391 ↑ 2.0 39,968 1

Merge Append (cost=40.54..1,647,217.41 rows=80,838 width=72) (actual time=188.663..829.391 rows=39,968 loops=1)

  • Sort Key: person_ntfn.notification_uuid
74. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w5_pkey on notifications_summary_weekly_partitioned_2019_w5 person_ntfn (cost=0.56..17,136.17 rows=951 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w6_pkey on notifications_summary_weekly_partitioned_2019_w6 person_ntfn_1 (cost=0.56..17,382.74 rows=994 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
76. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w7_pkey on notifications_summary_weekly_partitioned_2019_w7 person_ntfn_2 (cost=0.56..17,682.65 rows=996 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
77. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w8_pkey on notifications_summary_weekly_partitioned_2019_w8 person_ntfn_3 (cost=0.56..9,634.61 rows=535 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
78. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w9_pkey on notifications_summary_weekly_partitioned_2019_w9 person_ntfn_4 (cost=0.56..19,641.80 rows=1,084 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
79. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w10_pkey on notifications_summary_weekly_partitioned_2019_w10 person_ntfn_5 (cost=0.56..13,534.22 rows=728 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
80. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w11_pkey on notifications_summary_weekly_partitioned_2019_w11 person_ntfn_6 (cost=0.56..22,955.84 rows=1,208 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
81. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w12_pkey on notifications_summary_weekly_partitioned_2019_w12 person_ntfn_7 (cost=0.56..22,637.76 rows=1,196 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
82. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w13_pkey on notifications_summary_weekly_partitioned_2019_w13 person_ntfn_8 (cost=0.56..17,141.81 rows=952 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
83. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w14_pkey on notifications_summary_weekly_partitioned_2019_w14 person_ntfn_9 (cost=0.56..26,116.63 rows=1,407 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
84. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w15_pkey on notifications_summary_weekly_partitioned_2019_w15 person_ntfn_10 (cost=0.56..26,708.55 rows=1,516 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
85. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w16_pkey on notifications_summary_weekly_partitioned_2019_w16 person_ntfn_11 (cost=0.56..18,731.04 rows=1,031 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
86. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w17_pkey on notifications_summary_weekly_partitioned_2019_w17 person_ntfn_12 (cost=0.56..25,178.12 rows=1,365 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
87. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w18_pkey on notifications_summary_weekly_partitioned_2019_w18 person_ntfn_13 (cost=0.56..29,124.83 rows=1,600 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w19_pkey on notifications_summary_weekly_partitioned_2019_w19 person_ntfn_14 (cost=0.56..22,029.07 rows=1,191 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w20_pkey on notifications_summary_weekly_partitioned_2019_w20 person_ntfn_15 (cost=0.56..28,490.37 rows=1,584 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w21_pkey on notifications_summary_weekly_partitioned_2019_w21 person_ntfn_16 (cost=0.56..29,933.68 rows=1,657 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
91. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w22_pkey on notifications_summary_weekly_partitioned_2019_w22 person_ntfn_17 (cost=0.56..22,864.91 rows=1,244 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w23_pkey on notifications_summary_weekly_partitioned_2019_w23 person_ntfn_18 (cost=0.56..23,270.69 rows=1,282 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
93. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w24_pkey on notifications_summary_weekly_partitioned_2019_w24 person_ntfn_19 (cost=0.56..25,200.88 rows=1,394 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
94. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w25_pkey on notifications_summary_weekly_partitioned_2019_w25 person_ntfn_20 (cost=0.56..24,063.26 rows=1,367 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w26_pkey on notifications_summary_weekly_partitioned_2019_w26 person_ntfn_21 (cost=0.56..29,026.68 rows=1,718 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w27_pkey on notifications_summary_weekly_partitioned_2019_w27 person_ntfn_22 (cost=0.56..23,587.16 rows=1,269 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w28_pkey on notifications_summary_weekly_partitioned_2019_w28 person_ntfn_23 (cost=0.56..22,275.19 rows=1,232 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w29_pkey on notifications_summary_weekly_partitioned_2019_w29 person_ntfn_24 (cost=0.56..27,606.29 rows=1,516 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
99. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w30_pkey on notifications_summary_weekly_partitioned_2019_w30 person_ntfn_25 (cost=0.56..28,769.59 rows=1,548 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
100. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w31_pkey on notifications_summary_weekly_partitioned_2019_w31 person_ntfn_26 (cost=0.56..20,063.72 rows=1,067 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
101. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w32_pkey on notifications_summary_weekly_partitioned_2019_w32 person_ntfn_27 (cost=0.56..25,625.02 rows=1,346 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
102. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w33_pkey on notifications_summary_weekly_partitioned_2019_w33 person_ntfn_28 (cost=0.56..13,839.11 rows=756 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
103. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w34_pkey on notifications_summary_weekly_partitioned_2019_w34 person_ntfn_29 (cost=0.56..1,928.22 rows=101 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
104. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w35_pkey on notifications_summary_weekly_partitioned_2019_w35 person_ntfn_30 (cost=0.56..22,016.32 rows=1,177 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
105. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w36_pkey on notifications_summary_weekly_partitioned_2019_w36 person_ntfn_31 (cost=0.56..21,048.97 rows=1,100 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
106. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w37_pkey on notifications_summary_weekly_partitioned_2019_w37 person_ntfn_32 (cost=0.56..25,277.91 rows=1,390 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
107. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w38_pkey on notifications_summary_weekly_partitioned_2019_w38 person_ntfn_33 (cost=0.56..37,116.42 rows=2,103 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
108. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w39_pkey on notifications_summary_weekly_partitioned_2019_w39 person_ntfn_34 (cost=0.56..37,648.02 rows=1,985 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
109. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w40_pkey on notifications_summary_weekly_partitioned_2019_w40 person_ntfn_35 (cost=0.56..59,747.60 rows=2,591 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
110. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w41_pkey on notifications_summary_weekly_partitioned_2019_w41 person_ntfn_36 (cost=0.56..56,049.23 rows=2,391 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
111. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w42_pkey on notifications_summary_weekly_partitioned_2019_w42 person_ntfn_37 (cost=0.56..40,853.36 rows=1,760 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
112. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w43_pkey on notifications_summary_weekly_partitioned_2019_w43 person_ntfn_38 (cost=0.56..33,643.74 rows=1,383 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
113. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w44_pkey on notifications_summary_weekly_partitioned_2019_w44 person_ntfn_39 (cost=0.56..49,733.44 rows=2,105 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
114. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w45_pkey on notifications_summary_weekly_partitioned_2019_w45 person_ntfn_40 (cost=0.56..32,482.45 rows=1,559 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
115. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w46_pkey on notifications_summary_weekly_partitioned_2019_w46 person_ntfn_41 (cost=0.56..61,002.84 rows=2,524 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
116. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w47_pkey on notifications_summary_weekly_partitioned_2019_w47 person_ntfn_42 (cost=0.56..48,990.34 rows=2,031 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
117. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w48_pkey on notifications_summary_weekly_partitioned_2019_w48 person_ntfn_43 (cost=0.56..35,422.24 rows=1,681 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
118. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w49_pkey on notifications_summary_weekly_partitioned_2019_w49 person_ntfn_44 (cost=0.56..45,045.73 rows=2,397 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
119. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w50_pkey on notifications_summary_weekly_partitioned_2019_w50 person_ntfn_45 (cost=0.56..54,798.46 rows=2,481 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
120. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w51_pkey on notifications_summary_weekly_partitioned_2019_w51 person_ntfn_46 (cost=0.56..39,946.12 rows=1,748 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
121. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w52_pkey on notifications_summary_weekly_partitioned_2019_w52 person_ntfn_47 (cost=0.56..32,610.93 rows=1,388 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
122. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w1_pkey on notifications_summary_weekly_partitioned_2020_w1 person_ntfn_48 (cost=0.56..46,476.90 rows=1,991 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
123. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w2_pkey on notifications_summary_weekly_partitioned_2020_w2 person_ntfn_49 (cost=0.56..41,933.81 rows=1,830 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
124. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w3_pkey on notifications_summary_weekly_partitioned_2020_w3 person_ntfn_50 (cost=0.56..47,838.40 rows=2,070 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
125. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w4_pkey on notifications_summary_weekly_partitioned_2020_w4 person_ntfn_51 (cost=0.56..50,583.67 rows=2,178 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
126. 635.897 635.897 ↓ 17.4 39,968 1

Index Scan using notifications_summary_weekly_partitioned_2020_w5_pkey on notifications_summary_weekly_partitioned_2020_w5 person_ntfn_52 (cost=0.56..52,864.79 rows=2,293 width=72) (actual time=0.212..635.897 rows=39,968 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
  • Rows Removed by Filter: 52274
127. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w6_pkey on notifications_summary_weekly_partitioned_2020_w6 person_ntfn_53 (cost=0.56..18,657.37 rows=800 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
128. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w7_pkey on notifications_summary_weekly_partitioned_2020_w7 person_ntfn_54 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
129. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w8_pkey on notifications_summary_weekly_partitioned_2020_w8 person_ntfn_55 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
130. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w9_pkey on notifications_summary_weekly_partitioned_2020_w9 person_ntfn_56 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
131. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w10_pkey on notifications_summary_weekly_partitioned_2020_w10 person_ntfn_57 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
132. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w11_pkey on notifications_summary_weekly_partitioned_2020_w11 person_ntfn_58 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
133. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w12_pkey on notifications_summary_weekly_partitioned_2020_w12 person_ntfn_59 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
134. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w13_pkey on notifications_summary_weekly_partitioned_2020_w13 person_ntfn_60 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
135. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w14_pkey on notifications_summary_weekly_partitioned_2020_w14 person_ntfn_61 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
136. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w15_pkey on notifications_summary_weekly_partitioned_2020_w15 person_ntfn_62 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
137. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w16_pkey on notifications_summary_weekly_partitioned_2020_w16 person_ntfn_63 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
138. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w17_pkey on notifications_summary_weekly_partitioned_2020_w17 person_ntfn_64 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
139. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w18_pkey on notifications_summary_weekly_partitioned_2020_w18 person_ntfn_65 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
140. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w19_pkey on notifications_summary_weekly_partitioned_2020_w19 person_ntfn_66 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
141. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w20_pkey on notifications_summary_weekly_partitioned_2020_w20 person_ntfn_67 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
142. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w21_pkey on notifications_summary_weekly_partitioned_2020_w21 person_ntfn_68 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
143. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w22_pkey on notifications_summary_weekly_partitioned_2020_w22 person_ntfn_69 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
144. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w23_pkey on notifications_summary_weekly_partitioned_2020_w23 person_ntfn_70 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
145. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w24_pkey on notifications_summary_weekly_partitioned_2020_w24 person_ntfn_71 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
146. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w25_pkey on notifications_summary_weekly_partitioned_2020_w25 person_ntfn_72 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
147. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w26_pkey on notifications_summary_weekly_partitioned_2020_w26 person_ntfn_73 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
148. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w27_pkey on notifications_summary_weekly_partitioned_2020_w27 person_ntfn_74 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
149. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w28_pkey on notifications_summary_weekly_partitioned_2020_w28 person_ntfn_75 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
150. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w29_pkey on notifications_summary_weekly_partitioned_2020_w29 person_ntfn_76 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
151. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w30_pkey on notifications_summary_weekly_partitioned_2020_w30 person_ntfn_77 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
152. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w31_pkey on notifications_summary_weekly_partitioned_2020_w31 person_ntfn_78 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
153. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w32_pkey on notifications_summary_weekly_partitioned_2020_w32 person_ntfn_79 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
154. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w33_pkey on notifications_summary_weekly_partitioned_2020_w33 person_ntfn_80 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
155. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w34_pkey on notifications_summary_weekly_partitioned_2020_w34 person_ntfn_81 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
156. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w35_pkey on notifications_summary_weekly_partitioned_2020_w35 person_ntfn_82 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
157. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w36_pkey on notifications_summary_weekly_partitioned_2020_w36 person_ntfn_83 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
158. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w37_pkey on notifications_summary_weekly_partitioned_2020_w37 person_ntfn_84 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
159. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w38_pkey on notifications_summary_weekly_partitioned_2020_w38 person_ntfn_85 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
160. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w39_pkey on notifications_summary_weekly_partitioned_2020_w39 person_ntfn_86 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
161. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w40_pkey on notifications_summary_weekly_partitioned_2020_w40 person_ntfn_87 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
162. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w41_pkey on notifications_summary_weekly_partitioned_2020_w41 person_ntfn_88 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
163. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w42_pkey on notifications_summary_weekly_partitioned_2020_w42 person_ntfn_89 (cost=0.14..3.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
164. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
165. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
166. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
167. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
168. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
169. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
170. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
171. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
172. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
173. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
174. 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.17 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created_date <= $13) AND (created_date >= $14))
  • Filter: (category = 'PERSON'::text)
175. 0.932 1,314.862 ↑ 1,467.9 2,574 1

Materialize (cost=1,669,313.63..1,688,206.02 rows=3,778,479 width=119) (actual time=1,312.712..1,314.862 rows=2,574 loops=1)

176. 2.490 1,313.930 ↑ 1,467.9 2,574 1

Sort (cost=1,669,313.63..1,678,759.82 rows=3,778,479 width=119) (actual time=1,312.704..1,313.930 rows=2,574 loops=1)

  • Sort Key: device_ntfn.parent_ntfn_uuid
  • Sort Method: quicksort Memory: 458kB
177. 0.601 1,311.440 ↑ 1,467.9 2,574 1

Merge Left Join (cost=726,772.50..957,641.12 rows=3,778,479 width=119) (actual time=1,310.461..1,311.440 rows=2,574 loops=1)

  • Merge Cond: (device_ntfn.notification_uuid = device_response.notification_uuid)
  • Join Filter: (device_ntfn.responded_date <= now())
178. 2.798 625.899 ↑ 323.2 2,574 1

Sort (cost=719,476.39..721,556.29 rows=831,959 width=80) (actual time=625.511..625.899 rows=2,574 loops=1)

  • Sort Key: device_ntfn.notification_uuid
  • Sort Method: quicksort Memory: 458kB
179. 16.583 623.101 ↑ 323.2 2,574 1

Nested Loop (cost=1.69..613,904.73 rows=831,959 width=80) (actual time=49.523..623.101 rows=2,574 loops=1)

180. 0.425 539.594 ↓ 1.2 2,574 1

Nested Loop (cost=1.12..36,621.25 rows=2,206 width=24) (actual time=49.283..539.594 rows=2,574 loops=1)

181. 0.006 0.007 ↑ 25.0 1 1

HashAggregate (cost=0.56..0.81 rows=25 width=16) (actual time=0.006..0.007 rows=1 loops=1)

  • Group Key: get_event.event_uuid
182. 0.001 0.001 ↑ 25.0 1 1

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

183. 0.348 539.162 ↓ 25.5 2,574 1

Append (cost=0.56..1,463.81 rows=101 width=40) (actual time=49.211..539.162 rows=2,574 loops=1)

184. 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 live_ntfn (cost=0.56..14.66 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
185. 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 live_ntfn_1 (cost=0.56..14.63 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
186. 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 live_ntfn_2 (cost=0.56..15.32 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
187. 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 live_ntfn_3 (cost=0.56..9.81 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
188. 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 live_ntfn_4 (cost=0.56..16.72 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
189. 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 live_ntfn_5 (cost=0.56..11.92 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
190. 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 live_ntfn_6 (cost=0.56..18.75 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
191. 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 live_ntfn_7 (cost=0.56..18.06 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
192. 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 live_ntfn_8 (cost=0.56..13.93 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
193. 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 live_ntfn_9 (cost=0.56..19.57 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
194. 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 live_ntfn_10 (cost=0.56..20.51 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
195. 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 live_ntfn_11 (cost=0.56..15.64 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
196. 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 live_ntfn_12 (cost=0.56..19.91 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
197. 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 live_ntfn_13 (cost=0.56..21.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
198. 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 live_ntfn_14 (cost=0.56..16.88 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
199. 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 live_ntfn_15 (cost=0.56..20.85 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
200. 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 live_ntfn_16 (cost=0.56..22.05 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
201. 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 live_ntfn_17 (cost=0.56..17.58 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
202. 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 live_ntfn_18 (cost=0.56..18.06 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
203. 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 live_ntfn_19 (cost=0.56..20.14 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
204. 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 live_ntfn_20 (cost=0.56..20.14 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
205. 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 live_ntfn_21 (cost=0.56..22.21 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
206. 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 live_ntfn_22 (cost=0.56..18.77 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
207. 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 live_ntfn_23 (cost=0.56..16.99 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
208. 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 live_ntfn_24 (cost=0.56..20.89 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
209. 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 live_ntfn_25 (cost=0.56..21.52 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
210. 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 live_ntfn_26 (cost=0.56..16.02 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
211. 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 live_ntfn_27 (cost=0.56..18.47 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
212. 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 live_ntfn_28 (cost=0.56..11.89 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
213. 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 live_ntfn_29 (cost=0.56..4.28 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
214. 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 live_ntfn_30 (cost=0.56..14.11 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
215. 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 live_ntfn_31 (cost=0.56..13.45 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
216. 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 live_ntfn_32 (cost=0.56..14.78 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
217. 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 live_ntfn_33 (cost=0.56..21.36 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
218. 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 live_ntfn_34 (cost=0.56..20.44 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
219. 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 live_ntfn_35 (cost=0.56..60.30 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
220. 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 live_ntfn_36 (cost=0.56..64.83 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
221. 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 live_ntfn_37 (cost=0.56..46.14 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
222. 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 live_ntfn_38 (cost=0.56..29.60 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
223. 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 live_ntfn_39 (cost=0.56..43.36 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
224. 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 live_ntfn_40 (cost=0.56..32.55 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
225. 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 live_ntfn_41 (cost=0.56..55.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
226. 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 live_ntfn_42 (cost=0.56..41.82 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
227. 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 live_ntfn_43 (cost=0.56..35.66 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
228. 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 live_ntfn_44 (cost=0.56..42.27 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
229. 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 live_ntfn_45 (cost=0.56..43.39 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
230. 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 live_ntfn_46 (cost=0.56..34.05 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
231. 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 live_ntfn_47 (cost=0.56..24.96 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
232. 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 live_ntfn_48 (cost=0.56..37.26 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
233. 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 live_ntfn_49 (cost=0.56..37.21 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
234. 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 live_ntfn_50 (cost=0.56..41.83 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
235. 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 live_ntfn_51 (cost=0.56..44.85 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
236. 538.814 538.814 ↓ 2,574.0 2,574 1

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 live_ntfn_52 (cost=0.56..46.31 rows=1 width=40) (actual time=49.200..538.814 rows=2,574 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
  • Rows Removed by Filter: 11813
237. 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 live_ntfn_53 (cost=0.56..23.44 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
238. 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 live_ntfn_54 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
239. 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 live_ntfn_55 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
240. 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 live_ntfn_56 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
241. 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 live_ntfn_57 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
242. 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 live_ntfn_58 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
243. 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 live_ntfn_59 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
244. 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 live_ntfn_60 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
245. 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 live_ntfn_61 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
246. 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 live_ntfn_62 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
247. 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 live_ntfn_63 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
248. 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 live_ntfn_64 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
249. 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 live_ntfn_65 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
250. 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 live_ntfn_66 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
251. 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 live_ntfn_67 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
252. 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 live_ntfn_68 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
253. 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 live_ntfn_69 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
254. 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 live_ntfn_70 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
255. 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 live_ntfn_71 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
256. 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 live_ntfn_72 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
257. 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 live_ntfn_73 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
258. 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 live_ntfn_74 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
259. 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 live_ntfn_75 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
260. 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 live_ntfn_76 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
261. 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 live_ntfn_77 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
262. 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 live_ntfn_78 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
263. 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 live_ntfn_79 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
264. 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 live_ntfn_80 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
265. 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 live_ntfn_81 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
266. 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 live_ntfn_82 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
267. 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 live_ntfn_83 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
268. 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 live_ntfn_84 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
269. 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 live_ntfn_85 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
270. 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 live_ntfn_86 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
271. 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 live_ntfn_87 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
272. 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 live_ntfn_88 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
273. 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 live_ntfn_89 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
274. 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 live_ntfn_90 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
275. 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 live_ntfn_91 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
276. 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 live_ntfn_92 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
277. 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 live_ntfn_93 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
278. 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 live_ntfn_94 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
279. 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 live_ntfn_95 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
280. 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 live_ntfn_96 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
281. 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 live_ntfn_97 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
282. 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 live_ntfn_98 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
283. 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 live_ntfn_99 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
284. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx53 on notifications_summary_weekly_part_default live_ntfn_100 (cost=0.14..1.62 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date <= $16) AND (created_date >= $17) AND (category = 'LIVE'::text) AND (pending_date <= now()))
285. 0.000 66.924 ↑ 101.0 1 2,574

Append (cost=0.56..260.68 rows=101 width=72) (actual time=0.026..0.026 rows=1 loops=2,574)

286. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
287. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
288. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
289. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
290. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
291. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
292. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
293. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
294. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
295. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
296. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
297. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
298. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
299. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
300. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
301. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
302. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
303. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
304. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
305. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
306. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
307. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
308. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
309. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
310. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
311. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
312. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
313. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
314. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
315. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
316. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
317. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
318. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
319. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
320. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
321. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
322. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
323. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
324. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
325. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
326. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
327. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
328. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
329. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
330. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
331. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
332. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
333. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
334. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
335. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
336. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
337. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
338. 66.924 66.924 ↑ 1.0 1 2,574

Index Scan using notifications_summary_weekly_partitioned_2020_w5_pkey on notifications_summary_weekly_partitioned_2020_w5 device_ntfn_52 (cost=0.56..3.52 rows=1 width=72) (actual time=0.025..0.026 rows=1 loops=2,574)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
339. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
340. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w7_pkey on notifications_summary_weekly_partitioned_2020_w7 device_ntfn_54 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
341. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w8_pkey on notifications_summary_weekly_partitioned_2020_w8 device_ntfn_55 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
342. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w9_pkey on notifications_summary_weekly_partitioned_2020_w9 device_ntfn_56 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
343. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w10_pkey on notifications_summary_weekly_partitioned_2020_w10 device_ntfn_57 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
344. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w11_pkey on notifications_summary_weekly_partitioned_2020_w11 device_ntfn_58 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
345. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w12_pkey on notifications_summary_weekly_partitioned_2020_w12 device_ntfn_59 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
346. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w13_pkey on notifications_summary_weekly_partitioned_2020_w13 device_ntfn_60 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
347. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w14_pkey on notifications_summary_weekly_partitioned_2020_w14 device_ntfn_61 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
348. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w15_pkey on notifications_summary_weekly_partitioned_2020_w15 device_ntfn_62 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
349. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w16_pkey on notifications_summary_weekly_partitioned_2020_w16 device_ntfn_63 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
350. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w17_pkey on notifications_summary_weekly_partitioned_2020_w17 device_ntfn_64 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
351. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w18_pkey on notifications_summary_weekly_partitioned_2020_w18 device_ntfn_65 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
352. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w19_pkey on notifications_summary_weekly_partitioned_2020_w19 device_ntfn_66 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
353. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w20_pkey on notifications_summary_weekly_partitioned_2020_w20 device_ntfn_67 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
354. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w21_pkey on notifications_summary_weekly_partitioned_2020_w21 device_ntfn_68 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
355. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w22_pkey on notifications_summary_weekly_partitioned_2020_w22 device_ntfn_69 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
356. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w23_pkey on notifications_summary_weekly_partitioned_2020_w23 device_ntfn_70 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
357. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w24_pkey on notifications_summary_weekly_partitioned_2020_w24 device_ntfn_71 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
358. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w25_pkey on notifications_summary_weekly_partitioned_2020_w25 device_ntfn_72 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
359. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w26_pkey on notifications_summary_weekly_partitioned_2020_w26 device_ntfn_73 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
360. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w27_pkey on notifications_summary_weekly_partitioned_2020_w27 device_ntfn_74 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
361. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w28_pkey on notifications_summary_weekly_partitioned_2020_w28 device_ntfn_75 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
362. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w29_pkey on notifications_summary_weekly_partitioned_2020_w29 device_ntfn_76 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
363. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w30_pkey on notifications_summary_weekly_partitioned_2020_w30 device_ntfn_77 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
364. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w31_pkey on notifications_summary_weekly_partitioned_2020_w31 device_ntfn_78 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
365. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w32_pkey on notifications_summary_weekly_partitioned_2020_w32 device_ntfn_79 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
366. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w33_pkey on notifications_summary_weekly_partitioned_2020_w33 device_ntfn_80 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
367. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w34_pkey on notifications_summary_weekly_partitioned_2020_w34 device_ntfn_81 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
368. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w35_pkey on notifications_summary_weekly_partitioned_2020_w35 device_ntfn_82 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
369. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w36_pkey on notifications_summary_weekly_partitioned_2020_w36 device_ntfn_83 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
370. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w37_pkey on notifications_summary_weekly_partitioned_2020_w37 device_ntfn_84 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
371. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w38_pkey on notifications_summary_weekly_partitioned_2020_w38 device_ntfn_85 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
372. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w39_pkey on notifications_summary_weekly_partitioned_2020_w39 device_ntfn_86 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
373. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w40_pkey on notifications_summary_weekly_partitioned_2020_w40 device_ntfn_87 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
374. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w41_pkey on notifications_summary_weekly_partitioned_2020_w41 device_ntfn_88 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
375. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w42_pkey on notifications_summary_weekly_partitioned_2020_w42 device_ntfn_89 (cost=0.14..1.52 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
376. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
377. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
378. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
379. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
380. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
381. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
382. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
383. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
384. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
385. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
386. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= $11) AND (created_date >= $12))
  • Filter: (category = 'DEVICE'::text)
387. 0.000 684.940 ↓ 0.0 0 1

Sort (cost=7,296.11..7,302.93 rows=2,725 width=55) (actual time=684.940..684.940 rows=0 loops=1)

  • Sort Key: device_response.notification_uuid
  • Sort Method: quicksort Memory: 25kB
388. 148.902 685.434 ↓ 0.0 0 1

Gather (cost=1,000.00..7,140.62 rows=2,725 width=55) (actual time=684.924..685.434 rows=0 loops=1)

  • Workers Planned: 2
  • Params Evaluated: $15
  • Workers Launched: 2
389. 536.532 536.532 ↓ 0.0 0 3 / 3

Parallel Seq Scan on responses_org_part_18 device_response (cost=0.00..5,868.12 rows=1,135 width=55) (actual time=536.532..536.532 rows=0 loops=3)

  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (((response)::text || ' '::text) ~~* ANY ($15)))
  • Rows Removed by Filter: 56406
390. 0.048 37.589 ↑ 378.3 6 1

Nested Loop Left Join (cost=1.60..37,960.30 rows=2,270 width=311) (actual time=1.674..37.589 rows=6 loops=1)

  • Join Filter: (person_resp_ntfn.responded_date <= now())
391.          

Initplan (for Nested Loop Left Join)

392. 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.001..0.002 rows=1 loops=1)

393. 0.001 0.001 ↑ 1.0 1 1

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

394. 0.001 0.001 ↑ 1.0 1 1

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

395. 0.072 7.615 ↑ 83.3 6 1

Nested Loop (cost=1.12..36,496.00 rows=500 width=88) (actual time=1.580..7.615 rows=6 loops=1)

396. 0.007 0.009 ↑ 25.0 1 1

HashAggregate (cost=0.56..0.81 rows=25 width=16) (actual time=0.008..0.009 rows=1 loops=1)

  • Group Key: get_event_1.event_uuid
397. 0.002 0.002 ↑ 25.0 1 1

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

398. 0.022 7.534 ↑ 16.8 6 1

Append (cost=0.56..1,458.80 rows=101 width=88) (actual time=1.504..7.534 rows=6 loops=1)

399. 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 person_resp_ntfn (cost=0.56..14.74 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
400. 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 person_resp_ntfn_1 (cost=0.56..14.71 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
401. 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 person_resp_ntfn_2 (cost=0.56..15.41 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
402. 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 person_resp_ntfn_3 (cost=0.56..9.86 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
403. 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 person_resp_ntfn_4 (cost=0.56..16.82 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
404. 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 person_resp_ntfn_5 (cost=0.56..11.98 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
405. 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 person_resp_ntfn_6 (cost=0.56..18.87 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
406. 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 person_resp_ntfn_7 (cost=0.56..18.17 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
407. 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 person_resp_ntfn_8 (cost=0.56..14.01 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
408. 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 person_resp_ntfn_9 (cost=0.56..19.69 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
409. 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 person_resp_ntfn_10 (cost=0.56..20.63 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
410. 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 person_resp_ntfn_11 (cost=0.56..15.73 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
411. 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 person_resp_ntfn_12 (cost=0.56..20.03 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
412. 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 person_resp_ntfn_13 (cost=0.56..21.72 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
413. 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 person_resp_ntfn_14 (cost=0.56..16.98 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
414. 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 person_resp_ntfn_15 (cost=0.56..20.98 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
415. 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 person_resp_ntfn_16 (cost=0.56..22.19 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
416. 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 person_resp_ntfn_17 (cost=0.56..17.68 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
417. 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 person_resp_ntfn_18 (cost=0.56..18.17 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
418. 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 person_resp_ntfn_19 (cost=0.56..20.27 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
419. 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 person_resp_ntfn_20 (cost=0.56..20.26 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
420. 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 person_resp_ntfn_21 (cost=0.56..22.35 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
421. 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 person_resp_ntfn_22 (cost=0.56..18.89 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
422. 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 person_resp_ntfn_23 (cost=0.56..17.09 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
423. 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 person_resp_ntfn_24 (cost=0.56..21.02 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
424. 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 person_resp_ntfn_25 (cost=0.56..21.65 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
425. 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 person_resp_ntfn_26 (cost=0.56..16.11 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
426. 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 person_resp_ntfn_27 (cost=0.56..18.58 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
427. 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 person_resp_ntfn_28 (cost=0.56..11.96 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
428. 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 person_resp_ntfn_29 (cost=0.56..4.29 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
429. 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 person_resp_ntfn_30 (cost=0.56..14.19 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
430. 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 person_resp_ntfn_31 (cost=0.56..13.53 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
431. 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 person_resp_ntfn_32 (cost=0.56..14.86 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
432. 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 person_resp_ntfn_33 (cost=0.56..21.49 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
433. 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 person_resp_ntfn_34 (cost=0.56..20.56 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
434. 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 person_resp_ntfn_35 (cost=0.56..60.49 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
435. 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 person_resp_ntfn_36 (cost=0.56..65.03 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
436. 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 person_resp_ntfn_37 (cost=0.56..46.29 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
437. 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 person_resp_ntfn_38 (cost=0.56..29.69 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
438. 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 person_resp_ntfn_39 (cost=0.56..43.50 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
439. 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 person_resp_ntfn_40 (cost=0.56..32.65 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
440. 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 person_resp_ntfn_41 (cost=0.56..55.76 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
441. 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 person_resp_ntfn_42 (cost=0.56..41.95 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
442. 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 person_resp_ntfn_43 (cost=0.56..35.77 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
443. 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 person_resp_ntfn_44 (cost=0.56..42.40 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
444. 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 person_resp_ntfn_45 (cost=0.56..43.53 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
445. 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 person_resp_ntfn_46 (cost=0.56..34.15 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
446. 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 person_resp_ntfn_47 (cost=0.56..25.03 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
447. 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 person_resp_ntfn_48 (cost=0.56..37.37 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
448. 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 person_resp_ntfn_49 (cost=0.56..37.33 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
449. 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 person_resp_ntfn_50 (cost=0.56..41.96 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
450. 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 person_resp_ntfn_51 (cost=0.56..44.99 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
451. 7.512 7.512 ↓ 6.0 6 1

Index Scan using notifications_summary_weekly__organization_uuid_event_uuid_idx4 on notifications_summary_weekly_partitioned_2020_w5 person_resp_ntfn_52 (cost=0.56..46.46 rows=1 width=88) (actual time=1.487..7.512 rows=6 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
  • Rows Removed by Filter: 14381
452. 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 person_resp_ntfn_53 (cost=0.56..23.51 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
453. 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 person_resp_ntfn_54 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
454. 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 person_resp_ntfn_55 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
455. 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 person_resp_ntfn_56 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
456. 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 person_resp_ntfn_57 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
457. 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 person_resp_ntfn_58 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
458. 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 person_resp_ntfn_59 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
459. 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 person_resp_ntfn_60 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
460. 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 person_resp_ntfn_61 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
461. 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 person_resp_ntfn_62 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
462. 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 person_resp_ntfn_63 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
463. 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 person_resp_ntfn_64 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
464. 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 person_resp_ntfn_65 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
465. 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 person_resp_ntfn_66 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
466. 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 person_resp_ntfn_67 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
467. 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 person_resp_ntfn_68 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
468. 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 person_resp_ntfn_69 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
469. 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 person_resp_ntfn_70 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
470. 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 person_resp_ntfn_71 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
471. 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 person_resp_ntfn_72 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
472. 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 person_resp_ntfn_73 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
473. 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 person_resp_ntfn_74 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
474. 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 person_resp_ntfn_75 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
475. 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 person_resp_ntfn_76 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
476. 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 person_resp_ntfn_77 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
477. 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 person_resp_ntfn_78 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
478. 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 person_resp_ntfn_79 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
479. 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 person_resp_ntfn_80 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
480. 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 person_resp_ntfn_81 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
481. 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 person_resp_ntfn_82 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
482. 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 person_resp_ntfn_83 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
483. 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 person_resp_ntfn_84 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
484. 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 person_resp_ntfn_85 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
485. 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 person_resp_ntfn_86 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
486. 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 person_resp_ntfn_87 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
487. 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 person_resp_ntfn_88 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
488. 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 person_resp_ntfn_89 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
489. 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 person_resp_ntfn_90 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
490. 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 person_resp_ntfn_91 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
491. 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 person_resp_ntfn_92 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
492. 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 person_resp_ntfn_93 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
493. 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 person_resp_ntfn_94 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
494. 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 person_resp_ntfn_95 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
495. 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 person_resp_ntfn_96 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
496. 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 person_resp_ntfn_97 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
497. 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 person_resp_ntfn_98 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
498. 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 person_resp_ntfn_99 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
499. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx53 on notifications_summary_weekly_part_default person_resp_ntfn_100 (cost=0.14..1.38 rows=1 width=88) (never executed)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((created_date <= $19) AND (created_date >= $20) AND (category = 'PERSON'::text) AND ((responded_date <= now()) OR (failed_date <= now())))
500. 29.922 29.922 ↓ 0.0 0 6

Index Scan using responses_org_part_18_notification_uuid_idx on responses_org_part_18 pr (cost=0.42..2.82 rows=1 width=55) (actual time=4.987..4.987 rows=0 loops=6)

  • Index Cond: (notification_uuid = person_resp_ntfn.notification_uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (((response)::text || ' '::text) ~~* ANY ($18)))
  • Rows Removed by Filter: 1
Planning time : 206.630 ms
Execution time : 2,220.031 ms