Re: Profiling postgres

configure postgres with the following options

1. ./configure --enable-profiling
2. make and make install
3. start psql and issue the query
4. gmon.out will be in the data directory once you exit from psql

-Sushant.

On Sun, 2008-07-27 at 05:55 -0700, Suresh wrote:
>
> Hello,
>
> I want to profile some functions in postgres using gprof. I am
> following this procedure listed in nabble forum.
>
> # cd postgres/bin
> #  cd .../src/backend
> #  make clean
> #  make PROFILE="-pg" all
>
> How to proceed after this ? I am not getting the gmon.out file. How do
> I run ./postgres test under the profiler ?
>
> thanks and regards,
> Suresh
>
>
>
>