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 1mOGAI-0004Fy-PM for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Sep 2021 09:16:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mOGAH-0008UU-Nr for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Sep 2021 09:16:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mOGAH-0008UL-F1 for pgsql-hackers@lists.postgresql.org; Thu, 09 Sep 2021 09:16:13 +0000 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mOGAG-00089W-18 for pgsql-hackers@lists.postgresql.org; Thu, 09 Sep 2021 09:16:13 +0000 Received: by mail-wm1-x336.google.com with SMTP id l7-20020a1c2507000000b002e6be5d86b3so842691wml.3 for ; Thu, 09 Sep 2021 02:16:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aiven.io; s=google; h=from:to:subject:date:message-id:organization:in-reply-to:references :mime-version:content-transfer-encoding; bh=OxzmrvK4+pQ+RDgkCwxGBkOlYEjIFDwyeAhI7M+68P0=; b=TGRbEBDY9y19JlJSZ1NDaMt3RsKhCk/psakUo2qRTe8yCxu0DH6w2/1UXs7tZZ/kZJ 3/YqYh3HrC3if3NT1Ec43KEmRk+XhDqOXNMLbs7o4EpaaBqoZzJcbQIeWS6LaBJFdXia RA3LG8Enad5pBR5rIv9rYnYSy/CSjyZUCnW6k= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:subject:date:message-id:organization :in-reply-to:references:mime-version:content-transfer-encoding; bh=OxzmrvK4+pQ+RDgkCwxGBkOlYEjIFDwyeAhI7M+68P0=; b=a2qXZoH12pkT/qH2niF3cSl/By0J27OSB3T5JCehMX2VpGInLGdShsakoTVHj18zBO zATT+eYqPJQh1V8AujhThviln3iOqaCsnzpjb0VMw7Dez4/sm6EjDoqGH4Do1Dy41ZGf 4iOlCAkMbKqC2AC0/Zk6s4VItEhijCKmVsSDN8uYYH9STenZRk2ad2Ue0F+oayKWBD0K hImU5Hu8/z+LMB5VPGqqOhaGWBpS4Z8QYVVG7eDiBtIWG5JI3PQr2YRPodCw/8OgovoC 0TY7KplRSiNAuzsPFZiGNiNikkd7ZDVOsi9Q8zN8p1y5ky5boQHu0BeMFOZZ13mtplu4 0hiQ== X-Gm-Message-State: AOAM531eOFtLXsZRg5iLjqdVmjHvBQbRxTUsAmuJAmDit9zjTN1KxbjO bMLvpqpEpbF3lZjhM2cqBkGCQu/Z/tp62Q== X-Google-Smtp-Source: ABdhPJzSHCxmnxKTv2C9vTPzCAF32bVnNOFwR/E1rQDBAWDl8Pejp7HZftQRfj0kKihXg84WZX33xQ== X-Received: by 2002:a1c:4c13:: with SMTP id z19mr1837378wmf.154.1631178970536; Thu, 09 Sep 2021 02:16:10 -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 q128sm1143472wma.27.2021.09.09.02.16.07 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 09 Sep 2021 02:16:09 -0700 (PDT) From: Ronan Dunklau To: pgsql-hackers@lists.postgresql.org, Peter Eisentraut Subject: Re: Proposal: More structured logging Date: Thu, 09 Sep 2021 11:15:36 +0200 Message-ID: <19106440.dsh0iPAc3d@aivenronan> Organization: aiven In-Reply-To: <03fa81f6-77b0-e7eb-b390-dfe04f180495@enterprisedb.com> References: <3207907.AWbSqkKDnR@aivenronan> <163276811.1OrvvjSa7g@aivenronan> <03fa81f6-77b0-e7eb-b390-dfe04f180495@enterprisedb.com> 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 mercredi 8 septembre 2021, 11:51:31 CEST Peter Eisentraut a =E9crit : > On 01.09.21 10:00, Ronan Dunklau wrote: > > In-core it would open up the possibility to split log messages into > > different fields, for example the different statistics reported in the > > logs by VACUUM / ANALYZE VERBOSE and make it easier to consume the outp= ut > > without having to parse the message. Parsing the message also means that > > any tool parsing it needs to either be aware of the locale, or to force > > the user to use a specific one. >=20 > I think those messages would themselves have substructure. For example, > the current message >=20 > "I/O timings: read: %.3f ms, write: %.3f ms\n" >=20 > might be >=20 > {"I/O timings": {"read": ..., "write": ...}} >=20 > and that in turn is already part of a larger message. >=20 > So just having a single level of tags wouldn't really work for this. I agree having a nested structure may feel more natural, but I don't think = it=20 would matter too much if we standardize on ini-style property names (ie,=20 iotimings.read, iotimings.write and so on...) Regards, =2D-=20 Ronan Dunklau