Output of explain analyze :
explain analyze select count(*) from log_full where end_date between to_date('2017/12/03','YY/MM/DD') and to_date('2017/12/04','YY/MM/DD');
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------
Finalize Aggregate (cost=38058211.38..38058211.39 rows=1 width=8) (actual time=3502304.726..3502304.726 rows=1 loops=1)
-> Gather (cost=38058211.16..38058211.37 rows=2 width=8) (actual time=3502179.810..3502251.520 rows=3 loops=1)
Workers Planned: 2
Workers Launched: 2
-> Partial Aggregate (cost=38057211.16..38057211.17 rows=1 width=8) (actual time=3500338.084..3500338.084 rows
=1 loops=3)
-> Append (cost=0.00..38040836.26 rows=6549963 width=0) (actual time=1513398.593..3499538.302 rows=52402
29 loops=3)
-> Parallel Seq Scan on log_full_1_11_2017_action_status (cost=0.00..39863.21 rows=1 width=
0) (actual time=4047.915..4047.915 rows=0 loops=3)
Filter: ((end_date >= to_date('2017/12/03'::text, 'YY/MM/DD'::text)) AND (end_date <= to_date(
'2017/12/04'::text, 'YY/MM/DD'::text)))
Rows Removed by Filter: 286924
-> Parallel Seq Scan on log_full_1_11_2017_alive_status (cost=0.00..702893.03 rows=1 width=
0) (actual time=63648.476..63648.476 rows=0 loops=3)
Filter: ((end_date >= to_date('2017/12/03'::text, 'YY/MM/DD'::text)) AND (end_date <= to_date(
'2017/12/04'::text, 'YY/MM/DD'::text)))
Rows Removed by Filter: 4955092
-> Parallel Seq Scan on log_full_1_11_2017_modem_status (cost=0.00..10.59 rows=1 width=0) (
actual time=0.001..0.001 rows=0 loops=3)
Filter: ((end_date >= to_date('2017/12/03'::text, 'YY/MM/DD'::text)) AND (end_date <= to_date(
'2017/12/04'::text, 'YY/MM/DD'::text)))
....................
and so on full on on partitions..
2018-02-04 15:43 GMT+02:00 Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx>:
explain analyze takes too much time.. hours ...I run it now but it will take some time.The output of the explain :Finalize Aggregate (cost=38058211.38..38058211.39 rows=1 width=8)-> Gather (cost=38058211.16..38058211.37 rows=2 width=8)Workers Planned: 2-> Partial Aggregate (cost=38057211.16..38057211.17 rows=1 width=8)-> Append (cost=0.00..38040836.26 rows=6549963 width=0)-> Parallel Seq Scan on log_full_1_11_2017_action_status (cost=0.00..39863.21 rows=1 width= 0)Filter: ((end_date >= to_date('2017/12/03'::text, 'YY/MM/DD'::text)) AND (end_date <= to_date('2017/12/04'::text, 'YY/MM/DD'::text)))-> Parallel Seq Scan on log_full_1_11_2017_alive_status (cost=0.00..702893.03 rows=1 width= 0)Filter: ((end_date >= to_date('2017/12/03'::text, 'YY/MM/DD'::text)) AND (end_date <= to_date('2017/12/04'::text, 'YY/MM/DD'::text)))-> Parallel Seq Scan on log_full_1_11_2017_modem_status (cost=0.00..10.59 rows=1 width=0) Filter: ((end_date >= to_date('2017/12/03'::text, 'YY/MM/DD'::text)) AND (end_date <= to_date('2017/12/04'::text, 'YY/MM/DD'::text)))and so on parallel seq for each partition that I have..
