Skip to content

Optimization of AH get_account_history filtered calls

Bartek Wrona requested to merge bw_get_account_history_filter_opt into develop

Slightly redefined filtering query used in get_account_history implementation, to force PostgreSQL to use proper index.

The call reported by @mahdiyari lead to slow execution in PostgreSQL 14. This modification switched planner to expected behavior.

curl --request POST \
  --url http://172.17.0.10:6543 \
  --header 'Content-Type: application/json' \
  --data '{"id":2,"jsonrpc":"2.0","method":"condenser_api.get_account_history","params":["gtg",-1,250, 4]}'

Related to haf#141

Merge request reports