If you’re running LXD 5.3 you’re likely being affected by this Database error: "sql: transaction has already been committed or rolled back"
There is a fix for the instance list speed regression merged and it should be deployed to the latest/stable channel soon.