Re: Profiling postgres - Mailing list pgsql-general

From Sushant Sinha
Subject Re: Profiling postgres
Date
Msg-id 1217210810.9777.1.camel@dragflick
Whole thread Raw
In response to Profiling postgres  (Suresh <suiyengar@yahoo.com>)
List pgsql-general
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
>
>
>
>


pgsql-general by date:

Previous
From: Steve Martin
Date:
Subject: Re: Substitute a variable in PL/PGSQL.
Next
From: "David Wilson"
Date:
Subject: copy ... from stdin csv; and bytea