retrieve statement from catalogs

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема retrieve statement from catalogs
Дата
Msg-id BAY8-F59TEF8ta3IaUv00003c9c@hotmail.com
обсуждение исходный текст
Ответы Re: retrieve statement from catalogs  (Andrew Sullivan <andrew@libertyrms.info>)
Re: retrieve statement from catalogs  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Список pgsql-general
Hi everybody, can anyone tell me if there's a way to retrieve the select
instruction executed from the catalogs, or maybe via some structure in a
trigger?

The reason is that i have some selects constructed on-the-fly (just part of
it) and i want to save that in a table in order to know what are the most
used for optimizing them.

Another reason for doing that is that i don't know all the selects in the
program nor the page and this is an easier solution than examine all the
code.

thanx in advance, el_vigia

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail


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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Recomended FS
Следующее
От: Tino Wildenhain
Дата:
Сообщение: Re: PostgreSQL with MS Query?