| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Michael Malis <michaelmalis2(at)gmail(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Highly Variable Planning Times |
| Date: | 2017-04-19 22:12:21 |
| Message-ID: | 20170419221221.jlzipgysi53d3s73@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-04-19 22:24:15 | Re: Unportable implementation of background worker start |
| Previous Message | Tom Lane | 2017-04-19 22:04:07 | Unportable implementation of background worker start |