explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rgbB

Settings
# exclusive inclusive rows x rows loops node
1. 1.548 114,898.700 ↓ 1,862.5 3,725 1

Subquery Scan on n (cost=2,550.92..2,551.07 rows=2 width=200) (actual time=114,892.136..114,898.700 rows=3,725 loops=1)

2.          

CTE get_event

3. 0.003 4.564 ↑ 1.0 1 1

Append (cost=0.55..3.58 rows=1 width=726) (actual time=4.561..4.564 rows=1 loops=1)

4. 4.561 4.561 ↑ 1.0 1 1

Index Scan using events_org_part_default_evn_seq_vrange_uidx on events_org_part_default e (cost=0.55..3.58 rows=1 width=726) (actual time=4.560..4.561 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = 'f20cf6ff-64e4-4a07-a655-2c276bc37ba9'::uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> '2019-10-06 18:09:45+00'::timestamp with time zone))
  • Rows Removed by Filter: 1
5.          

CTE get_event_created_min

6. 0.003 0.004 ↑ 1.0 1 1

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

7. 0.001 0.001 ↑ 1.0 1 1

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

8.          

CTE get_event_closing_max

9. 0.012 0.013 ↑ 1.0 1 1

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

10. 0.001 0.001 ↑ 1.0 1 1

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

11.          

CTE get_response_choices

12. 0.006 89.840 ↑ 20,000.0 1 1

Append (cost=0.42..1,008.53 rows=20,000 width=128) (actual time=52.248..89.840 rows=1 loops=1)

13. 0.014 89.829 ↑ 10,000.0 1 1

Nested Loop (cost=0.42..355.99 rows=10,000 width=128) (actual time=52.245..89.829 rows=1 loops=1)

14. 0.009 89.599 ↑ 1.0 1 1

Nested Loop (cost=0.42..3.47 rows=1 width=992) (actual time=52.018..89.599 rows=1 loops=1)

15. 0.006 0.006 ↑ 1.0 1 1

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

  • Filter: (choices IS NULL)
16. 89.584 89.584 ↑ 1.0 1 1

Index Scan using forms_org_seq_vrange_uidx on forms f (cost=0.42..3.44 rows=1 width=1,027) (actual time=52.007..89.584 rows=1 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (form_uuid = e_3.form_uuid))
  • Filter: ((is_visible IS TRUE) AND (valid_range @> e_3.created))
  • Rows Removed by Filter: 3
17. 0.110 0.216 ↑ 10,000.0 1 1

ProjectSet (cost=0.00..52.52 rows=10,000 width=64) (actual time=0.214..0.216 rows=1 loops=1)

18. 0.105 0.106 ↑ 100.0 1 1

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

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

20. 0.001 0.005 ↓ 0.0 0 1

Nested Loop (cost=0.00..352.54 rows=10,000 width=128) (actual time=0.005..0.005 rows=0 loops=1)

21. 0.004 0.004 ↓ 0.0 0 1

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

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

ProjectSet (cost=0.00..52.52 rows=10,000 width=64) (never executed)

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.          

CTE get_response_matchers

26. 0.036 90.042 ↑ 2,000.0 1 1

HashAggregate (cost=800.00..845.00 rows=2,000 width=96) (actual time=90.028..90.042 rows=1 loops=1)

  • Group Key: lower(COALESCE(rc.translated_response, rc.text_response)), lower((replace(replace(COALESCE(rc.translated_response, rc.text_response), '%'::text, '\%'::text), '_'::text, '\_'::text) || ' %'::text)), rc.text_response
27. 90.006 90.006 ↑ 20,000.0 1 1

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

28.          

CTE get_lowered_responses_pattern_array

29. 0.051 90.096 ↑ 1.0 1 1

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

30. 90.045 90.045 ↑ 2,000.0 1 1

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

31.          

CTE get_person_device_notifications

32. 4.232 114,880.840 ↓ 4,303.5 8,607 1

