Received: from mail.cablespeed.com (mail.cablespeed.com [206.112.192.76]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4PIs9A75816 for ; Fri, 25 May 2001 14:54:09 -0400 (EDT) (envelope-from mvincent@cablespeed.com) Received: from windows (net-216-93-124-123.hcv.com [216.93.124.123]) by mail.cablespeed.com (8.9.3/8.9.3) with SMTP id LAA08854; Fri, 25 May 2001 11:53:36 -0700 Message-ID: <04c801c0e54b$8ca67140$1251000a@windows> From: "Mitch Vincent" To: "Marc Sherman" , References: Subject: Re: Re: Printing Notices to the web? Date: Fri, 25 May 2001 14:50:20 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200105/86 X-Sequence-Number: 396 EXPLAIN generates a single NOTICE, though it could have many lines... Like : brw=# explain select * from customers; NOTICE: QUERY PLAN: Seq Scan on customers (cost=0.00..1018.75 rows=17275 width=428) and then a more complex query : brw=# explain select * from customers,inventory,invoice_master,quote_master,quote_line_items; NOTICE: QUERY PLAN: Nested Loop (cost=0.00..655655853.05 rows=9909199125 width=1245) -> Nested Loop (cost=0.00..375370.55 rows=5441625 width=1076) -> Nested Loop (cost=0.00..48.05 rows=315 width=648) -> Nested Loop (cost=0.00..6.75 rows=35 width=464) -> Seq Scan on invoice_master (cost=0.00..1.05 rows=5 width=427) -> Seq Scan on quote_line_items (cost=0.00..1.07 rows=7 width=37) -> Seq Scan on quote_master (cost=0.00..1.09 rows=9 width=184) -> Seq Scan on customers (cost=0.00..1018.75 rows=17275 width=428) -> Seq Scan on inventory (cost=0.00..102.21 rows=1821 width=169) EXPLAIN -Mitch ----- Original Message ----- From: "Marc Sherman" To: Cc: Sent: Friday, May 25, 2001 2:37 PM Subject: RE: [PHP] Re: Printing Notices to the web? > From: pgsql-php-owner@postgresql.org > > : > > : Your hero has come :-) The pg_last_notice() function is > > : scheduled to be released in PHP 4.0.7 . Read more about it > > : here: http://www.php.net/bugs.php?id=9541&edit=1 > > Is this adequate for cases where a single query generates more > than one notice message? Don't explains generate a large number > for each query? > > - Marc > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >