Re: [HACKERS] Patch set under development to add usage reporting.

Tom Lane writes: > Peter Eisentraut writes: > > I don't really get the point of the SHOW STATISTICS command. There is > > already a command whose purpose is to retrieve data in tabular form, > > namely SELECT. > > I presume we need not worry about that, since the SQL committee are > cert

Re: [HACKERS] Patch set under development to add usage reporting.

Peter > > I had taken a look at existing statistics reporting (at > > least in the 7.4.x tree) and didn't see a good analog to what this > > provides. > > The statistics collector detailed at > > appears to do pr

Re: [HACKERS] Patch set under development to add usage reporting.

Peter Eisentraut writes: > On lör, 2009-10-31 at 13:37 -0400, John Murtari wrote: >> ... We also had >> developed the "SHOW STATISTICS" syntax for DB version that don't >> support INFORMATION SCHEMA. > I don't really get the point of the SHOW STATISTICS command. There is > already a command wh

Re: [HACKERS] Patch set under development to add usage reporting.

On lör, 2009-10-31 at 13:37 -0400, John Murtari wrote: > I had taken a look at existing statistics reporting (at > least in the 7.4.x tree) and didn't see a good analog to what this > provides. The statistics collector detailed at

Re: [HACKERS] Patch set under development to add usage reporting.

Peter, > > The project web site has a lot of info, but here is a quick > > example of what it does: > > > > thebook=# show statistics * from db history; > >db|minutes | Questions | Connections | Com_delete > > -++---+-+-

Re: [HACKERS] Patch set under development to add usage reporting.

Peter, > The patch itself appears to be licensed under the GPL, which means we > can't even look at it. We can look at it all we want, we just can't copy it. --Josh Berkus -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.pos

Re: [HACKERS] Patch set under development to add usage reporting.

On fre, 2009-10-30 at 12:02 -0400, John Murtari wrote: > The project web site has a lot of info, but here is a quick > example of what it does: > > thebook=# show statistics * from db history; >db|minutes | Questions | Connections | Com_delete > -++--

Re: [HACKERS] Patch set under development to add usage reporting.

Jaime, > > The project web site has a lot of info, but here is a quick > > example of what it does: > > thebook=# show statistics * from db history; db|minutes | Questions | Connections | Com_delete -++---+-+ thebook | 10

Re: [HACKERS] Patch set under development to add usage reporting.

Greg > > We now have a basic patch set that works and is basically stable (not > > recommended for production servers!). We've dedicated a page at our web > > site and it hopefully has answers to most of your questions, and also > > has the patch set for download. These are for 7.4.19 - t

Re: [HACKERS] Patch set under development to add usage reporting.

On Fri, Oct 30, 2009 at 11:02 AM, John Murtari wrote: > >     The project web site has a lot of info, but here is a quick > example of what it does: > > thebook=#  show statistics * from db history; >   db    |    minutes     | Questions | Connections | Com_delete > -++

Re: [HACKERS] Patch set under development to add usage reporting.

On Fri, 30 Oct 2009, John Murtari wrote: We now have a basic patch set that works and is basically stable (not recommended for production servers!). We've dedicated a page at our web site and it hopefully has answers to most of your questions, and also has the patch set for download. These a

[HACKERS] Patch set under development to add usage reporting.

Developers, I'm a senior developer for a small Company working on modifications to both MySQL and PostgreSQL to support better usage reporting for DBAs. The project is called ExtSQL. Most of our work was originally done on MySQL and we've just gotten into PostgreSQL during the last yea