On 17.05.2013 12:29, Nikolay Samokhvalov wrote:
> Hello hackers,
>
> Consider a Postgres cluster containing several DBs (for example several
> projects/sites). If one wants to optimize queries on one specified site --
> what should he do? His obvious need is to switch full logging for the exact
> database on, collect the logs and analyze them using pgFouine/pgBadger.
>
> But currently, there is no way to specify log settings for one database /
> one user / one host. There are only *global* settings in postgres.conf.
alter database postgres set log_statement='all'
alter user foo set log_statement='all'
- Heikki