postgresql.conf
...
#log_min_duration_statement = -1
…
の箇所を
postgresql.conf
...
log_min_duration_statement = 0
...
に変更し、postgres再起動すると全てのSQLがserverlogにSQLが出力される。
postgresql.conf
...
log_min_duration_statement = 3s
...
で３秒以上かかったSQLのみ出力。
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme