On Feb 19, 2009, at 9:40 AM, SHARMILA JOTHIRAJAH wrote:
--- On Thu, 2/19/09, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Subject: Re: How to pipe the psql copy command to Unix
'Date' command
To: sharmi_jo@xxxxxxxxx
Cc: "General postgres mailing list" <pgsql-general@xxxxxxxxxxxxxx>
Date: Thursday, February 19, 2009, 12:31 PM
SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx> writes:
Hi,
I want to find the time taken by this process
...retrieving data from oracle database using java and
copying that to postgres using copy.
So I need something like this
Start_Time|java testCode ...|psql -c "copy dummy
from stdin with delimiter ',' null
'NULL'" test| End_time
time java testCode ...|psql -c "copy dummy from stdin
with delimiter ',' null 'NULL'" test
Or do you really insist on doing the timestamp subtraction
by hand?
No...I would definitely prefer to get the time elapsed between the
start of the java program and the end of the copy command... Is that
possible ? If not at least the start and the end time so tht i can
do the calculation myself
Tom just showed you how. Use run full piped command with the unix
'time' utility.
Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
