[PR #2211] [MERGED] perf: add database indexes for insights queries #2125

New issue

Closed

opened 2026-02-26 20:32:32 +03:00 by kerem · 0 comments

kerem commented

2026-02-26 20:32:32 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/documenso/documenso/pull/2211
Author: @ephraimduncan
Created: 11/19/2025
Status: ✅ Merged
Merged: 11/26/2025
Merged by: @Mythie

Base: main ← Head: perf/insights-indexes

📝 Commits (4)

e182d29 perf: add database indexes for insights queries
ccb6ac2 chore: update indexes
2cacd79 Merge branch 'main' into perf/insights-indexes
b598da9 fix: resolve type error

📊 Changes

5 files changed (+204 additions, -165 deletions)

View changed files

📝 apps/remix/app/routes/_authenticated+/admin+/organisation-insights._index.tsx (+1 -1)
📝 packages/lib/server-only/admin/get-organisation-detailed-insights.ts (+87 -118)
📝 packages/lib/server-only/admin/get-signing-volume.ts (+77 -43)
➕ packages/prisma/migrations/20251126053402_add_insights_indexes/migration.sql (+26 -0)
📝 packages/prisma/schema.prisma (+13 -3)

📄 Description

Make Org Insights queries faster

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/documenso/documenso/pull/2211 **Author:** [@ephraimduncan](https://github.com/ephraimduncan) **Created:** 11/19/2025 **Status:** ✅ Merged **Merged:** 11/26/2025 **Merged by:** [@Mythie](https://github.com/Mythie) **Base:** `main` ← **Head:** `perf/insights-indexes` --- ### 📝 Commits (4) - [`e182d29`](https://github.com/documenso/documenso/commit/e182d29f9983d26dae0c09259f9a3847463e88dc) perf: add database indexes for insights queries - [`ccb6ac2`](https://github.com/documenso/documenso/commit/ccb6ac2e3b661338dab7cd04a608e9eee8a7e6fb) chore: update indexes - [`2cacd79`](https://github.com/documenso/documenso/commit/2cacd7959c2bcd131bcd6e0654e667e88debccd9) Merge branch 'main' into perf/insights-indexes - [`b598da9`](https://github.com/documenso/documenso/commit/b598da9098a1f436c0978a072d3e1dea14168617) fix: resolve type error ### 📊 Changes **5 files changed** (+204 additions, -165 deletions) <details> <summary>View changed files</summary> 📝 `apps/remix/app/routes/_authenticated+/admin+/organisation-insights._index.tsx` (+1 -1) 📝 `packages/lib/server-only/admin/get-organisation-detailed-insights.ts` (+87 -118) 📝 `packages/lib/server-only/admin/get-signing-volume.ts` (+77 -43) ➕ `packages/prisma/migrations/20251126053402_add_insights_indexes/migration.sql` (+26 -0) 📝 `packages/prisma/schema.prisma` (+13 -3) </details> ### 📄 Description Make Org Insights queries faster --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

kerem

2026-02-26 20:32:32 +03:00

closed this issue
added the
pull-request
label

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/documenso#2125

No description provided.

Rows
Columns