X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 869984758F1
	for <pgsql-sql@postgresql.org>; Wed, 23 Apr 2003 22:47:24 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 7020F474E42
	for <pgsql-sql@postgresql.org>; Wed, 23 Apr 2003 22:46:53 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3O2kuU6010276;
	Wed, 23 Apr 2003 22:46:56 -0400 (EDT)
To: josh@agliodbs.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Why doesn't EXPLAIN ANALYZE show UPDATE step? 
In-reply-to: <200304231123.38477.josh@agliodbs.com> 
References: <200304231123.38477.josh@agliodbs.com>
Comments: In-reply-to Josh Berkus <josh@agliodbs.com>
	message dated "Wed, 23 Apr 2003 11:23:38 -0700"
Date: Wed, 23 Apr 2003 22:46:56 -0400
Message-ID: <10275.1051152416@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Spam-Status: No, hits=-29.3 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES,
	REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/357
X-Sequence-Number: 13058

Josh Berkus <josh@agliodbs.com> writes:
> I was just noticing that EXPLAIN ANALYZE in 7.3.2 *still* doesn't show a 
> discrete UPDATE step for UPDATE queries.   Is this going to be changed in 
> 7.4?

No.  There is no UPDATE step in the plan tree.

You can determine the time spent doing updates by subtracting the
topmost plan node's total time from the total runtime, as suggested
in the next-to-last paragraph of
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/performance-tips.html

			regards, tom lane