timing a process
timing a process
От:
"Zhang, Anna" <azhang@verisign.com>
Дата:
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
Re: timing a process
От:
"Florian Helmberger" <f.helmberger@uptime.at>
Дата:
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