safe-global / safe-transaction-service / 17268253036
91%
master: 100%

LAST BUILD BRANCH: v5.41.0
DEFAULT BRANCH: master
Ran
Jobs 1
Files 210
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
coverage: 94.52%. Remained the same
17268253036

push

github

Uxio0 
Optimize get pending Safes query

- `DISTINCT` is way faster compared to `DISTINCT ON`

Old query:
```
EXPLAIN ANALYZE SELECT DISTINCT ON ( history_internaltx._from ) history_internaltx._from FROM history_internaltxdecoded INNER JOIN history_internaltx ON ( history_internaltxdecoded.internal_tx_id = history_internaltx.id ) WHERE NOT history_internaltxdecoded.processed;

----------
QUERY PLAN

----------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------
 Unique  (cost=27762085.14..34014641.74 rows=82268 width=21) (actual time=1084398.509..1121931.248 rows=6834483 loops=1)
   ->  Gather Merge  (cost=27762085.14..33886761.53 rows=51152084 width=21) (actual time=1084398.508..1117371.946 rows=50270217 loops=1)
         Workers Planned: 4
         Workers Launched: 4
         ->  Sort  (cost=27761085.09..27793055.14 rows=12788021 width=21) (actual time=1084269.502..1090759.046 rows=10054043 loops=5)
               Sort Key: history_internaltx._from
               Sort Method: external merge  Disk: 243336kB
               Worker 0:  Sort Method: external merge  Disk: 252608kB
               Worker 1:  Sort Method: external merge  Disk: 249808kB
               Worker 2:  Sort Method: external merge  Disk: 245864kB
               Worker 3:  Sort Method: external merge  Disk: 238176kB
               ->  Parallel Hash Join  (cost=1997271.69..26086722.56 rows=12788021 width=21) (actual time=814933.040..1077620.142 rows=10054043 loops=5)
                     Hash Cond: (history_internaltx.id = history_internaltxdecoded.internal_tx_id)
                     ->  Parallel Seq Scan on history_internaltx  (cost=0.00..20259409.94 rows=231951594 width=29) (actual time=3.050..445352.402 rows=185560877 loops
=5)
                     ->  Parallel Hash  (cost=1787467.43..1787467.43 rows=12788021 width=8) (actual tim... (continued)

16350 of 17298 relevant lines covered (94.52%)

0.95 hits per line

Jobs
ID Job ID Ran Files Coverage
1 17268253036.1 210
94.52
 GitHub Action Run
Source Files on build 17268253036