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

LAST BUILD BRANCH: main
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.3%. Remained the same
16320492644

push

github

Uxio0 
Optimize get blocks not confirmed sorted query

- There made no sense to add `processed` to the index, as it's always `False`
- By adding number to the index sorting is already done

```
staging_transaction_service=> EXPLAIN ANALYZE SELECT history_ethereumblock.number, history_ethereumblock.gas_limit, history_ethereumblock.gas_used, history_ethereumblock.timestamp, history_ethereumblock.block_hash, history_ethereumblock.parent_hash, history_ethereumblock.confirmed
FROM history_ethereumblock
WHERE NOT history_ethereumblock.confirmed
ORDER BY history_ethereumblock.number ASC
LIMIT 10;
                                                                              QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=1750.05..1750.07 rows=10 width=90) (actual time=5.244..5.246 rows=10 loops=1)
   ->  Sort  (cost=1750.05..1751.08 rows=413 width=90) (actual time=5.243..5.244 rows=10 loops=1)
         Sort Key: number
         Sort Method: top-N heapsort  Memory: 26kB
         ->  Index Scan using history_block_confirmed_idx on history_ethereumblock  (cost=0.27..1741.12 rows=413 width=90) (actual time=5.084..5.221 rows=89 loops=1)
 Planning Time: 0.334 ms
 Execution Time: 5.304 ms
(7 rows)

staging_transaction_service=> CREATE INDEX test on history_ethereumblock(number) WHERE confirmed = False;
CREATE INDEX
staging_transaction_service=> EXPLAIN ANALYZE SELECT history_ethereumblock.number, history_ethereumblock.gas_limit, history_ethereumblock.gas_used, history_ethereumblock.timestamp, history_ethereumblock.block_hash, history_ethereumblock.parent_hash, history_ethereumblock.confirmed
FROM history_ethereumblock
WHERE NOT history_ethereumblock.confirmed
ORDER BY history_ethereumblock.number ASC
LIMIT 10;
                                                              QUERY PLAN
--------------------------------------------------... (continued)

15833 of 16790 relevant lines covered (94.3%)

0.94 hits per line

Jobs
ID Job ID Ran Files Coverage
1 16320492644.1 210
94.3
 GitHub Action Run
Source Files on build 16320492644