postgres.git / summary / log / commit / refs

commit    9942376a5b61c824daf653e6aca0bf5c8516f7ab
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Wed Aug 17 19:51:11 2016 +0000

    Fix -e option in contrib/intarray/bench/bench.pl.
    
    As implemented, -e ran an EXPLAIN but then discarded the output, which
    certainly seems pointless.  Make it print to stdout instead.  It's been
    like that forever, so back-patch to all supported branches.
    
    Daniel Gustafsson, reviewed by Andreas Scherbaum
    
    Patch: <B97BDCB7-A3B3-4734-90B5-EDD586941629@yesql.se>


 contrib/intarray/bench/bench.pl | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/contrib/intarray/bench/bench.pl b/contrib/intarray/bench/bench.pl
index 4e18624b9c2..b3097a02461 100755
--- a/contrib/intarray/bench/bench.pl
+++ b/contrib/intarray/bench/bench.pl
@@ -70,7 +70,8 @@ if ( $opt{v} ) {
 }
 
 if ( $opt{e} ) {
-	$dbi->do("explain $sql");
+	my @plan = map { "$_->[0]\n" } @{$dbi->selectall_arrayref("explain $sql")};
+	print @plan;
 }
 
 my $t0 = [gettimeofday];


[parent: 7e01c8ef3a29]