explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WOuR

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.430 ↓ 0.0 0 1

Update on notifications_summary (cost=0.42..191.74 rows=54 width=357) (actual time=0.430..0.430 rows=0 loops=1)

  • Update on notifications_summary_org_part_101_wl2_2018
  • Update on notifications_summary_org_part_101_wl2_2019_w1
  • Update on notifications_summary_org_part_101_wl2_2019_w2
  • Update on notifications_summary_org_part_101_wl2_2019_w3
  • Update on notifications_summary_org_part_101_wl2_2019_w4
  • Update on notifications_summary_org_part_101_wl2_2019_w5
  • Update on notifications_summary_org_part_101_wl2_2019_w6
  • Update on notifications_summary_org_part_101_wl2_2019_w7
  • Update on notifications_summary_org_part_101_wl2_2019_w8
  • Update on notifications_summary_org_part_101_wl2_2019_w9
  • Update on notifications_summary_org_part_101_wl2_2019_w10
  • Update on notifications_summary_org_part_101_wl2_2019_w11
  • Update on notifications_summary_org_part_101_wl2_2019_w12
  • Update on notifications_summary_org_part_101_wl2_2019_w13
  • Update on notifications_summary_org_part_101_wl2_2019_w14
  • Update on notifications_summary_org_part_101_wl2_2019_w15
  • Update on notifications_summary_org_part_101_wl2_2019_w16
  • Update on notifications_summary_org_part_101_wl2_2019_w17
  • Update on notifications_summary_org_part_101_wl2_2019_w18
  • Update on notifications_summary_org_part_101_wl2_2019_w19
  • Update on notifications_summary_org_part_101_wl2_2019_w20
  • Update on notifications_summary_org_part_101_wl2_2019_w21
  • Update on notifications_summary_org_part_101_wl2_2019_w22
  • Update on notifications_summary_org_part_101_wl2_2019_w23
  • Update on notifications_summary_org_part_101_wl2_2019_w24
  • Update on notifications_summary_org_part_101_wl2_2019_w25
  • Update on notifications_summary_org_part_101_wl2_2019_w26
  • Update on notifications_summary_org_part_101_wl2_2019_w27
  • Update on notifications_summary_org_part_101_wl2_2019_w28
  • Update on notifications_summary_org_part_101_wl2_2019_w29
  • Update on notifications_summary_org_part_101_wl2_2019_w30
  • Update on notifications_summary_org_part_101_wl2_2019_w31
  • Update on notifications_summary_org_part_101_wl2_2019_w32
  • Update on notifications_summary_org_part_101_wl2_2019_w33
  • Update on notifications_summary_org_part_101_wl2_2019_w34
  • Update on notifications_summary_org_part_101_wl2_2019_w35
  • Update on notifications_summary_org_part_101_wl2_2019_w36
  • Update on notifications_summary_org_part_101_wl2_2019_w37
  • Update on notifications_summary_org_part_101_wl2_2019_w38
  • Update on notifications_summary_org_part_101_wl2_2019_w39
  • Update on notifications_summary_org_part_101_wl2_2019_w40
  • Update on notifications_summary_org_part_101_wl2_2019_w41
  • Update on notifications_summary_org_part_101_wl2_2019_w42
  • Update on notifications_summary_org_part_101_wl2_2019_w43
  • Update on notifications_summary_org_part_101_wl2_2019_w44
  • Update on notifications_summary_org_part_101_wl2_2019_w45
  • Update on notifications_summary_org_part_101_wl2_2019_w46
  • Update on notifications_summary_org_part_101_wl2_2019_w47
  • Update on notifications_summary_org_part_101_wl2_2019_w48
  • Update on notifications_summary_org_part_101_wl2_2019_w49
  • Update on notifications_summary_org_part_101_wl2_2019_w50
  • Update on notifications_summary_org_part_101_wl2_2019_w51
  • Update on notifications_summary_org_part_101_wl2_2019_w52
  • Update on notifications_summary_org_part_default
