timing in PostgreSQL

Поиск
Список
Период
Сортировка
От Carlos Chacon
Тема timing in PostgreSQL
Дата
Msg-id 34ebda740703291423q683905d3y8bfb95a96049d1e2@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hi, i need you help Postgres gurus...<br /><br />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....<br /><br />My first approach was
touse the function clock() of the time.h C library, in the postgres.c file.... but reading the file, i noticed that<br
/>youcan set a group of options that print statistics (generals or specifics to postgres modules, in the stdin) for
eachquery that you send to postgres Server... <br />So, i did it...<br /><br />Now, i don't have a clue how interpreter
whatpostgres print.... i search in the postgres manual but i find nothing about it....<br /><br />Now, where i can find
informationabout how to read this statistics??? (this sound a pg_admin question but read the second one) <br /><br
/>And,those times are exclusive postgres times, or they include the expended time of postgres in process the query,
plusthe time that postgres waits when there are other process running in the SO (you kwon, multi tasking)??? <br /><br
/>Bythe way, is this a good approach, or i will have to take the first approach that i mentioned???<br /><br
/>Thanks.<br/><br />Waiting your answers, <br />Carlos Chacon.<br /><br /><br /> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: [JDBC] problems with plan invalidation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CREATE INDEX and HOT - revised design