Re: Time Stamp - Mailing list pgsql-general

From Richard Huxton
Subject Re: Time Stamp
Date
Msg-id 423EEEF2.1010800@archonet.com
Whole thread Raw
In response to Time Stamp  (Hrishikesh Deshmukh <hdeshmuk@gmail.com>)
Responses Re: Time Stamp
List pgsql-general
Hrishikesh Deshmukh wrote:
> Hi All,
>
> I want to get a "timestamp" of the queries that i run!
> Is there a builtin command to do this/ does one need to write a
> function/stored procedure!
> Any pointers will help.

You don't say where you want this "timestamp".

In psql look into "\timing" (see the man page)
To record this in the logs, see the configuration section of the manual,
specifically "Error Reporting and Logging"

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Time Stamp
Next
From: Stephen Howie
Date:
Subject: Re: Help with transactions