Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50260=pgsql-performance-ar@postgresql.org>)
 id 1V5I5g-0001fA-M3
 for pgsql-performance@arkaria.postgresql.org; Fri, 02 Aug 2013 16:20:32 +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+M50260=pgsql-performance-ar@postgresql.org>)
 id 1V5I5g-0000TN-3j
 for pgsql-performance@arkaria.postgresql.org; Fri, 02 Aug 2013 16:20:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <eshkinkot@gmail.com>) id 1V5I5f-0000TH-7P
 for pgsql-performance@postgresql.org; Fri, 02 Aug 2013 16:20:31 +0000
Received: from mail-la0-x229.google.com ([2a00:1450:4010:c03::229])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <eshkinkot@gmail.com>) id 1V5I5b-0003iK-JL
 for pgsql-performance@postgresql.org; Fri, 02 Aug 2013 16:20:30 +0000
Received: by mail-la0-f41.google.com with SMTP id ec20so584956lab.28
 for <pgsql-performance@postgresql.org>; Fri, 02 Aug 2013 09:20:25 -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=2pmWJuKfO1KHr9K3kO9nkkieP+nxpI+IzNhS/Tuz37o=;
 b=PGOoC5FsrVb4aUCopBOG7ML4GFCUTqqQbWNTTMyvmqh3rE0fj1fXeKogLIo3kS/EIo
 EmDRv/xA0NmxmvV+Jacn0/LHkpdSMXovVGO1mwaNw2v/g10crlEB2pyqV4sbkCXhuvy8
 6JQzVcD1TZTL4btJ+SP4UH2rUsygeALKRG7rBlTKb4bP5De5iJhioJOXXEqcOsTjwpMp
 B0WHoAzhe5b30QhZK9lqLEzzJ4j+Iw/+aznix4l3oMJPDsyFEus+brwh54XfL+DIJH9E
 DzY43QsQRegiPE0PkMsddi+CYlUTyy+z/qxM7eV08dxlZTUht5zSxGp6b7uNauje4XdK
 Guxg==
X-Received: by 10.112.57.49 with SMTP id f17mr3984579lbq.26.1375460425828;
 Fri, 02 Aug 2013 09:20:25 -0700 (PDT)
Received: from seb.koffice.internal (koffice.avito.ru. [195.151.206.25])
 by mx.google.com with ESMTPSA id gh5sm3582578lbc.12.2013.08.02.09.20.23
 for <multiple recipients>
 (version=TLSv1.2 cipher=RC4-SHA bits=128/128);
 Fri, 02 Aug 2013 09:20:24 -0700 (PDT)
From: Sergey Burladyan <eshkinkot@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jeff Janes <jeff.janes@gmail.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>
 <CAMkU=1x51iVmUcLewMUBLB3fKW9tkpfsL0iYQuXp33aTAiQVPA@mail.gmail.com>
 <1899.1375458648@sss.pgh.pa.us>
