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 1giLVL-00006G-Ou for pgsql-performance@arkaria.postgresql.org; Sat, 12 Jan 2019 15:47:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1giLVI-0001yo-JB for pgsql-performance@arkaria.postgresql.org; Sat, 12 Jan 2019 15:47:20 +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 1giLVI-0001yh-Az for pgsql-performance@lists.postgresql.org; Sat, 12 Jan 2019 15:47:20 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1giLVA-0004wI-As for pgsql-performance@postgresql.org; Sat, 12 Jan 2019 15:47:19 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 6BE10115ECD1F for ; Sat, 12 Jan 2019 08:47:09 -0700 (MST) Date: Sat, 12 Jan 2019 08:47:09 -0700 (MST) From: Jim Finnerty To: pgsql-performance@postgresql.org Message-ID: <1547308029438-0.post@n3.nabble.com> In-Reply-To: References: Subject: Re: Detect missing combined indexes (automatically) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk By the term 'combined indexes', do you mean a multi-column index, or a set of single-column indexes that need to be combined by the planner? What methodology are you using to recommend missing indexes? You may be able to enlist help from more people if you provide a specific example of a query that you have that isn't performing well (with the explain (analyze, verbose, buffers) plan on https://explain.depesz.com/), the index(es) that improve performance (with the plan on https://explain.depesz.com/), and the 'single index' tools / methodology that you're currently using to suggest missing indexes. /Jim F ----- Jim Finnerty, AWS, Amazon Aurora PostgreSQL -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html