开发者

Monitor Postgres db queries

开发者 https://www.devze.com 2023-02-25 00:45 出处:网络
Is there an easy way to monitor Postgres db queries in a (Windows XP) environment. I\'m testing some new code and suspect that in some cases queries are being duplicated/repeated under certain conditi

Is there an easy way to monitor Postgres db queries in a (Windows XP) environment. I'm testing some new code and suspect that in some cases queries are being duplicated/repeated under certain conditions.

What is the e开发者_运维技巧asiest/best way to do this - I just need something simple - basically the timestamp and syntax of the query.


Just add the following line into the config file:

log_min_duration_statement = 0  

After a restart your logfile contains all statements.

0

精彩评论

暂无评论...
验证码 换一张
取 消