From: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
---|---|
To: | "'husttripper(at)vip(dot)sina(dot)com'" <husttripper(at)vip(dot)sina(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Adding new output parameter of pg_stat_statements to identify operation of the query. |
Date: | 2017-02-20 00:34:43 |
Message-ID: | 0A3221C70F24FB45833433255569204D1F6A3853@G01JPEXMBYT05 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of
> husttripper(at)vip(dot)sina(dot)com
> 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.
A view for counting the number of executions per operation type is being developed for PostgreSQL 10, which is expected to be released this year.
https://commitfest.postgresql.org/13/790/
Would this fit your need? If not, what's the benefit of getting the operation type via pg_stat_statements?
Regards
Takayuki Tsunakawa
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-02-20 00:45:38 | Re: case_preservation_and_insensitivity = on |
Previous Message | Thomas Munro | 2017-02-20 00:25:15 | Re: Parallel bitmap heap scan |