Re: {PROPOSAL] add session information column to pg_stat_statements

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: {PROPOSAL] add session information column to pg_stat_statements
Date: 2018-12-02 09:22:07
Message-ID: 1543742527592-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Arkhena 2018-12-02 10:20:59 Re: [PATCH] Log CSV by default
Previous Message Andrew Gierth 2018-12-02 06:08:22 Re: AllocSetContextCreate changes breake extensions