New SQL counter statistics view (pg_stat_sql)

Поиск
Список
Период
Сортировка
Искать
От
Haribabu Kommi
Тема
New SQL counter statistics view (pg_stat_sql)
Дата
Msg-id
CAJrrPGeY4xujjoR=z=KoyRMHEK_pSjjp=7VBhOAHq9rfgpV7QQ@mail.gmail.com
Список
Дерево обсуждения
New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Tom Lane <tgl@sss.pgh.pa.us>
Re: New SQL counter statistics view (pg_stat_sql) Robert Haas <robertmhaas@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Andres Freund <andres@anarazel.de>
Re: New SQL counter statistics view (pg_stat_sql) Tom Lane <tgl@sss.pgh.pa.us>
Re: New SQL counter statistics view (pg_stat_sql) Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: New SQL counter statistics view (pg_stat_sql) neha khatri <nehakhatri5@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: New SQL counter statistics view (pg_stat_sql) neha khatri <nehakhatri5@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Robert Haas <robertmhaas@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: New SQL counter statistics view (pg_stat_sql) David Fetter <david@fetter.org>
Re: New SQL counter statistics view (pg_stat_sql) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New SQL counter statistics view (pg_stat_sql) David Fetter <david@fetter.org>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Robert Haas <robertmhaas@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Andres Freund <andres@anarazel.de>
RE: New SQL counter statistics view (pg_stat_sql) "Smith, Peter" <peters@fast.au.fujitsu.com>
Re: New SQL counter statistics view (pg_stat_sql) Thomas Munro <thomas.munro@gmail.com>
RE: New SQL counter statistics view (pg_stat_sql) "Smith, Peter" <peters@fast.au.fujitsu.com>
Re: New SQL counter statistics view (pg_stat_sql) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New SQL counter statistics view (pg_stat_sql) Michael Paquier <michael@paquier.xyz>
Re: New SQL counter statistics view (pg_stat_sql) Mark Dilger <mark.dilger@enterprisedb.com>
Command statistics system (cmdstats) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Command statistics system (cmdstats) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Command statistics system (cmdstats) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Command statistics system (cmdstats) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Command statistics system (cmdstats) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Command statistics system (cmdstats) Robert Haas <robertmhaas@gmail.com>
Re: Command statistics system (cmdstats) Michael Paquier <michael@paquier.xyz>
Re: Command statistics system (cmdstats) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Command statistics system (cmdstats) Mark Dilger <mark.dilger@enterprisedb.com>
Re: Command statistics system (cmdstats) Michael Paquier <michael@paquier.xyz>
Re: Command statistics system (cmdstats) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Command statistics system (cmdstats) Michael Paquier <michael@paquier.xyz>
Re: Command statistics system (cmdstats) Michael Paquier <michael@paquier.xyz>
Re: Command statistics system (cmdstats) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: [HACKERS] New SQL counter statistics view (pg_stat_sql) vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: New SQL counter statistics view (pg_stat_sql) vinayak <Pokale_Vinayak_q3@lab.ntt.co.jp>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
Re: New SQL counter statistics view (pg_stat_sql) Haribabu Kommi <kommi.haribabu@gmail.com>
This is a new statistics view that is used to provide the number of
SQL operations that are
happened on a particular interval of time. This view is useful for the
system to find out the
pattern of the operations that are happening in the instance during
particular interval of
time.

Following is the more or less columns and their details of the pg_stat_sql view.

postgres=# \d pg_stat_sql          View "pg_catalog.pg_stat_sql"  Column    |           Type           | Modifiers
-------------+--------------------------+-----------selects     | bigint                   |inserts     | bigint                   |deletes     | bigint                   |updates     | bigint                   |declares    | bigint                   |fetches     | bigint                   |copies      | bigint                   |reindexes   | bigint                   |truncates   | bigint                   |stats_reset | timestamp with time zone |

The SQL counters gets updated only for the external SQL queries, not for
the SQL queries that are generated internally. The counters gets updated
at exec_simple_query and exec_execute_message functions.

User can reset the SQL counter statistics using an exposed function.
The Stats collection can be turned on/off using a GUC also.

Any comments/objections in providing a patch for the same?

Regards,
Hari Babu
Fujitsu Australia


В списке pgsql-hackers по дате отправления
От: Amit Kapila
Дата:
Сообщение: Re: dsm_unpin_segment
От: Haribabu Kommi
Дата:
FAQ