Hot answers tagged

6 votes

Is pgAdmin adding query time overhead?

You are looking at the wrong metric. Total query runtime: 66 msec. This resume in pgAdmin includes network latency and client overhead. Use EXPLAIN (ANALYZE, BUFFERS) for a detailed query plan, and ...
6 votes
Accepted

Is pgAdmin adding query time overhead?

Yes, pgAdmin adds a lot of latency overhead. I'm surprised you could even get it as low as 66msec. The answer is pretty easy, don't use pgAdmin for things like this. To try to figure out why a query ...
  • 33.2k

Only top scored, non community-wiki answers of a minimum length are eligible