Postgres Pro
Downloads
Home   >   mailing lists

Re: Large temporary file generated during query - Mailing list pgsql-general

From Jeff Janes
Subject Re: Large temporary file generated during query
Date
Msg-id CAMkU=1z9fGHF=2dChs4W-=6suE2JCEpXR6NHQ=F3TmtcxhR8CA@mail.gmail.com
Whole thread Raw
In response to Large temporary file generated during query  (Ryan Kelly <rpkelly22@gmail.com>)
Responses Re: Large temporary file generated during query  (Ryan Kelly <rpkelly22@gmail.com>)
List pgsql-general
Tree view 
On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly <rpkelly22@gmail.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

pgsql-general by date:

Previous
From: Aleksey Tsalolikhin
Date:
Subject: Re: How to mix psql commands and SQL commands on the shell command line?
Next
From: wd
Date:
Subject: Re: How to find which query a waiting query waiting for?