Too long queries
theese tests performed on HAfAH takes too much time:
FAILED tavern/account_history_api_patterns/enum_virtual_ops/border_between_blocks.tavern.yaml::Hived
FAILED tavern/account_history_api_patterns/enum_virtual_ops/range_between_blocks.tavern.yaml::Hived
FAILED tavern/account_history_api_patterns/enum_virtual_ops/range_between_blocks_with_filter.tavern.yaml::Hived
FAILED tavern/account_history_api_patterns/enum_virtual_ops/border_between_blocks_with_filter.tavern.yaml::Hived
Here is curl from first one:
time curl -s --data '{"jsonrpc":"2.0", "method":"account_history_api.enum_virtual_ops", "params":{"block_range_begin": 2889020, "block_range_end": 2889021, "operation_begin": 3846274, "limit": 150}, "id":1}' http://localhost:8095
example times:
real 0m3,636s
user 0m0,005s
sys 0m0,007s
times from HAfAH (set DEBUG=1 before run):
2022-02-25 17:18:01,640 - AH synchronizer - DEBUG - [1] SQL executed in 3685.65ms
2022-02-25 17:18:01,641 - AH synchronizer - DEBUG - [1] backend executed in 0.27ms
2022-02-25 17:18:01,641 - AH synchronizer - DEBUG - [1] process_request executed in 16.86ms
Here is my postgresql.conf