From: | Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Time Stamp |
Date: | 2005-03-21 16:38:37 |
Message-ID: | 829d7fb60503210838151a6e74@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)archonet(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Miles Keaton | 2005-03-21 17:33:27 | PostgreSQL users, tell your tale on Slashdot |
Previous Message | Michael Fuhr | 2005-03-21 16:15:55 | Re: PHP and Postgres setup |