Postgres Pro
Downloads
Home   >   mailing lists

Re: Very long execution time of "select nextval('..');" - Mailing list pgsql-general

From Shane Ambler
Subject Re: Very long execution time of "select nextval('..');"
Date
Msg-id 479C81B7.3010902@Sheeky.Biz
Whole thread Raw
In response to Very long execution time of "select nextval('..');"  (mljv@planwerk6.de)
List pgsql-general
Tree view 
mljv@planwerk6.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

pgsql-general by date:

Previous
From: mljv@planwerk6.de
Date:
Subject: Very long execution time of "select nextval('..');"
Next
From: "Lawrence Oluyede"
Date:
Subject: Re: Possible bug in PostgreSQL 8.3beta4 (postgres process segfaults)