explorer-backend
explorer-backend copied to clipboard
Solve queries bloating
Currently affected query sets:
- Assets
Error message:
Tried to send an out-of-range integer as a 2-byte value: 63702
Example query:
select distinct on (a.index, a.token_id, a.box_id) api_1 | a.token_id, api_1 | a.box_id, api_1 | a.header_id, api_1 | a.index, api_1 | a.value, api_1 | t.name, api_1 | t.decimals, api_1 | t.type api_1 | from node_assets a api_1 | left join tokens t on a.token_id = t.token_id api_1 | where a.box_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ...