Re: {PROPOSAL] add session information column to pg_stat_statements - Mailing list pgsql-hackers

From legrand legrand
Subject Re: {PROPOSAL] add session information column to pg_stat_statements
Date
Msg-id 1543742527592-0.post@n3.nabble.com
Whole thread Raw
In response to {PROPOSAL] add session information column to pg_stat_statements  (Sergei Agalakov <sergei.agalakov@gmail.com>)
Responses Re: {PROPOSAL] add session information column to pg_stat_statements
List pgsql-hackers
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 sessid field in pgss key, and a table for distinct
sessid,session_info values,
3/ store session_info in an array,
4/ ...






--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html


pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: AllocSetContextCreate changes breake extensions
Next
From: Arkhena
Date:
Subject: Re: [PATCH] Log CSV by default