show time consumed by query in psql

From: "Willy-Bas Loos" <willybas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: show time consumed by query in psql
Date: 2008-02-13 09:22:29
Message-ID: 1dd6057e0802130122n32ff8612j13312fc0f219b49d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I´m on a slow internet connection, but i want to optimize a view on a
server. I have console access, so psql seems the right way - pgAdmin from
the client is just way biassed.
How can i make psql report the amount of time that was consumed in the
query??
I´ve seen a couple of posts that refer to this, but everyone seems to solve
it in some other way. Is this not a feature of psql? (it should be!)

thx

WBL

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Wilson 2008-02-13 09:35:11 Re: Storing images as BYTEA or large objects
Previous Message Masse Jacques 2008-02-13 09:19:51 Re: dynamic crosstab