On Feb 19, 2009, at 6:30 PM, R Smith wrote:
On Feb 19, 2009, at 11:07 AM, SHARMILA JOTHIRAJAH wrote:
Thanks all
-Sharmila
--- On Thu, 2/19/09, Erik Jones <ejones@xxxxxxxxxxxxxx> wrote:
From: Erik Jones <ejones@xxxxxxxxxxxxxx>
Subject: Re: How to pipe the psql copy command to Unix
'Date' command
To: sharmi_jo@xxxxxxxxx
Cc: "Tom Lane" <tgl@xxxxxxxxxxxxx>, "General postgres mailing
list" <pgsql-general@xxxxxxxxxxxxxx>
Date: Thursday, February 19, 2009, 1:31 PM
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
I've used UNIX for years and I don't know what you mean by 'use run
full piped command'.
Sure I know pipes and scripting, but ?
I would put everything needed w/ a shell script, calls to java & PG,
and set a var to unixtime at start and subtract it from the ending
unixtime.
If nothing else, I might pick up a Linux trick!
Sorry, I'd started typing the sentence one say, back spaced and went
to type it another and it didn't really come out right. It should
have been:
Run the full piped command with the unix 'time' utility.
I.e. if the full piped command was: cmd1 someargs | cmd2 someargs2 |
cmd3 someargs3
then run: time cmd1 someargs | cmd2 someargs2 | cmd3 someargs3
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
