Re: Why doesn't EXPLAIN ANALYZE show UPDATE step? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Why doesn't EXPLAIN ANALYZE show UPDATE step?
Date
Msg-id 10275.1051152416@sss.pgh.pa.us
Whole thread Raw
In response to Why doesn't EXPLAIN ANALYZE show UPDATE step?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optomizing left outer joins
Next
From: Andreas Pflug
Date:
Subject: Statement triggers 7.4 NEW/OLD