我去年买的一加 Ace3 ，两千六七，就很好

领取到了，谢谢楼主

先治疗脑梗，脑梗治疗结束后，建议做个心脏彩超，看一下有无风湿性心脏病、瓣膜病。

酒店价格飞起...

这些要求坐标都得在当地吧，普通人没法申请...

刚搬新房，是 15 楼。楼下的 14 楼经常去找我，说我家小孩晚上动静大，跑来跑去。后来发现是 16 楼的小孩再跑来跑去的，我家听着感觉声音还可以，他家就听着受不了...

也可能是楼上的楼上

老婆赚的比我多，偶尔补贴我点...

薪资范围多少，我能做出来哈哈哈

目前薪资大约多少 K 啊

@leegradyllljjjj 深呼吸确实能缓解一点

即使没有多少工作，也会这样

春节期间从西安回青岛，很多地方高速上的信息牌写了应急车道可通行

有年终奖吗，有的话年终奖怎么算？

详细的 explain：

Finalize Aggregate (cost=425545.45..425545.46 rows=1 width=8) (actual time=522.040..573.976 rows=1 loops=1)
-> Gather (cost=425545.23..425545.44 rows=2 width=8) (actual time=521.286..573.949 rows=3 loops=1)
Workers Planned: 2
Workers Launched: 2
-> Partial Aggregate (cost=424545.23..424545.24 rows=1 width=8) (actual time=494.321..494.322 rows=1 loops=3)
-> Parallel Index Only Scan using bz_switchcover_open_close_time_c_idx on bz_switchcover (cost=0.43..421581.16 rows=1185629 width=0) (actual time=20.590..487.712 rows=9267 loops=3)
Index Cond: ((open_time <= '2023-07-16 23:59:59'::timestamp without time zone) AND (close_time >= '2023-07-16 00:00:00'::timestamp without time zone))
Heap Fetches: 18
Planning Time: 0.184 ms
JIT:
Functions: 11
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 1.365 ms, Inlining 0.000 ms, Optimization 1.067 ms, Emission 17.333 ms, Total 19.766 ms
Execution Time: 574.577 ms

@whoami9426

```
Finalize Aggregate (cost=362425.35..362425.36 rows=1 width=8)
-> Gather (cost=362425.14..362425.35 rows=2 width=8)
Workers Planned: 2
-> Partial Aggregate (cost=361425.14..361425.15 rows=1 width=8)
-> Parallel Index Only Scan using bz_switchcover_open_close_time_c_idx on bz_switchcover (cost=0.43..358436.32 rows=1195526 width=0)
Index Cond: ((open_time <= '2023-05-11 23:59:59'::timestamp without time zone) AND (close_time >= '2023-05-11 00:00:00'::timestamp without time zone))
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true

```

单纯的加上 limit 和 offset 分页查询是很快的，几十 ms ，就是 count 太耗时了。

select
*
from
switch.bz_switchcover
where
close_time>= '2023-05-01 00:00:00'
and open_time <= '2323-05-01 23:59:59'
order by open_time desc
limit 15 offset 0
;