查看postgresql的日志show queries log in PostgreSQL?
原文:https://tableplus.io/blog/2018/10/how-to-show-queries-log-in-postgresql.html
--------------------------------------------------
In this post, we are going to discuss how to log all executed queries for inspection later in PostgreSQL.
1. First, you have to enable logging all queries in PostgreSQL.
Please note that only those queries that are executed can be logged.
To do that, you have to config the PostgreSQL configuration file postgresql.conf
.
- On Debian-based systems it’s located in
/etc/postgresql/9.3/main/
(replace 9.3 with your version of PostgreSQL) - On Red Hat-based systems in
/var/lib/pgsql/data/
.
If you still can’t find it, then just type $locate postgresql.conf
in terminal, or execute the following SQL query:
SHOW config_file;
Then you need to alter these parameters inside PostgreSQL configuration file.
log_statement = 'all'
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
logging_collector = on
log_min_error_statement = error
On older versions of PostgreSQL prior to 8.0, replace 'all'
with 'true'
for the log_statement
:
log_statement = 'true'
2. Then restart the server
Run this command:
sudo /etc/init.d/postgresql restart
or this
sudo service postgresql restart
The content of all queries to the server should now appear in the log.
3. See the log
The location of the log file will depend on the configuration.
- On Debian-based systems the default is
/var/log/postgresql/postgresql-9.3-main.log
(replace 9.3 with your version of PostgreSQL). - On Red Hat-based systems it is located in
/var/lib/pgsql/data/pg_log/
.
Using TablePlus, you can enable the console log via the GUI and see all the queries.
To do that, click on the console log button near the top right panel, or use the shortcut key Cmd + Shift + C.
You can also choose to log the meta queries, data queries, or all queries.
New to TablePlus? It’s a modern, native tool with an elegant GUI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.
Download TablePlus here. It’s free anyway!
最新文章
- xmpp整理笔记:环境的快速配置(附安装包)
- WebRequest中的工厂方法模式
- (JAVA版)冒泡排序
- 前端学习-使用JS库Leaflet.js生成世界地图并获取标注地址经纬度。
- jmeter,监控插件
- 写个自己的Xcode4插件
- jedis入门一
- setFocus一定要写在setLayout设置的后面,否则不起作用——使用setFocusPolicy为控件设置不同的焦点策略:Tab焦点,Click焦点,Wheel焦点和没有焦点
- Android 定义自己的学习(5)它们的定义Progressbar
- vs调试有时能进去后台,有时不能进去
- C#关于AutoResetEvent的使用介绍(用AutoResetEvent实现同步)
- Ubuntu14下安装svn仓库,以及权限配置
- Ubuntu文件中文乱码
- 第一课android开发之在activity间传递参数
- React 轮播图实现
- 微信小程序计算经纬距离
- 数据库中in和exists关键字的区别
- js发送邮件 不会调用客户端。
- c++ Stl 随笔
- topcoder srm 690 div1 -3