SELECT country, district, tour_nb, vilet, currency, min(price) AS price FROM tp 
WHERE(vivod <>  0 ) GROUP BY country, district, tour_nb, vilet, currency

"HashAggregate  (cost=303904.86..312034.00 rows=650331 width=20) (actual time=36693.271..36722.198 rows=12940 loops=1)"
"  ->  Seq Scan on tp  (cost=0.00..206355.30 rows=6503304 width=20) (actual time=1.011..15802.976 rows=6286137 loops=1)"
"        Filter: (vivod <> 0)"
"Total runtime: 36747.007 ms"

"GroupAggregate  (cost=1328797.65..1451393.01 rows=653842 width=20) (actual time=1390911.489..1506019.124 rows=12940 loops=1)"
"  ->  Sort  (cost=1328797.65..1345143.70 rows=6538419 width=20) (actual time=1390911.354..1490413.182 rows=6284155 loops=1)"
"        Sort Key: country, district, tour_nb, vilet, currency"
"        ->  Seq Scan on tp  (cost=0.00..208511.94 rows=6538419 width=20) (actual time=19.984..383624.708 rows=6284155 loops=1)"
"              Filter: (vivod <> 0)"
"Total runtime: 1506438.271 ms"

"GroupAggregate  (cost=1266182.15..1384156.91 rows=629199 width=20) (actual time=1885757.945..2010626.806 rows=12916 loops=1)"
"  ->  Sort  (cost=1266182.15..1281912.12 rows=6291987 width=20) (actual time=1885741.047..1996114.434 rows=6284157 loops=1)"
"        Sort Key: country, district, tour_nb, vilet, currency"
"        ->  Seq Scan on tour_price  (cost=0.00..189976.87 rows=6291987 width=20) (actual time=18.462..580584.254 rows=6284157 loops=1)"
"Total runtime: 2011208.509 ms"

CREATE TABLE tp
(
  count int4 DEFAULT nextval(('tp_count_seq'::text)::regclass),
  tour int4,
  pack int4,
  category int2,
  hotel int4,
  room_class int2,
  food int2,
  days int2,
  stars int2,
  days_nights int2,
  quantity int2,
  "1" int4,
  price int4,
  "3" int4,
  "4" int4,
  "5" int4,
  "6" int4,
  "7" int4,
  "8" int4,
  "9" int4,
  "10" int4,
  oper int2,
  spo int4,
  vivod int2,
  hot int2,
  userlast int2,
  datelast date,
  vilet date,
  h_class int2,
  avia int2 DEFAULT  0 ,
  country int2,
  doplata int4,
  doplata_flag int2,
  district int4,
  currency int2,
  date_time_last timestamp,
  discount int2,
  reis int2
) 
WITH OIDS;

CREATE UNIQUE INDEX count_tp_ukey
  ON tp
  USING btree
  (count);
CREATE INDEX country_tp_key
  ON tp
  USING btree
  (country);
CREATE INDEX days_nights_tp_key
  ON tp
  USING btree
  (days_nights);
CREATE INDEX district_tp_key
  ON tp
  USING btree
  (district);
CREATE INDEX food_tp_key
  ON tp
  USING btree
  (food);
CREATE INDEX price_hot
  ON tp
  USING btree
  (hotel, price);
CREATE INDEX price_tp_key
  ON tp
  USING btree
  (price);
CREATE INDEX stars_tp_key
  ON tp
  USING btree
  (stars);
CREATE INDEX tp_currency
  ON tp
  USING btree
  (currency);
CREATE INDEX tp_tour
  ON tp
  USING btree
  (tour);
CREATE INDEX tp_tour_vilet
  ON tp
  USING btree
  (tour, vilet);
CREATE INDEX tp1
  ON tp
  USING btree
  (tour, vilet, hotel, days_nights, food, price);
CREATE INDEX tp2
  ON tp
  USING btree
  (country, district, tour, vilet, currency);
CREATE INDEX vilet_tp_key
  ON tp
  USING btree
  (vilet);

"GroupAggregate  (cost=0.00..24547251.92 rows=637497 width=20) (actual time=549.776..842178.413 rows=14612 loops=1)"
"  ->  Index Scan using tp2 on tp  (cost=0.00..24443658.78 rows=6374962 width=20) (actual time=13.170..818496.131 rows=6352345 loops=1)"
"Total runtime: 842213.238 ms"

"GroupAggregate  (cost=100000000.00..124780094.99 rows=643491 width=20) (actual time=360.265..838193.620 rows=14644 loops=1)"
"  ->  Index Scan using tp2 on tp  (cost=100000000.00..124675527.77 rows=6434906 width=20) (actual time=5.775..819053.614 rows=6356186 loops=1)"
"Total runtime: 838223.841 ms"