Log specific database queries in Postgresql

Question

Is it possible to log queries executed only on a particular database in postgresql?

One possible solution is to log the database name, and finally grep them. Would be helpful if there is a better approach, as the log generated is humongous that grep is not very convenient.

user330315 · Accepted Answer · 2013-02-05 11:33:03Z

1

The contrib module pg_stat_statements would be able to do that:

http://www.postgresql.org/docs/current/static/pgstatstatements.html

Because it only tracks statements for the database where the module was installed.

answered Feb 5, 2013 at 11:33

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

inquisitive Over a year ago

any insight on this stackoverflow.com/questions/36786949/…

Collectives™ on Stack Overflow

Log specific database queries in Postgresql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related