what is the way to analyse specific schema queries in Postgres?

Question

Queries of multiple schemas of DB are logged in the pg_log directory in an application server, and the performance of specific schema needs to be profiled.

The same queries that are running, the difference is that search_path is set to include different schemas in each case.

How to log queries using a specific in pg_log? Or is there any way to "tail" specific the log for queries using a specific schema on the command line?

Meant that S1,S2 are two schemas in DB1.In general, queries related to schemas are logged after "SET SESSION search_path TO 'S1'" and "SET SESSION search_path TO 'S2'" respectively in pg_log.right?Requirement is monitoring schema 'S2' ( queries after SET SESSION search_path TO 'S2' alone) alone. @LaurenzAlbe — rajesh.veera
– rajesh.veera, Commented Mar 15, 2019 at 9:14

Laurenz Albe · Accepted Answer · 2019-03-15 09:27:37Z

1

There is no way to do that.

What you could do is use different users to run the queries with different search_path settings, and then only log queries by a certain user:

ALTER ROLE myuser SET log_min_duration_statement = 0;

answered Mar 15, 2019 at 9:27

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

what is the way to analyse specific schema queries in Postgres?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related