Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mH0wR-0003F9-1N for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Aug 2021 09:35:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mH0wQ-0007W6-1P for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Aug 2021 09:35:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mH0wP-0007Vy-PQ for pgsql-hackers@lists.postgresql.org; Fri, 20 Aug 2021 09:35:57 +0000 Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mH0wN-00042W-L6 for pgsql-hackers@lists.postgresql.org; Fri, 20 Aug 2021 09:35:56 +0000 Received: by mail-wr1-x42b.google.com with SMTP id k29so13267460wrd.7 for ; Fri, 20 Aug 2021 02:35:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aiven.io; s=google; h=from:to:cc:subject:date:message-id:organization:in-reply-to :references:mime-version:content-transfer-encoding; bh=LSrxzJqHZq7Ib69u4aEwJm+nsJ19+U2YJhRqjfJcoPA=; b=B09u1fUrhRBv80UUx5RVIsYMxra+P5wvf46tkjFIiNWjZJKrFRbnWaK6IjkcA3kgwZ 8rep4cKlrCjV2BOOUOfdk/F3/oZyxHE9mLThTiOeKq+EimwWTIjGit2p0A4K1BGd+cbI tsfLzEIS0rge2uiXNnlEFGJKHy5olR/hoMT/I= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:date:message-id:organization :in-reply-to:references:mime-version:content-transfer-encoding; bh=LSrxzJqHZq7Ib69u4aEwJm+nsJ19+U2YJhRqjfJcoPA=; b=kOZdKVYHPtsWlRRarCm9VQwLtSP+E6U4wGET4NyL0Q8HJN7msesnIO+Bh5JHFjrT0D qBPE9xzL3XsqwCdnnKPOrtoB8Vt/ZJnzzjC2sGZ6/uY2O7ofDYR4TMtpP1epJDdYO2w6 V1rJoJZCg1KOMk1OAdE+rjGXcck6sA4HRYbgm8YrkO9N3wBdU3uSErG10cADOEZLDCDS /Ltvsm575Slz8ZESjINq+4sDQmowm2FMoq/hSe+w8oMNhjF1aIbfoizvmhkhOzi8eH8W 8ee7JO6HNSD4uzJMJGhD5VBoJfIpHG37/U3Y26do7Q7j19yF8Iq7GPk/T/T5MipCPgml cXlQ== X-Gm-Message-State: AOAM533+fQC4mAn75NfDnQcpIoCjGVV2Gl/3PWZvnuWEnjTqmn+euxz+ cJ5cmV0X4Xo2WDQwnxeHW9wUUg== X-Google-Smtp-Source: ABdhPJy5mHTj9MyeNhYIJqPWPth9HkEczQlZWFr9cww4bCbNIEGjuMiOCBTcr+rXYw8aMKduQ1hKvA== X-Received: by 2002:a5d:6349:: with SMTP id b9mr8941675wrw.341.1629452154123; Fri, 20 Aug 2021 02:35:54 -0700 (PDT) Received: from aivenronan.localnet (static-176-158-121-96.ftth.abo.bbox.fr. [176.158.121.96]) by smtp.gmail.com with ESMTPSA id l18sm11568476wmc.30.2021.08.20.02.35.53 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Aug 2021 02:35:53 -0700 (PDT) From: Ronan Dunklau To: Magnus Hagander , pgsql-hackers@lists.postgresql.org Cc: PostgreSQL Developers , Alvaro Herrera , Michael Paquier Subject: Re: Proposal: More structured logging Date: Fri, 20 Aug 2021 11:35:29 +0200 Message-ID: <6062364.BDNAq9uPBk@aivenronan> Organization: aiven In-Reply-To: <202108191450.7vik45yrlwle@alvherre.pgsql> References: <202108191450.7vik45yrlwle@alvherre.pgsql> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Le jeudi 19 ao=FBt 2021, 16:50:10 CEST Alvaro Herrera a =E9crit : > On 2021-Aug-19, Magnus Hagander wrote: > > Another thing I've noticed in more and more other products is to be > > able to log as json, which is then later thrown into a central logging > > system somewhere. Basically like csv, but with the schema defined in > > each row. Yes, a lot more overhead, but some systems really do like to > > consume json.... So when we're on the topic of more structured > > logging... >=20 > Yeah, I was thinking in json logging too -- specifically thinking about > Fluentbit and similar tools. Michael, your jsonlog module already fullfills this need. Is it something t= hat=20 should be merged into our tree ? =2D-=20 Ronan Dunklau