[CLUE-Tech] PostgreSQL statistics question

[kevin.lane at attbi.com]

A view is similar to a stored procedure, the difference being that views do not 
use variables, more of a static query. 
Views are composed of SQL commands, so it should be easy to create the 
views you need to gather the statistics on the server. 
 
(If I'm wrong on the definition of the view, then I'm sure someone will let me know!) ;-) 
-- 
Kevin Lane 
Kevin.Lane at attbi.com 
> On Fri, 2003-03-28 at 11:37, kevin.lane at attbi.com wrote:
> > Will this provide what you are looking for? 
> >  
> > http://www.samse.fr/GPL/pg_analyzer/README.html
> 
> Link looks like I can pull some good queries out of their program.
> Thanks for the link.
> 
> I did happen to figure this one out (PostgreSQL is waaaaay different to
> try and use when you are used to MySQL):
> 
> select sum(xact_commit) as total from pg_stat_database;
> 
> Apparently PostgreSQL makes use of views to simplify how their stats are
> saved. I think it is very cool to have your database statistics
> available in SQL queries. I just need to learn more about views in order
> to take full advantage of this.
> 
> Does anybody know if Oracle does anything like this?
> -- 
> Jeremiah Stanley <lists at miah.org>
> 
> _______________________________________________
> CLUE-Tech mailing list
> CLUE-Tech at clue.denver.co.us
> http://clue.denver.co.us/mailman/listinfo/clue-tech