disk access measurment

[monu agrawal]

Is there any way to find out how much time & how many disk accesses a transaction has taken ?

Make your own way.
Monu Agrawal
http://people.csa.iisc.ernet.in/monu
Indian Institute of Science
Bangalore
(91)9844090061

[Bruce Momjian]

monu agrawal wrote:

Is there any way to find out how much time & how many disk
accesses a transaction has taken ?

You can start the backend with -ta and it will show disk block accesses
for every stage. The statistics system shows block access information,
but not broken down per transaction.

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend