Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1htugm-0004Tw-4m for pgsql-performance@arkaria.postgresql.org; Sat, 03 Aug 2019 14:07:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1htugj-0000vU-AC for pgsql-performance@arkaria.postgresql.org; Sat, 03 Aug 2019 14:07:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1htugi-0000vN-UC for pgsql-performance@lists.postgresql.org; Sat, 03 Aug 2019 14:07:13 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1htugb-0005oN-Tu for pgsql-performance@lists.postgresql.org; Sat, 03 Aug 2019 14:07:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1564841220; bh=OoRc2p9z8nxbs/eYsRVYq1D7lr1nwO6IutGqECJCta4=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=DiDNjV6rgEbyw2kZhP8tyUjHfEeGCDnn8XsWAQUn4Am9pITOL8Ff91vc7UnOfFAQW gFgAL2JPhHHSeLSj4zTAJr9vqg6eFvYyAfCQsDP0gMRv61TxIDCc/lJQoDz4QylvBy wbfafG1M4xvynDIxPWKx+ifvdyrwAHK1DO9eZPVA= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [192.168.178.37] ([188.174.163.168]) by mail.gmx.com (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MwwZd-1iIJMl1GRP-00yUGE for ; Sat, 03 Aug 2019 16:07:00 +0200 Subject: Re: Strange runtime partition pruning behaviour with 11.4 To: pgsql-performance@lists.postgresql.org References: <29b2f4c6-987b-d364-2e1d-bbd479d06da2@gmx.net> From: Thomas Kellerer Message-ID: <9c55d578-bb70-d439-6450-abc291957ec3@gmx.net> Date: Sat, 3 Aug 2019 16:06:57 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:QCfhLGE5NlRi1yRF9F4HGXEYGNXlqfOuKlzaJJaBB6gsQEEEpvZ udx1Il97A1hvfu61qlTfR2Mj9OpQRl/gywHy/EYjQ1qgonUxqmi+SPmI5WHBl6BKlPL2sOR 686R4iCFlg7VhlryXUtjVANhr8/xkbryutx65kCbQBTAIT0B8neP/s7nK3W/HRzObZIuCR0 ww2MiAhjcF8VlAFvQbInQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:CbGzOkttj8E=:AV23YkDwA3uthGOVzO4aSN FzGbub1Mf/my3cX75mr6VkJkEYuebXSbtonGY7E1LDxh9nOzharVFKhbnYJUmRiBsM8aG4+Lg 4e/NdJlGu91QiYxg4ilccDEz7pw9LMCe8kctFaE2QD1c+TwVtFkgeeTO9ZnvVWLqsprgPDCps cnVglkx2bpU6dIH8pZ51m/efIgwpakHLV+2Y3HVcojrCqsas/LmqivGM8TAs8oEiv8gG/7nTN v1H7vq3MrtmsOY3aKfnZ+T/49YQzu3k0RYC2Y9UgmYJ2K1m5AKkHc8paC3+B8k40O5MONqmsk UERf5qry98qPne9HGU6zF4+TF2SLH97Y9i19G/ELj+smID9UeGxMzrhLRz0d6PUoWp725UV35 9Y2LBpgNspZoUarf13Zuu1JTRZwwcV4468j8Pmy3q/4s4+Q1k1m5Dkn0Q38eBF9f3r7Xlw6/Z Bf2Ye7S6wasWP3zn6mM6YmlGZrgQ8KKw9AX7bPKoq6up3a2v/U9yHlr3fgZA26DDxMbPK8pz3 mqXBADcLewZWYG4VjQ6wXFwlFGDPo2pbNcyKjIj8pvI+bBdMAFVMzp3MHDqy8x860LHNTALvt TZWMK6O9u3oTNbnfHkkOqk6+lqYBf0uq+q3TFfbEdjxGsQX1SilV4JISqz9H4wmgpbZusU+wo rVuyMwuHCpU1Ay0fzp+DFroxKR8B8s6dNy2h9L0sMzL9GzLTcetgP9dG7kX7AA/xK/j8jn4gH cFcA1HMTQlLMkZdJVsy5xfrlKyNl1ML31R6X2CJjLkdGXUc3lY/jONiZA+mvObzah78SpQOx2 M3xcVK3QX4G38iQLM1hHX5lL5Am4R7V1OL38aCUvFQ0e9JbuRKk/dzIe1f/IRfSjn6qMedODx ylxs0uKGfJ/MP9NozRwlw6eZ4pYusOYK6mh8yqbobpGT4kCpUjwPipY5njL3ciXFaioR+oWjc 0Sp/KiS3JCAV+tYpeEoOFLNlKEuXOza/SEdLk4Ab7vV1+0qk8Yqif+1L4k03vUfxvw3/ibN4h Up6/8StUeuUdBKhXJWMDeIGs9sXt+uBb7Sk460PCwcNCAUFpvAk5vCpqyi5LmzouHBIsGDfVi Uw1qmlHI2vjXlgI6YRNmQJk7rnB080ZvflLDVfDwbioQ9RXOneuFZerEiRLury2NsqVXVEJL7 hLDHg= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > it's posible to rewrite the query to: > > > test=3D# explain analyse select count(*) from foo_bar_baz as fbb where f= oo_id =3D (select foo_id from foo where foo_name =3D 'eeny'); > > I know, that's not a solution, but a workaround. :-( Yes, I discovered that as well. But I'm more confused (or concerned) by the fact that the (original) query= works correctly *without* statistics. Thomas