pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Dimi Paun <dimi@lattica.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Bad performance on simple query
Date: Mon, 17 Nov 2008 13:14:14 -0500
Message-ID: <1226945654.5760.106.camel@dimi.lattica.com> (raw)
In-Reply-To: <dcc563d10811170940l3a2673a9o19f253b5b10c4c38@mail.gmail.com>
References: <1226937197.5760.89.camel@dimi.lattica.com>
	<dcc563d10811170853y75b1286fy503d82222b49bf15@mail.gmail.com>
	<1226941621.5760.97.camel@dimi.lattica.com>
	<dcc563d10811170916n622e4f86g8f2b2dbe9b9e2a61@mail.gmail.com>
	<1226943062.5760.103.camel@dimi.lattica.com>
	<dcc563d10811170940l3a2673a9o19f253b5b10c4c38@mail.gmail.com>


On Mon, 2008-11-17 at 10:40 -0700, Scott Marlowe wrote:
> I'm guessing a fair bit of that time is pgadminIII prettifying the
> output for you, etc.  I.e. it's not all transfer time.  Hard to say
> without hooking some kind of profiler in pgadminIII.  Is psql running
> local and pgadminIII remotely?  Or are they both remote?  If both psql
> and pgadminIII are remote (i.e. same basic circumstances) then it's
> got to be a difference in the client causing the extra time.  OR is
> this output of explain analyze?

With \timing on I get basically the same output (local vs remote)
in psql (0.668ms vs. 0.760ms). More like it.


WTH is pgadminIII reporting?!?

-- 
Dimi Paun <dimi@lattica.com>
Lattica, Inc.

view thread (10+ messages)  latest in thread

Message-ID: <1226945654.5760.106.camel@dimi.lattica.com>
Permalink:  ../1226945654.5760.106.camel@dimi.lattica.com/
Also on:    postgresql.org/message-id/1226945654.5760.106.camel@dimi.lattica.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dimi@lattica.com, scott.marlowe@gmail.com
  Subject: Re: Bad performance on simple query
  In-Reply-To: <1226945654.5760.106.camel@dimi.lattica.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox