暂无图片
pg中的t_infomask & 128是啥意思?
我来答
分享
暂无图片 匿名用户
pg中的t_infomask & 128是啥意思?

CASE WHEN (t_infomask & 128) > 0 THEN 't' END AS lock_only


t_infomask & 128  这个是啥意思 

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
Murkey

SELECT '(0,'||lp||')' AS ctid, -- tuple ctid

t_xmax as xmax, -- xmax

CASE WHEN (t_infomask & 128) > 0 THEN 't' END AS lock_only, -- 0x0080,HEAP_XMAX_LOCK_ONLY

CASE WHEN (t_infomask & 4096) > 0 THEN 't' END AS is_multi, -- 0x1000,HEAP_XMAX_IS_MULTI

CASE WHEN (t_infomask2 & 8192) > 0 THEN 't' END AS keys_upd, -- 0x2000,HEAP_KEYS_UPDATED

CASE WHEN (t_infomask & 16) > 0 THEN 't' END AS keyshr_lock, -- 0x0010,HEAP_XMAX_KEYSHR_LOCK

CASE WHEN (t_infomask & 16+64) = 16+64 THEN 't' END AS shr_lock -- 0x0010 & 0x0040,HEAP_XMAX_SHR_LOCK = HEAP_XMAX_KEYSHR_LOCK | HEAP_XMAX_EXCL_LOCK

FROM heap_page_items(get_raw_page(pi_name,0))

ORDER BY lp;

是查看t_infomask2类型的

暂无图片 评论
暂无图片 有用 1
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