]> granicus.if.org Git - postgresql/blobdiff - src/test/regress/expected/window.out
Improve EXPLAIN to print the grouping columns in Agg and Group nodes.
[postgresql] / src / test / regress / expected / window.out
index 1e6365b4f9b4a37d0650b034c128823728ea2378..0f21fcb01da738d1d696812b84d86a5c34f286f3 100644 (file)
@@ -619,12 +619,13 @@ explain (costs off)
 select first_value(max(x)) over (), y
   from (select unique1 as x, ten+four as y from tenk1) ss
   group by y;
-          QUERY PLAN           
--------------------------------
+                 QUERY PLAN                  
+---------------------------------------------
  WindowAgg
    ->  HashAggregate
+         Group Key: (tenk1.ten + tenk1.four)
          ->  Seq Scan on tenk1
-(3 rows)
+(4 rows)
 
 -- test non-default frame specifications
 SELECT four, ten,