explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B7Di

Settings
# exclusive inclusive rows x rows loops node
1. 0.392 100,080.498 ↑ 1.0 100 1

Sort (cost=8,549,797.36..8,549,797.61 rows=100 width=620) (actual time=100,080.488..100,080.498 rows=100 loops=1)

  • Sort Key: e.event_id DESC
  • Sort Method: quicksort Memory: 76kB
2.          

CTE filtered_events

3. 0.078 99,914.535 ↑ 1.0 100 1

Limit (cost=8,549,592.35..8,549,592.60 rows=100 width=641) (actual time=99,914.441..99,914.535 rows=100 loops=1)

4. 236.987 99,914.457 ↑ 133,817.0 100 1

Sort (cost=8,549,592.35..8,583,046.61 rows=13,381,703 width=641) (actual time=99,914.440..99,914.457 rows=100 loops=1)

  • Sort Key: e_2.event_id DESC
  • Sort Method: top-N heapsort Memory: 109kB
5. 273.959 99,677.470 ↑ 44.4 301,293 1

Nested Loop Left Join (cost=7,656,725.79..8,038,153.29 rows=13,381,703 width=641) (actual time=94,081.453..99,677.470 rows=301,293 loops=1)

6. 5,297.786 98,800.925 ↑ 2.2 301,293 1

Hash Right Join (cost=7,656,725.51..7,817,955.23 rows=677,898 width=619) (actual time=94,079.079..98,800.925 rows=301,293 loops=1)

  • Hash Cond: (pl.plan_uuid = e_2.plan_uuid)
  • Join Filter: (pl.valid_range @> e_2.created)
  • Rows Removed by Join Filter: 16994782
  • Filter: ((pl.plan_uuid IS NULL) OR ((pl.name)::text <> ALL ('{"Voice Recording Notifications","Error Response Notifications","User Upload Onboarding Notifications","Data Upload Notifications"}'::text[])))
7. 1,615.974 1,615.974 ↑ 1.1 736 1

