On Sun, Jan 4, 2009 at 7:01 PM, Craig Ringer
wrote:
> Alternately, rather than doing everything within PL/PgSQL, just do it from
> normal SQL, issued through psql. That way you can just use \timing .
>
> For simple one-liners, instead of:
>
> psql -d DB1 -c 'select execute_function_foo();'
>
> you
Aaron Burnett wrote:
The first calls a function which essentially calls a handful of views.
psql -d DB1 -c 'select execute_function_foo();'
"calls" a handful of views?
What I am trying to get is the elapsed time logged for each individual query
or view that the function calls, as though I e
Hi,
I think I am experiencing the "forest through the trees" type of scenario
here.
In a nightly cron I have a shell script that executes a couple of things for
our data warehouse.
I call it like this from the cron:
/home/postgres/DB1/sys/createDB1.sh >> /home/postgres/DB1/logs/createDB1.log
2
