Postgres chooses wrong index on DISTINCT block_num

SELECT DISTINCT block_num 
FROM hive.operations_view 
WHERE op_type_id = 0 
ORDER BY block_num DESC 
LIMIT 100

for some operations (I found problematic for now 0,72 - vote and effective_vote operations, there is more than these two) postgres planner doesn't choose our index on hive.operations (it chooses seq scan)

Edited Oct 31, 2024 by Michal Zander
Assignee Loading
Time tracking Loading