Re: [HACKERS] Highly Variable Planning Times - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [HACKERS] Highly Variable Planning Times
Date
Msg-id 20170419221221.jlzipgysi53d3s73@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] Highly Variable Planning Times  (Michael Malis <michaelmalis2@gmail.com>)
List pgsql-hackers
On 2017-04-19 14:14:54 -0700, Michael Malis wrote:
> > Could you also get a profile using perf record -g?  The strace isn't
> > telling us all that much.
> 
> I've attached the perf.data file from `perf record -g -p
> <backend-pid>`. I'm not that familiar with perf so if there is more
> information you need let me know. This was on Ubuntu 16.04

You'd have to do a perf report > outfile.txt too, without your system we
can't analyze the perf.data.

https://wiki.postgresql.org/wiki/Profiling_with_perf

- Andres



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: [HACKERS] Unportable implementation of background worker start
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Unportable implementation of background worker start