On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly <rpkell...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
