按照时间来抽希，extract函数

根据函数取结果集，按照 create_time字段取分钟，返回一个经纬度，地图上不会秘密麻麻

select distinct on (extract(minute from create_time)) lat,lng from status_log

按照天，月，年等

extract (year from created_time) as year,
extract (month from created_time) as month,
extract (day from created_time) as day,
extract (hour from created_time) as hour,
extract (minute from created_time) as minute,
extract (second from created_time) as second

按照小时来如

select distinct on (extract(hours from create_time)) lat,lng from status_log