Re: Large temporary file generated during query

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Ryan Kelly <rpkelly22(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Large temporary file generated during query
Date: 2012-12-08 01:33:45
Message-ID: CAMkU=1z9fGHF=2dChs4W-=6suE2JCEpXR6NHQ=F3TmtcxhR8CA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly <rpkelly22(at)gmail(dot)com> wrote:
> I have a very large query that also touches quite a bit of data. It
> generates a large temporary file (actually, several, because the total
> size is about 4.5GB). I'm wondering which part of the query's plan
> causes these files to be created.

Doing an "explain (analyze, buffers)" should tell you that.

Cheers,

Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wd 2012-12-08 12:32:32 Re: How to find which query a waiting query waiting for?
Previous Message Aleksey Tsalolikhin 2012-12-07 22:35:18 Re: How to mix psql commands and SQL commands on the shell command line?