Postgres Pro
Downloads
Home   >   mailing lists

Re: Last log line for log_temp_files is disassociated with query - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Last log line for log_temp_files is disassociated with query
Date
Msg-id 51B272E1.5040708@agliodbs.com
Whole thread Raw
In response to Last log line for log_temp_files is disassociated with query  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Tree view 
On 06/07/2013 04:52 PM, Josh Berkus wrote:
> In many cases, this is what I see (9.2.4):
> 
> session_line_num|message|query
> 423|temporary file: path ...procid.0 file size: 525122|SELECT ...
> 424|temporary file: path ...procid.1 file size: 622044|SELECT ...
> 425|duration: 17078.635 ms  execute <unnamed>: SELECT ...|NULL
> 426|temporary file: path ...procid.0 file size: 1771353|NULL

Sorry, that last line should be:

426|temporary file: path ...procid.2 file size: 1771353|NULL


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Last log line for log_temp_files is disassociated with query
Next
From: Noah Misch
Date:
Subject: Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin