pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPossible interesting extra information for explain analyze?
3+ messages / 3 participants
[nested] [flat]
* Possible interesting extra information for explain analyze?
@ 2005-02-25 13:49 Jeff <threshar@torgo.978.org>
0 siblings, 2 replies; 3+ messages in thread
From: Jeff @ 2005-02-25 13:49 UTC (permalink / raw)
To: pgsql-performance
Given some recent posts / irc issues with dead tuple bloat..
And given that a lot of these people have at least been smart enough to
explain analyze would it be A. possible B. useful C. None of the above
to have various "scan" nodes of explain analyze also report how many
invisible / dead tuples they had to disqualify (Just to clarify, they
matched the search criteria, but were invisible due to MVCC rules).
Some thing like:
Seq Scan on boards (cost=0.00..686.30 rows=25430 width=0) (actual
time=8.866..5407.693 rows=18636 loops=1 invisiblerows=8934983098294)
This may help us to point out tuple bloat issues quicker... or it may
give the developer enough of a clue to search around and find out he
needs to vacuum... hmm.. but once we have an integrated autovacuum it
will be a moot point.....
Also another thing I started working on back in the day and hope to
finish when I get time (that is a funny idea) is having explain analyze
report when a step required the use of temp files.
--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Possible interesting extra information for explain analyze?
@ 2005-02-25 16:05 Tom Lane <tgl@sss.pgh.pa.us>
parent: Jeff <threshar@torgo.978.org>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2005-02-25 16:05 UTC (permalink / raw)
To: Jeff <threshar@torgo.978.org>; +Cc: pgsql-performance
Jeff <threshar@torgo.978.org> writes:
> Given some recent posts / irc issues with dead tuple bloat..
> And given that a lot of these people have at least been smart enough to
> explain analyze would it be A. possible B. useful C. None of the above
> to have various "scan" nodes of explain analyze also report how many
> invisible / dead tuples they had to disqualify (Just to clarify, they
> matched the search criteria, but were invisible due to MVCC rules).
I think this would not help a whole lot because (particularly on
indexscans) you won't get a very accurate picture of the true extent
of bloat. The contrib/pgstattuple utility is more useful for measuring
that sort of thing.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Possible interesting extra information for explain
@ 2005-02-27 20:25 Simon Riggs <simon@2ndquadrant.com>
parent: Jeff <threshar@torgo.978.org>
1 sibling, 0 replies; 3+ messages in thread
From: Simon Riggs @ 2005-02-27 20:25 UTC (permalink / raw)
To: Jeff <threshar@torgo.978.org>; +Cc: pgsql-performance
On Fri, 2005-02-25 at 08:49 -0500, Jeff wrote:
> Also another thing I started working on back in the day and hope to
> finish when I get time (that is a funny idea) is having explain analyze
> report when a step required the use of temp files.
Sounds useful. Please work on it...
Best Regards, Simon Riggs
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-02-27 20:25 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-25 13:49 Possible interesting extra information for explain analyze? Jeff <threshar@torgo.978.org>
2005-02-25 16:05 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-02-27 20:25 ` Re: Possible interesting extra information for explain Simon Riggs <simon@2ndquadrant.com>
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