Draft: (4) hivemind REST API
Requires: HAfAH!210 (closed) haf_api_node!97 (merged)
Issue: HAfAH#60 (closed)
https://hive-6.bc.fqdn.pl/ - Testing new index
---------------------------HIVEMIND VERSION, EXCLUDE MUTED------------------------------
explain analyze
SELECT * FROM hivemind_endpoints.get_ops_by_account('blocktrades','blocktrades')
--Execution Time: 80.580 ms
explain analyze
SELECT * FROM hivemind_endpoints.get_ops_by_account('quochuy','quochuy')
--Execution Time: 62.292 ms
explain analyze
SELECT * FROM hivemind_endpoints.get_ops_by_account('roelandp','roelandp')
--Execution Time: 82.307 ms
explain analyze
SELECT * FROM hivemind_endpoints.get_ops_by_account('yabapmatt','yabapmatt')
--Execution Time: 149.089 ms
explain analyze
SELECT * FROM hivemind_endpoints.get_ops_by_account('gtg','gtg')
--Execution Time: 92.408 ms
explain analyze
SELECT * FROM hivemind_endpoints.get_ops_by_account('arcange','blocktrades')
--Execution Time: 112.061 ms
explain analyze
SELECT * FROM hivemind_endpoints.get_ops_by_account('abit','abit')
--Execution Time: 66.359 ms
explain analyze -- 200 muted
SELECT * FROM hivemind_endpoints.get_ops_by_account('myfirst','myfirst')
--Execution Time: 84.211 ms
explain analyze -- 1000 + muted
SELECT * FROM hivemind_endpoints.get_ops_by_account('dazzjazzz','dazzjazzz')
--Execution Time: 100.274 ms
explain analyze -- 132000+ muted - the most extreme example
SELECT * FROM hivemind_endpoints.get_ops_by_account('aschatria','aschatria')
--Execution Time: 1295.328 ms
explain analyze -- 36000 muted - the most extreme example
SELECT * FROM hivemind_endpoints.get_ops_by_account('mhsiemaszko','mhsiemaszko')
--Execution Time: 103.010 ms
explain analyze -- 10000 muted - the most extreme example
SELECT * FROM hivemind_endpoints.get_ops_by_account('msp-lovebot','msp-lovebot')
--Execution Time: 134.481 ms
Edited by Michal Zander