QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ GroupAggregate (actual rows=277 loops=1) Group Key: sites.site_office, sites.site_location, (to_char(huawei_umts_ucell_20181217.start_time, 'YYYY-MM'::text)), sites.site_name -> Sort (actual rows=1783 loops=1) Sort Key: sites.site_office, sites.site_location, (to_char(huawei_umts_ucell_20181217.start_time, 'YYYY-MM'::text)), sites.site_name Sort Method: quicksort Memory: 1809kB -> Hash Left Join (actual rows=1783 loops=1) Hash Cond: ((huawei_umts_ucell_20181217.sect_id = data_extra.sect_id) AND ((to_char(huawei_umts_ucell_20181217.start_time, 'YYYY-MM'::text)) = data_extra.period)) -> Merge Join (actual rows=1783 loops=1) Merge Cond: (huawei_umts_ucell_20181217.sect_id = sectors.sect_id) -> Finalize GroupAggregate (actual rows=1788 loops=1) Group Key: huawei_umts_ucell_20181217.sect_id, (to_char(huawei_umts_ucell_20181217.start_time, 'YYYY-MM'::text)) -> Gather Merge (actual rows=56921 loops=1) Workers Planned: 2 Workers Launched: 2 -> Sort (actual rows=18974 loops=3) Sort Key: huawei_umts_ucell_20181217.sect_id, (to_char(huawei_umts_ucell_20181217.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 36499kB Worker 0: Sort Method: quicksort Memory: 40275kB Worker 1: Sort Method: quicksort Memory: 40263kB -> Parallel Append (actual rows=18974 loops=3) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181217.sect_id, (to_char(huawei_umts_ucell_20181217.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181217.sect_id, (to_char(huawei_umts_ucell_20181217.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181217 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181216.sect_id, (to_char(huawei_umts_ucell_20181216.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181216.sect_id, (to_char(huawei_umts_ucell_20181216.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181216 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1780 loops=1) Group Key: huawei_umts_ucell_20181205.sect_id, (to_char(huawei_umts_ucell_20181205.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42585 loops=1) Sort Key: huawei_umts_ucell_20181205.sect_id, (to_char(huawei_umts_ucell_20181205.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44787kB -> Parallel Seq Scan on huawei_umts_ucell_20181205 (actual rows=42585 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181219.sect_id, (to_char(huawei_umts_ucell_20181219.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181219.sect_id, (to_char(huawei_umts_ucell_20181219.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181219 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181227.sect_id, (to_char(huawei_umts_ucell_20181227.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181227.sect_id, (to_char(huawei_umts_ucell_20181227.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181227 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1774 loops=1) Group Key: huawei_umts_ucell_20181204.sect_id, (to_char(huawei_umts_ucell_20181204.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42562 loops=1) Sort Key: huawei_umts_ucell_20181204.sect_id, (to_char(huawei_umts_ucell_20181204.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44764kB -> Parallel Seq Scan on huawei_umts_ucell_20181204 (actual rows=42562 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1773 loops=1) Group Key: huawei_umts_ucell_20181203.sect_id, (to_char(huawei_umts_ucell_20181203.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42264 loops=1) Sort Key: huawei_umts_ucell_20181203.sect_id, (to_char(huawei_umts_ucell_20181203.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44461kB -> Parallel Seq Scan on huawei_umts_ucell_20181203 (actual rows=42264 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181222.sect_id, (to_char(huawei_umts_ucell_20181222.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181222.sect_id, (to_char(huawei_umts_ucell_20181222.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181222 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181214.sect_id, (to_char(huawei_umts_ucell_20181214.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181214.sect_id, (to_char(huawei_umts_ucell_20181214.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181214 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181215.sect_id, (to_char(huawei_umts_ucell_20181215.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181215.sect_id, (to_char(huawei_umts_ucell_20181215.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181215 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181218.sect_id, (to_char(huawei_umts_ucell_20181218.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181218.sect_id, (to_char(huawei_umts_ucell_20181218.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181218 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181220.sect_id, (to_char(huawei_umts_ucell_20181220.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181220.sect_id, (to_char(huawei_umts_ucell_20181220.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181220 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181221.sect_id, (to_char(huawei_umts_ucell_20181221.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181221.sect_id, (to_char(huawei_umts_ucell_20181221.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181221 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181225.sect_id, (to_char(huawei_umts_ucell_20181225.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181225.sect_id, (to_char(huawei_umts_ucell_20181225.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181225 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181226.sect_id, (to_char(huawei_umts_ucell_20181226.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181226.sect_id, (to_char(huawei_umts_ucell_20181226.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181226 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181228.sect_id, (to_char(huawei_umts_ucell_20181228.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181228.sect_id, (to_char(huawei_umts_ucell_20181228.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181228 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181229.sect_id, (to_char(huawei_umts_ucell_20181229.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181229.sect_id, (to_char(huawei_umts_ucell_20181229.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181229 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181230.sect_id, (to_char(huawei_umts_ucell_20181230.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181230.sect_id, (to_char(huawei_umts_ucell_20181230.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181230 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181231.sect_id, (to_char(huawei_umts_ucell_20181231.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42792 loops=1) Sort Key: huawei_umts_ucell_20181231.sect_id, (to_char(huawei_umts_ucell_20181231.start_time, 'YYYY-MM'::text)) Worker 0: Sort Method: quicksort Memory: 44997kB -> Parallel Seq Scan on huawei_umts_ucell_20181231 (actual rows=42792 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181213.sect_id, (to_char(huawei_umts_ucell_20181213.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42687 loops=1) Sort Key: huawei_umts_ucell_20181213.sect_id, (to_char(huawei_umts_ucell_20181213.start_time, 'YYYY-MM'::text)) Worker 1: Sort Method: quicksort Memory: 44890kB -> Parallel Seq Scan on huawei_umts_ucell_20181213 (actual rows=42687 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=890 loops=2) Group Key: huawei_umts_ucell_20181211.sect_id, (to_char(huawei_umts_ucell_20181211.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=21325 loops=2) Sort Key: huawei_umts_ucell_20181211.sect_id, (to_char(huawei_umts_ucell_20181211.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 25kB Worker 0: Sort Method: quicksort Memory: 44853kB -> Parallel Seq Scan on huawei_umts_ucell_20181211 (actual rows=21325 loops=2) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1777 loops=2) Group Key: huawei_umts_ucell_20181206.sect_id, (to_char(huawei_umts_ucell_20181206.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=21324 loops=2) Sort Key: huawei_umts_ucell_20181206.sect_id, (to_char(huawei_umts_ucell_20181206.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 18154kB Worker 1: Sort Method: quicksort Memory: 26697kB -> Parallel Seq Scan on huawei_umts_ucell_20181206 (actual rows=21324 loops=2) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1777 loops=1) Group Key: huawei_umts_ucell_20181207.sect_id, (to_char(huawei_umts_ucell_20181207.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42648 loops=1) Sort Key: huawei_umts_ucell_20181207.sect_id, (to_char(huawei_umts_ucell_20181207.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 44851kB -> Parallel Seq Scan on huawei_umts_ucell_20181207 (actual rows=42648 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1777 loops=1) Group Key: huawei_umts_ucell_20181208.sect_id, (to_char(huawei_umts_ucell_20181208.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42648 loops=1) Sort Key: huawei_umts_ucell_20181208.sect_id, (to_char(huawei_umts_ucell_20181208.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 44851kB -> Parallel Seq Scan on huawei_umts_ucell_20181208 (actual rows=42648 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1777 loops=1) Group Key: huawei_umts_ucell_20181209.sect_id, (to_char(huawei_umts_ucell_20181209.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42648 loops=1) Sort Key: huawei_umts_ucell_20181209.sect_id, (to_char(huawei_umts_ucell_20181209.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 44851kB -> Parallel Seq Scan on huawei_umts_ucell_20181209 (actual rows=42648 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1777 loops=1) Group Key: huawei_umts_ucell_20181210.sect_id, (to_char(huawei_umts_ucell_20181210.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42648 loops=1) Sort Key: huawei_umts_ucell_20181210.sect_id, (to_char(huawei_umts_ucell_20181210.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 44851kB -> Parallel Seq Scan on huawei_umts_ucell_20181210 (actual rows=42648 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1777 loops=1) Group Key: huawei_umts_ucell_20181212.sect_id, (to_char(huawei_umts_ucell_20181212.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=42648 loops=1) Sort Key: huawei_umts_ucell_20181212.sect_id, (to_char(huawei_umts_ucell_20181212.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 44851kB -> Parallel Seq Scan on huawei_umts_ucell_20181212 (actual rows=42648 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1749 loops=1) Group Key: huawei_umts_ucell_20181202.sect_id, (to_char(huawei_umts_ucell_20181202.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=41976 loops=1) Sort Key: huawei_umts_ucell_20181202.sect_id, (to_char(huawei_umts_ucell_20181202.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 44168kB -> Parallel Seq Scan on huawei_umts_ucell_20181202 (actual rows=41976 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1750 loops=1) Group Key: huawei_umts_ucell_20181201.sect_id, (to_char(huawei_umts_ucell_20181201.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=41655 loops=1) Sort Key: huawei_umts_ucell_20181201.sect_id, (to_char(huawei_umts_ucell_20181201.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 43842kB -> Parallel Seq Scan on huawei_umts_ucell_20181201 (actual rows=41655 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181223.sect_id, (to_char(huawei_umts_ucell_20181223.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=39226 loops=1) Sort Key: huawei_umts_ucell_20181223.sect_id, (to_char(huawei_umts_ucell_20181223.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 41375kB -> Parallel Seq Scan on huawei_umts_ucell_20181223 (actual rows=39226 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Partial GroupAggregate (actual rows=1783 loops=1) Group Key: huawei_umts_ucell_20181224.sect_id, (to_char(huawei_umts_ucell_20181224.start_time, 'YYYY-MM'::text)) -> Sort (actual rows=39226 loops=1) Sort Key: huawei_umts_ucell_20181224.sect_id, (to_char(huawei_umts_ucell_20181224.start_time, 'YYYY-MM'::text)) Sort Method: quicksort Memory: 41375kB -> Parallel Seq Scan on huawei_umts_ucell_20181224 (actual rows=39226 loops=1) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) -> Sort (actual rows=5046 loops=1) Sort Key: sectors.sect_id Sort Method: quicksort Memory: 637kB -> Hash Join (actual rows=5656 loops=1) Hash Cond: (sectors.site_id = sites.site_id) -> Seq Scan on sectors (actual rows=5656 loops=1) -> Hash (actual rows=2536 loops=1) Buckets: 4096 Batches: 1 Memory Usage: 189kB -> Seq Scan on sites (actual rows=2536 loops=1) -> Hash (actual rows=1788 loops=1) Buckets: 262144 Batches: 1 Memory Usage: 2251kB -> Subquery Scan on data_extra (actual rows=1788 loops=1) -> Finalize HashAggregate (actual rows=1788 loops=1) Group Key: huawei_umts_ucell_extra_201812.sect_id, (to_char(huawei_umts_ucell_extra_201812.start_time, 'YYYY-MM'::text)) -> Gather (actual rows=5357 loops=1) Workers Planned: 2 Workers Launched: 2 -> Parallel Append (actual rows=1786 loops=3) -> Partial HashAggregate (actual rows=1786 loops=3) Group Key: huawei_umts_ucell_extra_201812.sect_id, to_char(huawei_umts_ucell_extra_201812.start_time, 'YYYY-MM'::text) -> Parallel Seq Scan on huawei_umts_ucell_extra_201812 (actual rows=438464 loops=3) Filter: ((start_time >= '2018-12-01 00:00:00'::timestamp without time zone) AND (start_time < '2019-01-01 00:00:00'::timestamp without time zone)) Planning Time: 5620.536 ms Execution Time: 48745.974 ms (263 rows)