All geek questions in one place

Postgres db request monitor

Is there an easy way to track Postgres db requests in an environment (Windows XP). I am testing a new code and suspect that in some cases the requests are duplicated / repeated under certain conditions.

What is the easiest / best way to do this - I just need something simple - basically a timestamp and query syntax.

+4
source share
1 answer

Just add the following line to the configuration file:

log_min_duration_statement = 0

After a reboot, the log file contains all the instructions.

+4
source

Source: https://habr.com/ru/post/1347870/

More articles:


All Articles