41444945534
94%

Ran 02 Nov 2026 12:31PM UTC

Jobs 1

Files 86

Run time 1min

Badge

Embed ▾

Committed 02 Nov 2026 12:28PM UTC coverage: 93.538% (+0.007%) from 93.531%

Build # 41444945534

Build Type

push

github

Committed by

web-flow

Commit Message

Speed up the query for Safes with executable pending transactions (#330)

The old filter ran a NOT EXISTS for every pending row and walked all rows
of the Safe with a higher nonce, so a Safe with K pending rows cost
O(K^2). With Safes that have tens of thousands of pending rows, the first
page of list_safes_with_pending did not finish in 30 s.

A Safe has an executable pending transaction when its highest pending
nonce is above its highest executed nonce. Each side is one backward read
of an existing (safe_id, chain_id, nonce) index. has_pending and
list_safes_with_pending share this condition.

Part of PLA-2225, follow-up of #325.

Coverage Stats

3474 of 3714 relevant lines covered (93.54%)

0.94 hits per line

Coverage Regressions

Lines	Coverage	∆	File
7	96.35	0.08%	app/datasources/db/repositories/multisig_transaction_repository.py

Jobs

ID	Job ID	Ran	Files	Coverage
1	41444945534.1	02 Nov 2026 12:31PM UTC	86	93.54	GitHub Action Run

safe-global / safe-queue-service / 41444945534
94%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 41444945534

safe-global / safe-queue-service / 41444945534 94%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Coverage Regressions

Jobs

Source Files on build 41444945534

safe-global / safe-queue-service / 41444945534
94%

README BADGES
x