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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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 Content-Type Size
explain.out text/plain 9.1 KB
explaintesti text/plain 3.0 KB
nremoved.patch text/plain 17.2 KB

Responses

Browse pgsql-hackers by date

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