timing in PostgreSQL

From: "Carlos Chacon" <cdcarloschacon(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: timing in PostgreSQL
Date: 2007-03-29 21:23:01
Message-ID: 34ebda740703291423q683905d3y8bfb95a96049d1e2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, i need you help Postgres gurus...

I have been modified postgres for a while... and i need to test the
performance (for now, only time) of my modifications against the original
postgres....

My first approach was to use the function clock() of the time.h C library,
in the postgres.c file.... but reading the file, i noticed that
you can set a group of options that print statistics (generals or specifics
to postgres modules, in the stdin) for each query that you send to postgres
Server...
So, i did it...

Now, i don't have a clue how interpreter what postgres print.... i search in
the postgres manual but i find nothing about it....

Now, where i can find information about how to read this statistics??? (this
sound a pg_admin question but read the second one)

And, those times are exclusive postgres times, or they include the expended
time of postgres in process the query, plus the time that postgres waits
when there are other process running in the SO (you kwon, multi tasking)???

By the way, is this a good approach, or i will have to take the first
approach that i mentioned???

Thanks.

Waiting your answers,
Carlos Chacon.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-03-29 21:27:14 Re: CREATE INDEX and HOT - revised design
Previous Message Kris Jurka 2007-03-29 21:16:42 Re: [JDBC] problems with plan invalidation