Skip to content

Instantly share code, notes, and snippets.

View dapi's full-sized avatar
🌴
Open for offers

Danil Pismenny dapi

🌴
Open for offers
View GitHub Profile
--- BLOCK
Payload: {
"from_block":10000000,
"to_block":10120011,
"include_all_blocks":true,
"field_selection":{
"block":[
"number",
"hash",
@dapi
dapi / 1.sql
Created April 14, 2025 08:59
transaction_logs
You are now connected to database "cocodrilo_development" as user "danil".
cocodrilo_development=# \d+ transaction_logs;
Table "public.transaction_logs"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
----------------+---------+-----------+----------+-------------+----------+-------------+--------------+-------------
block_number | integer | | not null | | plain | | |
transaction_id | integer | | not null | | plain | | |
log_index | integer | | not null | | plain | | |
tags | jsonb | | not null | '[]'::jsonb | extended | | |
Indexes:
@dapi
dapi / 1.sql
Created April 14, 2025 09:02
transaction_log_v2s
Table "public.transaction_log_v2s"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
-----------------------------+---------------------+-----------+----------+---------------------------+----------+-------------+--------------+-------------
block_number | integer | | not null | | plain | | |
transaction_id | smallint | | not null | | plain | | |
log_index | smallint | | not null | | plain | | |
transaction_from_address_id | integer | | not null | | plain | | |
transaction_to_address_id | integer
{
"from_block": 1,
"to_block": 1000000,
"logs": [
{
"address": [
20059476,
29444609,
26851445,
44362257,
{
"from_block": 1,
"to_block": 1000000,
"logs": [
{
"address": [
45480608,
28155531,
65552029,
28455280,