Re: How to log 'user time' in postgres logs

francis picabia <fpicabia(at)gmail(dot)com> writes:
> The server was running Moodle. The slow load time was noticed when loading
> a quiz containing
> multiple images. All Apache log results showed a 6 seconds or a multiple
> of 6 for how long
> it took to retrieve each image.

> Interestingly, if I did a wget, on the server, to the image link (which was
> processed through a pluginfile.php URL)
> even the HTML page returned of "please login first" took consistently 6
> seconds. Never 2, 3, 4, 5 or 7, 8, 9...
> So whatever was wrong, there was a 6 second penalty for this.

Hmm ... some weird DNS behavior, perhaps? That is one way to explain
a pattern like this. How long does it take to "dig" or "nslookup"
your server name?

regards, tom lane