On Feb 19, 2009, at 9:40 AM, SHARMILA JOTHIRAJAH wrote:
--- On Thu, 2/19/09, Tom Lane <[email protected]> wrote:
From: Tom Lane <[email protected]>
Subject: Re: [GENERAL] How to pipe the psql copy command to Unix
'Date' command
To: [email protected]
Cc: "General postgres mailing list" <[email protected]>
Date: Thursday, February 19, 2009, 12:31 PM
SHARMILA JOTHIRAJAH <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
