1. 查看占io的sql: postgres=# select userid::regrole, dbid, query from pg_stat_statements order by total_time desc limit 5; ERROR: pg_stat_statements must be loaded via shared_preload_libraries 2. 添加配置 #postgresql.conf #---# PG_STAT_STATEMENTS OPTIONS #---shared...
cd ${script_dir}/postgresql-12.0/contrib/pg_stat_statements/ echo -e "$(date +%F_%T) $LINENO: ${GREEN} make install pg_stat_statements ${NC}" make install -j${processor} &>/dev/null sleep 5 cd ${script_dir}/ rm ${script_dir}/postgresql-12.0 -rf echo -e "$(date ...
pg_stat_statements.track = all EOF archivedir="${install_dir}/dgiot_pg_writer/archivedir" echo " archive_command = 'test ! -f ${archivedir}/%f && cp %p ${archivedir}/%f'" >> ${postgresql_conf} pg_hba_conf="${install_dir}/dgiot_pg_writer/data/pg_hba.conf" # METHOD...
Open source platform for iot , 6 min Quick Deployment,10M devices connection,Carrier level Stability;物联网开源平台,6分钟快速部署,千万级承载,电信级稳定性. Low code for Object model-Rule Engine-Data Channel-Configuration Page; Fully open source, Multi ind
添加pg_stat_statements数据库监控插件 cd ${script_dir}/postgresql-12.0/contrib/pg_stat_statements/ echo -e "`date +%F_%T` $LINENO: ${GREEN} make install pg_stat_statements ${NC}" make install -j${processor} &> /dev/null sleep 5 cd ${script_dir}/ rm ${script_dir}/postgresql-...
1. 查看占io的sql: postgres=# select userid::regrole, dbid, query from pg_stat_statements order by total_time desc limit 5; ERROR: pg_stat_statements must be loaded via shared_preload_libraries 2. 添加配置 #postgresql.conf #---# PG_STAT_STATEMENTS OPTIONS #---shared...
cd ${script_dir}/postgresql-12.0/contrib/pg_stat_statements/ echo -e "`date +%F_%T` $LINENO: ${GREEN} make install pg_stat_statements ${NC}" make install -j${processor} &> /dev/null sleep 5 cd ${script_dir}/ rm ${script_dir}/postgresql-12.0 -rf echo -e "`date +...
echo -e "`date +%F_%T` $LINENO: ${GREEN} make install pg_stat_statements ${NC}" make install -j${processor} &> /dev/null sleep 5 cd ${script_dir}/ rm ${script_dir}/postgresql-12.0 -rf echo -e "`date +%F_%T` $LINENO: ${GREEN} build postgres sueccess${NC}" ...
Files master .ci .github apps bin data deploy etc include lib-ce lib-extra priv scripts src test .editorconfig .gitattributes .gitignore .tool-versions CHANGELOG.md CONTRIBUTING.md LICENSE Makefile README-CN.md README-JP.md README-RU.md ...
echo -e "`date +%F_%T` $LINENO: ${GREEN} make install pg_stat_statements ${NC}" make install -j${processor} &> /dev/null sleep 5 cd ${script_dir}/ rm ${script_dir}/postgresql-12.0 -rf echo -e "`date +%F_%T` $LINENO: ${GREEN} build postgres sueccess${NC}" ...