jbuice

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

jbuice

### 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: