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  by Michal Zander