Postgres Pro
Downloads
Home   >   mailing lists

logging aql queries only one table or tables of one scheme - Mailing list pgsql-admin

From Häfliger Guido
Subject logging aql queries only one table or tables of one scheme
Date
Msg-id D2417C80A342B246BEAF2C90A301E0AF76FCED6F@MailNT.vogelwarte.ch
Whole thread Raw
Responses Re: logging aql queries only one table or tables of one scheme  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view

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.haefliger@vogelwarte.ch
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/

 

pgsql-admin by date:

Previous
From: Andres Freund
Date:
Subject: Re: unclear behavior xmax/xmin
Next
From:
Date:
Subject: RE: Ora2pg Not Getting Installed- Please Provide Inputs