pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedWhy doesn't EXPLAIN ANALYZE show UPDATE step?
2+ messages / 2 participants
[nested] [flat]
* Why doesn't EXPLAIN ANALYZE show UPDATE step?
@ 2003-04-23 18:23 Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 2+ messages in thread
From: Josh Berkus @ 2003-04-23 18:23 UTC (permalink / raw)
To: pgsql-sql
Folks,
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?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Why doesn't EXPLAIN ANALYZE show UPDATE step?
@ 2003-04-24 02:46 Tom Lane <tgl@sss.pgh.pa.us>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-04-24 02:46 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-04-24 02:46 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-23 18:23 Why doesn't EXPLAIN ANALYZE show UPDATE step? Josh Berkus <josh@agliodbs.com>
2003-04-24 02:46 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox