Re: Similar to csvlog but not really, json logs?

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Jim Nasby <jim(at)nasby(dot)net>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Similar to csvlog but not really, json logs?
Date: 2014-08-27 16:53:28
Message-ID: 20140827165328.GM21544@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2014-08-26 23:04:48 -0500, Jim Nasby wrote:
> On 8/26/14, 8:45 PM, Michael Paquier wrote:
> >Hi all,
> >
> >As mentioned here, we support multiple logging format:
> >http://www.postgresql.org/docs/devel/static/runtime-config-logging.html
> >Now what about a json format logging with one json object per log entry?
> >
> >A single json entry would need more space than a csv one as we need to
> >track the field names with their values. Also, there is always the
> >argument that if an application needs json-format logs, it could use
> >csvlog on Postgres-side and do the transformation itself. But wouldn't
> >it be a win for application or tools if such an option is available
> >in-core?
> >
> >Note that I am not planning to work on that in a close future, but it
> >would be a good TODO item for beginners if it is worth pursuing.
>
> Perhaps instead of doing this in-core it would be better to make log handling more extensible? I'm thinking add a specific "binary" format and an external tool that can parse that and do whatever the user wants with it. That means we don't have to keep adding more complexity to the internal log handling (which already has the risk of being a bottleneck), while allowing maximum user flexibility.

There's a logging hook. Most of this should be doable from there.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2014-08-27 17:00:12 Re: postgresql latency & bgwriter not doing its job
Previous Message Jim Nasby 2014-08-27 16:51:40 Re: delta relations in AFTER triggers