Обсуждение: 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

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