chaingraph icon indicating copy to clipboard operation
chaingraph copied to clipboard

Query: find transactions which weren't broadcasted before being mined

Open bitjson opened this issue 4 years ago • 0 comments

Given a block hash, which transactions appear to have been added by the miner? Transactions which were first heard over the P2P network are added to node_transaction, and after being confirmed in a block, they are moved to node_transaction_history.

If the Chaingraph instance has been running for at least the past block, any transactions which were sent over the P2P network should be present in node_transaction_history; any transactions in the following block which are not present can be assumed to have been added directly by the miner without broadcasting them over the network.

This would be a good example query to add to the website, and possibly would make a good computed field, e.g. block.unbroadcasted_transactions.

bitjson avatar Nov 19 '21 21:11 bitjson