SQL timeouts for various queries on mainnet DB

[singulart]

Example query that fails to return data due to timeout:

select count from transactions where block_timestamp > 1666656000;

Error message: canceling statement due to statement timeout

[telezhnaya]

Hey @singulart , Public read-only replica has huge load and it's not intended for heavy requests. count(*) usually requires sufficient resources.

If you want to find the number of transactions after a specific date, you can use NEAR Analytics instead.

[singulart]

Thanks a lot for your support! I will try near analytics!