Re: postgresql query runtime

From: Pavel Stehule <pavel(dot)stehule(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:11:58
Message-ID: CAFj8pRDTiuXx2QeTKG4QGfkXCpjEGCW-StXCNz6Wyz=qO-EwKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2011/10/11 Radhya sahal <rad_cs_2006(at)yahoo(dot)com>:
> 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.
>

Hello

use

\timing

\? is your friend :)

Regards

Pavel Stehule

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Szymon Guz 2011-10-11 19:13:04 Re: postgresql query runtime
Previous Message Radhya sahal 2011-10-11 19:08:31 postgresql query runtime