Re: Slow queries on simple index

> Hmm, where is the evidence that your query uses theindex? Maybe the
> generic plan accidentally forces SeqScan?

You may be correct - I just noticed that I am able to reproduce slow queries through my app. However, running the exact same queries in psql does use the index.

What might be different about my app's connections than psql? It uses Npgsql 9.0.2 on .NET 8, with these settings:

// src is "Host=[fdaa:9:e856:a7b:910f:0:a:102];Port=5432;Username=pluralkit;Database=pluralkit;Maximum Pool Size=150;Minimum Pool Size = 50;Max Auto Prepare=50"
var builder = new NpgsqlConnectionStringBuilder(src)
{
Pooling = true,
Enlist = false,
NoResetOnClose = true,
Timeout = 2
};

My understanding is slow query logs calculate the query time on the backend, and any client or network latency is not counted. Is this correct?

Kindly,
Lillian