performance: time & disk access measurment
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 #
#############################################
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