explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g41w

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 1.428 ↑ 19.2 26 1

Append (cost=2.06..838.58 rows=500 width=186) (actual time=1.199..1.428 rows=26 loops=1)

2. 0.007 0.057 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2018 (cost=2.06..28.96 rows=18 width=177) (actual time=0.057..0.057 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
3. 0.050 0.050 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2018_event_uuid_idx (cost=0.00..2.06 rows=18 width=0) (actual time=0.050..0.050 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
4. 0.000 0.026 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w1 (cost=2.00..18.25 rows=11 width=177) (actual time=0.026..0.026 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
5. 0.026 0.026 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w1_event_uuid_idx (cost=0.00..2.00 rows=11 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
6. 0.001 0.035 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w2 (cost=2.01..19.75 rows=12 width=177) (actual time=0.035..0.035 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
7. 0.034 0.034 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w2_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
8. 0.001 0.029 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w3 (cost=2.01..19.75 rows=12 width=177) (actual time=0.029..0.029 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
9. 0.028 0.028 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w3_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
10. 0.001 0.033 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w4 (cost=2.03..22.68 rows=14 width=177) (actual time=0.033..0.033 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
11. 0.032 0.032 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w4_event_uuid_idx (cost=0.00..2.02 rows=14 width=0) (actual time=0.032..0.032 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
12. 0.004 0.033 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w5 (cost=2.01..19.74 rows=12 width=177) (actual time=0.033..0.033 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
13. 0.029 0.029 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w5_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
14. 0.001 0.032 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w6 (cost=1.99..16.79 rows=10 width=177) (actual time=0.032..0.032 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
15. 0.031 0.031 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w6_event_uuid_idx (cost=0.00..1.99 rows=10 width=0) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
16. 0.003 0.029 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w7 (cost=2.01..19.76 rows=12 width=177) (actual time=0.029..0.029 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
17. 0.026 0.026 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w7_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
18. 0.001 0.026 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w8 (cost=2.03..24.21 rows=15 width=177) (actual time=0.026..0.026 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
19. 0.025 0.025 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w8_event_uuid_idx (cost=0.00..2.03 rows=15 width=0) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
20. 0.000 0.030 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w9 (cost=2.03..22.71 rows=14 width=177) (actual time=0.030..0.030 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
21. 0.030 0.030 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w9_event_uuid_idx (cost=0.00..2.02 rows=14 width=0) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
22. 0.001 0.026 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w10 (cost=2.02..21.24 rows=13 width=177) (actual time=0.026..0.026 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
23. 0.025 0.025 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w10_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
24. 0.000 0.028 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w11 (cost=2.02..21.21 rows=13 width=177) (actual time=0.028..0.028 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
25. 0.028 0.028 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w11_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
26. 0.003 0.032 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w12 (cost=2.01..19.72 rows=12 width=177) (actual time=0.032..0.032 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
27. 0.029 0.029 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w12_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
28. 0.000 0.038 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w13 (cost=2.03..22.70 rows=14 width=177) (actual time=0.038..0.038 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
29. 0.038 0.038 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w13_event_uuid_idx (cost=0.00..2.02 rows=14 width=0) (actual time=0.038..0.038 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
30. 0.001 0.030 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w14 (cost=2.02..21.24 rows=13 width=177) (actual time=0.030..0.030 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
31. 0.029 0.029 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w14_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
32. 0.000 0.025 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w15 (cost=2.02..21.24 rows=13 width=177) (actual time=0.025..0.025 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
33. 0.025 0.025 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w15_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
34. 0.000 0.026 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w16 (cost=2.02..21.24 rows=13 width=177) (actual time=0.026..0.026 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
35. 0.026 0.026 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w16_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
36. 0.003 0.031 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w17 (cost=2.01..19.73 rows=12 width=177) (actual time=0.031..0.031 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
37. 0.028 0.028 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w17_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
38. 0.001 0.023 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w18 (cost=2.01..19.74 rows=12 width=177) (actual time=0.023..0.023 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
39. 0.022 0.022 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w18_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
40. 0.003 0.029 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w19 (cost=2.02..21.24 rows=13 width=177) (actual time=0.029..0.029 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
41. 0.026 0.026 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w19_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
42. 0.001 0.021 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w20 (cost=2.02..21.24 rows=13 width=177) (actual time=0.021..0.021 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
43. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w20_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
44. 0.001 0.025 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w21 (cost=2.02..21.23 rows=13 width=177) (actual time=0.025..0.025 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
45. 0.024 0.024 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w21_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
46. 0.000 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w22 (cost=2.01..19.74 rows=12 width=177) (actual time=0.027..0.027 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
47. 0.027 0.027 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w22_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
48. 0.001 0.031 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w23 (cost=2.02..21.24 rows=13 width=177) (actual time=0.031..0.031 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
49. 0.030 0.030 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w23_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
50. 0.003 0.028 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w24 (cost=2.02..21.26 rows=13 width=177) (actual time=0.028..0.028 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
51. 0.025 0.025 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w24_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
52. 0.000 0.022 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w25 (cost=2.02..21.26 rows=13 width=177) (actual time=0.022..0.022 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
53. 0.022 0.022 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w25_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
54. 0.003 0.031 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w26 (cost=2.05..27.28 rows=17 width=177) (actual time=0.031..0.031 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
55. 0.028 0.028 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w26_event_uuid_idx (cost=0.00..2.05 rows=17 width=0) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
56. 0.001 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w27 (cost=2.01..19.77 rows=12 width=177) (actual time=0.027..0.027 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
57. 0.026 0.026 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w27_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
58. 0.000 0.025 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w28 (cost=2.02..21.17 rows=13 width=177) (actual time=0.025..0.025 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
59. 0.025 0.025 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w28_event_uuid_idx (cost=0.00..2.01 rows=13 width=0) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
60. 0.000 0.041 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w29 (cost=2.01..19.65 rows=12 width=177) (actual time=0.041..0.041 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
61. 0.041 0.041 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w29_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.041..0.041 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
62. 0.001 0.034 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w30 (cost=2.01..19.74 rows=12 width=178) (actual time=0.034..0.034 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
63. 0.033 0.033 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w30_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
64. 0.003 0.021 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w31 (cost=1.86..15.06 rows=9 width=177) (actual time=0.021..0.021 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
65. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w31_event_uuid_idx (cost=0.00..1.86 rows=9 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
66. 0.001 0.039 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w32 (cost=2.01..19.80 rows=12 width=177) (actual time=0.039..0.039 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
67. 0.038 0.038 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w32_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.038..0.038 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
68. 0.003 0.024 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w33 (cost=1.98..15.24 rows=9 width=186) (actual time=0.024..0.024 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
69. 0.021 0.021 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w33_event_uuid_idx (cost=0.00..1.98 rows=9 width=0) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
70. 0.001 0.028 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w34 (cost=2.01..19.78 rows=12 width=187) (actual time=0.028..0.028 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
71. 0.027 0.027 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w34_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
72. 0.000 0.033 ↓ 0.0 0 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w35 (cost=2.04..24.25 rows=15 width=187) (actual time=0.033..0.033 rows=0 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
73. 0.033 0.033 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w35_event_uuid_idx (cost=0.00..2.03 rows=15 width=0) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
74. 0.106 0.173 ↑ 1.0 26 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w36 (cost=1.99..35.79 rows=26 width=188) (actual time=0.115..0.173 rows=26 loops=1)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Heap Blocks: exact=7
75. 0.067 0.067 ↓ 2.1 55 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w36_event_uuid_idx (cost=0.00..1.98 rows=26 width=0) (actual time=0.067..0.067 rows=55 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
76. 0.015 0.015 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w37_pkey on notifications_summary_org_part_23_wl2_2019_w37 (cost=0.14..3.17 rows=1 width=390) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
77. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w38_pkey on notifications_summary_org_part_23_wl2_2019_w38 (cost=0.14..3.17 rows=1 width=390) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
78. 0.015 0.015 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w39_pkey on notifications_summary_org_part_23_wl2_2019_w39 (cost=0.14..3.17 rows=1 width=390) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
79. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w40_pkey on notifications_summary_org_part_23_wl2_2019_w40 (cost=0.14..3.17 rows=1 width=390) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
80. 0.009 0.009 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w41_pkey on notifications_summary_org_part_23_wl2_2019_w41 (cost=0.14..3.17 rows=1 width=390) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
81. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w42_pkey on notifications_summary_org_part_23_wl2_2019_w42 (cost=0.14..3.17 rows=1 width=390) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
82. 0.010 0.010 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w43_pkey on notifications_summary_org_part_23_wl2_2019_w43 (cost=0.14..3.17 rows=1 width=390) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
83. 0.011 0.011 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w44_pkey on notifications_summary_org_part_23_wl2_2019_w44 (cost=0.14..3.17 rows=1 width=390) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
84. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w45_pkey on notifications_summary_org_part_23_wl2_2019_w45 (cost=0.14..3.17 rows=1 width=390) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
85. 0.010 0.010 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w46_pkey on notifications_summary_org_part_23_wl2_2019_w46 (cost=0.14..3.17 rows=1 width=390) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
86. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w47_pkey on notifications_summary_org_part_23_wl2_2019_w47 (cost=0.14..3.17 rows=1 width=390) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
87. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w48_pkey on notifications_summary_org_part_23_wl2_2019_w48 (cost=0.14..3.17 rows=1 width=390) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
88. 0.022 0.022 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w49_pkey on notifications_summary_org_part_23_wl2_2019_w49 (cost=0.14..3.17 rows=1 width=390) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
89. 0.010 0.010 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w50_pkey on notifications_summary_org_part_23_wl2_2019_w50 (cost=0.14..3.17 rows=1 width=390) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
90. 0.007 0.007 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w51_pkey on notifications_summary_org_part_23_wl2_2019_w51 (cost=0.14..3.17 rows=1 width=390) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
91. 0.008 0.008 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w52_pkey on notifications_summary_org_part_23_wl2_2019_w52 (cost=0.14..3.17 rows=1 width=390) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid)
  • Filter: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
Planning time : 31,022.882 ms
Execution time : 4.159 ms