Skip to content

Fix performance issue in top-holders API

EXPLAIN ANALYZE
SELECT * FROM btracker_endpoints.get_top_holders('HIVE', 'balance', 1);
--Execution Time: 2662.059 ms

query lacks indexes and page calculation using row_number seems not optimal

Edited by Michal Zander