Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gJWDZ-0001F6-55 for pgsql-performance@arkaria.postgresql.org; Mon, 05 Nov 2018 04:10:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gJWDW-0004YL-BG for pgsql-performance@arkaria.postgresql.org; Mon, 05 Nov 2018 04:10:22 +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.89) (envelope-from ) id 1gJWDW-0004Y5-0c for pgsql-performance@lists.postgresql.org; Mon, 05 Nov 2018 04:10:22 +0000 Received: from mail-it1-x12c.google.com ([2607:f8b0:4864:20::12c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gJWDO-0003Xg-Lw for pgsql-performance@lists.postgresql.org; Mon, 05 Nov 2018 04:10:21 +0000 Received: by mail-it1-x12c.google.com with SMTP id r12-v6so8096645ita.3 for ; Sun, 04 Nov 2018 20:10:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=FLUhvViM8hr9MsXhrpVmuZAsREHYuEnp/QTg4qNrbGg=; b=fv9pxv3LlNwOsEpIZ7TP2cMSr31+8+RHEwL7g2QCxv0mcQdXbDD1HS51E7k5ng0Tc6 rXph+H4NgfSqtcAlWGrkZ/5CtUH2LnLg8bzLWKUobNvI2NkcEVA2+72GE38mQ6uSxfCC zf/0rr6EiESgH20UmBr7WRZEQSluvMr3Ipll+ETOLqZfEQjioSyjiEkd7r6JSE5qal2C rRZsk7SrWdgZNgCJnAuu9Bt8Yl9fYkIdTbzRaBFYsc1QR3aHGPvcZfyEbEKHBxwmkkx0 azAueZcX4RE9WnsuOK4CcUpgKBK4OIItDxl9hehdV/4R5/fXLwdbkbVARsSh8/lvr66n 5LgA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=FLUhvViM8hr9MsXhrpVmuZAsREHYuEnp/QTg4qNrbGg=; b=W3g/mqq1RE9PeELo82RDYxIT2kLJfxUb19SDGQv45/wDiLCZ74pfc9bG9bgQBcQ0EN edJsMmjMC+RYB+gwHWhsVEOgSty6Rb5vsXOJHdjGfv5MlT9RQ3y1//oAxuA+9iHCUcz9 oNksjWUmT5oPB4NBOAZYXXbc884D0XbUHuS6MrxROasdg0q92vH3OIegjnqYIxEEwd9x 4//rJZYpDZ++NU7rvwBbVg9L/hSZVjp+uU/Xvrvb0l1ISugT7XSDp1XxgO/NPva9TRcf N6kzIH+vMqUaK6DF8DFZVZGiqmRsRjOsWAeHgsCzKjOsmJWNVC5f53HhRPdPWtPMFdQ/ jK4A== X-Gm-Message-State: AGRZ1gK/zLcEdOvMOy4An8gMNLmieDKQ4gnbhZkkkk41a8BghY4/Bvax M8r6IgVSU3UX1KRckSfcccVSQg== X-Google-Smtp-Source: AJdET5cYUff3uCTLBG/Mf6GdW+DFmqlXEPFLHRznlYRVErdgO8auUoa9wMZjNW14ZCwPzFKu2VgU9w== X-Received: by 2002:a24:62cf:: with SMTP id d198-v6mr5875454itc.162.1541391011541; Sun, 04 Nov 2018 20:10:11 -0800 (PST) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id n3-v6sm9928037iob.13.2018.11.04.20.10.11 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 04 Nov 2018 20:10:11 -0800 (PST) Received: by pryzbyj (Postfix, from userid 1000) id 025F5804FC9; Sun, 4 Nov 2018 22:10:09 -0600 (CST) Date: Sun, 4 Nov 2018 22:10:09 -0600 From: Justin Pryzby To: Richard Lee Cc: tomas.vondra@2ndquadrant.com, pgsql-performance@lists.postgresql.org Subject: Re: Fwd: Query with high planning time compared to execution time Message-ID: <20181105041009.GY25283@telsasoft.com> References: <8db7abc2-9ddf-858c-e3db-af014cf2ccd9@2ndquadrant.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, Nov 05, 2018 at 11:36:46AM +0800, Richard Lee wrote: > Hi, > > Debug symbols can only be enabled during configure? How about when > Postgresql is running? If you're running from RPMs (maybe from yum.postgresql.org), you can install postgresql10-debuginfo (maybe using: "debuginfo-install postgresql10"). Just be sure it installs the debuginfo for exactly the same RPM (rather than installing a new minor version, for example). If you compiled it yourself, you can probably point GDB to the un-stripped binaries. Again, assuming you have binaries from exactly the same source version, no additional patches, etc. Justin