Sep 4, 2026

The optimized query to return the total coin, unspendable amount, and total count of unspendable outputs now completes in 40 seconds on shelly, 80 seconds for hash accumulation. Keep in mind that we have no utxo accumulator, so this is a full store scan. Since this is really only an administrative query, that's plenty fast. And of course it will be much slower if turbo is disabled (single threaded query) and/or on a weaker machine (shelly has 128 threads).