Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tERxE-007NwC-MQ for pgsql-general@arkaria.postgresql.org; Fri, 22 Nov 2024 11:36:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tERxC-007reM-Sk for pgsql-general@arkaria.postgresql.org; Fri, 22 Nov 2024 11:36:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tERxC-007reC-Fn for pgsql-general@lists.postgresql.org; Fri, 22 Nov 2024 11:36:02 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tERx9-003Czd-JP for pgsql-general@lists.postgresql.org; Fri, 22 Nov 2024 11:36:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1732275356; x=1732880156; i=karsten.hilbert@gmx.net; bh=tU1R8f8EblOB8gSYlnoweULB8eBYErFDmhRimVVDGJQ=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=k4xxomf3tL16D/XGhY/OHg4sI8lasUyg6cGJOmqGrfM2g0uoycPI3DHkTrcderj7 R7Ibw2OlqRte/LFSw7PTqGhzQHtTXyj5P/Q3Dq/AXw15zocZx56eZYeXspNI/tugK uKe4ocPgYlOlQDj7L2oqr6vDbY1Gn/q4THqaKlthlOGEMwihdmAVVRjqjPRens3Lu hD4GVS73ST38o6DC3tdmzavcsk16miXFEPSNgFAnhCasTUP0qFrWCH5ZZbAW87T+J oqW6m2Uk8Fu82clq5F4JmoHSycjaVuj2nVSohcxEu/HlLUc1B79P8643vh2VSXxHK jywyAyHAx5MzW4sUuA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.144.204.193]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1N7i8Y-1tjqqU3FeU-00ynR6 for ; Fri, 22 Nov 2024 12:35:56 +0100 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1tERx5-0004kg-28 for pgsql-general@lists.postgresql.org; Fri, 22 Nov 2024 12:35:55 +0100 Date: Fri, 22 Nov 2024 12:35:55 +0100 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: PostgreSQL Log Info Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:RuzZsQfIFmEpEHYjULNxVq1Vq6ckmW64AigifrUsUfCsq80KesH z2fgMdKlf+tmFR78pdJI+GNocfBsS3AeTbU7scoztkgd6FmyoIz4vQf28MeZ6L5EL7GISWA A3hEaPhzVIljnQafr+CL8o8hyk3hvsrTvFulRQw2k5M5ZZklRXnO3skSDhO9y+o83dLC1Mk V9+CgUaQ8n6T6SGalq0yg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:5SPY1+zglAI=;XUBmPRwvd/nk20GMy6SRfdT3pdg 9nJCVaNxv4eNmrFVi0OKC6jATMXdWcNGuxssfOs10z+cyMhjViqYhPQMJ3VUjbKbgO2NC8ww0 Xlbp05uHf2Bo9SftDjVGlOx7qggjhUYYWmDJ3JmomRFIVKd5fRdJmrhKDqExI26708ZvlKufg F9nGas2kt75DBtoc6VE7/oioC6zTSRX6rqrmu+eTfQ54rN/+vryPIqilxm17WEU1MNHF2b6er 8C1r+Z5gaDbIULrDlx8AgWVymncl8Pw21F89vK1IjM1BpBFjaRApCrQUcKdiJP7UyJxW8XCWJ m8fZdC5DEW8Y02pZyB71QzMFZSWkm03/0I+nz2JHDA/qmf+YlQMfqcgupXTc6AKgxTKud1J+P mBwjZ+WqDFdG9jKLeUF99aZE07w27a5am0I9PT8q42hqG4Sq7cNdp/pE3xBNuvAHDIdcRihbo w5N3EgpKgTma5WaVeRRQd7x6lqZHixPxQrJ98OFlu8ZoWlUje3pUc5r6HPA5F3xtsk9h5QSQ8 +6fg2EolBLSODxc1d54lWZv63U072ibswDmDc0P4COyfeS2eWESCjiJzqTZ8FLcbEZWBb7BST lZosCMeii9w0YLF/fVFHz0O6DtykYLE4kpY8xU/R004kVeclZ85YJNRLZcECBe3UmgPBFn8hW b+GISZ3kwQNWKzPik2s3HCAEVxGkHJ8T6m86AI20dPWzIYv89kAChtOtT+oRZor2mCf4jgmCs dtlYGV8cD1EGAi5MBGd+5wJqLi5NQpooO57TiGgLJ3e1v1yMn4Edsyf6SJPiWPpVSYJK6mj+G dyRwWt6wbfycKwPoJXTq09CH64Q2o0l8IZ1IVmrXwMuy4nwsIqct9c4PYqjv7tX4KMjOCZN8p j/uiVqhWnJ20F6hpvyqkMJxmpALd37WpevQRjduug6WReMORo2g1Ae1iY Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Fri, Nov 22, 2024 at 01:02:27PM +0530 schrieb Jethish Jethish: > If an select query is fired I need the query returned values needs to be > logged in my PostgreSQL log file. What do you expect your log file to be in size after, say, a day of activity ? Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B