Difference between revisions of "Log statement"

From wikieduonline
Jump to navigation Jump to search
Line 23: Line 23:
 
== Related ==
 
== Related ==
 
* <code>[[/etc/postgresql/12/main/postgresql.conf]]</code>
 
* <code>[[/etc/postgresql/12/main/postgresql.conf]]</code>
* [[AWS RDS query logging]]
+
* [[AWS RDS query logging]]: https://aws.amazon.com/premiumsupport/knowledge-center/rds-postgresql-query-logging/
  
 
== See also ==
 
== See also ==

Revision as of 21:45, 22 September 2022

#log_statement = 'none'			# none, ddl, mod, all
ALTER USER interactive_user SET log_statement = 'all';
SET SESSION log_statement TO 'all'; 
ALTER SYSTEM SET log_statement = 'all';
ALTER USER application_user SET log_statement = 'none';

https://www.postgresql.org/docs/current/runtime-config-logging.html

Controls which SQL statements are logged. Valid values are none (off), ddl, mod, and all (all statements). ddl logs all data definition 
statements, such as CREATE, ALTER, and DROP statements. mod logs all ddl statements, plus data-modifying statements such as INSERT, 
UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE, EXECUTE, and EXPLAIN ANALYZE statements are also logged if their contained command is 
of an appropriate type. For clients using extended query protocol, logging occurs when an Execute message is received, and values of the 
Bind parameters are included (with any embedded single-quote marks doubled).

The default is none. Only superusers can change this setting.



Related

See also

Advertising: