How to log PostgreSQL queries?
If you would like to log all PostgreSQL queries into a file, you can do that by changing few settings int the configuration file
data/postgresql.conf file and change the following settings:
#log_directory = 'pg_log’change to
log_directory = 'pg_log’
#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log’change to
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
#log_statement = 'none’change to
log_statement = 'all’
#logging_collector = offchange to
logging_collector = on
- Run the following statement:
SELECT set_config('log_statement', 'all', true);
- Then restart the PostgreSQL server
sudo service postgresql restart
Now, you can find the logs in the following directory
Where can I find error log files for PHP?
PHP stores error logs in /var/log/apache2 if PHP is an apache2 module. Shared hosts are often storing log files in your root directory /log subdirectory. If you are using cPanel, the master log is ...Questions
How to do error logging in CodeIgniter (PHP)
Code igniter has logging capabilities built-in. Make sure you do the following: Make your /application/logs folder writable In /application/config/config.php set the following: php $config['log_thr...Questions
How to Get the Query Executed in Laravel 5
By default, the query log is disabled (https://github.com/laravel/framework/commit/e0abfe5c49d225567cb4dfd56df9ef05cc297448) in Laravel 5: Don’t worry, you can enable the query log by running the f...Questions
How to enable MySQL Query Log?
MySQL query log stores the history of executed queries. This history is stored in a log file. On busy servers, this file ca grow very large. To enable the query log, put the following line into /et...Questions
We are hiring.
Software is our way of making the world a tiny bit better. We build tools for the makers of tomorrow.
Help us in making the internet more reliable.
Help us with developer education and get paid.
Reliability is the
Delightful observability tools that turn your logs & monitoring into a secret weapon for shipping better software faster.Explore Better Stack