logging aql queries only one table or tables of one scheme

From: Häfliger Guido <guido(dot)haefliger(at)vogelwarte(dot)ch>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: logging aql queries only one table or tables of one scheme
Date: 2018-11-19 09:36:02
Message-ID: D2417C80A342B246BEAF2C90A301E0AF76FCED6F@MailNT.vogelwarte.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello

Is it possible to enable query statement logging only for one table (or one scheme)? If I set log_min_duration_statement = 0 everything is logged, the log-files becomes huge.

Maybe there are other possibilities to achieve this target?

Guido Häfliger

____________________________________________________

Dipl. Ing. ETH Guido Häfliger
EDV/GIS-Spezialist
Tel. ++41 41 462 97 60
guido(dot)haefliger(at)vogelwarte(dot)ch<mailto:guido(dot)haefliger(at)vogelwarte(dot)ch>
www.vogelwarte.ch<http://www.vogelwarte.ch/>

Schweizerische Vogelwarte | Seerose 1 | CH-6204 Sempach | Schweiz
Station ornithologique suisse | Seerose 1 | CH-6204 Sempach | Suisse
Stazione ornitologica svizzera | Seerose 1 | CH-6204 Sempach | Svizzera
Swiss Ornithological Institute | Seerose 1 | CH-6204 Sempach | Switzerland

Willkommen im neuen Besuchszentrum in Sempach! http://www.vogelwarte.ch/de/besuch/
Bienvenue au nouveau centre de visite à Sempach! http://www.vogelwarte.ch/fr/visite/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message soumik.bhattacharjee 2018-11-19 15:20:28 RE: Ora2pg Not Getting Installed- Please Provide Inputs
Previous Message Andres Freund 2018-11-18 20:34:28 Re: unclear behavior xmax/xmin