Re: timing a process - Mailing list pgsql-admin

From Florian Helmberger
Subject Re: timing a process
Date
Msg-id OPEOLKEAAIMGBAMJNACKAEPADHAA.f.helmberger@uptime.at
Whole thread Raw
In response to timing a process  ("Zhang, Anna" <azhang@verisign.com>)
List pgsql-admin
Hi.

You can try something like this:

  time psql template1 postgres -c "select usename from pg_user"

Cheers,
Florian

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Zhang, Anna
> Sent: Wednesday, January 23, 2002 10:25 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] timing a process
>
>
> Hi All,
>
> I like to know how to timing a process? like in oracle sqlplus, we can set
> timing on, then execute a statement, such way we can know how long the
> process takes. In psql, is there such feature?
>
>
> Anna Zhang
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


pgsql-admin by date:

Previous
From: Luis Amigo
Date:
Subject: Re: Maximum Performance
Next
From: Radu-Adrian Popescu
Date:
Subject: Max. connections & overload