Re: postgresql query runtime

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Radhya sahal <rad_cs_2006(at)yahoo(dot)com>
Cc: pgsql-performance group <pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgresql query runtime
Date: 2011-10-11 19:14:46
Message-ID: CAFjNrYtYc0xKssKm+WEVZ7xx0f9gvOCo-bwGjjt5kuUh5NDwaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 11 October 2011 21:13, Szymon Guz <mabewlun(at)gmail(dot)com> wrote:

>
>
> On 11 October 2011 21:08, Radhya sahal <rad_cs_2006(at)yahoo(dot)com> wrote:
>
>> Hi
>> I want to know how can i measure runtime query in postgresql if i use
>> command line psql?
>> not explain rutime for the query such as the runtime which appear in
>> pgadmin ?
>> such as Total query runtime: 203 ms.
>>
>
>
> run this in psql:
>
> \t
>
> regards
> Szymon
>

yes... \timing of course... I think I shouldn't send emails when I've got a
fever :)

- Szymon

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2011-10-11 19:15:58 Re: postgresql query runtime
Previous Message Szymon Guz 2011-10-11 19:13:04 Re: postgresql query runtime