PostgreSQL how to see which queries have run

Question

I have a PostgreSQL DB at my computer and I have an application that runs queries on it   How can I see which queries has run on my DB   I use a Linux computer and pgadmin

User · Answer

I found the log file at  usr local var log postgres log on a mac installation from brew

User · Answer

PostgreSql is very advanced when related to logging techniques  Logs are stored in Installationfolder data pg log folder  While log settings are placed in postgresql conf file   Log format is usually set as stderr  But CSV log format is recommended  In order to enable CSV format change in   log destination    stderr csvlog     logging collector   on   In order to log all queries  very usefull for new installations  set min  execution time for a query  log min duration statement   0   In order to view active Queries on your database  use  SELECT   FROM pg stat activity   To log specific queries set query type   log statement    all              none  ddl  mod  all   For more information on Logging queries see PostgreSql Log

User · Answer

Turn on the server log  log statement   all  This will log every call to the database server  I would not use log statement   all on a production server  Produces huge log files  The manual about logging-parameters   log statement  enum  Controls which SQL statements are logged  Valid values are none  off   ddl  mod  and all  all statements          Resetting the log statement parameter requires a server reload  SIGHUP   A restart is not necessary  Read the manual on how to set parameters  Don t confuse the server log with pgAdmin s log  Two different things  You can also look at the server log files in pgAdmin  if you have access to the files  may not be the case with a remote server  and set it up correctly  In pgadmin III  have a look at  Tools - gt  Server status  That option was removed in  pgadmin4  I prefer to read the server log files with vim  or any editor   reader of your choice

User · Answer

While using Django with postgres 10 6  logging was enabled by default  and I was able to simply do   tail -f  var log postgresql     Ubuntu 18 04  django 2   python3

User · Answer

You can see in pg log folder if the log configuration is enabled in postgresql conf with this log directory name

[database] PostgreSQL how to see which queries have run

Examples related to database

Examples related to postgresql

Examples related to pgadmin