contrib/pg_stat_statements
От | ITAGAKI Takahiro |
---|---|
Тема | contrib/pg_stat_statements |
Дата | |
Msg-id | 20081011172450.3402.52131E4D@oss.ntt.co.jp обсуждение исходный текст |
Ответы |
Re: contrib/pg_stat_statements
Re: contrib/pg_stat_statements Re: contrib/pg_stat_statements |
Список | pgsql-hackers |
Hello, Postgres has configurations to log statements into server logs, but there are few convenience ways to summarize the logs as a view. Some external projects like pgFouine or PQA have the functionality, but they consume much CPU resources and cannot summarize in real-time -- summarize-time is longer than write-time of the logs in heavily loads. I'd like to submit pg_stat_statements contrib module, that counts up incoming statements in shared memory and summarizes the result as a view. It is just a statements-version of pg_stat_user_functions. Information collected by the view are: - query string - total_time and cpu_time - buffer access (gets, reads, writes, local reads and local writes) - number of rows retrieved or affected (There is a sample output in sgml in the attached tarball.) I attach WIP version of the module. auto_explain.patch is also required because the module uses a new version DefineCustomVariable. http://archives.postgresql.org/message-id/20081009165157.9BE4.52131E4D@oss.ntt.co.jp The module allocates fixed share memory at the server start and store statements statistics in it. On out of memory, least recently used statements are discarded. Comments and suggenstions welcome! Regards, --- ITAGAKI Takahiro NTT Open Source Software Center
Вложения
В списке pgsql-hackers по дате отправления: