http://kb.owrench.com/index.php?action=history&feed=atom&title=Postgresql_slow_queryPostgresql slow query - Revision history2026-05-04T04:22:41ZRevision history for this page on the wikiMediaWiki 1.34.2http://kb.owrench.com/index.php?title=Postgresql_slow_query&diff=159&oldid=prev137.97.105.157: Postgresql slow query2021-04-27T05:32:42Z<p>Postgresql slow query</p>
<p><b>New page</b></p><div>[[Category:It-support|Postgresql slow query]]<br />
<br />
<br />
1) To enable slow query log in postgresql, firstly you have to open the postgres configuration file "/etc/postgresql/9.1/main/postgresql.conf"<br />
<br />
2) Then find the following line <br />
<br />
#log_min_duration_statement = -1<br />
<br />
Uncomment it and replace -1 with a query runtime threshold in milliseconds.<br />
<br />
eg: log_min_duration_statement = 1000<br />
<br />
3) Make sure logging_collector is set to on.<br />
<br />
4) Then save the configuration and restart the service<br />
<br />
sudo systemctl restart postgresql<br />
<br />
5) The go to the postgreSQL log collecting directory "/var/lib/pgsql/data/pg_log/" and find the log file in it.</div>137.97.105.157