Difference between revisions of "Log statement"
Jump to navigation
Jump to search
| (7 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
[[ALTER USER]] interactive_user SET log_statement = 'all'; | [[ALTER USER]] interactive_user SET log_statement = 'all'; | ||
| + | [[SET SESSION]] log_statement TO 'all'; | ||
[[ALTER SYSTEM SET]] log_statement = 'all'; | [[ALTER SYSTEM SET]] log_statement = 'all'; | ||
| Line 16: | Line 17: | ||
The default is none. Only superusers can change this setting. | The default is none. Only superusers can change this setting. | ||
| − | |||
| − | |||
== Related == | == Related == | ||
| + | * [[AWS RDS query logging]], <code>[[log_min_duration_statement]]</code> | ||
* <code>[[/etc/postgresql/12/main/postgresql.conf]]</code> | * <code>[[/etc/postgresql/12/main/postgresql.conf]]</code> | ||
| + | * Read https://www.cybertec-postgresql.com/en/debugging-deadlocks-in-postgresql/ | ||
== See also == | == See also == | ||
| + | * {{aws rds parameter-group}} | ||
* {{PostgreSQL}} | * {{PostgreSQL}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 08:31, 11 October 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[edit]
- AWS RDS query logging,
log_min_duration_statement /etc/postgresql/12/main/postgresql.conf- Read https://www.cybertec-postgresql.com/en/debugging-deadlocks-in-postgresql/
See also[edit]
- RDS Parameter group:
aws rds [ create-db-parameter-group | describe-db-cluster-parameters ] - PostgreSQL:
pg_dump, pg_restore,pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB,Adminer, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs,postgresql.conf,pg_hba.conf, $HOME/.pg_service.conf, Create database (PostgreSQL), Create user,createdb,GRANT,pg_stat, PostgreSQL VACUUM, EXPLAIN,pg stat activity, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL),EXPLAIN ANALYZE, Bitmap scan,EXPLAIN VERBOSE,EXPLAIN VERBOSE (PostgresSQL),WAL,ALTER USER,CREATE ROLE, CREATE USER,\du,show users,\l, The Statistics Collector, pganalyze,cron.schedule, Master,pg_tables, PostgreSQL replication,CREATE, SET, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users
Advertising:
