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.
