explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d6lm

Settings
# exclusive inclusive rows x rows loops node
1. 2.206 36,801.402 ↓ 726.7 2,180 1

Sort (cost=453,020.38..453,020.38 rows=3 width=168) (actual time=36,801.241..36,801.402 rows=2,180 loops=1)

  • Sort Key: pn.person_uuid
  • Sort Method: quicksort Memory: 675kB
2.          

CTE get_event

3. 714.581 850.388 ↑ 586.0 1 1

Bitmap Heap Scan on events_org_part_140 e (cost=33.12..1,284.90 rows=586 width=106) (actual time=850.386..850.388 rows=1 loops=1)

  • Recheck Cond: (event_uuid = '170321c8-cfaf-462c-8e0b-91d5046f69be'::uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid))
  • Rows Removed by Filter: 1758
  • Heap Blocks: exact=804
4. 135.807 135.807 ↑ 1.0 1,759 1

Bitmap Index Scan on events_org_part_140_event_uuid_idx1 (cost=0.00..32.98 rows=1,759 width=0) (actual time=135.807..135.807 rows=1,759 loops=1)

  • Index Cond: (event_uuid = '170321c8-cfaf-462c-8e0b-91d5046f69be'::uuid)
5.          

CTE get_response_matchers

6. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=440,964.02..441,864.02 rows=40,000 width=96) (never executed)

  • 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
7. 0.000 0.000 ↓ 0.0 0

Result (cost=0.42..397,164.02 rows=5,840,000 width=96) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Append (cost=0.42..265,764.02 rows=5,840,000 width=64) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Subquery Scan on "*SELECT* 1" (cost=0.42..427.09 rows=10,000 width=64) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.42..327.09 rows=10,000 width=128) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..24.59 rows=100 width=32) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..22.08 rows=1 width=983) (never executed)

13. 0.000 0.000 ↓ 0.0 0

CTE Scan on get_event e_1 (cost=0.00..11.72 rows=3 width=24) (never executed)

  • Filter: (choices IS NULL)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using forms_org_seq_vrange_uidx on forms f (cost=0.42..3.44 rows=1 width=1,018) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (form_uuid = e_1.form_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> e_1.created))
15. 0.000 0.000 ↓ 0.0 0

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

16. 0.000 0.000 ↓ 0.0 0

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

17. 0.000 0.000 ↓ 0.0 0

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

18. 0.000 0.000 ↓ 0.0 0

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

19. 0.000 0.000 ↓ 0.0 0

Subquery Scan on "*SELECT* 2" (cost=0.00..236,136.92 rows=5,830,000 width=64) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.00..177,836.92 rows=5,830,000 width=128) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..1,479.42 rows=58,300 width=32) (never executed)

22. 0.000 0.000 ↓ 0.0 0

CTE Scan on get_event e_2 (cost=0.00..11.72 rows=583 width=32) (never executed)

  • Filter: (choices IS NOT NULL)
23. 0.000 0.000 ↓ 0.0 0

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

24. 0.000 0.000 ↓ 0.0 0

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

25. 0.000 0.000 ↓ 0.0 0

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

26. 0.000 0.000 ↓ 0.0 0

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

27.          

CTE get_event_notifications

28. 0.000 8,354.040 ↓ 29.2 19,403 1

Hash Join (cost=49.05..8,900.98 rows=664 width=124) (actual time=866.519..8,354.040 rows=19,403 loops=1)

  • Hash Cond: (ns.event_uuid = get_event.event_uuid)
29.          

Initplan (for Hash Join)

30. 0.028 850.421 ↑ 1.0 1 1

Aggregate (cost=17.58..17.59 rows=1 width=8) (actual time=850.420..850.421 rows=1 loops=1)

31. 850.393 850.393 ↑ 586.0 1 1

CTE Scan on get_event e_3 (cost=0.00..11.72 rows=586 width=16) (actual time=850.391..850.393 rows=1 loops=1)

32. 0.005 0.007 ↑ 1.0 1 1

