| 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: | Whole Thread | Raw Message | 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 |