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

help / color / mirror / Atom feed
From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: Hot Standby performance issue
Date: Wed, 23 Oct 2013 01:15:14 +0200
Message-ID: <52670702.3030201@fuzzy.cz> (raw)
In-Reply-To: <1382478627757-5775529.post@n5.nabble.com>
References: <1382291901534-5775181.post@n5.nabble.com>
	<526460B7.3020008@fuzzy.cz>
	<1382367933794-5775257.post@n5.nabble.com>
	<52658780.1040002@fuzzy.cz>
	<1382390332002-5775332.post@n5.nabble.com>
	<5265A28E.4060601@fuzzy.cz>
	<1382396377294-5775349.post@n5.nabble.com>
	<5265B562.3040407@fuzzy.cz>
	<1382400045239-5775361.post@n5.nabble.com>
	<5266BD42.2030303@fuzzy.cz>
	<1382478627757-5775529.post@n5.nabble.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

On 22.10.2013 23:50, sparikh wrote:
> Sorry, it was typo from my side. I meant strace only.

OK.

> 
> I will try to request both perf and strace to be installed. But I am
> not quite sure as the VMs are managed by third party. Will keep you
> posted...

What do you mean by VM? Is this a virtualized environment or bare hardware?

> 
> The main thing puzzling to me is Explain Plan with Analyze takes
> couple of secs to execute the operation but in reality it runs for
> more than 20 mins.

So, now I'm getting confused. Can you please provide timings for each
case. I.e. how long it takes to execute

1) plain query
2) explain query
3) explain analyze query

Execute each of those a couple of times, and let us know about
significant variations.

It should always be

       EXPLAIN ANALYZE >= query >= EXPLAIN

If you're reporting you see "EXPLAIN ANALYZE < query" then I find that
really strange.

Tomas


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (31+ messages)  latest in thread

Message-ID: <52670702.3030201@fuzzy.cz>
Permalink:  ../52670702.3030201@fuzzy.cz/
Also on:    postgresql.org/message-id/52670702.3030201@fuzzy.cz

 · 

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: tv@fuzzy.cz
  Subject: Re: Hot Standby performance issue
  In-Reply-To: <52670702.3030201@fuzzy.cz>

* 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