Re: [GENERAL] Is it possible to measure IO costs of a query in

2005-01-16 Thread Tzahi Fadida
ent: Sunday, January 16, 2005 5:44 AM > To: Tzahi Fadida > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Is it possible to measure IO costs of > a query in postgreSQL? > > > On Sat, Jan 08, 2005 at 08:01:51PM +0200, Tzahi Fadida wrote: > > > I have been tryi

Re: [GENERAL] Is it possible to measure IO costs of a query in postgreSQL?

2005-01-15 Thread Michael Fuhr
On Sat, Jan 08, 2005 at 08:01:51PM +0200, Tzahi Fadida wrote: > 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 es

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

2005-01-08 Thread Tzahi Fadida
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 t