Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2011-10-11 19:15:58
Subject: Re: postgresql query runtime
Previous:From: Szymon GuzDate: 2011-10-11 19:13:04
Subject: Re: postgresql query runtime

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group