如下:SELECT procpid, START, now() - START AS lap, current_query FROM ( SELECT backendid, pg_stat_get_backend_pid (S.backendid) AS procpid, ...
select table_schema as '数据库', table_name as '表名', table_rows as '记录数', truncate(data_length/1024/1024, 2) as '数据容量(MB)', truncate(index_length/1024/1024, 2) as '索引容量(MB)' from information_schema.ta...
golang默认采用UTC,即Unix标准时间。而一般情况下,我们存数据库采用的是中国时间,即CST;UTC和CST一般相差8个小时;time.Now()输出默认CST时区时间;time.Parse()默认输出UTC时区时间。所以在使用time.Format时如果不注意会出现时间对不上相差8个小时的问题。解决方法如下:通过time.Unix转为时间类型 函数认为接收的时间戳是UTC 并会结果...
sudo apt update sudo apt upgrade sudo apt install librdkafka-dev