Useful Queries

List of some queries I've found to be useful.

All encoded storage items under a specific prefix

example uses SystemAccount prefix

-- Query for all storage items under a specific key prefix

SELECT encode(storage::bytea, 'hex'), block_num FROM
    (SELECT storage.key, storage.storage, storage.block_num, blocks.spec FROM storage, blocks
        WHERE
	    storage.key like (E'\\x26aa394eea5630e07c48ae0c9558cef7b99d880ec681799c0cf30e8886371da9')::bytea||'%'
        AND
	    blocks.block_num = storage.block_num
        AND
	    blocks.spec = 2023
    ) as z
    ORDER BY block_num;