Re: {PROPOSAL] add session information column to pg_stat_statements

2018-12-02 Thread Sergei Agalakov
On 12/2/2018 2:22 AM, legrand legrand wrote: I'm also very interested by collecting "search_path" information for statements, but this information may not be unique for pg_stat_statements key (dbid,userid,queryid) ... How would this 1-N relation be handled ? 1/ just catch initial session_info fo

Re: {PROPOSAL] add session information column to pg_stat_statements

2018-12-02 Thread legrand legrand
I'm also very interested by collecting "search_path" information for statements, but this information may not be unique for pg_stat_statements key (dbid,userid,queryid) ... How would this 1-N relation be handled ? 1/ just catch initial session_info for each (dbid,userid,queryid), 2/ adding a sessi

{PROPOSAL] add session information column to pg_stat_statements

2018-12-01 Thread Sergei Agalakov
I have renamed the thread [PROPOSAL] extend the object names to the qualified names in pg_stat_statements started on https://www.postgresql.org/message-id/9baf5c06-d6ab-c688-010c-843348e3d98c%40gmail.com and ended on https://www.postgresql.org/message-id/c93bb5ce-22bd-eb6b-a057-d0666585258f%40gma