Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5MHxNa08941 for ; Fri, 22 Jun 2001 13:59:23 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f5MHw1304843; Fri, 22 Jun 2001 13:58:01 -0400 (EDT) To: "Josh Berkus" cc: Alex Pilosov , pgsql-sql@postgresql.org Subject: Re: View performance question In-reply-to: References: Comments: In-reply-to "Josh Berkus" message dated "Fri, 22 Jun 2001 09:48:18 -0700" Date: Fri, 22 Jun 2001 13:58:00 -0400 Message-ID: <4840.993232680@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/384 X-Sequence-Number: 3680 "Josh Berkus" writes: > I can't figure out how to get Explain to output to a file instead of the > screen. Embarassing, I know, but the command seems to subbornly resist > all command-line re-direction. I think that in psql, EXPLAIN results (and notices in general) come out via stderr not stdout. regards, tom lane