Re: How to log 'user time' in postgres logs - Mailing list pgsql-general

From Tom Lane
Subject Re: How to log 'user time' in postgres logs
Date
Msg-id 29679.1567021881@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to log 'user time' in postgres logs  (francis picabia <fpicabia@gmail.com>)
Responses Re: How to log 'user time' in postgres logs
List pgsql-general
francis picabia <fpicabia@gmail.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



pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Recomended front ends?
Next
From: Alban Hertroys
Date:
Subject: Re: Question about password character in ECPG's connection string