Hi,
I want to know how long did it take for my query to run!
Thanks,
Hrishi
On Mon, 21 Mar 2005 15:57:38 +0000, Richard Huxton <dev@archonet.com> wrote:
> 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
>