Skip to content

Instantly share code, notes, and snippets.

@dapi

dapi/1.sql

Created April 14, 2025 09:02
Show Gist options
  • Save dapi/2c40d17d0cc83416bd66a6c4b0253ab6 to your computer and use it in GitHub Desktop.
Save dapi/2c40d17d0cc83416bd66a6c4b0253ab6 to your computer and use it in GitHub Desktop.
Download ZIP
transaction_log_v2s
Raw
1.sql
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 | | not null | | plain | | |
transaction_sighash | bigint | | not null | | plain | | |
transaction_status | boolean | | not null | false | plain | | |
transaction_kind | smallint | | not null | | plain | | |
transaction_contract_id | integer | | not null | | plain | | |
log_address_id | integer | | not null | | plain | | |
topics | character varying[] | | not null | '{}'::character varying[] | extended | | |
Indexes:
"idx_on_block_number_transaction_from_address_id_tra_994ea27c10" gin (block_number, transaction_from_address_id, transaction_to_address_id, log_address_id, topics)
"idx_on_block_number_transaction_id_log_index_b1f48ce92b" UNIQUE, btree (block_number, transaction_id, log_index)
Access method: heap
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment