One of our instances was killed:
| Out of memory: Kill process 27670 (postmaster) score 381 or sacrifice child
| Killed process 27670 (postmaster) total-vm:13207796kB, anon-rss:5736kB, file-rss:0kB, shmem-rss:12421696kB
The VM has: 32GB RAM, shared_buffers=12GB, work_mem=128MB
Running only pg11.3
Trying to diagnose the issue by running a query on a narrower range of dates,
it looks to me that's due to many sorts nodes per worker.
Part of the query plan looks like this:
[...]
-> 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))
[...many partial GroupAggregate/Sort repeated here for ~200 child tables...]
This isn't the first time I've had to reduce work_mem on a parallel query to
avoid OOM, but it seems unreasonable to be concerned with 50MB sorts.
It looks like the results of each Sort node stay in RAM, during processing of
additional sort nodes (is that required?)
I SET max_parallel_workers_per_gather=0 and dumped mem context:
...
PortalContext: 203948152 total in 25756 blocks; 176600 free (319 chunks); 203771552 used:
...
Grand total: 1918118632 bytes in 30716 blocks; 192472208 free (3685 chunks); 1725646424 used
The total shows ~1700MB but the largest context is only 200MB.
"Caller tuples" accounts for 1400MB.
awk '/Caller tuples/{s+=$3}END{print s/1024^3}' /tmp/mem-context
1.44043
I'm attaching full plan and mem context.
It doesn't seem to be changed under pg12b2, which is concerning since PG12
advertizes that it gracefully supports "thousands" of partitions. It seems to
me that would require tiny work_mem, which would be devastating to some
workloads. This is not a contrived test case, it's one of our reports run
across ~10 months of history with weekly granularity.
Thanks in advance for any advice.
Justin
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)
TopMemoryContext: 837328 total in 31 blocks; 170944 free (12 chunks); 666384 used
PLpgSQL cast info: 8192 total in 1 blocks; 7744 free (0 chunks); 448 used
PLpgSQL cast cache: 8192 total in 1 blocks; 1584 free (0 chunks); 6608 used
PL/pgSQL function: 8192 total in 1 blocks; 3320 free (1 chunks); 4872 used: maybe_div(double precision,double precision)
CFuncHash: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
Rendezvous variable hash: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
PLpgSQL function hash: 24528 total in 2 blocks; 2624 free (0 chunks); 21904 used
TableSpace cache: 8192 total in 1 blocks; 2096 free (0 chunks); 6096 used
Btree proof lookup cache: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
Type information cache: 24352 total in 2 blocks; 2624 free (0 chunks); 21728 used
Operator lookup cache: 24576 total in 2 blocks; 10760 free (3 chunks); 13816 used
pgstat TabStatusArray lookup hash table: 131072 total in 5 blocks; 36944 free (11 chunks); 94128 used
TopTransactionContext: 8192 total in 1 blocks; 7296 free (4 chunks); 896 used
ExecutorState: 16384 total in 2 blocks; 7464 free (5 chunks); 8920 used
RowDescriptionContext: 8192 total in 1 blocks; 6896 free (0 chunks); 1296 used
MessageContext: 532480 total in 7 blocks; 28336 free (8 chunks); 504144 used
Operator class cache: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
smgr relation table: 524288 total in 7 blocks; 234688 free (24 chunks); 289600 used
TransactionAbortContext: 32768 total in 1 blocks; 32512 free (0 chunks); 256 used
Portal hash: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
TopPortalContext: 8192 total in 1 blocks; 7664 free (0 chunks); 528 used
PortalHoldContext: 24632 total in 2 blocks; 7392 free (0 chunks); 17240 used
PortalContext: 203948152 total in 25756 blocks; 176600 free (319 chunks); 203771552 used:
ExecutorState: 49765784 total in 177 blocks; 4832464 free (8 chunks); 44933320 used
TupleSort main: 57400 total in 2 blocks; 4400 free (0 chunks); 53000 used
Caller tuples: 1048576 total in 8 blocks; 113960 free (11 chunks); 934616 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 41943040 total in 15 blocks; 1147184 free (48 chunks); 40795856 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 41943040 total in 15 blocks; 1147184 free (48 chunks); 40795856 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5827112 free (52 chunks); 44504536 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5936312 free (52 chunks); 44395336 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5976872 free (52 chunks); 44354776 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5974792 free (52 chunks); 44356856 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5976872 free (52 chunks); 44354776 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5976872 free (52 chunks); 44354776 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5976872 free (52 chunks); 44354776 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5976872 free (52 chunks); 44354776 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 5976872 free (52 chunks); 44354776 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 6042392 free (52 chunks); 44289256 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 6066312 free (52 chunks); 44265336 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 6376232 free (52 chunks); 43955416 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 6675752 free (52 chunks); 43655896 used
TupleSort main: 1581112 total in 2 blocks; 4400 free (0 chunks); 1576712 used
Caller tuples: 50331648 total in 16 blocks; 7009592 free (52 chunks); 43322056 used
HashTableContext: 8192 total in 1 blocks; 7752 free (0 chunks); 440 used
HashBatchContext: 303776 total in 9 blocks; 7936 free (0 chunks); 295840 used
HashTableContext: 8192 total in 1 blocks; 7752 free (0 chunks); 440 used
HashBatchContext: 270920 total in 8 blocks; 7936 free (0 chunks); 262984 used
TupleSort main: 65592 total in 3 blocks; 5368 free (2 chunks); 60224 used
Caller tuples: 2097152 total in 9 blocks; 806800 free (23 chunks); 1290352 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 5536 free (1 chunks); 2656 used
ExprContext: 2097152 total in 9 blocks; 751488 free (24 chunks); 1345664 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7856 free (1 chunks); 336 used
ExprContext: 8192 total in 1 blocks; 7488 free (0 chunks); 704 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 17000 free (3 chunks); 48536 used
ExprContext: 8192 total in 1 blocks; 2656 free (8 chunks); 5536 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 17048 free (3 chunks); 48488 used
ExprContext: 8192 total in 1 blocks; 2656 free (10 chunks); 5536 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 16960 free (3 chunks); 48576 used
ExprContext: 8192 total in 1 blocks; 2608 free (8 chunks); 5584 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 17056 free (5 chunks); 48480 used
ExprContext: 8192 total in 1 blocks; 2608 free (10 chunks); 5584 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 17024 free (4 chunks); 48512 used
ExprContext: 8192 total in 1 blocks; 2608 free (12 chunks); 5584 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 17064 free (3 chunks); 48472 used
ExprContext: 8192 total in 1 blocks; 2656 free (8 chunks); 5536 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 16992 free (3 chunks); 48544 used
ExprContext: 8192 total in 1 blocks; 2608 free (8 chunks); 5584 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 17016 free (3 chunks); 48520 used
ExprContext: 8192 total in 1 blocks; 2656 free (6 chunks); 5536 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 16976 free (3 chunks); 48560 used
ExprContext: 8192 total in 1 blocks; 2608 free (6 chunks); 5584 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 2704 free (10 chunks); 5488 used
ExprContext: 8192 total in 1 blocks; 4520 free (0 chunks); 3672 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 17040 free (4 chunks); 48496 used
ExprContext: 8192 total in 1 blocks; 2608 free (12 chunks); 5584 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 16992 free (3 chunks); 48544 used
ExprContext: 8192 total in 1 blocks; 2608 free (8 chunks); 5584 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 65536 total in 4 blocks; 16960 free (3 chunks); 48576 used
ExprContext: 8192 total in 1 blocks; 2608 free (12 chunks); 5584 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
83 more child contexts containing 1769472 total in 140 blocks; 742112 free (195 chunks); 1027360 used
Relcache by OID: 131072 total in 5 blocks; 33952 free (10 chunks); 97120 used
CacheMemoryContext: 57811568 total in 714 blocks; 7349296 free (0 chunks); 50462272 used
CachedPlan: 2048 total in 2 blocks; 664 free (0 chunks); 1384 used: SELECT $1 / $2
CachedPlanSource: 2048 total in 2 blocks; 416 free (0 chunks); 1632 used: SELECT $1 / $2
CachedPlanQuery: 2048 total in 2 blocks; 760 free (1 chunks); 1288 used
SPI Plan: 1024 total in 1 blocks; 608 free (0 chunks); 416 used
CachedPlan: 2048 total in 2 blocks; 848 free (0 chunks); 1200 used: SELECT 0.0
CachedPlanSource: 2048 total in 2 blocks; 624 free (0 chunks); 1424 used: SELECT 0.0
CachedPlanQuery: 2048 total in 2 blocks; 944 free (1 chunks); 1104 used
SPI Plan: 1024 total in 1 blocks; 608 free (0 chunks); 416 used
CachedPlan: 2048 total in 2 blocks; 632 free (0 chunks); 1416 used: SELECT $2 = 0.0
CachedPlanSource: 2048 total in 2 blocks; 376 free (0 chunks); 1672 used: SELECT $2 = 0.0
CachedPlanQuery: 2048 total in 2 blocks; 544 free (1 chunks); 1504 used
SPI Plan: 1024 total in 1 blocks; 608 free (0 chunks); 416 used
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_201907_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_201907_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_201907_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190630_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190630_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190630_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190629_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190629_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190629_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190628_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190628_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190628_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190627_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190627_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190627_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190626_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190626_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190626_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190625_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190625_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190625_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190624_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190624_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190624_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190623_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190623_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190623_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190622_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190622_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190622_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190621_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190621_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190621_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190620_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190620_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190620_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190619_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190619_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190619_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190618_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190618_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190618_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190617_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190617_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190617_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190616_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190616_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190616_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190615_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190615_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190615_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190614_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190614_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190614_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190613_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190613_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190613_unique_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_20190612_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190612_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190612_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190611_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190611_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190610_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190610_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190609_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190609_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190608_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190608_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190607_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190607_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190606_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190606_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190605_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190605_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190604_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190604_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190603_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190603_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190602_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190602_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190601_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190601_idx
index info: 3072 total in 2 blocks; 1048 free (1 chunks); 2024 used: huawei_umts_ucell_extra_201905_unique_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_201905_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_201905_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190430_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190430_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190429_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190429_idx
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: huawei_umts_ucell_extra_20190428_site_idx
index info: 3072 total in 2 blocks; 1208 free (1 chunks); 1864 used: huawei_umts_ucell_extra_20190428_idx
1451 more child contexts containing 4059952 total in 2932 blocks; 1516176 free (1213 chunks); 2543776 used
WAL record construction: 49768 total in 2 blocks; 6368 free (0 chunks); 43400 used
PrivateRefCount: 8192 total in 1 blocks; 2624 free (0 chunks); 5568 used
MdSmgr: 65536 total in 4 blocks; 13208 free (1 chunks); 52328 used
LOCALLOCK hash: 262144 total in 6 blocks; 28088 free (20 chunks); 234056 used
Timezones: 104120 total in 2 blocks; 2624 free (0 chunks); 101496 used
ErrorContext: 8192 total in 1 blocks; 7936 free (4 chunks); 256 used
Grand total: 1920207592 bytes in 30722 blocks; 193251304 free (3721 chunks); 1726956288 used
