On Tuesday 28 October 2003 14:33, Jaime Casanova wrote: > 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.
Use pg_ctl -l logfile option to start postmaster. It will log the things. And set log_statement=true in postgresql.conf. So there will be all the sql statements logged in. HTH Shridhar ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org