Re: logging aql queries only one table or tables of one scheme

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: guido(dot)haefliger(at)vogelwarte(dot)ch
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: logging aql queries only one table or tables of one scheme
Date: 2018-11-19 16:13:18
Message-ID: CAKFQuwZMi9R3VEmDzNK6=LibmZ=BTZnNpYXVNrOchjHS=jH_GA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Nov 19, 2018 at 2:38 AM Häfliger Guido
<guido(dot)haefliger(at)vogelwarte(dot)ch> 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).

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mariel Cherkassky 2018-11-19 17:31:35 autovacuum is running but pg_stat_all_tables empty
Previous Message soumik.bhattacharjee 2018-11-19 15:20:28 RE: Ora2pg Not Getting Installed- Please Provide Inputs