Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZrH5g-0002hJ-T9 for pgsql-performance@arkaria.postgresql.org; Wed, 28 Oct 2015 03:07:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZrH5f-0004Wz-Uu for pgsql-performance@arkaria.postgresql.org; Wed, 28 Oct 2015 03:07:55 +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_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZrH5f-0004Wh-9B for pgsql-performance@postgresql.org; Wed, 28 Oct 2015 03:07:55 +0000 Received: from mail-by2on0093.outbound.protection.outlook.com ([207.46.100.93] helo=na01-by2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZrH5b-0008N3-8K for pgsql-performance@postgresql.org; Wed, 28 Oct 2015 03:07:54 +0000 Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.attlocal.net (2602:306:ce8b:3460:505:133b:5569:d170) by CY1PR11MB0683.namprd11.prod.outlook.com (10.163.236.21) with Microsoft SMTP Server (TLS) id 15.1.312.18; Wed, 28 Oct 2015 03:07:46 +0000 Subject: Re: Query planner wants to use seq scan To: Bertrand Paquet , Tom Lane References: <21872.1445947392@sss.pgh.pa.us> CC: "pgsql-performance@postgresql.org" From: Jim Nasby Message-ID: <56303BFA.4010003@BlueTreble.com> Date: Tue, 27 Oct 2015 22:07:38 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [2602:306:ce8b:3460:505:133b:5569:d170] X-ClientProxiedBy: CO2PR18CA0017.namprd18.prod.outlook.com (25.161.80.27) To CY1PR11MB0683.namprd11.prod.outlook.com (25.163.236.21) X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0683; 2:t1QyCKSezXWa1TUPRZatiQvTIp19Gct1sAw5VC/sGASMhauVQBaV2JeiW5XQxfyeRxqgX1xu0KHikaPzqONgulcB2PCtzLQ/l4Zu0WQCb8u2+Iv3//fRAGJqeOpDloXmj3P1RcuSR9HfwQ8YibkrUOYiSfQUDjJ+a/0QQWrYG7I=; 3:dIFiX0NgoukVaKZuyXTp9oi/3woPW9dJDOQCKNeuKCCz+7kUuKuuxljNCHTxeGSezdB9ayym1HBrHdpzrdXQxlLVu9rojRiH2THw8Bq12dr9pCEmRFW3vrhIT6IP0vj11fS1dlSEldmjRtOHX/558A==; 25:CcRsBTtQQT6D9oGrAhLLXBQYeum8HcahBpp3h4O7ApYPZ6p5O4AanDS7qwJt3WlrCbR5BJks4bwJUSR5I34GHqvIt8+oxUQ+xXcwHyQ8eYtyJEnUV+bBsOXH8CiCjFgKs4pQ2GPt3lj2wOofnRYhL5/L/WDX2HplNPBswuqbkwpSqO9fsYhUp/BTkkUfGm981unTK5yMOPXtPKOGjH7RAMDM8SOQLIlsg231UvA55dVoYAdQYtazM1NzZ+xxQeM+ACvlii+A8Z/E6ppJVDKUPQ==; 20:wRcFJ1bRJUZr6W0igS+W8Wxc9GhS085q09NJdZA1hQUlCm9gzdVcBWBWQILpCWVWlmsZYnHvp+gwZR8wwTR9CZRR4wO5/jvTumCbW6PUralBk1EuWBRKnx/XmI4NHXpObzLQ+FHeT+7p3H1lB/+xjxO+sZfVN47iSFlkFDxmMxw= X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:CY1PR11MB0683; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:(184068855800151); X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004)(2401047)(520078)(5005006)(8121501046)(3002001)(102215026); SRVR:CY1PR11MB0683; BCL:0; PCL:0; RULEID:; SRVR:CY1PR11MB0683; X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0683; 4:FswGtjhc4h7s3MATSqPCKYUOFCGRziH1mhszsv5gw0VXVyIq9TqW2wxfV3xtySEEoQXAB3Zbyx3PlhRwSWaRNkBqSXzCenuUFLqBxhiBDP1yKSdEv0ihL17BourvI28SQCfdfJhPdGT1TeNqIjE2/mUJTsjoIkmbVVla6kbvR7u2WFPwx+joHqkbF9J8oLUx0U/vr+nWWYRY23v5xANfBJ6VG/15iGOT0gIaGeWmuZs/TOLaIUl+mxxFVBH0VQTKcRaJoXeh/EL+THP3sB0cD4hO4AhgupjTp8gqb+lcrs0Zt4km5WxcHnxxc05r+MZPeKmCHBVMrILJO985AX7GxEFh5DYOKuWtposg+P2YoabAv+824piTq4iq6jeaepIN X-Forefront-PRVS: 0743E8D0A6 X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(199003)(479174004)(24454002)(377454003)(189002)(99136001)(69596002)(5007970100001)(5004730100002)(83506001)(47776003)(65806001)(65956001)(59896002)(23676002)(33656002)(189998001)(92566002)(86362001)(15975445007)(97736004)(5001770100001)(4001350100001)(81156007)(77096005)(87976001)(2950100001)(5001920100001)(53416004)(40100003)(87266999)(5008740100001)(122386002)(93886004)(42186005)(64126003)(80316001)(105586002)(5001960100002)(36756003)(106356001)(19580395003)(76176999)(101416001)(65816999)(50986999)(50466002)(54356999)(3826002)(85282002)(336755003)(18886065003); DIR:OUT; SFP:1101; SCL:1; SRVR:CY1PR11MB0683; H:decina.attlocal.net; FPR:; SPF:None; PTR:InfoNoRecords; A:1; MX:1; LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtDWTFQUjExTUIwNjgzOzIzOmhaYWRyUENWbTZDQzNsUFhhWWJzK2tzNXBI?= =?utf-8?B?ZldMUTBXSjJHUk0rRlRldFNuUXFBWlBjVEFNNVlRQnYvdElsS3VETVRZdHhs?= =?utf-8?B?czJTbE1oOUxhY2svT2ZMS28zNklScHd6eDVnSEl3NnBuOTF1N3U5K3FQU2ZM?= =?utf-8?B?QWd1Q21EWjdTeVpZTys0LzlpZS9TZFZjRGVOZmJDYTlaY2d2S01saVZULzBt?= =?utf-8?B?T0p3dVp1UWJlb1pSYlRRcEtUQzZVVWczQnBUdWk3aTNybnN1VnpVMCtENFNP?= =?utf-8?B?Z0NjMDlsbEpPMlVwV3JWa3cvMEJTbWJidG1uMW1VWnRaeENhM0pxODJzWENz?= =?utf-8?B?Vk9JS2lPS1dsV0dab3VobnVnWWRwYThKU1B3bXlYa1d2M0ZtdVMvTEN3WnFK?= =?utf-8?B?bjJ5bHFRdGk0b0p2UEM0ZUoxL3RwMzJramRjL0l6Sk5HVlNJMjNMVi9aVHNX?= =?utf-8?B?bWY0MExYNlJ0WWR4bFJNM2VtVm9uQitwSkk3cmxOa0JrbHI4ZnBLSmN5Yk9Y?= =?utf-8?B?WmN4WktVTE1oUzVLcUhFV0xGQk5kR0JhYTVBVHhkOTBFZitvRk1mdTdwSVEz?= =?utf-8?B?R2VJd2tqMm1ERXdXYno4bGdlbDByWWo0RlYwaWlNaVRwRkJJTUdvVE5iVkRo?= =?utf-8?B?RS9Sbk9BWHY3YlhlTkg0NGxSZjFXRjloRGFzMThTR1BWbXZLRmxPMHhSa0ta?= =?utf-8?B?VjZsV3FEa0x5STE4K0hEeEs0YmNHZUNueHRRSXBXZWVaeWtJeWkyV2JNYjdn?= =?utf-8?B?bFBSV3hHallRc2RQK2ozdzF1MktVaDRRNG1mS0J6OEZPL1hNbU9oL2xNZ1JX?= =?utf-8?B?ZXZyZWhneGk4SzZtT1AwL0FxeWFVM21nc1c2VVVFRU9PWG5UZ1BnTEdsbnQ2?= =?utf-8?B?TUg1cVVWd3oxSEV5eWg2cWZ6Ym1pY0hBVjZ2NHQ3d2tBVU1Xckx3NnJ4eXlU?= =?utf-8?B?czFRVzJPMGo0VllGa2k0Sm8rT2UwZ1FxNEVMMmlpblcrSHExSU5sSmttM2JN?= =?utf-8?B?aSt0U0ZIdjRxTXA2SGlMQUowelEwMzhDNDhMQUV0R0JHemx6RXlaSGswcmlq?= =?utf-8?B?MGo2S0s0Y2NtSE1VQ0ova0VlTkducVYrM0ozUlBMWnU3Tmw1d2NQL0Q2L3Qy?= =?utf-8?B?Y3J3UEM2aWx1MFp6TCsyemZpeWIxSGxuSG1mUWs3YmYzUDN2WFJFT3pjWkNO?= =?utf-8?B?OTVsbGdYaVNlbWgzbTFxcXFJTjZZWTJOTlFUcFJLMFBJYXY4dGV5YmY2UjBV?= =?utf-8?B?MDVHUW5NYkViMks2dFhzL1lDTkNsKzdScGQ5dkN6WDJsMU1JVnU1em1UWWx2?= =?utf-8?B?TS9KSFlKZmp4UEJoSmN4d24xZHZrNXFXeS9MYTh1a09Lem9Ib1Y3L2tCUUUy?= =?utf-8?B?bkg0WmlmZ21RTnp4WU90VkFFMnZGcTJSY1VqM3JKTnE1c05KUEtnWEx3VVUw?= =?utf-8?B?Q040K2k1Sm9ZWHdIbi9zcU9kWm9QbHBxYWV3VFhqWGJEeVUrQW5JbHdmeERK?= =?utf-8?B?c0s1eXV6dWN3ZVBWM3g2STZ6MkFBeXZsb1ZBczA0QVUxczdWWm0raUJZLzly?= =?utf-8?B?bEswZTErdjVDWGQzNjRQSUtRSHZKcWQwQUlJQ29DOWFybjJLVTFYSk1Qb0Z2?= =?utf-8?B?Q2Y3Si9XdDAxVTB4R3VodjFGR2YzOXhnMW9wdTNzWUF3R2kzbnNkUUFqOWdD?= =?utf-8?B?OUh2SHFUTEFPWFN4YWorZmI4NS9uQzRVd3pxZTRIMGpSRXBKTUkvVXdUUGor?= =?utf-8?B?cEo3bUduaUhSdTV0WWJ1K2t0L21KbFIvMjJuK1N3d0NyRGg4cTU3ZEtURTho?= =?utf-8?B?T0xLT3ltckFKL0JsaW1OZ2JTVkhZSFJnSHZZZ2NlWFRiSmdhOGFDRkwxS3hy?= =?utf-8?Q?E+2G/0cF5a985Ah6hLo3f17m/fjcSR0Z?= X-Microsoft-Exchange-Diagnostics: 1; CY1PR11MB0683; 5:vj+YSKJYZ8Opb9yVFK4qUqD8bHz3ZKrzvQEBWmF6ojp1HFae79cRn7JDGcH3mYqltm3uN01AUjGhD5RwxHroYRRu0JyGU+L+2W3R7oNgI9XypKSlClPcyGluf3YxL9FVstJcyo062YmEudKmA7jMmQ==; 24:pXtOUG9BRbodopwnNP/CGxD10HqAeBH1iOEqYD8A5cKvPfbY37VdzO7ZCxaMh5vq1573ntjmCG0t+LspX27R+LuzvYIKRpjiRTo+k6sXJnw=; 20:k+IlS+HElDuamhR9JfihRbTeYCAIJha3pcj3XT2ASkHuKUJvhYoblPtdmWIDwN94hSA2X7ACZC9SzejlY/zN4Q== SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 28 Oct 2015 03:07:46.0361 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY1PR11MB0683 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 10/27/15 3:56 PM, Bertrand Paquet wrote: > Tonight, the index on the three field is used, may be my yesterday > vacuum updated stats. BTW, you can run just ANALYZE, which is *far* faster than a VACUUM on a large table. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance