| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: New SQL counter statistics view (pg_stat_sql) |
| Date: | 2016-08-22 17:54:43 |
| Message-ID: | CA+TgmoYQc0qBREduUcQ9qZauYgXQ2qnKyfYEBOc-W=kqeLAvsQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Aug 20, 2016 at 11:17 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I'm inclined to suggest you forget this approach and propose a single
> counter for "SQL commands executed", which avoids all of the above
> definitional problems. People who need more detail than that are
> probably best advised to look to contrib/pg_stat_statements, anyway.
I disagree. I think SQL commands executed, lumping absolutely
everything together, really isn't much use. Haribabu's categorization
scheme seems to need some work, but the idea of categorizing
statements by type and counting executions per type seems very
reasonable.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2016-08-22 17:59:12 | Re: New SQL counter statistics view (pg_stat_sql) |
| Previous Message | Pavel Stehule | 2016-08-22 17:52:44 | Re: Showing parallel status in \df+ |