Home > mailing lists

Profiling PostgreSQL - Mailing list pgsql-performance

From	Dimitris Karampinas
Subject	Profiling PostgreSQL
Date	May 22, 2014 16:27:33
Msg-id	CAC_Q3NwxzpZ41iByo8PKvROT4BbZRedCuJZGBVFsg-iGvCivFg@mail.gmail.com Whole thread Raw
Responses	Re: Profiling PostgreSQL Re: Profiling PostgreSQL
List	pgsql-performance

Is there any way to get the call stack of a function when profiling PostgreSQL with perf ?

I configured with --enable-debug, I run a benchmark against the system and I'm able to identify a bottleneck.

40% of the time is spent on an spinlock yet I cannot find out the codepath that gets me there.

Using --call-graph with perf record didn't seem to help.

Any ideas ?

Cheers,

Dimitris

From: Geoff Hull
Date: 21 May 2014, 02:06:58
Subject: Re: View has different query plan than select statement

From: David Boreham
Date: 22 May 2014, 16:34:41
Subject: Re: Profiling PostgreSQL