pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff <threshar@torgo.978.org>
To: performance pgsql <pgsql-performance@postgresql.org>
Subject: Possible interesting extra information for explain analyze?
Date: Fri, 25 Feb 2005 08:49:23 -0500
Message-ID: <ed07e0b06fee34124da83f065e19e486@torgo.978.org> (raw)

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/




view thread (3+ messages)  latest in thread

Message-ID: <ed07e0b06fee34124da83f065e19e486@torgo.978.org>
Permalink:  ../ed07e0b06fee34124da83f065e19e486@torgo.978.org/
Also on:    postgresql.org/message-id/ed07e0b06fee34124da83f065e19e486@torgo.978.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: threshar@torgo.978.org
  Subject: Re: Possible interesting extra information for explain analyze?
  In-Reply-To: <ed07e0b06fee34124da83f065e19e486@torgo.978.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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