Unique (cost=648.57..648.68 rows=2 width=352) (actual time=114,874.896..114,880.840 rows=8,607 loops=1)

33. 47.432 114,876.608 ↓ 4,303.5 8,607 1

Sort (cost=648.57..648.58 rows=2 width=352) (actual time=114,874.893..114,876.608 rows=8,607 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 <= '2019-10-06 18:09:45+00'::timestamp with time zone) THEN person_ntfn.delinked_date ELSE NULL::timestamp with time zone END), device_ntfn.recipient_uuid, device_ntfn.notification_uuid, (CASE WHEN (device_ntfn.failed_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) THEN device_ntfn.failed_date ELSE NULL::timestamp with time zone END), (CASE WHEN (device_ntfn.delivered_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) THEN device_ntfn.delivered_date ELSE NULL::timestamp with time zone END), (CASE WHEN ((device_response.received <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (((device_response.response)::text || ' '::text) ~~* ANY ($10))) THEN device_ntfn.responded_date ELSE NULL::timestamp with time zone END), (CASE WHEN ((device_response.received <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (((device_response.response)::text || ' '::text) ~~* ANY ($11))) THEN 'RESPONDED'::text WHEN (device_ntfn.delivered_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) THEN 'DELIVERED'::text WHEN (device_ntfn.failed_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) THEN 'FAILED'::text WHEN (live_ntfn.pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) THEN 'PENDING'::text ELSE ''::text END), (CASE WHEN (live_ntfn.pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) THEN live_ntfn.pending_date ELSE NULL::timestamp with time zone END), device_response.response_uuid, (CASE WHEN ((device_response.received <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (((device_response.response)::text || ' '::text) ~~* ANY ($12))) THEN device_response.response ELSE NULL::character varying END), (CASE WHEN (device_response.received <= '2019-10-06 18:09:45+00'::timestamp with time zone) THEN device_response.received ELSE NULL::timestamp with time zone END), device_response.recipient_type, (NULL::uuid), (NULL::character varying), (NULL::timestamp with time zone), (NULL::character varying), (NULL::timestamp with time zone)
  • Sort Method: quicksort Memory: 2671kB
34. 6.618 114,829.176 ↓ 4,303.5 8,607 1

Append (cost=2.46..648.56 rows=2 width=352) (actual time=118.085..114,829.176 rows=8,607 loops=1)

35. 88.958 106,851.894 ↓ 8,566.0 8,566 1

Nested Loop Left Join (cost=2.46..472.96 rows=1 width=327) (actual time=118.083..106,851.894 rows=8,566 loops=1)

  • Join Filter: (device_ntfn.responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone)
36.          

Initplan (forNested Loop Left Join)

37. 90.100 90.100 ↑ 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=90.099..90.100 rows=1 loops=1)

38. 0.001 0.001 ↑ 1.0 1 1

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

39. 0.001 0.001 ↑ 1.0 1 1

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

40. 0.002 0.002 ↑ 1.0 1 1

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

41. 0.001 0.001 ↑ 1.0 1 1

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

42. 0.001 0.001 ↑ 1.0 1 1

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

43. 0.001 0.001 ↑ 1.0 1 1

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

44. 0.016 0.016 ↑ 1.0 1 1

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

45. 0.005 0.005 ↑ 1.0 1 1

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

46. 171.575 1,273.358 ↓ 8,385.0 8,385 1

Nested Loop (cost=1.71..469.12 rows=1 width=136) (actual time=14.742..1,273.358 rows=8,385 loops=1)

47. 170.461 581.913 ↓ 8,385.0 8,385 1

Nested Loop (cost=1.15..320.65 rows=1 width=80) (actual time=14.671..581.913 rows=8,385 loops=1)

48. 5.953 117.977 ↓ 8,385.0 8,385 1

Nested Loop (cost=0.58..171.90 rows=1 width=24) (actual time=14.505..117.977 rows=8,385 loops=1)

49. 0.013 4.583 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=16) (actual time=4.581..4.583 rows=1 loops=1)

  • Group Key: get_event.event_uuid
50. 4.570 4.570 ↑ 1.0 1 1

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

51. 7.286 107.441 ↓ 171.1 8,385 1

Append (cost=0.56..171.38 rows=49 width=40) (actual time=9.881..107.441 rows=8,385 loops=1)

52. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
53. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
54. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
55. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
56. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
57. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
58. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
59. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
60. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
61. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
62. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
63. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
64. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
65. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
66. 99.741 99.741 ↓ 8,385.0 8,385 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx19 on notifications_summary_weekly_partitioned_2019_w19 live_ntfn_14 (cost=0.56..3.59 rows=1 width=40) (actual time=9.845..99.741 rows=8,385 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
  • Rows Removed by Filter: 12077
67. 0.165 0.165 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx20 on notifications_summary_weekly_partitioned_2019_w20 live_ntfn_15 (cost=0.56..3.59 rows=1 width=40) (actual time=0.165..0.165 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
68. 0.055 0.055 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx21 on notifications_summary_weekly_partitioned_2019_w21 live_ntfn_16 (cost=0.56..3.59 rows=1 width=40) (actual time=0.055..0.055 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
69. 0.086 0.086 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx22 on notifications_summary_weekly_partitioned_2019_w22 live_ntfn_17 (cost=0.56..3.59 rows=1 width=40) (actual time=0.086..0.086 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
70. 0.108 0.108 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_organization_uuid_event_uuid_idx23 on notifications_summary_weekly_partitioned_2019_w23 live_ntfn_18 (cost=0.56..3.59 rows=1 width=40) (actual time=0.108..0.108 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
71. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
72. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
73. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
74. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
75. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
76. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
77. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
78. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
79. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
80. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
81. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
82. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
83. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
84. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
85. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
86. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
87. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
88. 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..3.59 rows=1 width=40) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event.event_uuid))
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
89. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
90. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
91. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
92. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
93. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
94. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
95. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
96. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
97. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
98. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
99. 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.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
100. 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_48 (cost=0.14..3.18 rows=1 width=40) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((created_date >= $18) AND (pending_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (category = 'LIVE'::text) AND (get_event.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $17)))
101. 75.465 293.475 ↑ 49.0 1 8,385

Append (cost=0.56..148.25 rows=49 width=72) (actual time=0.017..0.035 rows=1 loops=8,385)

102. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
103. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
104. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
105. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
106. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
107. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
108. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
109. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
110. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
111. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
112. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
113. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
114. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
115. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
116. 142.545 142.545 ↑ 1.0 1 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w19_pkey on notifications_summary_weekly_partitioned_2019_w19 device_ntfn_14 (cost=0.56..3.59 rows=1 width=72) (actual time=0.016..0.017 rows=1 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
117. 25.155 25.155 ↓ 0.0 0 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w20_pkey on notifications_summary_weekly_partitioned_2019_w20 device_ntfn_15 (cost=0.56..3.59 rows=1 width=72) (actual time=0.003..0.003 rows=0 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
118. 16.770 16.770 ↓ 0.0 0 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w21_pkey on notifications_summary_weekly_partitioned_2019_w21 device_ntfn_16 (cost=0.56..3.59 rows=1 width=72) (actual time=0.002..0.002 rows=0 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
119. 16.770 16.770 ↓ 0.0 0 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w22_pkey on notifications_summary_weekly_partitioned_2019_w22 device_ntfn_17 (cost=0.56..3.59 rows=1 width=72) (actual time=0.002..0.002 rows=0 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
120. 16.770 16.770 ↓ 0.0 0 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w23_pkey on notifications_summary_weekly_partitioned_2019_w23 device_ntfn_18 (cost=0.56..3.59 rows=1 width=72) (actual time=0.002..0.002 rows=0 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
121. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
122. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
123. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
124. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
125. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
126. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
127. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
128. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
129. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
130. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
131. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
132. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
133. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
134. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
135. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
136. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
137. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
138. 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.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
139. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
140. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
141. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
142. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
143. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
144. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
145. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
146. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
147. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
148. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
149. 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.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
150. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_part_default_pkey on notifications_summary_weekly_part_default device_ntfn_48 (cost=0.15..1.26 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = live_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $13)) AND (created_date >= $14))
  • Filter: (category = 'DEVICE'::text)
151. 92.235 519.870 ↑ 49.0 1 8,385

Append (cost=0.56..147.98 rows=49 width=72) (actual time=0.009..0.062 rows=1 loops=8,385)

152. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
153. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
154. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
155. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
156. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
157. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
158. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
159. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
160. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
161. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
162. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
163. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
164. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
165. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
166. 83.850 83.850 ↑ 1.0 1 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w19_pkey on notifications_summary_weekly_partitioned_2019_w19 person_ntfn_14 (cost=0.56..3.59 rows=1 width=72) (actual time=0.008..0.010 rows=1 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
167. 109.005 109.005 ↓ 0.0 0 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w20_pkey on notifications_summary_weekly_partitioned_2019_w20 person_ntfn_15 (cost=0.56..3.59 rows=1 width=72) (actual time=0.013..0.013 rows=0 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
168. 83.850 83.850 ↓ 0.0 0 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w21_pkey on notifications_summary_weekly_partitioned_2019_w21 person_ntfn_16 (cost=0.56..3.59 rows=1 width=72) (actual time=0.010..0.010 rows=0 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
169. 75.465 75.465 ↓ 0.0 0 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w22_pkey on notifications_summary_weekly_partitioned_2019_w22 person_ntfn_17 (cost=0.56..3.59 rows=1 width=72) (actual time=0.009..0.009 rows=0 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
170. 75.465 75.465 ↓ 0.0 0 8,385

Index Scan using notifications_summary_weekly_partitioned_2019_w23_pkey on notifications_summary_weekly_partitioned_2019_w23 person_ntfn_18 (cost=0.56..3.59 rows=1 width=72) (actual time=0.009..0.009 rows=0 loops=8,385)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
171. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
172. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
173. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
174. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
175. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
176. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
177. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
178. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
179. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
180. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
181. 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..3.58 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
182. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
183. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
184. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
185. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
186. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
187. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
188. 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..3.59 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
189. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
190. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
191. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
192. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
193. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
194. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
195. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
196. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
197. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
198. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
199. 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.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
200. 0.000 0.000 ↓ 0.0 0

Index Scan using notifications_summary_weekly_part_default_pkey on notifications_summary_weekly_part_default person_ntfn_48 (cost=0.15..1.24 rows=1 width=72) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (notification_uuid = device_ntfn.parent_ntfn_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $15)) AND (created_date >= $16))
  • Filter: (category = 'PERSON'::text)
201. 105,399.450 105,399.450 ↓ 0.0 0 8,385

Index Scan using responses_notification_uuid_idx on responses device_response (cost=0.56..3.58 rows=1 width=63) (actual time=12.543..12.570 rows=0 loops=8,385)

  • Index Cond: (notification_uuid = device_ntfn.notification_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> '2019-10-06 18:09:45+00'::timestamp with time zone) AND (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid))
202. 2.507 7,970.664 ↓ 41.0 41 1

Nested Loop (cost=1.21..175.57 rows=1 width=311) (actual time=114.017..7,970.664 rows=41 loops=1)

203.          

Initplan (forNested Loop)

204. 0.003 0.003 ↑ 1.0 1 1

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

205. 0.002 0.002 ↑ 1.0 1 1

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

206. 0.002 0.002 ↑ 1.0 1 1

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

207. 0.890 15.702 ↓ 1,164.0 1,164 1

Nested Loop (cost=0.58..171.90 rows=1 width=80) (actual time=0.175..15.702 rows=1,164 loops=1)

208. 0.010 0.015 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=16) (actual time=0.014..0.015 rows=1 loops=1)

  • Group Key: get_event_1.event_uuid
209. 0.005 0.005 ↑ 1.0 1 1

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

210. 0.623 14.797 ↓ 23.8 1,164 1

Append (cost=0.56..171.38 rows=49 width=80) (actual time=0.072..14.797 rows=1,164 loops=1)

211. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
212. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
213. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
214. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
215. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
216. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
217. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
218. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
219. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
220. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
221. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
222. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
223. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
224. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
225. 14.059 14.059 ↓ 1,164.0 1,164 1

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..3.59 rows=1 width=80) (actual time=0.052..14.059 rows=1,164 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
  • Rows Removed by Filter: 19298
226. 0.024 0.024 ↓ 0.0 0 1

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..3.59 rows=1 width=80) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
227. 0.052 0.052 ↓ 0.0 0 1

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..3.59 rows=1 width=80) (actual time=0.052..0.052 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
228. 0.020 0.020 ↓ 0.0 0 1

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..3.59 rows=1 width=80) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
229. 0.019 0.019 ↓ 0.0 0 1

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..3.59 rows=1 width=80) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
230. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
231. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
232. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
233. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
234. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
235. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
236. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
237. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
238. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
239. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
240. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
241. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
242. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
243. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
244. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
245. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
246. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
247. 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..3.59 rows=1 width=80) (never executed)

  • Index Cond: ((organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (event_uuid = get_event_1.event_uuid))
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
248. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
249. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
250. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
251. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
252. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
253. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
254. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
255. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
256. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
257. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
258. 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.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
259. 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_48 (cost=0.14..3.18 rows=1 width=80) (never executed)

  • Index Cond: (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid)
  • Filter: ((responded_date <= '2019-10-06 18:09:45+00'::timestamp with time zone) AND (created_date >= $21) AND (category = 'PERSON'::text) AND (get_event_1.event_uuid = event_uuid) AND (created_date <= LEAST('2019-10-06 18:09:45+00'::timestamp with time zone, $20)))
260. 7,952.448 7,952.448 ↓ 0.0 0 1,164

Index Scan using responses_notification_uuid_idx on responses pr (cost=0.56..3.60 rows=1 width=63) (actual time=6.832..6.832 rows=0 loops=1,164)

  • Index Cond: (notification_uuid = person_resp_ntfn.notification_uuid)
  • Filter: ((is_visible IS TRUE) AND (valid_range @> '2019-10-06 18:09:45+00'::timestamp with time zone) AND (organization_uuid = 'fe857c89-72ec-4b77-ab22-96bd295ece2c'::uuid) AND (((response)::text || ' '::text) ~~* ANY ($19)))
261. 4.617 114,897.152 ↓ 1,862.5 3,725 1

GroupAggregate (cost=0.05..0.14 rows=2 width=152) (actual time=114,892.111..114,897.152 rows=3,725 loops=1)

  • Group Key: get_person_device_notifications.person_uuid, get_person_device_notifications.person_ntfn_uuid, get_person_device_notifications.event_uuid
262. 5.421 114,892.535 ↓ 4,303.5 8,607 1

Sort (cost=0.05..0.06 rows=2 width=120) (actual time=114,892.076..114,892.535 rows=8,607 loops=1)

  • Sort Key: ‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà, ‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà‚ñà, get_person_device_notifications.event_uuid
  • Sort Method: quicksort Memory: 1595kB
263. 114,887.114 114,887.114 ↓ 4,303.5 8,607 1

CTE Scan on get_person_device_notifications (cost=0.00..0.04 rows=2 width=120) (actual time=114,874.954..114,887.114 rows=8,607 loops=1)

Planning time : 178.268 ms
Execution time : 114,931.735 ms