Thanks a lot for your hints, I will try to do it with pgaudit, seems to be a useful tool Best regards Guido -----Ursprüngliche Nachricht----- Von: Achilleas Mantzios [mailto:achill@xxxxxxxxxxxxxxxxxxxxx] Gesendet: Montag, 19. November 2018 20:04 An: pgsql-admin@xxxxxxxxxxxxxxxxxxxx Betreff: Re: logging aql queries only one table or tables of one scheme On 19/11/18 6:13 μ.μ., David G. Johnston wrote: > On Mon, Nov 19, 2018 at 2:38 AM Häfliger Guido > <guido.haefliger@xxxxxxxxxxxxx> wrote: >> 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. > No, that particular setting (like most) doesn't operate at a > sub-session level. And since it is super-user only changing it for > individual queries is not recommended - though you could create a > security definer function to make it doable (never tried it myself). pgaudit does the trick, but it takes some reading to get what you need. > > David J. >
