By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,178 Members | 987 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,178 IT Pros & Developers. It's quick & easy.

disk access measurment

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 | (610) 359-1001
+ 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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.