Re: How to pipe the psql copy command to Unix 'Date' command

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@engineyard.com> wrote:
>>
>>> From: Erik Jones <ejones@engineyard.com>
>>> Subject: Re: [GENERAL] How to pipe the psql copy command to Unix
>>> 'Date' command
>>> To: sharmi_jo@yahoo.com
>>> Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "General postgres mailing
>>> list" <pgsql-general@postgresql.org>
>>> 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@sss.pgh.pa.us> wrote:
>>>>
>>>>> From: Tom Lane <tgl@sss.pgh.pa.us>
>>>>> Subject: Re: [GENERAL] How to pipe the psql copy
>>> command to Unix 'Date' command
>>>>> To: sharmi_jo@yahoo.com
>>>>> Cc: "General postgres mailing list"
>>> <pgsql-general@postgresql.org>
>>>>> Date: Thursday, February 19, 2009, 12:31 PM
>>>>> SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>
>>> 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