Skip to content

Instantly share code, notes, and snippets.

@dapi
Created April 14, 2025 08:59
Show Gist options
  • Save dapi/55122e7cc9585feafe8261d5173dfeb5 to your computer and use it in GitHub Desktop.
Save dapi/55122e7cc9585feafe8261d5173dfeb5 to your computer and use it in GitHub Desktop.
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:
"idx_on_block_number_transaction_id_log_index_cc9ee772bf" UNIQUE, btree (block_number, transaction_id, log_index)
"index_transaction_logs_on_block_number_and_tags" gin (block_number, tags)
Access method: heap
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment