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 по дате отправления
От: Haribabu Kommi
Дата: