Skip site navigation (1) Skip section navigation (2)

EXPLAIN and nfiltered, take two

From: Marko Tiikkaja <marko(dot)tiikkaja(at)2ndquadrant(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: EXPLAIN and nfiltered, take two
Date: 2011-09-08 12:11:52
Message-ID: 4E68B108.1090907@2ndquadrant.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

Here's a patch for $SUBJECT based on the feedback here:
http://archives.postgresql.org/message-id/9053.1295888538@sss.pgh.pa.us

I intentionally decided to omit the information for Join Filter, since 
the information can already be deduced from EXPLAIN ANALYZE output, and 
for Left Joins and Anti Joins "Rows Removed by Join Filter" didn't 
really make much sense.

The "Rows Removed by .." information is always shown by default (when 
there is a Filter or Recheck Cond, of course), and I didn't feel like it 
was worth it to add a new option for EXPLAIN to turn that information off.

As for documentation..  I'm really at a loss here.  I tried numerous 
different things for doc/src/sgml/perform.sgml, but I didn't feel like 
any of them added anything.  The EXPLAIN ANALYZE output seems quite 
self-explanatory after all.

Attached are also the tests I used, and an example output.


-- 
Marko Tiikkaja                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Attachment: nremoved.patch
Description: text/plain (17.2 KB)
Attachment: explaintesti
Description: text/plain (3.0 KB)
Attachment: explain.out
Description: text/plain (9.1 KB)

Responses

pgsql-hackers by date

Next:From: Marti RaudseppDate: 2011-09-08 12:59:57
Subject: Re: [PATCH] Don't truncate integer part in to_char for 'FM99.'
Previous:From: Simon RiggsDate: 2011-09-08 10:59:11
Subject: Re: Back branch update releases this week; beta postponed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group