Seq Scan on plans pl (cost=0.00..39,811.31 rows=796 width=64) (actual time=37.300..1,615.974 rows=736 loops=1)

  • Filter: ((is_visible IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
  • Rows Removed by Filter: 1014747
8. 219.258 91,887.165 ↑ 2.3 301,293 1

Hash (cost=7,596,402.11..7,596,402.11 rows=687,872 width=592) (actual time=91,887.165..91,887.165 rows=301,293 loops=1)

  • Buckets: 16384 (originally 16384) Batches: 128 (originally 64) Memory Usage: 68119kB
9. 671.825 91,667.907 ↑ 2.3 301,293 1

Hash Right Join (cost=7,479,389.15..7,596,402.11 rows=687,872 width=592) (actual time=90,999.316..91,667.907 rows=301,293 loops=1)

  • Hash Cond: (f.form_uuid = e_2.form_uuid)
  • Join Filter: (f.valid_range @> e_2.created)
  • Rows Removed by Join Filter: 921660
10. 1,758.232 1,758.232 ↑ 1.1 386 1

Seq Scan on forms f (cost=0.00..29,485.11 rows=431 width=56) (actual time=108.415..1,758.232 rows=386 loops=1)

  • Filter: ((is_visible IS TRUE) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
  • Rows Removed by Filter: 245075
11. 162.460 89,237.850 ↑ 2.3 301,293 1

Hash (cost=7,420,408.75..7,420,408.75 rows=687,872 width=571) (actual time=89,237.850..89,237.850 rows=301,293 loops=1)

  • Buckets: 16384 (originally 16384) Batches: 128 (originally 64) Memory Usage: 50638kB
12. 202.591 89,075.390 ↑ 2.3 301,293 1

Unique (cost=6,658,760.15..7,413,530.03 rows=687,872 width=571) (actual time=88,793.763..89,075.390 rows=301,293 loops=1)

13. 338.125 88,872.799 ↑ 40.1 301,374 1

Sort (cost=6,658,760.15..6,688,950.95 rows=12,076,318 width=571) (actual time=88,793.760..88,872.799 rows=301,374 loops=1)

  • Sort Key: e_2.event_uuid, e_2.event_id, e_2.submitter_uuid, e_2.priority, e_2.incident_id, e_2.override_device_restrictions, e_2.escalation_override, e_2.bypass_phone_intro, e_2.require_phone_password, e_2.conference_properties, e_2.created, e_2.status, e_2.terminated, e_2.request_uuid, e_2.sequence, e_2.revision_uuid, e_2.event_type, e_2.system_event_type, e_2.form_uuid, e_2.plan_uuid, e_2.choices, (lower(e_2.valid_range)), (upper(e_2.valid_range)), e_2.recipients
  • Sort Method: external merge Disk: 86672kB
14. 345.016 88,534.674 ↑ 40.1 301,374 1

Merge Left Join (cost=467,277.27..1,258,010.35 rows=12,076,318 width=571) (actual time=87,695.424..88,534.674 rows=301,374 loops=1)

  • Merge Cond: (e_2.event_uuid = ns.event_uuid)
  • Join Filter: (ns.created_date >= e_2.created)
  • Filter: ((e_2.submitter_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) OR (ns.recipient_uuid IS NOT NULL))
  • Rows Removed by Filter: 987202
15. 2,317.234 13,625.207 ↓ 3.0 1,288,495 1

Sort (cost=442,047.82..443,122.63 rows=429,922 width=569) (actual time=13,166.317..13,625.207 rows=1,288,495 loops=1)

  • Sort Key: e_2.event_uuid
  • Sort Method: external merge Disk: 284824kB
16. 114.971 11,307.973 ↓ 3.0 1,288,495 1

Append (cost=0.00..330,970.38 rows=429,922 width=569) (actual time=11.294..11,307.973 rows=1,288,495 loops=1)

  • Subplans Removed: 11
17. 1,293.866 1,293.866 ↓ 3.0 118,523 1

Seq Scan on events_org_part_12_l3_t_2018 e_2 (cost=0.00..28,709.29 rows=39,487 width=363) (actual time=11.291..1,293.866 rows=118,523 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 1401
18. 495.807 495.807 ↓ 3.0 57,310 1

Seq Scan on events_org_part_12_l3_t_201901 e_3 (cost=0.00..12,950.30 rows=19,094 width=365) (actual time=19.909..495.807 rows=57,310 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 570
19. 506.397 506.397 ↓ 3.0 49,476 1

Seq Scan on events_org_part_12_l3_t_201902 e_4 (cost=0.00..11,130.94 rows=16,481 width=365) (actual time=14.885..506.397 rows=49,476 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 388
20. 931.561 931.561 ↓ 3.0 89,303 1

Seq Scan on events_org_part_12_l3_t_201903 e_5 (cost=0.00..22,840.05 rows=29,754 width=366) (actual time=19.911..931.561 rows=89,303 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 477
21. 1,029.555 1,029.555 ↓ 3.0 109,620 1

Seq Scan on events_org_part_12_l3_t_201904 e_6 (cost=0.00..26,459.65 rows=36,507 width=365) (actual time=18.398..1,029.555 rows=109,620 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 542
22. 950.535 950.535 ↓ 3.0 100,873 1

Seq Scan on events_org_part_12_l3_t_201905 e_7 (cost=0.00..22,860.15 rows=33,605 width=1,438) (actual time=13.025..950.535 rows=100,873 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 556
23. 1,311.336 1,311.336 ↓ 3.0 106,391 1

Seq Scan on events_org_part_12_l3_t_201906 e_8 (cost=0.00..24,225.87 rows=35,460 width=366) (actual time=23.420..1,311.336 rows=106,391 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 670
24. 1,975.655 1,975.655 ↓ 3.0 228,014 1

Seq Scan on events_org_part_12_l3_t_201907 e_9 (cost=0.00..52,219.55 rows=76,042 width=882) (actual time=23.783..1,975.655 rows=228,014 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 1087
25. 1,053.234 1,053.234 ↓ 3.0 104,403 1

Seq Scan on events_org_part_12_l3_t_201908 e_10 (cost=0.00..27,426.08 rows=34,773 width=365) (actual time=7.180..1,053.234 rows=104,403 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 623
26. 1,200.720 1,200.720 ↓ 3.0 80,457 1

Seq Scan on events_org_part_12_l3_t_201909 e_11 (cost=0.00..24,346.17 rows=26,802 width=367) (actual time=21.837..1,200.720 rows=80,457 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 484
27. 130.380 130.380 ↓ 3.0 78,697 1

Seq Scan on events_org_part_12_l3_t_201910 e_12 (cost=0.00..20,917.24 rows=26,240 width=516) (actual time=0.044..130.380 rows=78,697 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 425
28. 156.692 156.692 ↓ 3.0 75,696 1

Seq Scan on events_org_part_12_l3_t_201911 e_13 (cost=0.00..28,846.96 rows=25,232 width=514) (actual time=0.040..156.692 rows=75,696 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 302
29. 125.452 125.452 ↓ 2.9 71,419 1

Seq Scan on events_org_part_12_l3_t_201912 e_14 (cost=0.00..20,301.37 rows=24,228 width=517) (actual time=0.038..125.452 rows=71,419 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 347
30. 31.812 31.812 ↓ 3.0 18,313 1

Seq Scan on events_org_part_12_l3_t_202001 e_15 (cost=0.00..5,552.28 rows=6,206 width=516) (actual time=0.041..31.812 rows=18,313 loops=1)

  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND ((system_event_type IS NULL) OR ((system_event_type)::text = 'SYSTEM_MESSAGE'::text)) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (created <= now()))
  • Rows Removed by Filter: 146
31. 325.172 74,564.451 ↓ 17.8 301,831 1

Sort (cost=25,229.44..25,271.79 rows=16,938 width=40) (actual time=74,529.047..74,564.451 rows=301,831 loops=1)

  • Sort Key: ns.event_uuid
  • Sort Method: external sort Disk: 15920kB
32. 32.378 74,239.279 ↓ 17.8 300,963 1

Append (cost=0.56..24,039.72 rows=16,938 width=40) (actual time=0.102..74,239.279 rows=300,963 loops=1)

  • Subplans Removed: 50
33. 1.071 1.071 ↓ 8.5 111 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient_u_idx on notifications_summary_weekly_partitioned_2019_w5 ns (cost=0.56..11.82 rows=13 width=40) (actual time=0.100..1.071 rows=111 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
34. 1.152 1.152 ↓ 10.1 131 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx1 on notifications_summary_weekly_partitioned_2019_w6 ns_1 (cost=0.56..11.74 rows=13 width=40) (actual time=0.071..1.152 rows=131 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
35. 6.263 6.263 ↓ 9.1 109 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx2 on notifications_summary_weekly_partitioned_2019_w7 ns_2 (cost=0.56..11.07 rows=12 width=40) (actual time=4.199..6.263 rows=109 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
36. 5.854 5.854 ↓ 14.0 112 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx3 on notifications_summary_weekly_partitioned_2019_w8 ns_3 (cost=0.56..8.35 rows=8 width=40) (actual time=3.947..5.854 rows=112 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
37. 5.794 5.794 ↓ 11.2 146 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx4 on notifications_summary_weekly_partitioned_2019_w9 ns_4 (cost=0.56..11.75 rows=13 width=40) (actual time=3.626..5.794 rows=146 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
38. 1,531.191 1,531.191 ↓ 11.5 115 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx5 on notifications_summary_weekly_partitioned_2019_w10 ns_5 (cost=0.56..9.74 rows=10 width=40) (actual time=22.118..1,531.191 rows=115 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
39. 2,352.277 2,352.277 ↓ 8.8 150 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx6 on notifications_summary_weekly_partitioned_2019_w11 ns_6 (cost=0.56..14.45 rows=17 width=40) (actual time=25.490..2,352.277 rows=150 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
40. 2,095.064 2,095.064 ↓ 7.2 130 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx7 on notifications_summary_weekly_partitioned_2019_w12 ns_7 (cost=0.56..15.13 rows=18 width=40) (actual time=11.415..2,095.064 rows=130 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
41. 1,552.886 1,552.886 ↓ 8.1 105 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx8 on notifications_summary_weekly_partitioned_2019_w13 ns_8 (cost=0.56..11.74 rows=13 width=40) (actual time=31.347..1,552.886 rows=105 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
42. 2,616.676 2,616.676 ↓ 7.2 143 1

Index Scan using notifications_summary_weekly__organization_uuid_recipient__idx9 on notifications_summary_weekly_partitioned_2019_w14 ns_9 (cost=0.56..16.63 rows=20 width=40) (actual time=21.224..2,616.676 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
43. 2,636.713 2,636.713 ↓ 9.3 177 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx10 on notifications_summary_weekly_partitioned_2019_w15 ns_10 (cost=0.56..16.12 rows=19 width=40) (actual time=32.326..2,636.713 rows=177 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
44. 1,583.563 1,583.563 ↓ 5.2 99 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx11 on notifications_summary_weekly_partitioned_2019_w16 ns_11 (cost=0.56..16.01 rows=19 width=40) (actual time=14.080..1,583.563 rows=99 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
45. 1,949.562 1,949.562 ↓ 4.5 95 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx12 on notifications_summary_weekly_partitioned_2019_w17 ns_12 (cost=0.56..17.63 rows=21 width=40) (actual time=16.797..1,949.562 rows=95 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
46. 2,538.055 2,538.055 ↓ 5.6 135 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx13 on notifications_summary_weekly_partitioned_2019_w18 ns_13 (cost=0.56..19.23 rows=24 width=40) (actual time=25.788..2,538.055 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
47. 1,253.987 1,253.987 ↓ 5.2 93 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx14 on notifications_summary_weekly_partitioned_2019_w19 ns_14 (cost=0.56..15.25 rows=18 width=40) (actual time=22.680..1,253.987 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
48. 2,053.421 2,053.421 ↓ 5.1 143 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx15 on notifications_summary_weekly_partitioned_2019_w20 ns_15 (cost=0.56..21.93 rows=28 width=40) (actual time=31.632..2,053.421 rows=143 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
49. 2,423.242 2,423.242 ↓ 8.0 199 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx16 on notifications_summary_weekly_partitioned_2019_w21 ns_16 (cost=0.56..20.31 rows=25 width=40) (actual time=13.353..2,423.242 rows=199 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
50. 1,225.281 1,225.281 ↓ 9.5 171 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx17 on notifications_summary_weekly_partitioned_2019_w22 ns_17 (cost=0.56..15.34 rows=18 width=40) (actual time=0.053..1,225.281 rows=171 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
51. 2,241.210 2,241.210 ↓ 6.7 127 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx18 on notifications_summary_weekly_partitioned_2019_w23 ns_18 (cost=0.56..15.81 rows=19 width=40) (actual time=40.846..2,241.210 rows=127 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
52. 0.734 0.734 ↓ 8.1 146 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx19 on notifications_summary_weekly_partitioned_2019_w24 ns_19 (cost=0.56..15.14 rows=18 width=40) (actual time=0.052..0.734 rows=146 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
53. 2.167 2.167 ↓ 8.6 172 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx20 on notifications_summary_weekly_partitioned_2019_w25 ns_20 (cost=0.56..16.50 rows=20 width=40) (actual time=0.064..2.167 rows=172 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
54. 1.792 1.792 ↓ 8.0 191 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx21 on notifications_summary_weekly_partitioned_2019_w26 ns_21 (cost=0.56..19.23 rows=24 width=40) (actual time=0.074..1.792 rows=191 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
55. 0.579 0.579 ↓ 7.2 130 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx22 on notifications_summary_weekly_partitioned_2019_w27 ns_22 (cost=0.56..15.14 rows=18 width=40) (actual time=0.067..0.579 rows=130 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
56. 0.514 0.514 ↓ 5.2 93 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx23 on notifications_summary_weekly_partitioned_2019_w28 ns_23 (cost=0.56..15.30 rows=18 width=40) (actual time=0.039..0.514 rows=93 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
57. 0.560 0.560 ↓ 7.7 154 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx24 on notifications_summary_weekly_partitioned_2019_w29 ns_24 (cost=0.56..16.50 rows=20 width=40) (actual time=0.043..0.560 rows=154 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
58. 0.571 0.571 ↓ 8.7 174 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx25 on notifications_summary_weekly_partitioned_2019_w30 ns_25 (cost=0.56..16.51 rows=20 width=40) (actual time=0.038..0.571 rows=174 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
59. 0.520 0.520 ↓ 7.9 135 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx26 on notifications_summary_weekly_partitioned_2019_w31 ns_26 (cost=0.56..14.46 rows=17 width=40) (actual time=0.035..0.520 rows=135 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
60. 0.514 0.514 ↓ 7.9 134 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx27 on notifications_summary_weekly_partitioned_2019_w32 ns_27 (cost=0.56..14.79 rows=17 width=40) (actual time=0.056..0.514 rows=134 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
61. 0.286 0.286 ↓ 7.9 71 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx28 on notifications_summary_weekly_partitioned_2019_w33 ns_28 (cost=0.56..9.05 rows=9 width=40) (actual time=0.038..0.286 rows=71 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
62. 0.053 0.053 ↓ 7.0 7 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx29 on notifications_summary_weekly_partitioned_2019_w34 ns_29 (cost=0.56..3.58 rows=1 width=40) (actual time=0.029..0.053 rows=7 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
63. 0.538 0.538 ↓ 8.9 124 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx30 on notifications_summary_weekly_partitioned_2019_w35 ns_30 (cost=0.56..12.60 rows=14 width=40) (actual time=0.034..0.538 rows=124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
64. 39.968 39.968 ↓ 22.3 3,719 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx31 on notifications_summary_weekly_partitioned_2019_w36 ns_31 (cost=0.56..121.60 rows=167 width=40) (actual time=1.249..39.968 rows=3,719 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
65. 94.301 94.301 ↓ 23.0 13,046 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx32 on notifications_summary_weekly_partitioned_2019_w37 ns_32 (cost=0.56..405.97 rows=566 width=40) (actual time=0.096..94.301 rows=13,046 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
66. 92.118 92.118 ↓ 21.8 19,586 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx33 on notifications_summary_weekly_partitioned_2019_w38 ns_33 (cost=0.56..648.32 rows=899 width=40) (actual time=2.203..92.118 rows=19,586 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
67. 25.135 25.135 ↓ 28.9 18,124 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx34 on notifications_summary_weekly_partitioned_2019_w39 ns_34 (cost=0.56..467.48 rows=628 width=40) (actual time=0.033..25.135 rows=18,124 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
68. 45,179.795 45,179.795 ↓ 18.7 20,518 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx35 on notifications_summary_weekly_partitioned_2019_w40 ns_35 (cost=0.56..1,682.71 rows=1,098 width=40) (actual time=0.042..45,179.795 rows=20,518 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
69. 41.884 41.884 ↓ 16.6 20,179 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx36 on notifications_summary_weekly_partitioned_2019_w41 ns_36 (cost=0.56..1,861.08 rows=1,215 width=40) (actual time=0.062..41.884 rows=20,179 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
70. 25.849 25.849 ↓ 21.8 16,893 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx37 on notifications_summary_weekly_partitioned_2019_w42 ns_37 (cost=0.56..1,181.79 rows=776 width=40) (actual time=0.033..25.849 rows=16,893 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
71. 49.889 49.889 ↓ 23.1 13,460 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx38 on notifications_summary_weekly_partitioned_2019_w43 ns_38 (cost=0.56..900.96 rows=583 width=40) (actual time=0.053..49.889 rows=13,460 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
72. 56.541 56.541 ↓ 19.1 15,138 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx39 on notifications_summary_weekly_partitioned_2019_w44 ns_39 (cost=0.56..1,226.18 rows=793 width=40) (actual time=0.048..56.541 rows=15,138 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
73. 53.188 53.188 ↓ 18.3 14,546 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx40 on notifications_summary_weekly_partitioned_2019_w45 ns_40 (cost=0.56..1,230.22 rows=797 width=40) (actual time=0.045..53.188 rows=14,546 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
74. 76.002 76.002 ↓ 12.5 21,011 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx41 on notifications_summary_weekly_partitioned_2019_w46 ns_41 (cost=0.56..2,598.52 rows=1,682 width=40) (actual time=0.045..76.002 rows=21,011 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
75. 63.944 63.944 ↓ 15.7 18,444 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx42 on notifications_summary_weekly_partitioned_2019_w47 ns_42 (cost=0.56..1,820.75 rows=1,178 width=40) (actual time=0.050..63.944 rows=18,444 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
76. 48.660 48.660 ↓ 25.0 14,823 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx43 on notifications_summary_weekly_partitioned_2019_w48 ns_43 (cost=0.56..921.95 rows=594 width=40) (actual time=0.039..48.660 rows=14,823 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
77. 65.681 65.681 ↓ 17.2 18,848 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx44 on notifications_summary_weekly_partitioned_2019_w49 ns_44 (cost=0.56..1,654.83 rows=1,094 width=40) (actual time=0.045..65.681 rows=18,848 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
78. 62.080 62.080 ↓ 16.1 16,739 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx45 on notifications_summary_weekly_partitioned_2019_w50 ns_45 (cost=0.56..1,605.78 rows=1,038 width=40) (actual time=0.043..62.080 rows=16,739 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
79. 62.033 62.033 ↓ 19.1 15,487 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx46 on notifications_summary_weekly_partitioned_2019_w51 ns_46 (cost=0.56..1,246.52 rows=811 width=40) (actual time=0.085..62.033 rows=15,487 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
80. 47.859 47.859 ↓ 17.7 13,481 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx47 on notifications_summary_weekly_partitioned_2019_w52 ns_47 (cost=0.56..1,172.85 rows=761 width=40) (actual time=0.052..47.859 rows=13,481 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
81. 28.938 28.938 ↓ 13.0 16,341 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx49 on notifications_summary_weekly_partitioned_2020_w1 ns_48 (cost=0.56..1,933.79 rows=1,253 width=40) (actual time=0.047..28.938 rows=16,341 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
82. 10.935 10.935 ↓ 15.3 6,558 1

Index Scan using notifications_summary_weekly_organization_uuid_recipient__idx50 on notifications_summary_weekly_partitioned_2020_w2 ns_49 (cost=0.56..663.24 rows=430 width=40) (actual time=0.044..10.935 rows=6,558 loops=1)

  • Index Cond: ((organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid) AND (recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
83. 0.011 0.011 ↓ 0.0 0 1

Index Scan using notifications_summary_weekly_pa_organization_uuid_ntfn_id_idx53 on notifications_summary_weekly_part_default ns_50 (cost=0.14..3.17 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid)
  • Filter: ((recipient_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid) AND (created_date <= CURRENT_TIMESTAMP))
84. 602.586 602.586 ↑ 1.0 1 301,293

Index Scan using persons_org_part_67_l2_t_org_seq_vrange_uidx on persons_org_part_67_l2_t p (cost=0.29..0.31 rows=1 width=38) (actual time=0.002..0.002 rows=1 loops=301,293)

  • Index Cond: (person_uuid = e_2.submitter_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
85. 0.109 100,080.106 ↑ 1.0 100 1

Hash Right Join (cost=128.40..201.43 rows=100 width=620) (actual time=100,079.896..100,080.106 rows=100 loops=1)

  • Hash Cond: (m.event_uuid = e.event_uuid)
86. 0.020 165.187 ↓ 11.1 100 1

Subquery Scan on m (cost=125.15..198.11 rows=9 width=71) (actual time=165.058..165.187 rows=100 loops=1)

  • Filter: (m.row_number = 1)
87. 0.164 165.167 ↑ 18.2 100 1

WindowAgg (cost=125.15..175.31 rows=1,824 width=102) (actual time=165.055..165.167 rows=100 loops=1)

88. 0.402 165.003 ↑ 18.2 100 1

Sort (cost=125.15..129.71 rows=1,824 width=78) (actual time=164.986..165.003 rows=100 loops=1)

  • Sort Key: msg.event_uuid, (CASE msg.language WHEN persons_org_part_67_l2_t.language THEN 1 WHEN 'en'::text THEN 2 ELSE 3 END), msg.language
  • Sort Method: quicksort Memory: 39kB
89. 0.445 164.601 ↑ 18.2 100 1

Hash Left Join (cost=3.75..26.35 rows=1,824 width=78) (actual time=7.994..164.601 rows=100 loops=1)

  • Hash Cond: ((msg.language)::text = (persons_org_part_67_l2_t.language)::text)
90. 0.296 164.115 ↑ 18.2 100 1

Nested Loop (cost=0.43..6.98 rows=1,824 width=74) (actual time=7.911..164.115 rows=100 loops=1)

91. 0.219 0.219 ↓ 100.0 100 1

CTE Scan on filtered_events e_1 (cost=0.00..2.00 rows=1 width=16) (actual time=0.002..0.219 rows=100 loops=1)

  • Filter: (system_event_type IS NULL)
92. 163.600 163.600 ↑ 1.0 1 100

Index Scan using messages_org_part_12_event_uuid_idx on messages_org_part_12 msg (cost=0.43..4.97 rows=1 width=74) (actual time=1.634..1.636 rows=1 loops=100)

  • Index Cond: (event_uuid = e_1.event_uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
93. 0.006 0.041 ↑ 1.0 1 1

Hash (cost=3.31..3.31 rows=1 width=3) (actual time=0.041..0.041 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
94. 0.035 0.035 ↑ 1.0 1 1

Index Scan using persons_org_part_67_l2_t_org_seq_vrange_uidx on persons_org_part_67_l2_t (cost=0.29..3.31 rows=1 width=3) (actual time=0.034..0.035 rows=1 loops=1)

  • Index Cond: (person_uuid = '8f331ad1-fe92-419e-af03-f510fd115160'::uuid)
  • Filter: ((is_visible IS TRUE) AND upper_inf(valid_range) AND (organization_uuid = 'db95abb9-1b04-494f-81c2-be2ac21236bd'::uuid))
95. 0.075 99,914.810 ↑ 1.0 100 1

Hash (cost=2.00..2.00 rows=100 width=588) (actual time=99,914.810..99,914.810 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
96. 99,914.735 99,914.735 ↑ 1.0 100 1

CTE Scan on filtered_events e (cost=0.00..2.00 rows=100 width=588) (actual time=99,914.455..99,914.735 rows=100 loops=1)

Planning time : 4,620.326 ms
Execution time : 100,213.757 ms