SQL Transaction running time

> How do I find out how long an SQL transaction has been running ?
> 
> I realise that the information can only be available whilst the
> transaction is still processing but where
> can I get it from


Hi Owen,

    The simplest way is to submit your transaction with a \t\p\g\t command.
    This will (in order) \t print the start time
                         \p print the transaction sql statement(s)
                         \g execute the transaction
                         \t print the end time of the transaction.

   Martin Bowes

Ingres Q & A

Back to William's Home Page

Email William