*** C:/Users/buildfarm/mpolyakova/postgrespro_master/src/test/regress/expected/stats_ext.out	Fri Feb 16 12:56:00 2018
--- C:/Users/buildfarm/mpolyakova/postgrespro_master/src/test/regress/results/stats_ext.out	Sat Feb 17 20:50:48 2018
***************
*** 309,323 ****
           ->  Seq Scan on ndistinct
  (5 rows)
  
! EXPLAIN (COSTS off)
   SELECT COUNT(*) FROM ndistinct GROUP BY b, c, d;
           QUERY PLAN          
! -----------------------------
!  HashAggregate
     Group Key: b, c, d
!    ->  Seq Scan on ndistinct
! (3 rows)
  
  EXPLAIN (COSTS off)
   SELECT COUNT(*) FROM ndistinct GROUP BY a, d;
           QUERY PLAN          
--- 309,338 ----
           ->  Seq Scan on ndistinct
  (5 rows)
  
! EXPLAIN --(COSTS off)
   SELECT COUNT(*) FROM ndistinct GROUP BY b, c, d;
                                   QUERY PLAN                                 
! ----------------------------------------------------------------------------
!  GroupAggregate  (cost=1026.89..1168.21 rows=1632 width=20)
     Group Key: b, c, d
!    ->  Sort  (cost=1026.89..1051.89 rows=10000 width=12)
!          Sort Key: b, c, d
!          ->  Seq Scan on ndistinct  (cost=0.00..191.00 rows=10000 width=12)
! (5 rows)
! 
! set enable_sort = 0;
! EXPLAIN --(COSTS off)
!  SELECT COUNT(*) FROM ndistinct GROUP BY b, c, d;
!                                  QUERY PLAN                                 
! ----------------------------------------------------------------------------
!  GroupAggregate  (cost=10000001026.89..10000001168.21 rows=1632 width=20)
!    Group Key: b, c, d
!    ->  Sort  (cost=10000001026.89..10000001051.89 rows=10000 width=12)
!          Sort Key: b, c, d
!          ->  Seq Scan on ndistinct  (cost=0.00..191.00 rows=10000 width=12)
! (5 rows)
  
+ reset enable_sort;
  EXPLAIN (COSTS off)
   SELECT COUNT(*) FROM ndistinct GROUP BY a, d;
           QUERY PLAN          

======================================================================