2. 0.020 0.020 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2018_created_date_idx on notifications_summary_org_part_101_wl2_2018 (cost=0.42..4.07 rows=1 width=339) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
3. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w1_created_date_idx on notifications_summary_org_part_101_wl2_2019_w1 (cost=0.29..3.44 rows=1 width=339) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
4. 0.037 0.037 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w2_created_date_idx on notifications_summary_org_part_101_wl2_2019_w2 (cost=0.42..6.24 rows=1 width=339) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
5. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w3_created_date_idx on notifications_summary_org_part_101_wl2_2019_w3 (cost=0.29..3.35 rows=1 width=339) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
6. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w4_created_date_idx on notifications_summary_org_part_101_wl2_2019_w4 (cost=0.42..3.47 rows=1 width=339) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
7. 0.010 0.010 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w5_created_date_idx on notifications_summary_org_part_101_wl2_2019_w5 (cost=0.42..3.47 rows=1 width=339) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
8. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w6_created_date_idx on notifications_summary_org_part_101_wl2_2019_w6 (cost=0.42..3.47 rows=1 width=339) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
9. 0.010 0.010 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w7_created_date_idx on notifications_summary_org_part_101_wl2_2019_w7 (cost=0.42..3.47 rows=1 width=339) (actual time=0.009..0.010 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
10. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w8_created_date_idx on notifications_summary_org_part_101_wl2_2019_w8 (cost=0.42..3.47 rows=1 width=339) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
11. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w9_created_date_idx on notifications_summary_org_part_101_wl2_2019_w9 (cost=0.29..3.35 rows=1 width=339) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
12. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w_created_date_idx1 on notifications_summary_org_part_101_wl2_2019_w10 (cost=0.29..3.35 rows=1 width=339) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
13. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w_created_date_idx2 on notifications_summary_org_part_101_wl2_2019_w11 (cost=0.42..3.47 rows=1 width=339) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
14. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w_created_date_idx3 on notifications_summary_org_part_101_wl2_2019_w12 (cost=0.42..3.47 rows=1 width=339) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
15. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w_created_date_idx4 on notifications_summary_org_part_101_wl2_2019_w13 (cost=0.42..3.47 rows=1 width=339) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
16. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w_created_date_idx5 on notifications_summary_org_part_101_wl2_2019_w14 (cost=0.29..3.35 rows=1 width=339) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
17. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w_created_date_idx6 on notifications_summary_org_part_101_wl2_2019_w15 (cost=0.42..3.47 rows=1 width=339) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
18. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w_created_date_idx7 on notifications_summary_org_part_101_wl2_2019_w16 (cost=0.29..3.35 rows=1 width=339) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
19. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w_created_date_idx8 on notifications_summary_org_part_101_wl2_2019_w17 (cost=0.29..3.35 rows=1 width=339) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
20. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019_w_created_date_idx9 on notifications_summary_org_part_101_wl2_2019_w18 (cost=0.29..3.35 rows=1 width=339) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
21. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx10 on notifications_summary_org_part_101_wl2_2019_w19 (cost=0.29..3.35 rows=1 width=339) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
22. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx11 on notifications_summary_org_part_101_wl2_2019_w20 (cost=0.29..3.35 rows=1 width=339) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
23. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx12 on notifications_summary_org_part_101_wl2_2019_w21 (cost=0.29..3.35 rows=1 width=339) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
24. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx13 on notifications_summary_org_part_101_wl2_2019_w22 (cost=0.29..3.35 rows=1 width=339) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
25. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx14 on notifications_summary_org_part_101_wl2_2019_w23 (cost=0.42..3.47 rows=1 width=339) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
26. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx15 on notifications_summary_org_part_101_wl2_2019_w24 (cost=0.29..3.35 rows=1 width=339) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
27. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx16 on notifications_summary_org_part_101_wl2_2019_w25 (cost=0.29..3.35 rows=1 width=339) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
28. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx17 on notifications_summary_org_part_101_wl2_2019_w26 (cost=0.29..3.34 rows=1 width=339) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
29. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx18 on notifications_summary_org_part_101_wl2_2019_w27 (cost=0.29..3.35 rows=1 width=339) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
30. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx19 on notifications_summary_org_part_101_wl2_2019_w28 (cost=0.29..3.35 rows=1 width=339) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
31. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx20 on notifications_summary_org_part_101_wl2_2019_w29 (cost=0.29..3.35 rows=1 width=339) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
32. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx21 on notifications_summary_org_part_101_wl2_2019_w30 (cost=0.29..3.35 rows=1 width=339) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
33. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx22 on notifications_summary_org_part_101_wl2_2019_w31 (cost=0.42..3.47 rows=1 width=339) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
34. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx23 on notifications_summary_org_part_101_wl2_2019_w32 (cost=0.42..3.47 rows=1 width=339) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
35. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx24 on notifications_summary_org_part_101_wl2_2019_w33 (cost=0.29..3.33 rows=1 width=347) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
36. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx25 on notifications_summary_org_part_101_wl2_2019_w34 (cost=0.29..3.34 rows=1 width=348) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
37. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx26 on notifications_summary_org_part_101_wl2_2019_w35 (cost=0.29..3.34 rows=1 width=348) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
38. 0.006 0.006 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx27 on notifications_summary_org_part_101_wl2_2019_w36 (cost=0.15..3.20 rows=1 width=396) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
39. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx28 on notifications_summary_org_part_101_wl2_2019_w37 (cost=0.15..3.20 rows=1 width=396) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
40. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx29 on notifications_summary_org_part_101_wl2_2019_w38 (cost=0.15..3.20 rows=1 width=396) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
41. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx30 on notifications_summary_org_part_101_wl2_2019_w39 (cost=0.15..3.20 rows=1 width=396) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
42. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx31 on notifications_summary_org_part_101_wl2_2019_w40 (cost=0.15..3.20 rows=1 width=396) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
43. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx32 on notifications_summary_org_part_101_wl2_2019_w41 (cost=0.15..3.20 rows=1 width=396) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
44. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx33 on notifications_summary_org_part_101_wl2_2019_w42 (cost=0.15..3.20 rows=1 width=396) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
45. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx34 on notifications_summary_org_part_101_wl2_2019_w43 (cost=0.15..3.20 rows=1 width=396) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
46. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx35 on notifications_summary_org_part_101_wl2_2019_w44 (cost=0.15..3.20 rows=1 width=396) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
47. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx36 on notifications_summary_org_part_101_wl2_2019_w45 (cost=0.15..3.20 rows=1 width=396) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
48. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx37 on notifications_summary_org_part_101_wl2_2019_w46 (cost=0.15..3.20 rows=1 width=396) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
49. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx38 on notifications_summary_org_part_101_wl2_2019_w47 (cost=0.15..3.20 rows=1 width=396) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
50. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx39 on notifications_summary_org_part_101_wl2_2019_w48 (cost=0.15..3.20 rows=1 width=396) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
51. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx40 on notifications_summary_org_part_101_wl2_2019_w49 (cost=0.15..3.20 rows=1 width=396) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
52. 0.004 0.004 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx41 on notifications_summary_org_part_101_wl2_2019_w50 (cost=0.15..3.20 rows=1 width=396) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
53. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx42 on notifications_summary_org_part_101_wl2_2019_w51 (cost=0.15..3.20 rows=1 width=396) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
54. 0.003 0.003 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_101_wl2_2019__created_date_idx43 on notifications_summary_org_part_101_wl2_2019_w52 (cost=0.15..3.20 rows=1 width=396) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (created_date = now())
  • Filter: ((organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid) AND (notification_uuid = uuid_generate_v4()))
55. 0.001 0.019 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_default (cost=10.21..11.76 rows=1 width=340) (actual time=0.019..0.019 rows=0 loops=1)

  • Recheck Cond: ((created_date = now()) AND (organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid))
  • Filter: (notification_uuid = uuid_generate_v4())
56. 0.001 0.018 ↓ 0.0 0 1

BitmapAnd (cost=10.21..10.21 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=1)

57. 0.017 0.017 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_default_created_date_idx (cost=0.00..2.08 rows=19 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (created_date = now())
58. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on notifications_summary_org_part_default_ntf_uuid_uidx (cost=0.00..7.88 rows=377 width=0) (never executed)

  • Index Cond: (organization_uuid = '0a44a920-9b88-48b7-acb3-d9b8758dd315'::uuid)
Planning time : 3,915.177 ms
Execution time : 2.929 ms