acquisition_duration in select * from cur;

dimitri_p

Hi,

select * from cur;

displays currently executed queries and there are two columns: acquisition_duration and transaction_duration.

Usually the two are very close like this

acquisition_duration = 42min 4 sec
transaction_duration = 42min 5 sec

but sometimes acquisition duration is smaller, like

acquisition_duration = 34min
transaction_duration = 42min

how do I interpret this?

would that mean the second transaction held the resources for 8 minutes less because it was sitting in the queue waiting to get them for 8 minutes?