Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50270=pgsql-performance-ar@postgresql.org>)
 id 1V5MkP-0006aX-Vx
 for pgsql-performance@arkaria.postgresql.org; Fri, 02 Aug 2013 21:18:54 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50270=pgsql-performance-ar@postgresql.org>)
 id 1V5MkP-0006tN-Fr
 for pgsql-performance@arkaria.postgresql.org; Fri, 02 Aug 2013 21:18:53 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <eshkinkot@gmail.com>) id 1V5Miw-0006r0-OE
 for pgsql-performance@postgresql.org; Fri, 02 Aug 2013 21:17:22 +0000
Received: from mail-la0-x22b.google.com ([2a00:1450:4010:c03::22b])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <eshkinkot@gmail.com>) id 1V5Mit-0002yE-PQ
 for pgsql-performance@postgresql.org; Fri, 02 Aug 2013 21:17:21 +0000
Received: by mail-la0-f43.google.com with SMTP id ep20so785624lab.16
 for <pgsql-performance@postgresql.org>; Fri, 02 Aug 2013 14:17:16 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=from:to:cc:subject:references:date:in-reply-to:message-id
 :user-agent:mime-version:content-type;
 bh=NG093F9CgR4ISS6qyX0s0ICnz59T8a6rkU6PJX+sGZ4=;
 b=rNfZTwVnOAXGe/exSYSHv4WzqZIaefufjuY5LT9u8eo4PmIt/vADaJ++i3y74Gd1Y4
 +zU49UT0Qf3l6LYoR2JIXa1CUSBizvSibFaQnqBl4WNne3eail0XBdS84us5nOtpSDOK
 VwZOvLnIFrVk9R16zfLvcPOnvu70qxqaCQaxuaOKLEv+aT4Rl2yde6vw6RrHhX+GTS1M
 SS0XVJUNidgW9a8Q7SEDYpPpLdNzb5J+HzYqQbZo+pUi5fhXSytJkV/tap2EagmD30sL
 9yzo4y4bWCcIsR7iWYXuT2F5t0Ed3sXLZLNdTJ37pmcC3joEF/ALtQscin76l24yl3Ne
 XYDA==
X-Received: by 10.112.55.173 with SMTP id t13mr4343587lbp.39.1375478236766;
 Fri, 02 Aug 2013 14:17:16 -0700 (PDT)
Received: from home.progtech.ru (os.progtech.ru. [80.252.153.41])
 by mx.google.com with ESMTPSA id t15sm4009572lbh.16.2013.08.02.14.17.15
 for <multiple recipients>
 (version=TLSv1.2 cipher=RC4-SHA bits=128/128);
 Fri, 02 Aug 2013 14:17:15 -0700 (PDT)
From: Sergey Burladyan <eshkinkot@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>,
 "pgsql-performance\@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Looks like merge join planning time is too big, 55 seconds
References: 
 <CAJ2ymdjK-+LZHFY+cskRq98c_4F1PEfveOVNbNGpWL0Pczy5Ew@mail.gmail.com>
 <8761vpwid4.fsf@seb.koffice.internal>
 <CAMkU=1zyWZEC0YfQ0D4obWWHZqcLoLApUzf-f2+LOVH2ib=s_g@mail.gmail.com>
 <87li4lusvd.fsf@seb.koffice.internal>
 <CAMkU=1zuaFU7-DBJGawX+P+e4HjXmL+R_sxOLoB4Q18B5fRPHw@mail.gmail.com>
 <87li4l9j34.fsf@home.progtech.ru> <87k3k5kkup.fsf@home.progtech.ru>
 <20130802031914.GE5669@eldon.alvh.no-ip.org>
 <87haf8v2h8.fsf@seb.koffice.internal>
 <CAMkU=1yZvKht41LTrQB5UO7J=bO+beFLDLZ5E84_nRNLj20eRQ@mail.gmail.com>
 <874nb8uif7.fsf@seb.koffice.internal>
Date: Sat, 03 Aug 2013 01:17:13 +0400
In-Reply-To: <874nb8uif7.fsf@seb.koffice.internal> (Sergey Burladyan's message
 of "Fri, 02 Aug 2013 21:11:24 +0400")
Message-ID: <87haf74wti.fsf@home.progtech.ru>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Sergey Burladyan <eshkinkot@gmail.com> writes:

> Hot standby:
...
> '          ->  Index Only Scan using items_user_id_idx on public.items  (cost=0.00..24165743.48 rows=200673143 width=8) (actual time=56064.499..56064.499 rows=1 loops=1)'
> '                Output: public.items.user_id'
> '                Index Cond: (public.items.user_id IS NOT NULL)'
> '                Heap Fetches: 8256426'
> '                Buffers: shared hit=3694164 read=6591224 written=121652'
> 'Total runtime: 56064.571 ms'
>
> Master:
>
...
> '          ->  Index Only Scan using items_user_id_idx on public.items  (cost=0.00..24166856.02 rows=200680528 width=8) (actual time=202.756..202.756 rows=1 loops=1)'
> '                Output: public.items.user_id'
> '                Index Cond: (public.items.user_id IS NOT NULL)'
> '                Heap Fetches: 0'
> '                Buffers: shared hit=153577 read=1'
> 'Total runtime: 202.786 ms'

Looks like visibility map is not replicated into slave somehow?

If it matters, Master was restarted yesterday, Standby was not.



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