[HACKERS] Adding new output parameter of pg_stat_statements to identify operation of the query.

Поиск
Список
Период
Сортировка
От
Тема [HACKERS] Adding new output parameter of pg_stat_statements to identify operation of the query.
Дата
Msg-id 20170219093542.BF8F4440421@webmail.sinamail.sina.com.cn
обсуждение исходный текст
Ответы Re: [HACKERS] Adding new output parameter of pg_stat_statements toidentify operation of the query.  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Список pgsql-hackers
 Hi PG hackers:
         When using pg_stat_statements to collect running SQL of PG, we find it is hard for our program to get exact operation type of the SQL,  such as SELECT, DELETE, UPDATE, INSERT, and so on.
   So we modify the the source code of pg_stat_statements and add another output parameter to tell us the operation type.
Of course some application know their operation type, but for us and many public databases, doing this is hard. 
The only way is to reparse the SQL, obviously it is too expensive for a monitoring or diagnosis system.
We have done the job and are willing to post a patch.
I sent one through my work mail, but it seems that my mail didn't reach the maillist, so I try again by using my personal mail account.

jasonysli

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Parallel Append implementation
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Reporting xmin from VACUUMs