TDengine icon indicating copy to clipboard operation
TDengine copied to clipboard

Published 20 hours ago • verified publisher icon taosdata

query performance issue

Open xingcun opened this issue 2 years ago • 2 comments

Bug Description

6921666927245_ pic

非超级表下的普通表，一千万条数据查询count(*)就要花费7秒

Environment (please complete the following information):

  • OS: [e.g. CentOS 7.0]
  • Memory 16g, CPU 4核, 普通硬盘current Disk Space
  • TDengine Version [3.0]

xingcun avatar Oct 28 '22 07:10 xingcun

这个表有没有做过大量更新操作？表结构describe table 发一下看看

yu285 avatar Oct 31 '22 02:10 yu285

image

xingcun avatar Nov 01 '22 04:11 xingcun