Skip to content

Instantly share code, notes, and snippets.

@vodolaz
Created December 8, 2022 09:50
Show Gist options
  • Save vodolaz/cfd91fc7b9a36592c2f2095cefc7b5b5 to your computer and use it in GitHub Desktop.
Save vodolaz/cfd91fc7b9a36592c2f2095cefc7b5b5 to your computer and use it in GitHub Desktop.
tracer
2022-12-08T09:40:02.175820Z INFO neon_tracer: starting options=Options { addr: "0.0.0.0:8250", tracer_db_host: "geyserneonfilter.cslouxgojbkh.eu-central-1.rds.amazonaws.com", tracer_db_port: "5432", tracer_db_password: "D5JPC7eWB6umZQnK8agYcm", tracer_db_user: "neonfilter", tracer_db_database: "geyserneonfilter", indexer_db_host: "postgres", indexer_db_port: "5432", indexer_db_password: "neon-proxy-pass", indexer_db_user: "neon-proxy", indexer_db_database: "neon-db", evm_loader: eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU, web3_proxy: "https://devnet.neonevm.org", metrics_ip: 0.0.0.0, metrics_port: 9292 }
2022-12-08T09:40:02.334356Z INFO neon_tracer: before start monitoring
2022-12-08T09:40:02.334522Z INFO neon_tracer::metrics: Registering metrics...
2022-12-08T09:40:02.334606Z INFO neon_tracer::metrics: Metrics server started on port 9292
2022-12-08T09:40:11.033251Z INFO eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180706958)), to_block: Some(Num(180706958)), address: Some(Single(H160T(0xe898c0e2c54074eba891089afa6797086ae4c719))), topics: Some([Many([H256T(0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b), H256T(0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c)])]), block_hash: None }}: neon_tracer::service::neon_proxy: eth_getLogs: FilterObject { from_block: Some(Num(180706958)), to_block: Some(Num(180706958)), address: Some(Single(H160T(0xe898c0e2c54074eba891089afa6797086ae4c719))), topics: Some([Many([H256T(0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b), H256T(0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c)])]), block_hash: None }
2022-12-08T09:40:11.033359Z DEBUG eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180706958)), to_block: Some(Num(180706958)), address: Some(Single(H160T(0xe898c0e2c54074eba891089afa6797086ae4c719))), topics: Some([Many([H256T(0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b), H256T(0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c)])]), block_hash: None }}: neon_tracer::db: Querying logs:
SELECT a.block_slot, a.tx_idx, a.tx_log_idx, a.log_idx, a.address, a.log_data, a.tx_hash, a.topic, a.topic_list, b.block_hash
FROM neon_transaction_logs AS a
INNER JOIN solana_blocks AS b
ON b.block_slot = a.block_slot
AND b.is_active = True
WHERE a.block_slot >= 180706958 AND a.block_slot <= 180706958 AND a.topic IN ('0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b', '0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c') AND a.address IN ('0xe898c0e2c54074eba891089afa6797086ae4c719')
ORDER BY a.block_slot DESC
LIMIT 1000
2022-12-08T09:40:11.038605Z DEBUG eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180706958)), to_block: Some(Num(180706958)), address: Some(Single(H160T(0xe898c0e2c54074eba891089afa6797086ae4c719))), topics: Some([Many([H256T(0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b), H256T(0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c)])]), block_hash: None }}: neon_tracer::db: Found 0 results
2022-12-08T09:40:11.178085Z INFO eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180531468)), to_block: Some(Num(180531468)), address: Some(Many([H160T(0x3aeec087e0452fc4ae4e0936176b4d7cbe854dae), H160T(0x37878e86dff621ccbc7a0872b441040531a8ca54), H160T(0x7d00e72d374fb64b18260307f0b86d944c8f2dd5)])), topics: Some([Single(H256T(0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc))]), block_hash: None }}: neon_tracer::service::neon_proxy: eth_getLogs: FilterObject { from_block: Some(Num(180531468)), to_block: Some(Num(180531468)), address: Some(Many([H160T(0x3aeec087e0452fc4ae4e0936176b4d7cbe854dae), H160T(0x37878e86dff621ccbc7a0872b441040531a8ca54), H160T(0x7d00e72d374fb64b18260307f0b86d944c8f2dd5)])), topics: Some([Single(H256T(0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc))]), block_hash: None }
2022-12-08T09:40:11.178226Z DEBUG eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180531468)), to_block: Some(Num(180531468)), address: Some(Many([H160T(0x3aeec087e0452fc4ae4e0936176b4d7cbe854dae), H160T(0x37878e86dff621ccbc7a0872b441040531a8ca54), H160T(0x7d00e72d374fb64b18260307f0b86d944c8f2dd5)])), topics: Some([Single(H256T(0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc))]), block_hash: None }}: neon_tracer::db: Querying logs:
SELECT a.block_slot, a.tx_idx, a.tx_log_idx, a.log_idx, a.address, a.log_data, a.tx_hash, a.topic, a.topic_list, b.block_hash
FROM neon_transaction_logs AS a
INNER JOIN solana_blocks AS b
ON b.block_slot = a.block_slot
AND b.is_active = True
WHERE a.block_slot >= 180531468 AND a.block_slot <= 180531468 AND a.topic IN ('0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc') AND a.address IN ('0x3aeec087e0452fc4ae4e0936176b4d7cbe854dae', '0x37878e86dff621ccbc7a0872b441040531a8ca54', '0x7d00e72d374fb64b18260307f0b86d944c8f2dd5')
ORDER BY a.block_slot DESC
LIMIT 1000
2022-12-08T09:40:11.179374Z INFO eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180531468)), to_block: Some(Num(180531468)), address: Some(Single(H160T(0x2f80debb416e7d831f9dd927eb4524abcd6b8f23))), topics: Some([Many([H256T(0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b), H256T(0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78), H256T(0x6edcaf6241105b4c94c2efdbf3a6b12458eb3d07be3a0e81d24b13c44045fe7a), H256T(0x18e1ea4139e68413d7d08aa752e71568e36b2c5bf940893314c2c5b01eaa0c42)])]), block_hash: None }}: neon_tracer::service::neon_proxy: eth_getLogs: FilterObject { from_block: Some(Num(180531468)), to_block: Some(Num(180531468)), address: Some(Single(H160T(0x2f80debb416e7d831f9dd927eb4524abcd6b8f23))), topics: Some([Many([H256T(0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b), H256T(0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78), H256T(0x6edcaf6241105b4c94c2efdbf3a6b12458eb3d07be3a0e81d24b13c44045fe7a), H256T(0x18e1ea4139e68413d7d08aa752e71568e36b2c5bf940893314c2c5b01eaa0c42)])]), block_hash: None }
2022-12-08T09:40:11.179830Z DEBUG eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180531468)), to_block: Some(Num(180531468)), address: Some(Single(H160T(0x2f80debb416e7d831f9dd927eb4524abcd6b8f23))), topics: Some([Many([H256T(0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b), H256T(0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78), H256T(0x6edcaf6241105b4c94c2efdbf3a6b12458eb3d07be3a0e81d24b13c44045fe7a), H256T(0x18e1ea4139e68413d7d08aa752e71568e36b2c5bf940893314c2c5b01eaa0c42)])]), block_hash: None }}: neon_tracer::db: Querying logs:
SELECT a.block_slot, a.tx_idx, a.tx_log_idx, a.log_idx, a.address, a.log_data, a.tx_hash, a.topic, a.topic_list, b.block_hash
FROM neon_transaction_logs AS a
INNER JOIN solana_blocks AS b
ON b.block_slot = a.block_slot
AND b.is_active = True
WHERE a.block_slot >= 180531468 AND a.block_slot <= 180531468 AND a.topic IN ('0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b', '0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78', '0x6edcaf6241105b4c94c2efdbf3a6b12458eb3d07be3a0e81d24b13c44045fe7a', '0x18e1ea4139e68413d7d08aa752e71568e36b2c5bf940893314c2c5b01eaa0c42') AND a.address IN ('0x2f80debb416e7d831f9dd927eb4524abcd6b8f23')
ORDER BY a.block_slot DESC
LIMIT 1000
2022-12-08T09:40:11.184788Z DEBUG eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180531468)), to_block: Some(Num(180531468)), address: Some(Many([H160T(0x3aeec087e0452fc4ae4e0936176b4d7cbe854dae), H160T(0x37878e86dff621ccbc7a0872b441040531a8ca54), H160T(0x7d00e72d374fb64b18260307f0b86d944c8f2dd5)])), topics: Some([Single(H256T(0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc))]), block_hash: None }}: neon_tracer::db: Found 1 results
2022-12-08T09:40:11.185176Z DEBUG eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180531468)), to_block: Some(Num(180531468)), address: Some(Single(H160T(0x2f80debb416e7d831f9dd927eb4524abcd6b8f23))), topics: Some([Many([H256T(0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b), H256T(0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78), H256T(0x6edcaf6241105b4c94c2efdbf3a6b12458eb3d07be3a0e81d24b13c44045fe7a), H256T(0x18e1ea4139e68413d7d08aa752e71568e36b2c5bf940893314c2c5b01eaa0c42)])]), block_hash: None }}: neon_tracer::db: Found 0 results
2022-12-08T09:40:11.596576Z INFO eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180706959)), to_block: Some(Num(180706968)), address: Some(Single(H160T(0xe898c0e2c54074eba891089afa6797086ae4c719))), topics: Some([Many([H256T(0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b), H256T(0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c)])]), block_hash: None }}: neon_tracer::service::neon_proxy: eth_getLogs: FilterObject { from_block: Some(Num(180706959)), to_block: Some(Num(180706968)), address: Some(Single(H160T(0xe898c0e2c54074eba891089afa6797086ae4c719))), topics: Some([Many([H256T(0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b), H256T(0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c)])]), block_hash: None }
2022-12-08T09:40:11.596692Z DEBUG eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180706959)), to_block: Some(Num(180706968)), address: Some(Single(H160T(0xe898c0e2c54074eba891089afa6797086ae4c719))), topics: Some([Many([H256T(0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b), H256T(0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c)])]), block_hash: None }}: neon_tracer::db: Querying logs:
SELECT a.block_slot, a.tx_idx, a.tx_log_idx, a.log_idx, a.address, a.log_data, a.tx_hash, a.topic, a.topic_list, b.block_hash
FROM neon_transaction_logs AS a
INNER JOIN solana_blocks AS b
ON b.block_slot = a.block_slot
AND b.is_active = True
WHERE a.block_slot >= 180706959 AND a.block_slot <= 180706968 AND a.topic IN ('0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b', '0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c') AND a.address IN ('0xe898c0e2c54074eba891089afa6797086ae4c719')
ORDER BY a.block_slot DESC
LIMIT 1000
2022-12-08T09:40:11.597687Z DEBUG eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180706959)), to_block: Some(Num(180706968)), address: Some(Single(H160T(0xe898c0e2c54074eba891089afa6797086ae4c719))), topics: Some([Many([H256T(0x9ab3aefb2ba6dc12910ac1bce4692cf5c3c0d06cff16327c64a3ef78228b130b), H256T(0x76571b7a897a1509c641587568218a290018fbdc8b9a724f17b77ff0eec22c0c)])]), block_hash: None }}: neon_tracer::db: Found 0 results
2022-12-08T09:40:11.741183Z INFO eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180531469)), to_block: Some(Num(180531478)), address: Some(Many([H160T(0x3aeec087e0452fc4ae4e0936176b4d7cbe854dae), H160T(0x37878e86dff621ccbc7a0872b441040531a8ca54), H160T(0x7d00e72d374fb64b18260307f0b86d944c8f2dd5)])), topics: Some([Single(H256T(0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc))]), block_hash: None }}: neon_tracer::service::neon_proxy: eth_getLogs: FilterObject { from_block: Some(Num(180531469)), to_block: Some(Num(180531478)), address: Some(Many([H160T(0x3aeec087e0452fc4ae4e0936176b4d7cbe854dae), H160T(0x37878e86dff621ccbc7a0872b441040531a8ca54), H160T(0x7d00e72d374fb64b18260307f0b86d944c8f2dd5)])), topics: Some([Single(H256T(0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc))]), block_hash: None }
2022-12-08T09:40:11.741183Z INFO eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180531469)), to_block: Some(Num(180531478)), address: Some(Single(H160T(0x2f80debb416e7d831f9dd927eb4524abcd6b8f23))), topics: Some([Many([H256T(0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b), H256T(0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78), H256T(0x6edcaf6241105b4c94c2efdbf3a6b12458eb3d07be3a0e81d24b13c44045fe7a), H256T(0x18e1ea4139e68413d7d08aa752e71568e36b2c5bf940893314c2c5b01eaa0c42)])]), block_hash: None }}: neon_tracer::service::neon_proxy: eth_getLogs: FilterObject { from_block: Some(Num(180531469)), to_block: Some(Num(180531478)), address: Some(Single(H160T(0x2f80debb416e7d831f9dd927eb4524abcd6b8f23))), topics: Some([Many([H256T(0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b), H256T(0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78), H256T(0x6edcaf6241105b4c94c2efdbf3a6b12458eb3d07be3a0e81d24b13c44045fe7a), H256T(0x18e1ea4139e68413d7d08aa752e71568e36b2c5bf940893314c2c5b01eaa0c42)])]), block_hash: None }
2022-12-08T09:40:11.741294Z DEBUG eth_get_logs{self=evm_loader=eeLSJgWzzxrqKv1UxtRVVH8FX3qCQWUs9QuAjJpETGU object=FilterObject { from_block: Some(Num(180531469)), to_block: Some(Num(180531478)), address: Some(Single(H160T(0x2f80debb416e7d831f9dd927eb4524abcd6b8f23))), topics: Some([Many([H256T(0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b), H256T(0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78), H256T(0x6edcaf6241105b4c94c2efdbf3a6b12458eb3d07be3a0e81d24b13c44045fe7a), H256T(0x18e1ea4139e68413d7d08aa752e71568e36b2c5bf940893314c2c5b01eaa0c42)])]), block_hash: None }}: neon_tracer::db: Querying logs:
SELECT a.block_slot, a.tx_idx, a.tx_log_idx, a.log_idx, a.address, a.log_data, a.tx_hash, a.topic, a.topic_list, b.block_hash
FROM neon_transaction_logs AS a
INNER JOIN solana_blocks AS b
ON b.block_slot = a.block_slot
AND b.is_active = True
WHERE a.block_slot >= 180531469 AND a.block_slot <= 180531478 AND a.topic IN ('0x2170c741c41531aec20e7c107c24eecfdd15e69c9bb0a8dd37b1840b9e0b207b', '0xe5ce249087ce04f05a957192435400fd97868dba0e6a4b4c049abf8af80dae78', '0x6edcaf6241105b4c94c2efdbf3a6b12458eb3d07be3a0e81d24b13c44045fe7a', '0x18e1ea4139e68413d7d08aa752e71568e36b2c5bf940893314c2c5b01eaa0c42') AND a.address IN ('0x2f80debb416e7d831f9dd927eb4524abcd6b8f23')
ORDER BY a.block_slot DESC
LIMIT 1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment