Re: How to profile an "SQL script"?

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Kynn Jones <kynnjo(at)gmail(dot)com>
Cc: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How to profile an "SQL script"?
Date: 2008-12-03 20:46:54
Message-ID: 4936F03E.5040205@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Andreas Kretschmer wrote:
> Kynn Jones <kynnjo(at)gmail(dot)com> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kynn Jones 2008-12-04 00:03:00 Re: How to profile an "SQL script"?
Previous Message Andreas Kretschmer 2008-12-03 19:40:23 Re: How to profile an "SQL script"?