Versions

pathman version 1.3.1, pg 9.5.5, rhl 6

other info

Number of child tables: 290 (Use \d+ to list them.)
Partition column,:
statis_date | timestamp without time zone | not null
this will generate a new partition every day.
tbl_user_access_rt_20170523,
tbl_user_access_rt_20170524,
tbl_user_access_rt_20170525,
tbl_user_access_rt_20170526

Sql text:

SELECT statis_date, sum(new_user) as new_user, sum(start_ups) as start_ups, sum(active_user) as active_user
FROM tbl_user_access_rt
WHERE appid = 'BF688C717A5C3A69FE8CA522643C0A68' AND statis_date >= '2017-05-25 23:55:00' AND device_type in('A,I')
GROUP BY statis_date
ORDER BY statis_date ASC;

Planning time: 22174.959 ms
Execution time: 41.448 ms