Re: Report Generator Proposal

Поиск
Список
Период
Сортировка
От Mauricio de Castro
Тема Re: Report Generator Proposal
Дата
Msg-id 200309160729.40290.mcastro@solis.coop.br
обсуждение исходный текст
Ответ на Re: Report Generator Proposal  (kaolin fire <cognosco@tentacle.net>)
Список pgsql-admin
Report Generator in PHP-GTK that work with Pear-db. It's very easy for
users...

http://agata.codigolivre.org.br

Creator: Pablo (pablo@php.net)

[]s
Mauricio

On Monday 15 September 2003 18:25, kaolin fire wrote:
> On Monday, September 15, 2003, at 02:06  PM, Gaetano Mendola wrote:
> > ""Matt Clark"" <matt@ymogen.net> wrote:
> >> It'd be easy to automate all except the explain, a script that did
> >
> > everything else could then emit "If your preoblem relates to a
> >
> >> specific query, then run 'explain analyze <query>' and attach it to
> >> your
> >
> > message as well".
> >
> > Well, must be charge of psql store somewhere all selects performed
> > between the BEGIN REPORT and END REPORT and perform
> > the explain command of that selects with the explain; may be the really
> > difficult here is that psql
> > shall know all tables involved in a select and insert in the report the
> > descriptions of that tables.
> > Before to work on it I want be sure that is a good idea.
> >
> > Regards
> > Gaetano Mendola
>
> sounds good.  maybe with the option (enabled by default?) to only show
> the columns used in the queries for the tables pulled.  ((wheat from
> chaff and all that))
>
> hmm.  though there's still the (some small percentage of) things that
> could be going wrong with custom stored procedures.  dumping those
> would be (I'm presuming, based on the scope of the task as it's been
> described) reasonably simply, but figuring out what they touch could be
> prohibitive?
>
> kudos for any attempt, though, all around. :)
>
> -kaolin fire
> -postgresql novice
> -http://poemranker.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Maurício de Castro
Coordenador de Desenvolvimento em Software Livre
SOLIS - Cooperativa de Soluções Livres
http://www.solis.coop.br
51 3011 0610


В списке pgsql-admin по дате отправления:

Предыдущее
От:
Дата:
Сообщение: postgresql headers
Следующее
От: Jose Vicente Nunez Z
Дата:
Сообщение: Inserting 26 million rows takes 8 hours, how to improve those times?