Slowness in simple queries

[mauricioribeiro]

Hi everyone,

I'm getting slow responses (30-100ms for simple select queries) from Spanner in my FastAPI app. In order to confirm the latency is not an issue, I deployed a Postgres instance (Enterprise Edition, 4 vCPUs 26 GB MEM) in the same location (europe-west1 Belgium) as the Spanner (2 nodes) and tested/profiled both in my local app. Here is the comparison:

Postgres (6ms/10 profiles avg):

Spanner (28ms/9 profiles avg):

I can confirm the Spanner query is executed in less than 1ms:

Bottleneck seems to happen in the execute() function, from what I understood analysing the Google Profiling comparison.

Also got similar slowness with the tutorial case.

Could someone please help me on this? Have anyone already experienced something similar?