create table test_table as
select
row_number() OVER (ORDER BY null) as id,
extract(epoch from date_trunc('second', NOW()) - '1 minute'::INTERVAL * ROUND(RANDOM() * 60*24*180)) start_ts,
floor(random()*(15))+1 key1,
floor(random()*(7))+1 key2,
floor(random()*(2))+1 key3,
floor(random()*2) + 1 key4
from generate_series(1, 4000000) s(i);

CREATE INDEX idx_start_ts1 ON test_table (start_ts);

analyze test_table;

create or replace view test_push1 as
select * from test_table
union all
select 1,1,1,1,1,1;

create or replace view test_push2 as
select * from test_table;

explain analyze
select *
from test_push2
where start_ts >= 1534680463 + 60*60*18*45 
  and start_ts < 1534680463 + 60*60*24*44

explain analyze
select *
from test_push1
where start_ts >= 1534680463 + 60*60*18*45 
  and start_ts < 1534680463 + 60*60*24*44

create or replace view test_push1 as
select * from test_table
union all
select * from test_table2