Andreas Kretschmer wrote:
Kynn Jones <kynnjo@xxxxxxxxx> schrieb:
Hi. I have a longish collection of SQL statements stored in a file that I run
periodically via cron. Running this "script" takes a bit too long, even for a
cron job, and I would like to streamline it.
Is there a way to tell Postgres to print out, after each SQL statement is
executed, how long it took to execute?
Do you run this with psql? You can switch on timing-output, with
\timing. It displays after each statement the run-time for this
statement.
See also log_duration and log_min_duration settings.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
