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

performance: time & disk access measurment

P: n/a
Is there any way in pgsql to measure that how much time a transaction has taken & how many disk accesses it has performed.

#############################################
# Monu Agrawal #
# Indian Institute of Science #
# Bangalore #
# E-25 #
# 91-80-2932432 #
#############################################
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Le Samedi 8 Novembre 2003 17:38, monu agrawal a écrit :
Is there any way in pgsql to measure that how much time a transaction has
taken & how many disk accesses it has performed.


You can use pgAdmin3 (http://www.pgadmin.org) SQL editor for transaction time.
Now, if you are using WAL with enough shared memory, it is likely there will
be little disk access other than flushing data to disk from time to time.

Cheers,
Jean-Michel
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.