Re: Last log line for log_temp_files is disassociated with query

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Last log line for log_temp_files is disassociated with query
Date: 2013-06-07 23:55:13
Message-ID: 51B272E1.5040708@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2013-06-08 01:30:58 Re: Partitioning performance: cache stringToNode() of pg_constraint.ccbin
Previous Message Josh Berkus 2013-06-07 23:52:06 Last log line for log_temp_files is disassociated with query