Date: Fri, 02 Aug 2013 20:20:22 +0400
In-Reply-To: <1899.1375458648@sss.pgh.pa.us> (Tom Lane's message of "Fri, 02
 Aug 2013 11:50:48 -0400")
Message-ID: <878v0kuks9.fsf@seb.koffice.internal>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (gnu/linux)
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=-=-="
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

--=-=-=
Content-Type: text/plain

Tom Lane <tgl@sss.pgh.pa.us> writes:

> Jeff Janes <jeff.janes@gmail.com> writes:
> > On Thu, Aug 1, 2013 at 5:16 PM, Sergey Burladyan <eshkinkot@gmail.com> wrote:
> >> If I not mistaken, may be two code paths like this here:
> >> (1) mergejoinscansel -> scalarineqsel-> ineq_histogram_selectivity -> get_actual_variable_range -> index_getnext
> >> (2) scalargtsel -> scalarineqsel -> ineq_histogram_selectivity -> get_actual_variable_range -> index_getnext
>
> > Yeah, I think you are correct.
>
> mergejoinscansel does *not* call scalarineqsel, nor get_actual_variable_range.
> It calls get_variable_range, which only looks at the pg_statistic
> entries.

Hmm, I speak about 9.2.2 but in current HEAD this call still exist,
please see: http://doxygen.postgresql.org/selfuncs_8c_source.html#l02976

> I think we need to see the actual stack traces, not incomplete versions.
> It's possible that the situation here involves bloat in pg_statistic, but
> we're just leaping to conclusions if we assume that that's where the index
> fetches are occurring.

I found debug symbols and send stack trace to mail list, but it blocked
by size, try again with zip


--=-=-=
Content-Type: application/x-gzip
Content-Disposition: attachment; filename=gdb.log.gz
Content-Transfer-Encoding: base64

H4sICKh++1ECA2dkYi5sb2cA7Z1Zc9tGEsff9SlQ9oOcLUWcA8cgu9qqOBtX
5bCdlZO3VGGHgwGFGAQYHLKUePezb8+ABwCCkuMSaVnqVFliZgCw+z89Pdev
oKfEccgVgf+CJAl8P/QDnxEnzZ1Sy9h59oWTlMXcmWTp1PxTp1Vx6h89pb27
RKgSxbzNXVGUT69rXZ39o1jU6Tz9Q8dO0dT/PHGiaNokY8VJPCz9wpG1M2mq
cpLmKmtiPZmmdTVp8rSq49OLr1zv6ClznBdpps/ttybwafvR8H2JLs/IFZjq
eSwJXaGI8+RXHgTvn5w4cl40eT3+3RfFXE/+uNTlZFFU9azU1e/Zl+EpO2WD
gmXhtEmzeHJ6OqlKNZlK9Vbn8aSqi1LO9MRYN0niU/UVpYIfPeUDCbVkiW8k
nMetiKXO8m13kqJ8mzfzET+zQtkaSikXlLu3uL4HF6v5rJzMjYt+wI6eusMg
UW7AjYemuZ5b2yJVzOdF7jwzt7aGBn5IIJgoOYFgyha6rKC9da70uBavdmox
WjMv4pEHVXUpaz273q65SOvWrCTxk2mow8R5sg/p2qYyv0AIENB1w6On3paA
ief2Bfz2CrSJ9SpclgoKP/G5SzYKvfz6u1fRi9fnP7z65WVHnk2oWF3On7+M
Xr0+f/n1jx1J4JFchFSF/gHcZq44eur33RbEI0oat1Pw9CpKdK0uogstFxA2
Sq6dDqnLpprcoZVSKV1VE/u17U85ByM9AkYGW0YyrjdGznSd66t61MITJ05L
req0yM9eFOU7WcZv4Kp/rQr374FPIHeKvgfS55zYBAS2R1LVjcyiS1mmcprp
qJT5TEOQFUW93UngqljWcqRfFWVdLEZ6YdrRRLg8AU3m8grK7rL5mjrNqomM
60mls6TJVWU6ViigZ4VD32HUc9vW079HF5Bxilkp5xHcaNrkMq2vb3N+kyUk
m4I/xWJRFmr7+rSa1WfUOf6VEHp84qgir+pLmW1faGvq64Xe4+A0KpFgkLwp
GSoUh8ooBAGdQVSATnDLUpR1W1JPtr5ryB5FucP70HeO/3O8W7q1JuQTquB5
0MspHaggRNJRYVZbDRKV5klxaAMpCc1MjPUtVB4Do8HC12n8Aq40CeUbmWXu
N0VmTF0WfRePBVyWSZuVQHdwjp5RlwSEeKHPQxeGdFvKzlwa2k98Uw9Fvu/a
Uvfs7vuwGR0myyGC+sKEJ+8PjaFQejkBhZErtT6O9N5dgZrGZzQA4YTve751
o+pcO1UeXJvmi6Y2GsHFxAbvubaf79DdVZOU1vHJIpO5krVtbEbBa7fvta8C
agcdlcmm0h/gcHth17dY95w5cX4r0tx2uO9fw6Thu1evvj2HTP7bnkN84/lC
1heT1k7wx4xWvumJ3sD1aeKTjesZpOwPdr8azeIfJMDdjlA3OE0ZrBGoP3A6
jpPYph8Yoqey0jDpiyp4QARRn85hwlZtHFd2At2RQIXxPo2HG40pYDt3qQnW
YGC8nCZsZTxEdppHK/PB6HpkWm7M3y4cGYX35xVkTvPb5FvuBeCUsOZ3DB8L
s23doaxOz1zzq9v7fHefTdIxnnkEjA+HfUiFQTec1n5V47Odg5hKA7OwJzAh
fKujIrdG7dDZ9FTT8zcVzI/1YRSlHDoo688PQsEDZUff3xtdXpsoz3Nd7rC+
tqZvBXjdLGDCnZSyXSFs1Wfwf3VkrxpJZMosjCAbRMbO7sxqaibZZkKu4+06
LU6cvJlHs7JoFlX/NrEfOUEa+2MOicAGKEzLGRvI6bE2yVu70nx2m6I3Srdf
P8Aqm7bNOM0GsxMREBnajtZMB5Exy4rpxg+ilfFjIcvOIA0zLD9uS3UOuafv
OZcE6i5kda5VU1ajIXNbSIFZh+vufcE8Znq7O9SL+3ZeU9Uyj2GVsNFrXBrj
eVG+Xhj3KjOGT4smj3+SsIar9jdmD5reTMfZYJqiE66sJ4s2diPb/M4z+6su
tV6O1H0HKA8ZMZsKW54wePQdOgPz2cX6cvAh8Ez09mcdQoWutPt2317ZYft1
rv/d8WLpAcyZ7PToxNG9BBKbgLYXvoGJeT7bjr5F69z+gs9sMkIcVRPdOmAG
c2rCLhg6KkjYcXTpZVXPR9J016V1OEotXOI8WX6P005Inb+1m+hXl6l+dwoz
vDJKaz2vokvn0nl3AZM455lzeWrKojR2zhzKGfcE58T54u9P1vpYbWNd1YdV
ilET1qKrlAsyeZq1YV1V0U9lYbaZfoEli5162z5qg/tG1T4wEMymwc/F4kd9
CbOq1dbBmA5mBTuHRGf60M9ydscyqSIHs6cT6MiQlWr7Q88hIVcjRXYXxQXd
BjOuhCbMzrh+goFYZudNvhHNlnQyG9UhNHjT1r8xMbgJs0SY3d1dumye4SYJ
Gcqy6ZtTIsndbme3+cQ2cnvQAb2Mk4EGnIV2qf4izbJWhzewBNc7Jei4Sey+
GTnen8nEzEM4HZosRNJrtrWxIzE4cp7Uc+JL3wU3OLixK45lVh8+wHeLEtjz
KjYc2WA5ajTRV1rBosEY1hvdomq0m+9x9KLEhVzFB5OvBJIVaRuvvfKlSc3P
ZDkb2Z2F0svtUpOzcznXB/SFh2b/kQ8mRlIG7VD8vL1tHYl7tMxcOZdVvXxK
+9FY6FPTVbyVLW9qWcJE89PZwwlkXO47b3QJX/FjUSzM+fXev5dyP4DvHex2
yDjgahV17bW3xt3q9C7RjIbkEKZTZkwXfdNdod2pPYneGOyNmBjcpYnmuybL
tSANw6NvYLhN8wYSyOnR0fNSy7cLsy3n0JOP4RUeFeXA42komD3qz/98mIgD
8YQIGbvJb+QbkG/YxAnyDcg3IN+AfMNB+AbKYDX+PwQcEHC4V4ADQ7IByYaH
QDYIJBuQbECyAckGJBuQbECy4R6TDWLowJc+JYHwiBCfCdkgkGxAsuEQZMN6
0wDRBnKDMMg2INuAbAOyDcg2INuAbMPjZBtE+xoDRt0/H+4bHJhgt7iOhAMS
DptQQcIBCQckHJBwOAjh4HnOcYCAAwIO9wlw4JQi4ICAA766AQEHBBwQcEDA
AQEHBBwQcDjsqxss4ACrc8rw1Q0IOCDgsDkaXu0ZIN9AduuCeAPiDYg3IN6A
eAPiDYg3PD68YapcqpZn/Jz+8TDxBk59j5vpwY2uI97wEXhDMn1YeMM6VB4E
3hAyj9xvvMFaiHhDD2+Y0oQ/LLzB5bfhDavV2kPDG3xfSXEr3hDAkvyH493S
rTWh7v3jG3jQjtK6nGlzymI6+G4llqfKWzoUi0TO0+z6r4xFeZNlVZSkZdUN
oEwndWUWGF0ZvUS0NeBdv9wMq+nsYuQWc9Jhq4b36L13Sk7ssehgHe0nUlqt
lVQXOo7WSptDmrd6RKFy7Cj+0AejneNeZhde1Ex60jqFfGrqonXo7IiZdzBo
VwupdLcVfNk9f9/OqOaZO8/w4SfMtTZnW/ZAJdbSshv5SJXNyPYuk8JB6y70
wVy6urFTSzokwPo5jImDCE1DyrchkACMsKuSurzeqG6d3ZXNzQW9M2oSW8Rl
t/Lj/MdyyzaqiqZU9qD2zpplBfBEq+butAyT9jTMdo9lo/Qio9uI/l9v4v21
pdHXfDDJwA4/g9OiQFC/HX7AnKhVR+ZxZB2w++q3ib2rnT6oT0XjB9Krphiv
tVaOkhrW6tGaVfx94hzWaQ5PCIvbyLg9Ha+iuoiWZu5IYDud2O33bq3+es/r
tUq/cxxEMep524xPEAq63Dp6q61+0W4BoYZ2CgNLKEAh2yyREyXYnt0x/cgs
FsxGCxVDd6QK1+6YK6Pp9TIjWe8q51lRX0Av3ZH6sji6J3G+dJMF1HJAtmkq
LUtYZBrGJjMnEzvaydZ9EmvtiToZYmRcTntsQMeXmzyoolzrWMdn7GQ9Uxlr
tsPQQy53PxYfWjqF+NCd4UMrRT9zfIgQjxo/thgZEopRfEgkiWKueMz4kJXm
s8aHxDY+RCk3O56u+TOEnwM/JJAfuokfSlds0InTLPmhuD2xshyRk9pNEDum
26PqymmcIu9cewaPWH1ugaMObOSHoevD1yJq1Mc0Vvt3jx01ijnZrUsXNYoF
okaIGiFqhKgRokaIGiFq9BhQI8WobP9aSvD+gb5GxYWk7gc3+Y2QEUJGmzhB
yAghI4SMEDI6CGREQevj90gZIWWElBFSRkgZIWWElBFSRkgZIWWElBFSRkgZ
IWWElBFSRnfxkqJkmzIiXLgBJ8z9TN5SlCBlhJTRvfuLTcsNPMSMyA3CIGeE
nBFyRsgZIWeEnBFyRo+TM3Itb/P6/QN+n5HwbvIbOSPkjDZxgpwRckbIGSFn
dCDOyHOO/4ucEXJGyBkhZ4ScEXJGyBkhZ4ScEXJGyBkhZ4ScEXJGyBkhZ7Sn
txkZzsh3BWf4NiPkjJAz+kjOaLmBh5wRuUEY5IyQM0LOCDkj5IyQM3oInNH/
AY6LQHabzwAA

--=-=-=
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


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

--=-=-=--