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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I managed to install postgresql10-debuginfo:
[root@kvrh7os202 /]# yum install -y postgresql10-debuginfo.x86_64

Executed perf-record and perf-report:
-bash-4.2$ perf record -g -- psql -U sri sri < /var/lib/pgsql/10/data/pg_log/1-b10/query.txt
< ... snipped ... >
 Planning time: 1817.355 ms
 Execution time: 31.849 ms
(480 rows)

[ perf record: Woken up 1 times to write data ]
[ perf record: Captured and wrote 0.025 MB perf.data (136 samples) ]
-bash-4.2$
-bash-4.2$ perf report -g > perf_report_20181105_1452.out

Please refer to the attached for the perf report output (not sure if it was done correctly).

Regards,
Richard Lee

On Mon, Nov 5, 2018 at 12:10 PM Justin Pryzby <pryzby@xxxxxxxxxxxxx> wrote:
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

Attachment: perf_report_20181105_1452.out
Description: Binary data


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux