【日常笔记v1.0.0】

日常笔记整理

1 查看定时任务命令

crontab -l

2.linux下的etc/profile环境变量配置

export JAVA_HOME=/usr/local/jdk1.8
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib
export PATH=${JAVA_HOME}/bin:$PATH
export CATALINA_HOME=/usr/local/tomcat8
export LD_LIBRARY_PATH=/usr/local/model/Program/Bin/x64/:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH=/usr/local/model/Program/Libs/x64/:$LD_LIBRARY_PATH
export Path_GModel=/usr/local/model/Program/
export GDAL_DATA=/usr/local/share/gdal
export PATH=/usr/local/jdk1.8/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/opt/ant/apache-ant-1.10.3/bin:/root/bin:/opt/ant/apache-ant-1.10.3/bin:/root/bin:/opt/ant/apache-ant-1.10.3/bin:/root/bin:/opt/ant/apache-ant-1.10.3/bin:/root/bin:GDAL_DATA:/root/anaconda2/bin:/root/anaconda2

3.服务器账号

postgres操作指令

/usr/pgsql-11/bin/postgresql-11-setup initdb -D /mnt/pgsql/data

chkconfig postgresql-11.service on

postgres 数据库语句查看表占用磁盘大小

1.查看单个数据库的存储空间占用

SELECT pg_size_pretty( pg_database_size('mydb') );

2.查看单张表的存储空间占用

SELECT pg_size_pretty( pg_total_relation_size('mytable') );

3.统计数据库中各表占用磁盘大小：

SELECT table_schema || '.' || table_name AS table_full_name, pg_size_pretty(pg_total_relation_size('"' || table_schema || '"."' || table_name || '"')) AS size FROM information_schema.tables ORDER BY pg_total_relation_size('"' || table_schema || '"."' || table_name || '"') DESC

4.统计各数据库占用磁盘大小：

SELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner, CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname)) ELSE 'No Access' END AS SIZE FROM pg_catalog.pg_database d ORDER BY CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') THEN pg_catalog.pg_database_size(d.datname) ELSE NULL END DESC -- nulls first

代码生成工具：

https://gitee.com/renrenio/renren-generator

https://easydoc.xyz/s/78237135/ZUqEdvA4/zX1XGjn2