> 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
