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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to log 'user time' in postgres logs
Дата
Msg-id 29679.1567021881@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to log 'user time' in postgres logs  (francis picabia <fpicabia@gmail.com>)
Ответы Re: How to log 'user time' in postgres logs  (francis picabia <fpicabia@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Recomended front ends?
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Question about password character in ECPG's connection string