Is it possible to measure IO costs of a query in postgreSQL?

Поиск
Список
Период
Сортировка
От Tzahi Fadida
Тема Is it possible to measure IO costs of a query in postgreSQL?
Дата
Msg-id 01b001c4f5ac$24be5550$0b00a8c0@llord
обсуждение исходный текст
Ответы Re: Is it possible to measure IO costs of a query in postgreSQL?  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
I have been trying for a week now without success to discover
if you can measure the cost of a query (with my c function).
EXPLAIN ANALYZE seems to give you the actual time it took it
to run but the "cost" seems to be a fixed estimate number and not
actual. I see in the code many times references to pgstats so
i figure there must be some kind of accounting.
Does anyone have a clue on this? its very important to me
to be able to measure scientifically the costs of a query.
10x.

Regards,
    tzahi.

WARNING TO SPAMMERS:  see at
http://members.lycos.co.uk/my2nis/spamwarning.html



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: cache lookup failed for type 0
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: J2SE 1.5 Cache Rowset(JSR 114 )