Re: Very long execution time of "select nextval('..');"

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: mljv(at)planwerk6(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very long execution time of "select nextval('..');"
Date: 2008-01-27 13:05:59
Message-ID: 479C81B7.3010902@Sheeky.Biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mljv(at)planwerk6(dot)de wrote:

> Unfortunatly i can not tell at which time this happens as the log doesn't
> show the time of day.
>

Start with your postgresql.conf -

http://www.postgresql.org/docs/8.2/interactive/runtime-config-logging.html

points of interest :-

log_min_messages - debug1 to get some more info in the log

log_line_prefix - %t will show the timestamp of the log entry

log_statement - can record the queries to the log so you can see just
what is being run as you go through the log.

--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lawrence Oluyede 2008-01-27 13:38:18 Re: Possible bug in PostgreSQL 8.3beta4 (postgres process segfaults)
Previous Message mljv 2008-01-27 10:51:32 Very long execution time of "select nextval('..');"