If you are querying WowTokenCreated on the Index Supply free plan, please reach out to me as I have a query suggestion for you. It will bring your cold query latency from a couple of seconds down to ~150ms.

here is the faster query:

If you are querying WowTokenCreated on the Index Supply free plan, please reach out to me as I have a query suggestion for you. It will bring your cold query latency from a couple of seconds down to ~150ms.

here is the faster query: https://tinyurl.com/wowtoken-with-addr

Indexing Ethereum https://indexsupply.com

Engineer @ Syndicate, prev: Rainbow, Foundation & Cloudflare /poetic-web, builds caststorage.com

It's the same query without the address. If the underlying data is cached (in pg's shared buffers or the OS's page cache) (it is as of this cast) then there will be no difference.

This particular query is on the slower side simply because of how many rows are being returned. I'm not saying that queries without addresses will always have a penalty, but in this particular case, adding the address predicate will increase cache hit rate because fewer file system pages are needed. And when it's not cached it will be quicker for the same reason.

What was the slow query? Interested in comparing