vanpeisi7 最近的时间轴更新 vanpeisi7 最近的时间轴更新 |
vanpeisi7V2EX 第 520519 号会员，加入于 2020-11-25 19:12:13 +08:00今日活跃度排名 2478 |
| 你们感冒时都请假吗？如果请假，需要去医院开证明不？ 职场话题 • vanpeisi7 • 9 天前 • 最后回复来自 NewYear | 43 |
| 为什么一坐到工位上就感到疲惫、心慌？ 职场话题 • vanpeisi7 • 35 天前 • 最后回复来自 ROrdo | 68 |
| 求助，关于 sql 查询时间取并集的情况
1 PostgreSQL • vanpeisi7 • 2024-01-09 14:17:43 PM • 最后回复来自 Belmode
|
11 |
| 请教一下 rabbitmq 应答超时异常问题 程序员 • vanpeisi7 • 2023-11-09 10:51:26 AM • 最后回复来自 WashFreshFresh | 4 |
| Rabbitmq 中， acknowledge-mode 配置为 auto，消费会丢失数据吗？ 程序员 • vanpeisi7 • 2023-10-26 14:47:36 PM • 最后回复来自 vanpeisi7 | 4 |
vanpeisi7 最近回复了
27 天前 回复了 maxmax4max 创建的主题 › 生活 › 已婚的来说下，每个月给老婆/家庭多少钱。 |
老婆赚的比我多，偶尔补贴我点...
27 天前 回复了 yuanyao 创建的主题 › 职场话题 › 一面出 LRU 算法题算难吗 |
薪资范围多少，我能做出来哈哈哈
29 天前 回复了 jeanz 创建的主题 › 求职 › 工作三年换工作，求大家指点简历内容 |
目前薪资大约多少 K 啊
37 天前 回复了 vanpeisi7 创建的主题 › 职场话题 › 为什么一坐到工位上就感到疲惫、心慌？ |
@leegradyllljjjj 深呼吸确实能缓解一点
37 天前 回复了 vanpeisi7 创建的主题 › 职场话题 › 为什么一坐到工位上就感到疲惫、心慌？ |
即使没有多少工作，也会这样
有年终奖吗，有的话年终奖怎么算？
2024-01-08 14:37:07 +08:00 回复了 vanpeisi7 创建的主题 › PostgreSQL › 求助，关于 sql 查询时间取并集的情况 |
详细的 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
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
2024-01-08 14:34:47 +08:00 回复了 vanpeisi7 创建的主题 › PostgreSQL › 求助，关于 sql 查询时间取并集的情况 |
@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
```
```
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
```
Select Language