日志记录= Ubuntu上的PostgresSQL 9.5的所有问题16.04

Question

所以我明白，所有会让我选择我想监视我的应用程序，但是，POSTGRES守护进程正在运行一个自己的选择对数据库并且它记录它...

有谁知道如何避免这个作为我的日志将得到填补，而迅速

LOG: statement: SELECT 
      (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Transactions", 
      (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Commits", 
      (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Rollbacks" 
2017-01-09 23:53:36 UTC [14264-16] [email protected] LOG: statement: SELECT 
      (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Transactions", 
      (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Commits", 
      (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Rollbacks" 
2017-01-09 23:53:37 UTC [14264-17] [email protected] LOG: statement: SELECT 
      (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Transactions", 
      (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Commits", 
      (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Rollbacks" 
2017-01-09 23:53:38 UTC [14264-18] [email protected] LOG: statement: SELECT 
      (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Transactions", 
      (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Commits", 
      (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Rollbacks" 
2017-01-09 23:53:39 UTC [14264-19] [email protected] LOG: statement: SELECT 
      (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16384)) AS "Transactions", .... 
... 
... 

Answer 1

只打开日志记录应用，

SQL：

ALTER USERyour_app_usernameSET log_statement='ALL';