Closed qn-srikanth closed 1 year ago
Hi @qn-srikanth, there is not an index for this query. Please refer to this page for some more information about custom indices: https://github.com/algorand/indexer/blob/develop/docs/PostgresqlIndexes.md
This is timing out because a full table scan is required to fetch the results. For assets, it is very likely that the response cannot be returned before a timeout occurs. It is solved by adding in an Index as described here.
Subject of the issue
Indexer is unable to retrieve the transactions of the asset : 1111523351
Your environment
Indexer version : 2.15.3 (compiled at 2023-01-30T14:28:02+0000 from git hash 3223f6314e56c10764ef1843e536625a6678eaa6)
Steps to reproduce
read timeout
in the indexer settings = 30 sec.Expected behaviour
Actual behaviour
Timeout