From: | "Joel Burton" <joel(at)joelburton(dot)com> |
---|---|
To: | "Dorward Villaruz" <dorwardv(at)ntsp(dot)nec(dot)co(dot)jp>, "Postgres General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: is there a way |
Date: | 2002-05-02 14:43:25 |
Message-ID: | JGEPJNMCKODMDHGOBKDNAEIFCMAA.joel@joelburton.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
1) is there a way to time execution of sql statements in postgres without
using any frontend languages like php ?
You can use a shell time command to wrap around the psql command. Something
like:
$ time psql -f sql_commands_to_execute
pg7.3devel (in CVS) lets you "EXPLAIN ANALYZE SELECT ...", which shows
actually processing time for a query as well as each individual processing
step (!)
2) is there also a way of inserting 2000000 records to a table without
using any frontend languages like php?
Write it in plpgsql, plperl, plpython, or (not yet in the official distro)
plruby.
From | Date | Subject | |
---|---|---|---|
Next Message | Shaun Thomas | 2002-05-02 14:54:12 | Re: What popular, large commercial websites run |
Previous Message | Oliver Elphick | 2002-05-02 14:32:49 | Re: is there a way |