feature request: log bytes out for each request - Mailing list pgsql-general

From Aleksey Tsalolikhin
Subject feature request: log bytes out for each request
Date
Msg-id AANLkTinzt7D5RtkXvpxievetqnTtDgJug-wN6CkA+WBy@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi.  Could you please consider logging size of reply, like Apache
httpd does with its logfile?

We've started having intermittent spikes in network usage (the network
interface on the
DB server is getting maxed out) and I suspect there is a single very
large query (just a
working hypothesis at this point).

Logging of answer sizes would help track down an issue like this; plus
you could track
on an ongoing basis how much work you're doing, which may be useful for capacity
planning.

Thanks for a great database server!

Kind regards,
Aleksey

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Next
From: Allan Kamau
Date:
Subject: ERROR row is too big size 9336, exceeds size 8160 when populating record with tsquery and tsvector fields