Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jSQmS-00084J-Jf for pgsql-performance@arkaria.postgresql.org; Sat, 25 Apr 2020 19:48:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jSQmR-0006NY-FU for pgsql-performance@arkaria.postgresql.org; Sat, 25 Apr 2020 19:48:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jSQmR-0006NQ-8D for pgsql-performance@lists.postgresql.org; Sat, 25 Apr 2020 19:48:03 +0000 Received: from mail-wm1-x341.google.com ([2a00:1450:4864:20::341]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jSQmL-0005Tg-BU for pgsql-performance@lists.postgresql.org; Sat, 25 Apr 2020 19:48:02 +0000 Received: by mail-wm1-x341.google.com with SMTP id v4so12675883wme.1 for ; Sat, 25 Apr 2020 12:47:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:references:to:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=Zn2uGsOnewn/U8dJ8fDzbmrHunkCLk4K5AUCIttuVBs=; b=Zox6qCie/hOjjsysBvc2R3C/ApI0pUjHPTADDgRLWG3PbT+F3XqoKh5PfA/GfVS0Jv ljcwYtClUuwjL+GZhXzBesK5h0ISlftGWyoRZwbcjjSyXCMgviDT4VsKei6Q3PnFTUcL OJ34FDnbCNRrs1COqPW8BV7oilHJWL6FvVva+gOLYPay/GhyorITLCg8EKZpBOXCAos/ rQmsrdx3S45F8KedQbS0ATUkE/9HwgsA94+r9hdBkz5tJJps1jGD1zQC9BVkP96ZItsU jh9mDs+Bxt1+iXq31YnY9W3CclaWnLeXp+uJ4o8g7qCOAoXz80qXn+GkFoi1WfAZ5Bk6 jh8w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:references:to:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=Zn2uGsOnewn/U8dJ8fDzbmrHunkCLk4K5AUCIttuVBs=; b=mZSBNA9imzCVZovJ1cmgnMYpwHCfO39LqaXd9QAGJMjTMW1YvQRNoIyIS2mO7wKT0d YU/Fp14ZP16Z1XQ6rX6d0cB0GswD6uPZYRBVfVu1EEtPx429d0IXKxM/EzQ6w05F0IfX a5FH8smFpmewF55s7Rhf+IgNaJBWwZbyOkoGNp7sVOgvvkYTStcVAZcj6wRnmNjhFwn4 CWzcUqxiP0wweH/na4z1AHDXDEuKhB7zIPZnv+kkmH3SqvBib0hCeMMTdMS4HSjYOwBX dAH4L0OdOF3r8imxSdJwG/+T0TgFYz3wBOgdSnN1cO+ayiZPG4DZYBXrWsj2YmlhWFmn IEFQ== X-Gm-Message-State: AGi0Pua5TQIiZJmwoIan0kdx7I5U4wvasNQio5hAQyMtiwkBLa/dW4N0 w8jQb4YoVj8gnkPuJHRXDP4T7beytPs= X-Google-Smtp-Source: APiQypLNEggh6xfM7NLrPIk09OfWzgce00o5Egjo96n5/ZCJnsEye24hkv6z3duY0FHeCCcRrEGB7Q== X-Received: by 2002:a1c:96c6:: with SMTP id y189mr18321814wmd.106.1587844075663; Sat, 25 Apr 2020 12:47:55 -0700 (PDT) Received: from [192.168.2.100] (32.red-80-39-211.dynamicip.rima-tde.net. [80.39.211.32]) by smtp.googlemail.com with ESMTPSA id b22sm7762699wmj.1.2020.04.25.12.47.53 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 25 Apr 2020 12:47:54 -0700 (PDT) Subject: Re: PostgreSQL does not choose my indexes well References: <20200425120246.GP13712@tamriel.snowman.net> To: pgsql-performance@lists.postgresql.org From: Arcadio Ortega Reinoso X-Forwarded-Message-Id: <20200425120246.GP13712@tamriel.snowman.net> Message-ID: <3dab8d3f-8567-c9d1-0fe6-d440e4099ccd@gmail.com> Date: Sat, 25 Apr 2020 21:47:52 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.7.0 MIME-Version: 1.0 In-Reply-To: <20200425120246.GP13712@tamriel.snowman.net> Content-Type: multipart/mixed; boundary="------------EC0091467BDE26C028C594A2" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------EC0091467BDE26C028C594A2 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit I'm also wondering exactly which Postgres version this is. Also a good question. Thanks, Stephen postgresql-12/bionic-pgdg,now 12.2-2.pgdg18.04+1 amd64 [instalado] postgresql-client-12/bionic-pgdg,now 12.2-2.pgdg18.04+1 amd64 [instalado, automático] postgresql-client-common/bionic-pgdg,bionic-pgdg,now 213.pgdg18.04+1 all [instalado, automático] postgresql-common/bionic-pgdg,bionic-pgdg,now 213.pgdg18.04+1 all [instalado, automático] postgresql-doc-11/bionic-pgdg,bionic-pgdg,now 11.7-2.pgdg18.04+1 all [instalado] --------------EC0091467BDE26C028C594A2 Content-Type: application/pgp-signature; name="signature.asc" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="signature.asc" LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcgdjEKCmlRSWNC QUVCQ2dBR0JRSmVwQ2JtQUFvSkVPMXNpamlEUjJSVk5SY1FBTEcxWUdHbC93MVJ4SjhQTTdI NUN6dWMKUzJTbm93ajhZQmJlYnhuVmRjQWdEaFJaOFVjWm9KbHNwMEpWbDBDMytFZjc1emFr bjk3R1dSdFB1UjV3SEFlMgpVcXhiVGpYcFBMZ3Y2cXVkVE5KUWZVUHJTdDJxckJ5QWh3UHdt QnBVTzlWTEMyOTAyRzAyTVQyVE1sQSs4TzgyClQ4VkhzdkMzbzdFNE9Ib1puY0xuUU9aVHZN WVUxaXk1V3M3bzRZSWk4b0ZKNm9yMGtmekNBbzlTdTFGTHhSK0IKUm0wWHNDaDdNOHJiMTJN SW5VRkE5NTZZL2tBMjVXQWx0WUVTRUFYYzhldFN1Ty8xcFBKSEtPbE9UQXhDNDh0bQpPb2dQ SjdDSFZzNzdHVVhleDAzRmNwQjhjeWdhS1JITXNISk1VSUYvVy9GbDhhZk51UnlveHhoWDk3 T1cwMS96ClFqcC91Z25aYXNPTUs1YmU3bE14MkswdXFHaDFzTGFVbHVyYzE5SlJQanFwR2hu OW5CZDZRSSt4WmUyUGlKSzEKeVYxOTcvUkhDZTVwRVo4M0ZZYXhyVzJhTGRLaVRZL29CR3Ju UnZsa1NETWh0OTIxWWJRc0Z3cEpUaEdzZlZtdApaekJOeUN6N1ZKcFFoQWxWSlpLZVlUZnJo RUhWZUlPeC9vZ3IwL2tSWGJJY1JUaW9VY3IrQjBTSXlQaXkvWDlnCjVxMHQvZkgzR0dpZkdp SFA4VE5HeERJV3gyS0d0ZGtTcHNoeHdlWEl2RVZ4NisybEY1emRya0tyMGpBL1kvMkQKSDhR NDRCL0p5SCtWM2FwLzVIYTZ4SHg3aFlDV3kya25zUUxFSEZQWTFpT21UNVZyQWwyTzVhU1Bp Q0xCVytORgpCYnNHVGplWlY5ZktDK3dNQnU0awo9WHFudwotLS0tLUVORCBQR1AgU0lHTkFU VVJFLS0tLS0KCg== --------------EC0091467BDE26C028C594A2--