0

Everything is in the same place, same local computer.

Whenever my Go application as well as pgAdmin 4 queries the PostgreSQL database, it takes at least a few dozens of milliseconds, however short the actual execution time is. Where does this overhead originate from? What causes the delay? It’s the same without the EXPLAIN ANALYSE.

pgAdmin 4

Overhead

The problem is with “Total query runtime: 68 msec.” for EXPLAIN ANALYZE SELECT 1; taking 5 microseconds. There’s no way to reduce the client overhead other than querying less?

1
  • pgadmin4 is slow, no mystery there. Go surprises me mildly, can you show a concrete example?
    – jjanes
    May 11, 2021 at 16:59

1 Answer 1

2

It's the overhead that the SQL client has, in this case pgAdmin.

Use a different SQL client. pgAdmin isn't known to be the fastest. You will always have an overhead. Parsing and network communication (even if everything is local) can never be avoided. The client needs to receive and display the result - that is where pgAdmin seems to be the slowest option (I have never used it myself, but this question shows up here and on Stack Overflow on a regular basis).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.