Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1j7Agm-0008Ty-W8 for pgsql-admin@arkaria.postgresql.org; Thu, 27 Feb 2020 04:22:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j7Agl-0006Nk-Jn for pgsql-admin@arkaria.postgresql.org; Thu, 27 Feb 2020 04:22:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j7Agk-0006NY-Fy for pgsql-admin@lists.postgresql.org; Thu, 27 Feb 2020 04:22:19 +0000 Received: from sonic311-22.consmr.mail.sg3.yahoo.com ([106.10.244.39]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1j7Agh-0004ud-NT for pgsql-admin@lists.postgresql.org; Thu, 27 Feb 2020 04:22:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1582777331; bh=2q9Xk1w0X0Nh6S1R1EpWoPNlMuSlMzR9Efa6V9+KlhQ=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=s0qqZByAh8NVJPZhysIERM7w86M8yl5k3W/fZ+PDi3crjjNg9WGtQknrMGMPZWEeXcFejgY1qjo9/MuBsgtm4s9p7WksRwcC0Ayyi0cFII79ptVNV3KWLwsF5JW9zzcsONOKfwa9vruEXo+kvYokkJ8H97D9Jn7TFPN8RIiGzOls5+o3sQPqZeRDpe7xsnoKF2DP0aJGQ1BtQablwFP7G7ccQ9J44SKscyak+zeyrugQe1j/1wjElCHwO34u+gXeiounH3HoU6x37p7/UttOoqGBao5yU/FbRY2oMNhLd6N+dCBUG+nMmSfU1Z/sNlvmxHV4H3WPAOWikYiOPaAxiw== X-YMail-OSG: DjkUSeoVM1nMWLdRirxszujh4Y72LXONyfrDJehwt50AFiIzUkZqQjR0X4wBM7R NREAgoatlPezyZpYOZ..VDvIMVuk5uMd4sGtNs6UVnNhc3WMgTabv1Xx1QXPi2fXr63HAZEy8Agq mb.CtD8TSZOZYWsVEc6XstdSZhExqL8RLwIH4BxuLU4zHnim4vf14UArZDuu7dwCWiWnRu_9OBpM m3GDY0g9rxlKPgM6e41wdxk4SjZdyHcZskI6q1lTf3yVoC_vJm1uMiWOmTp4NPy9vW74CWWz.Sw. U5wdi.efiYd3HQuWnvBB5JxvZHbvuK_S_6CvPRzGpiF7YiuAmQL41xbDnHf.98TT3dUWWaKPRVEV l2JCAZ9FSoJOMT1rp88wWzsU1pTYRddTUd9.JRLdyUgMPnkCjUKSt.z4uAxcMr363wwIfqb6sD3w MOktIOjqw1tu3W1q0q5rCMKwmDr6hNtdA0eqp8g6oaWZjcvQl_MIurENpQPRqnBa4gaaRfee43HY Ayt8T17MTO0dMEGn61w6kz6hvl2hHFo8dYdAhAKA4_3aASIAcdTVYI156.hFnnGBkH7ySmknploO FLbtbXF2DKOX0_jgullZYAIQPBJGjXb_SlJCvS1IoxV7FHciJXR5B_x39JJbbHXGRj9QLlC11Gdu NB2CexAEut.hMZCf3lrAOsrdCcKTps6tOsyCCtPvkIBolCWaqLwm5mefhp4cCXRpjmt8uMucyBUu wTzyY79QksIJ0KduD9mZlOBdkGJpMBfWcGi9ZkrMWhTdEJSKjbxdYBMzGfKYaHENuLHuO1T7kxhg TPih3ddaP9u.3x3W68arIPx0B9BOhQ65J7.S483lXhr39zoJIv.VgMu7SzbQ9IQ1kBTY8BJJXdjp 5_MJW7wfmMgVSERATo9R61uUTOMqgttQqOV_l1CEaezffF5pXZxEreRL2RdFDXYqPM1w5mxU4bMp bOyFxnXQ0b4AV7DrxjvbCzs2pdsNA.ZR6aKELjBh5p5Ni_5lG3vRbZdklW7ov5czLcH8WHNeRMot G1MapIVFxsFDdsCwPrQli_ewrQt9hNicQtmpTUt6atbr9AXoBfnnDVRYFINF1xMrTIhSsHA9oF_I jrH3GYnKjoB0ZAZt0mR80aV3I39BI8.vVANYbj83qAwv3homBZOvAi_c_8tZyKR7ESyebAGIoDdG wauAIHH40fvQujkrsZjSB3wkljX_iDuyqx2NKhO744tZz9o2lSc7nRIVMEbM8hLrdfN1LsJs9JH7 vQMxHyynQjVYwhHYxXBv4r2EBp2yJAV8l5Rpoo1yz7pRRORlF1U3ClZ3yWQYPlPNFKiU8ROvLHl4 6xfiNHZ0X0hwH.hDVD9EyBzn8bdBqB54- Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.sg3.yahoo.com with HTTP; Thu, 27 Feb 2020 04:22:11 +0000 Date: Thu, 27 Feb 2020 04:22:06 +0000 (UTC) From: manish yadav Reply-To: manish yadav To: pgsql-admin@lists.postgresql.org, "S.Bob" Message-ID: <1410727976.946305.1582777326664@mail.yahoo.com> In-Reply-To: <2c0a721c-977f-6233-5eed-c77bd0d3fbdb@quadratum-braccas.com> References: <2c0a721c-977f-6233-5eed-c77bd0d3fbdb@quadratum-braccas.com> Subject: Re: pgbadger question MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_946304_1496321008.1582777326662" X-Mailer: WebService/1.1.15302 YMailNorrin Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.1 Safari/605.1.15 Content-Length: 5736 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_946304_1496321008.1582777326662 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, Please try with passing parameter log_line_prefix using --prefix pgbadger --prefix -o postgres-Mon.html ./postgre= s-Mon.log=C2=A0 Note : =C2=A0copy/paste exact value from=C2=A0PostgreSQL.conf file/show all= and paste in the command above. Thanks and Regards, Manish Yadav Mobile : +91 8527607945=20 On Thursday, 27 February 2020, 1:47:43 AM IST, S.Bob wrote: =20 =20 All; Sorry if this is OT: We have a client that logs all statements with : log_statement =3D 'all' However they also have left log_min_duration_statement disabled: log_min_duration_statement =3D -1 When I attempt to parse a report with pgbadger like this: pgbadger -o postgres-Mon.html ./postgres-Mon.log It parses zero queries, even though the query data is there, just that=20 it was logged via log_statement =3D 'all' instead of via setting=20 log_min_duration_statement =3D x Is there any way=C2=A0 to force pgbadger to pick up / reckognize the logges= =20 queries? Thanks in advance --=20 `When you say "I wrote a program that crashed Windows", people just stare a= t you blankly and say "Hey, I got those with the system, *for free*".' (By = Linus Torvalds) =20 ------=_Part_946304_1496321008.1582777326662 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

Please try with passing parameter log_line_prefix using --prefix
=

pgbadger --prefix <= ;value in log_line_prefix> -o postgres-Mon.html ./postgres-Mon.log =

Note :  copy/paste exact value from PostgreSQL.conf file/= show all and paste in the command above.


Thanks and Rega= rds,

Manish Ya= dav
Mobile : +91 8527607945


=20
=20
On Thursday, 27 February 2020, 1:47:43 AM IST, S.Bob &l= t;sbob@quadratum-braccas.com> wrote:


All;


Sorry if this is OT:


W= e have a client that logs all statements with :
<= br>
log_statement =3D 'all'

However they also have left log_min_duration_st= atement disabled:

log_= min_duration_statement =3D -1


When I attempt to parse a report with p= gbadger like this:

pgb= adger -o postgres-Mon.html ./postgres-Mon.log

It parses zero queries, = even though the query data is there, just that
i= t was logged via log_statement =3D 'all' instead of via setting
<= div dir=3D"ltr">log_min_duration_statement =3D x
=

Is there any way = ; to force pgbadger to pick up / reckognize the logges
queries?


=
Thanks in advance



--=
`When you say "I wrote a program that crashed W= indows", people just stare at you blankly and say "Hey, I got those with th= e system, *for free*".' (By Linus Torvalds)

<= /div>


------=_Part_946304_1496321008.1582777326662--