Aggregate (cost=13.19..13.20 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

33. 0.002 0.002 ↑ 586.0 1 1

CTE Scan on get_event e_4 (cost=0.00..11.72 rows=586 width=8) (actual time=0.002..0.002 rows=1 loops=1)

34. 853.020 8,343.784 ↓ 15.2 20,144 1

Append (cost=0.56..8,825.01 rows=1,329 width=124) (actual time=866.407..8,343.784 rows=20,144 loops=1)

35. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 ns (cost=0.56..453.02 rows=76 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
36. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx1 on notifications_summary_weekly_partitioned_2019_w6 ns_1 (cost=0.56..115.85 rows=19 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
37. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx2 on notifications_summary_weekly_partitioned_2019_w7 ns_2 (cost=0.56..96.34 rows=16 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
38. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx3 on notifications_summary_weekly_partitioned_2019_w8 ns_3 (cost=0.56..107.97 rows=18 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
39. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx4 on notifications_summary_weekly_partitioned_2019_w9 ns_4 (cost=0.56..120.88 rows=20 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
40. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx5 on notifications_summary_weekly_partitioned_2019_w10 ns_5 (cost=0.56..111.67 rows=18 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
41. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx6 on notifications_summary_weekly_partitioned_2019_w11 ns_6 (cost=0.56..127.12 rows=21 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
42. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx7 on notifications_summary_weekly_partitioned_2019_w12 ns_7 (cost=0.56..104.07 rows=17 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
43. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 ns_8 (cost=0.56..473.38 rows=77 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
44. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx9 on notifications_summary_weekly_partitioned_2019_w14 ns_9 (cost=0.56..108.08 rows=17 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
45. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 ns_10 (cost=0.56..121.58 rows=19 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
46. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx11 on notifications_summary_weekly_partitioned_2019_w16 ns_11 (cost=0.56..129.67 rows=20 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx12 on notifications_summary_weekly_partitioned_2019_w17 ns_12 (cost=0.56..126.86 rows=20 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
48. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx13 on notifications_summary_weekly_partitioned_2019_w18 ns_13 (cost=0.56..136.11 rows=21 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx14 on notifications_summary_weekly_partitioned_2019_w19 ns_14 (cost=0.56..126.53 rows=20 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
50. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx15 on notifications_summary_weekly_partitioned_2019_w20 ns_15 (cost=0.56..148.08 rows=23 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
51. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx16 on notifications_summary_weekly_partitioned_2019_w21 ns_16 (cost=0.56..150.02 rows=23 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx17 on notifications_summary_weekly_partitioned_2019_w22 ns_17 (cost=0.56..151.40 rows=23 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
53. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx18 on notifications_summary_weekly_partitioned_2019_w23 ns_18 (cost=0.56..143.16 rows=22 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx19 on notifications_summary_weekly_partitioned_2019_w24 ns_19 (cost=0.56..141.10 rows=22 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
55. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx20 on notifications_summary_weekly_partitioned_2019_w25 ns_20 (cost=0.56..147.16 rows=23 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
56. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 ns_21 (cost=0.56..148.15 rows=23 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
57. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx22 on notifications_summary_weekly_partitioned_2019_w27 ns_22 (cost=0.56..121.29 rows=19 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
58. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx23 on notifications_summary_weekly_partitioned_2019_w28 ns_23 (cost=0.56..118.57 rows=18 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
59. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx24 on notifications_summary_weekly_partitioned_2019_w29 ns_24 (cost=0.56..151.26 rows=23 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
60. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx25 on notifications_summary_weekly_partitioned_2019_w30 ns_25 (cost=0.56..147.80 rows=23 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
61. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx26 on notifications_summary_weekly_partitioned_2019_w31 ns_26 (cost=0.56..103.26 rows=15 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
62. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx27 on notifications_summary_weekly_partitioned_2019_w32 ns_27 (cost=0.56..130.08 rows=20 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
63. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx28 on notifications_summary_weekly_partitioned_2019_w33 ns_28 (cost=0.56..81.45 rows=12 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
64. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx29 on notifications_summary_weekly_partitioned_2019_w34 ns_29 (cost=0.56..60.02 rows=9 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
65. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 ns_30 (cost=0.56..135.41 rows=21 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
66. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 ns_31 (cost=0.56..134.10 rows=21 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
67. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 ns_32 (cost=0.56..144.47 rows=22 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 ns_33 (cost=0.56..148.75 rows=23 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
69. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 ns_34 (cost=0.56..149.45 rows=22 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
70. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx35 on notifications_summary_weekly_partitioned_2019_w40 ns_35 (cost=0.56..146.02 rows=20 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
71. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx36 on notifications_summary_weekly_partitioned_2019_w41 ns_36 (cost=0.56..158.85 rows=21 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
72. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2019_w42_pkey on notifications_summary_weekly_partitioned_2019_w42 ns_37 (cost=0.56..163.27 rows=20 width=120) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
73. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 ns_38 (cost=0.56..154.43 rows=21 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 ns_39 (cost=0.56..171.88 rows=23 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
75. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx40 on notifications_summary_weekly_partitioned_2019_w45 ns_40 (cost=0.56..136.26 rows=18 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
76. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 ns_41 (cost=0.56..158.91 rows=21 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
77. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 ns_42 (cost=0.56..176.98 rows=24 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx43 on notifications_summary_weekly_partitioned_2019_w48 ns_43 (cost=0.56..138.30 rows=19 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
79. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 ns_44 (cost=0.56..142.39 rows=20 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx45 on notifications_summary_weekly_partitioned_2019_w50 ns_45 (cost=0.56..145.57 rows=20 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
81. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 ns_46 (cost=0.56..150.95 rows=21 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
82. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx47 on notifications_summary_weekly_partitioned_2019_w52 ns_47 (cost=0.56..104.94 rows=14 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
83. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx49 on notifications_summary_weekly_partitioned_2020_w1 ns_48 (cost=0.56..109.82 rows=15 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
84. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=0.56..135.09 rows=18 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
85. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx51 on notifications_summary_weekly_partitioned_2020_w3 ns_50 (cost=0.56..140.97 rows=19 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
86. 7,490.764 7,490.764 ↓ 155.0 20,144 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx52 on notifications_summary_weekly_partitioned_2020_w4 ns_51 (cost=0.56..949.32 rows=130 width=119) (actual time=15.962..7,490.764 rows=20,144 loops=1)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
  • Rows Removed by Filter: 253
87. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w5_pkey on notifications_summary_weekly_partitioned_2020_w5 ns_52 (cost=0.56..160.37 rows=19 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_partitioned_2020_w6_pkey on notifications_summary_weekly_partitioned_2020_w6 ns_53 (cost=0.56..110.90 rows=13 width=119) (never executed)

  • Index Cond: ((organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (created_date <= $8) AND (created_date >= $9))
  • Filter: (category = ANY ('{LIVE,DEVICE,PERSON}'::text[]))
89. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx55 on notifications_summary_weekly_partitioned_2020_w7 ns_54 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
90. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx56 on notifications_summary_weekly_partitioned_2020_w8 ns_55 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
91. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx57 on notifications_summary_weekly_partitioned_2020_w9 ns_56 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
92. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx58 on notifications_summary_weekly_partitioned_2020_w10 ns_57 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
93. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx59 on notifications_summary_weekly_partitioned_2020_w11 ns_58 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx60 on notifications_summary_weekly_partitioned_2020_w12 ns_59 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
95. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx61 on notifications_summary_weekly_partitioned_2020_w13 ns_60 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx62 on notifications_summary_weekly_partitioned_2020_w14 ns_61 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
97. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx63 on notifications_summary_weekly_partitioned_2020_w15 ns_62 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
98. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx64 on notifications_summary_weekly_partitioned_2020_w16 ns_63 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
99. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx65 on notifications_summary_weekly_partitioned_2020_w17 ns_64 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
100. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx66 on notifications_summary_weekly_partitioned_2020_w18 ns_65 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
101. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx67 on notifications_summary_weekly_partitioned_2020_w19 ns_66 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
102. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx68 on notifications_summary_weekly_partitioned_2020_w20 ns_67 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx69 on notifications_summary_weekly_partitioned_2020_w21 ns_68 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
104. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx70 on notifications_summary_weekly_partitioned_2020_w22 ns_69 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
105. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx71 on notifications_summary_weekly_partitioned_2020_w23 ns_70 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
106. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx72 on notifications_summary_weekly_partitioned_2020_w24 ns_71 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
107. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx73 on notifications_summary_weekly_partitioned_2020_w25 ns_72 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
108. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx74 on notifications_summary_weekly_partitioned_2020_w26 ns_73 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
109. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx75 on notifications_summary_weekly_partitioned_2020_w27 ns_74 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
110. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx76 on notifications_summary_weekly_partitioned_2020_w28 ns_75 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
111. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx77 on notifications_summary_weekly_partitioned_2020_w29 ns_76 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
112. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx78 on notifications_summary_weekly_partitioned_2020_w30 ns_77 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
113. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx79 on notifications_summary_weekly_partitioned_2020_w31 ns_78 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
114. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx80 on notifications_summary_weekly_partitioned_2020_w32 ns_79 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
115. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx81 on notifications_summary_weekly_partitioned_2020_w33 ns_80 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
116. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx82 on notifications_summary_weekly_partitioned_2020_w34 ns_81 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
117. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx83 on notifications_summary_weekly_partitioned_2020_w35 ns_82 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
118. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx84 on notifications_summary_weekly_partitioned_2020_w36 ns_83 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
119. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx85 on notifications_summary_weekly_partitioned_2020_w37 ns_84 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
120. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx86 on notifications_summary_weekly_partitioned_2020_w38 ns_85 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
121. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
122. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx88 on notifications_summary_weekly_partitioned_2020_w40 ns_87 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
123. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx89 on notifications_summary_weekly_partitioned_2020_w41 ns_88 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
124. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx90 on notifications_summary_weekly_partitioned_2020_w42 ns_89 (cost=0.14..3.17 rows=1 width=254) (never executed)

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
125. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
126. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
127. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
128. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
129. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
130. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
131. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
132. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
133. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
134. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
135. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid)
  • Filter: ((created_date <= $8) AND (created_date >= $9) AND (category = ANY ('{LIVE,DEVICE,PERSON}'::text[])))
136. 0.005 0.018 ↑ 200.0 1 1

Hash (cost=15.19..15.19 rows=200 width=16) (actual time=0.018..0.018 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
137. 0.007 0.013 ↑ 200.0 1 1

HashAggregate (cost=13.19..15.19 rows=200 width=16) (actual time=0.012..0.013 rows=1 loops=1)

  • Group Key: get_event.event_uuid
138. 0.006 0.006 ↑ 586.0 1 1

CTE Scan on get_event (cost=0.00..11.72 rows=586 width=16) (actual time=0.006..0.006 rows=1 loops=1)

139.          

CTE get_person_device_ntfn_responses

140. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=900.45..925.24 rows=2 width=298) (never executed)

141.          

Initplan (for Nested Loop)

142. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=900.00..900.01 rows=1 width=32) (never executed)

143. 0.000 0.000 ↓ 0.0 0

CTE Scan on get_response_matchers rc (cost=0.00..800.00 rows=40,000 width=32) (never executed)

144. 0.000 0.000 ↓ 0.0 0

CTE Scan on get_event_notifications ns_101 (cost=0.00..18.26 rows=2 width=64) (never executed)

  • Filter: ((category = ANY ('{DEVICE,PERSON}'::text[])) AND (responded_date <= now()))
145. 0.000 0.000 ↓ 0.0 0

Index Scan using responses_org_part_default_notification_uuid_idx on responses_org_part_default r (cost=0.43..3.46 rows=1 width=250) (never executed)

  • Index Cond: (notification_uuid = ns_101.notification_uuid)
  • Filter: ((is_visible IS TRUE) AND (upper_inf(valid_range) IS TRUE) AND (organization_uuid = 'd7c353a7-8973-4719-94b3-e49caadb3d49'::uuid) AND (((response)::text || ' '::text) ~~* ANY ($11)))
146.          

CTE get_device_notifications

147. 4,212.623 35,878.682 ↓ 8,573.0 8,573 1

Nested Loop (cost=0.00..30.05 rows=1 width=254) (actual time=6,640.511..35,878.682 rows=8,573 loops=1)

  • Join Filter: (dns.notification_uuid = lns.parent_ntfn_uuid)
  • Rows Removed by Join Filter: 73847822
148. 31.779 31.779 ↓ 2,871.7 8,615 1

CTE Scan on get_event_notifications dns (cost=0.00..14.94 rows=3 width=214) (actual time=22.639..31.779 rows=8,615 loops=1)

  • Filter: (category = 'DEVICE'::text)
  • Rows Removed by Filter: 10788
149. 31,634.280 31,634.280 ↓ 2,857.7 8,573 8,615

CTE Scan on get_event_notifications lns (cost=0.00..14.94 rows=3 width=24) (actual time=1.993..3.672 rows=8,573 loops=8,615)

  • Filter: ((pending_date IS NOT NULL) AND (category = 'LIVE'::text))
  • Rows Removed by Filter: 10830
150.          

CTE get_person_notifications

151. 869.852 869.852 ↓ 738.3 2,215 1

CTE Scan on get_event_notifications pns (cost=0.00..14.95 rows=3 width=254) (actual time=866.529..869.852 rows=2,215 loops=1)

  • Filter: (category = 'PERSON'::text)
  • Rows Removed by Filter: 17188
152. 1.467 36,799.196 ↓ 726.7 2,180 1

Hash Left Join (cost=0.09..0.21 rows=3 width=168) (actual time=36,792.242..36,799.196 rows=2,180 loops=1)

  • Hash Cond: (pn.person_ntfn_uuid = ds.person_ntfn_uuid)
  • Filter: ((ds.person_ntfn_uuid IS NOT NULL) OR (pn.person_failed_date IS NOT NULL) OR (pn.person_responded_date IS NOT NULL))
  • Rows Removed by Filter: 35
153. 872.070 872.070 ↓ 738.3 2,215 1

CTE Scan on get_person_notifications pn (cost=0.00..0.06 rows=3 width=72) (actual time=866.535..872.070 rows=2,215 loops=1)

154. 0.953 35,925.659 ↓ 2,180.0 2,180 1

Hash (cost=0.07..0.07 rows=1 width=88) (actual time=35,925.659..35,925.659 rows=2,180 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 330kB
155. 0.292 35,924.706 ↓ 2,180.0 2,180 1

Subquery Scan on ds (cost=0.03..0.07 rows=1 width=88) (actual time=35,917.851..35,924.706 rows=2,180 loops=1)

156. 6.293 35,924.414 ↓ 2,180.0 2,180 1

GroupAggregate (cost=0.03..0.07 rows=1 width=160) (actual time=35,917.849..35,924.414 rows=2,180 loops=1)

  • Group Key: adns.person_ntfn_uuid
157. 19.371 35,918.121 ↓ 8,573.0 8,573 1

Sort (cost=0.03..0.04 rows=1 width=72) (actual time=35,917.450..35,918.121 rows=8,573 loops=1)

  • Sort Key: adns.person_ntfn_uuid
  • Sort Method: quicksort Memory: 1164kB
158. 35,898.750 35,898.750 ↓ 8,573.0 8,573 1

CTE Scan on get_device_notifications adns (cost=0.00..0.02 rows=1 width=72) (actual time=6,640.515..35,898.750 rows=8,573 loops=1)

Planning time : 100.986 ms
Execution time : 36,819.724 ms