This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
### Keybase proof | |
I hereby claim: | |
* I am jbuice on github. | |
* I am hartparr (https://keybase.io/hartparr) on keybase. | |
* I have a public key ASCsACO1lahrgGsngwbS3U1qkZMt8RbJ-AiBdRR4q5jPoAo | |
To claim this, I am signing this object: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
2024-03-29 14:00:26.346 UTC [2703967] teloscan@teloscanmainnet LOG: duration: 2209.109 ms execute <unnamed>: SELECT b.number as "blockNumber", b.hash, parent_hash as "parentHash", b.nonce, b.sha3uncles, b.logs_bloom as "logsBloom", b.transactions_root as "transactionsRoot", b.gas_used as "gasUsed", b.gas_limit as "gasLimit", b.extra_data as "extraData", b.timestamp::text, b.size, COALESCE(transactions_count, 0) as "transactionsCount" FROM blocks as b LEFT JOIN (SELECT block_number, COUNT(*) as transactions_count FROM transactions GROUP BY block_number) as t ON t.block_number = b.number WHERE COALESCE(transactions_count, 0) > 0 ORDER BY "blockNumber" DESC LIMIT $1 OFFSET $2 | |
2024-03-29 14:00:26.426 UTC [2703946] teloscan@teloscanmainnet LOG: duration: 2318.661 ms execute <unnamed>: SELECT b.number as "blockNumber", b.hash, parent_hash as "parentHash", b.nonce, b.sha3uncles, b.logs_bloom as "logsBloom", b.transactions_root as "transactionsRoot", b.gas_used as "gasUsed", b.gas_limit as "gasLimit", b.extra_d |