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

From: Tzahi Fadida <tzahi_ml(at)myrealbox(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is it possible to measure IO costs of a query in postgreSQL?
Date: 2005-01-08 18:01:51
Message-ID: 01b001c4f5ac$24be5550$0b00a8c0@llord
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2005-01-08 18:26:55 Re: J2SE 1.5 Cache Rowset(JSR 114 )
Previous Message Tom Lane 2005-01-08 17:56:45 Re: ERROR: cache lookup failed for type 0