Re: Fwd: Query with high planning time compared to execution time

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Richard Lee <swift1984(at)gmail(dot)com>
Cc: tomas(dot)vondra(at)2ndquadrant(dot)com, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Fwd: Query with high planning time compared to execution time
Date: 2018-11-05 04:10:09
Message-ID: 20181105041009.GY25283@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Lee 2018-11-05 07:04:29 Re: Fwd: Query with high planning time compared to execution time
Previous Message Richard Lee 2018-11-05 03:36:46 Re: Fwd: Query with high planning time compared to execution time