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

2009-10-31 Thread John Murtari
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 - the

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

2009-10-31 Thread John Murtari
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 |

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

2009-10-31 Thread Peter Eisentraut
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.

2009-10-31 Thread Josh Berkus
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:

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

2009-10-31 Thread John Murtari
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.

2009-10-31 Thread Peter Eisentraut
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.

2009-10-31 Thread Tom Lane
Peter Eisentraut pete...@gmx.net 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

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

2009-10-31 Thread John Murtari
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 http://www.postgresql.org/docs/7.4/interactive/monitoring-stats.html appears to do pretty much

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

2009-10-31 Thread John Murtari
Tom Lane writes: Peter Eisentraut pete...@gmx.net 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

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

2009-10-30 Thread John Murtari
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

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

2009-10-30 Thread Greg Smith
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

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

2009-10-30 Thread Jaime Casanova
On Fri, Oct 30, 2009 at 11:02 AM, John Murtari jmurt...@thebook.com 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