Monitor Postgres db queries

Question

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 easiest/best way to do this - I just need something simple - basically the timestamp and syntax of the query.

Daniel · Accepted Answer · 2011-04-13 08:19:40Z

4

Just add the following line into the config file:

log_min_duration_statement = 0

After a restart your logfile contains all statements.

answered Apr 13, 2011 at 8:19

Daniel

28.2k20 gold badges93 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user330315 Over a year ago

A restart is not necessary. pg_ctl reload should be sufficient

Collectives™ on Stack Overflow

Monitor Postgres db queries

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related