Index loan_files.loan_transaction_id on LoanFile

Shipped: October 19, 2026 at 12:47 AM UTC
Author: Kamo
Commit: 00db0af

The deal -> loans lookup **************** deal status, pipeline summary, and the retireIfEmpty check after an application is deleted) was a sequential scan. The index was applied to production by hand on 2026-10-18 (securityservice docs/sql/2026-10-18-loan-files- loan-transaction-id-index.sql) under the same name, so a KamoInitializer ddl-auto run finds it by name instead of building a second one.

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free Forever View Pricing