poanetwork/blockscout

In explorer it's just a problem with opening address of RandomAura. It takes too long and then crashes explorer.
Execution time which I sen is from here:
explorer=> EXPLAIN ANALYZE VERBOSE SELECT a0."block_number", a0."value", a0."value_fetched_at", a0."inserted_at", a0."updated_at", a0."address_hash", value - coalesce(lag(value, 1) over (order by block_number),
0), b1."timestamp" FROM "address_coin_balances" AS a0 INNER JOIN "blocks" AS b1 ON a0."block_number" = b1."number" WHERE (a0."address_hash" = '\x3000000000000000000000000000000000000001' ) AND (NOT (a0."value" I
S NULL)

                                                                                               QUERY PLAN                                                                                                    

Sort (cost=1094309.05..1097928.31 rows=1447704 width=108) (actual time=8734.868..9027.944 rows=1431434 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash, ((a0.value - COALESCE(lag(a0.value, 1) OVER (?), '0'::numeric))), b1."timestamp", a0.block_number
Sort Key: a0.block_number DESC
Sort Method: external merge Disk: 126144kB
-> WindowAgg (cost=748971.23..777925.31 rows=1447704 width=108) (actual time=6402.329..7762.118 rows=1431434 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash, (a0.value - COALESCE(lag(a0.value, 1) OVER (?), '0'::numeric)), b1."timestamp", a0.block_number
-> Sort (cost=748971.23..752590.49 rows=1447704 width=68) (actual time=6402.318..6742.283 rows=1431434 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash, b1."timestamp"
Sort Key: a0.block_number
Sort Method: external merge Disk: 114944kB
-> Hash Join (cost=229070.87..482070.49 rows=1447704 width=68) (actual time=1672.574..5367.562 rows=1431434 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash, b1."timestamp"
Inner Unique: true
Hash Cond: (b1.number = a0.block_number)
-> Seq Scan on public.blocks b1 (cost=0.00..182764.97 rows=4413197 width=16) (actual time=0.098..1199.297 rows=4382999 loops=1)
Output: b1."timestamp", b1.number
-> Hash (cost=195422.57..195422.57 rows=1447704 width=60) (actual time=1671.555..1671.555 rows=1431416 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash
Buckets: 65536 Batches: 64 Memory Usage: 2554kB
-> Bitmap Heap Scan on public.address_coin_balances a0 (cost=73068.27..195422.57 rows=1447704 width=60) (actual time=277.800..1118.153 rows=1431416 loops=1)
Output: a0.block_number, a0.value, a0.value_fetched_at, a0.inserted_at, a0.updated_at, a0.address_hash
Recheck Cond: (a0.address_hash = '\x3000000000000000000000000000000000000001'::bytea)
Rows Removed by Index Recheck: 2073383
Filter: (a0.value IS NOT NULL)
Rows Removed by Filter: 45
Heap Blocks: exact=51290 lossy=33105
-> Bitmap Index Scan on address_coin_balances_address_hash_block_number_index (cost=0.00..72706.34 rows=1447704 width=0) (actual time=257.494..257.494 rows=1444287 loops=1)
Index Cond: (a0.address_hash = '\x3000000000000000000000000000000000000001'::bytea)
Planning time: 0.253 ms
Execut