摘要：
select * from pg_stat_activity where datname = 'datname' and waiting_reason = 'lock'; 根据查询结果中的pid值杀掉进程 select pg_terminate_backend(pid) 阅读全文
摘要：
SELECT array_to_json(array_agg(row_to_json(sys_xzqh))) from sys_xzqh where xzqh like '%341126%' 阅读全文
摘要：
import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.*;public class WeekdaysUtils { public static List<String> list = ne 阅读全文
摘要：
List<Vo> list = dao.selectList();if(CollectionUtils.isNotEmpty(list)) { Optional<Vo> max = list.stream().filter(obj->ObjectUtils.isNotEmpty(obj) && Ob 阅读全文
摘要：
-- sum() over(partition by ... order by ...)SELECT len/sum(len)over(partition by road_id) param from rs; -- min() over(partition by ... order by ...)S 阅读全文
摘要：
SELECT len/sum(len)over(partition by road_id) param from road_jcpd_section 阅读全文
摘要：
@Component@EnableScheduling // 1.开启定时任务@EnableAsync // 2.开启多线程public class MultithreadScheduleTask { @Async @Scheduled(fixedRate= 3000) //3秒执行一次 publi 阅读全文
摘要：
SELECT rl.road_code,string_agg(distinct rs.tech_level_label, ',') from road_lst rlleft join road_section rs on rl.id = rs.road_idwhere rs.tech_level_l 阅读全文
摘要：
1、创建物化视图 CREATE MATERIALIZED VIEW "view_xxx“ as select * from 表 2、刷新物化视图 refresh materialized view view_xxx; 3、删除物化视图 drop materialized view view_xxx; 阅读全文
摘要：
在Terminal终端中输入 git config user.name git config --global user.name "xl" 阅读全文