• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

kobotoolbox / kpi / 41509974545
64%
master: 76%

Build:
Build:
LAST BUILD BRANCH: release/2.026.43
DEFAULT BRANCH: master
Ran 02 Nov 2026 07:31PM UTC
Jobs 10
Files 915
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

02 Nov 2026 07:26PM UTC coverage: 83.236% (+0.02%) from 83.217%
41509974545

push

github

web-flow
perf(projectViews): load project view asset lists faster DEV-3196 (#7801)

### 📣 Summary
Project views load their list of projects much faster, especially views
that cover every country.

### 📖 Description
Opening a project view used to get slower as the number of projects it
covers grew, because the list was counted and sorted in full every time,
and some project details were looked up one project at a time. The list
now comes back in a few steps whatever its size, with the same projects
in the same order. The project view list API no longer returns the total
number of projects (`count`); the `next` link still pages through the
results.

### 👷 Description for instance maintainers
A migration adds two indexes on the projects table: one for the default
sort of project lists, one for the sort by creation date. They are
created concurrently, without locking the table.

If `SKIP_HEAVY_MIGRATIONS` is set, the migration only prints the SQL
below; run it in PostgreSQL directly, otherwise project views stay slow:

```sql
CREATE INDEX CONCURRENTLY IF NOT EXISTS "asset_survey_default_order_idx" ON "kpi_asset" USING btree ((array_position(ARRAY['deployed', 'draft', 'archived']::varchar[], "_deployment_status")), "date_modified" DESC, "id") WHERE ("asset_type" = 'survey' AND NOT "pending_delete");
CREATE INDEX CONCURRENTLY IF NOT EXISTS "asset_date_created_id_idx" ON "kpi_asset" USING btree ("date_created" DESC, "id");
```

10441 of 13753 branches covered (75.92%)

49 of 68 new or added lines in 8 files covered. (72.06%)

694 existing lines in 43 files now uncovered.

33326 of 40038 relevant lines covered (83.24%)

5.51 hits per line

Uncovered Changes

Lines Coverage ∆ File
12
43.7
-1.26% kobo/apps/project_views/views.py
5
58.97
2.76% kobo/apps/organizations/models.py
2
89.47
46.62% kpi/mixins/asset.py

Coverage Regressions

Lines Coverage ∆ File
93
42.11
-48.95% kobo/apps/openrosa/apps/api/viewsets/xform_list_api.py
83
45.68
-9.67% kobo/apps/openrosa/libs/utils/logger_tools.py
63
33.96
-59.43% kobo/apps/openrosa/apps/api/viewsets/briefcase_api.py
56
48.31
-47.46% kobo/apps/openrosa/apps/api/viewsets/xform_submission_api.py
52
57.0
7.0% kpi/utils/xml.py
37
51.22
-45.12% kobo/apps/openrosa/libs/serializers/xform_serializer.py
33
56.67
-36.67% kobo/apps/openrosa/libs/renderers/renderers.py
30
0.0
-75.0% kobo/apps/openrosa/apps/django_digest_backends/cache.py
27
34.0
-54.0% kobo/apps/data_collectors/authentication.py
22
47.87
4.27% kobo/apps/audit_log/models.py
20
43.9
-48.78% kobo/apps/openrosa/libs/filters.py
15
20.0
-60.0% kobo/apps/openrosa/apps/api/utils/xml.py
15
64.76
-7.62% kpi/utils/object_permission.py
14
54.03
1.61% kobo/apps/openrosa/apps/logger/signals.py
12
40.48
-7.14% kobo/apps/openrosa/apps/main/models/meta_data.py
12
52.56
-14.1% kpi/authentication.py
10
78.05
13.59% kobo/apps/openrosa/apps/logger/xform_instance_parser.py
10
55.0
0.0% kobo/apps/openrosa/libs/utils/middleware.py
8
63.57
7.86% kobo/apps/audit_log/signals.py
8
72.04
-2.37% kobo/apps/openrosa/apps/logger/models/xform.py
8
30.12
1.2% kpi/utils/storage.py
7
30.56
-6.48% kobo/apps/openrosa/apps/api/tools.py
6
31.25
-37.5% kobo/apps/openrosa/libs/utils/string.py
5
50.0
-50.0% kobo/apps/openrosa/libs/mixins/openrosa_headers_mixin.py
5
69.57
-21.74% kobo/apps/openrosa/libs/permissions.py
5
40.0
-50.0% kpi/utils/fuzzy_int.py
5
69.76
27.32% kpi/utils/mongo_helper.py
4
75.38
3.59% kobo/apps/openrosa/apps/logger/models/instance.py
4
41.94
-12.9% kobo/apps/openrosa/libs/authentication.py
4
0.0
-100.0% kobo/apps/openrosa/libs/utils/storage.py
3
57.26
-2.42% kobo/apps/openrosa/apps/logger/models/attachment.py
3
60.0
-30.0% kobo/apps/openrosa/libs/serializers/data_serializer.py
3
60.0
-30.0% kpi/mixins/mfa.py
2
66.67
-13.33% kobo/apps/openrosa/apps/viewer/signals.py
2
27.78
-5.56% kobo/apps/openrosa/libs/utils/decorators.py
1
75.0
-25.0% kobo/apps/audit_log/mixins.py
1
92.86
32.14% kobo/apps/audit_log/utils.py
1
83.05
-1.69% kobo/apps/openrosa/apps/logger/exceptions.py
1
46.1
0.37% kobo/apps/openrosa/apps/viewer/models/data_dictionary.py
1
91.54
38.39% kpi/models/asset.py
1
52.97
9.59% kpi/renderers.py
1
75.0
-6.25% kpi/utils/drf_exceptions.py
1
61.71
33.14% kpi/views/v2/asset.py
Jobs
ID Job ID Ran Files Coverage
1 41509974545.1 02 Nov 2026 07:31PM UTC 910
52.83
2 41509974545.2 02 Nov 2026 07:32PM UTC 910
49.86
3 41509974545.3 02 Nov 2026 07:32PM UTC 912
51.11
4 41509974545.4 02 Nov 2026 07:32PM UTC 910
43.71
5 41509974545.5 02 Nov 2026 07:33PM UTC 912
44.99
6 41509974545.6 02 Nov 2026 07:35PM UTC 910
58.44
7 41509974545.7 02 Nov 2026 07:35PM UTC 912
59.52
8 41509974545.8 02 Nov 2026 07:35PM UTC 913
67.76
9 41509974545.9 02 Nov 2026 07:36PM UTC 915
70.18
10 41509974545.10 02 Nov 2026 07:49PM UTC 912
54.06
Source Files on build 41509974545
  • Tree
  • List 915
  • Changed 10
  • Source Changed 0
  • Coverage Changed 10
Coverage ∆ File Lines Relevant Covered Missed Hits/Line Branch Hits Branch Misses
  • Back to Repo
  • 7155f7f5 on github
  • Prev Build on release/2.026.37 (#41489061948)
  • Next Build on release/2.026.37 (#41638193663)
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE TRIAL · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc