kobotoolbox / kpi / 16889169611

81%

master: 76%

push

github

fix(auditLogs): use fast pagination (#6069)

### 📣 Summary
Speed up the audit log endpoints.

### 💭 Notes
Use FastPagination on the audit log endpoints to avoid having to do a
select distinct on a large number of fields on a large table.

### 👀 Preview steps
Run the server with --print-sql.

1. Go to `/api/v2/audit-logs/?q=log_type:asset-management&format=json`
2. 🔴 [on main] Notice there is a query in the logs for `SELECT COUNT(*)
from (SELECT DISTINCT <lots of fields> from audit_log_auditlog...)`
3. 🟢 [on PR] Notice the query is now `SELECT COUNT(*) from (SELECT
DISTINCT id FROM audit_log_auditlog...)`

6181 of 9770 branches covered (63.27%)

6 of 6 new or added lines in 3 files covered. (100.0%)

23361 of 28847 relevant lines covered (80.98%)

0.81 hits per line