Re: Profiling postgres

From: Sushant Sinha <sushant354(at)gmail(dot)com>
To: suresh(at)cse(dot)iitb(dot)ac(dot)in
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Profiling postgres
Date: 2008-07-28 02:06:50
Message-ID: 1217210810.9777.1.camel@dragflick
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Wilson 2008-07-28 04:18:16 copy ... from stdin csv; and bytea
Previous Message Steve Martin 2008-07-27 23:18:33 Re: Substitute a variable in PL/PGSQL.