View Queries to server
Started by Ryan Mahoneyalmost 25 years ago3 messagesgeneral
Is it possible to view the last 100 queries issued to the database?
-r
Import Notes
Reply to msg id not found: 3AF15178.DF5F10C0@amwdb.u-strasbg.frReference msg id not found: Pine.LNX.4.30.0105031407170.26292-100000@melkinpaasi.cs.Helsinki.FI
Re: View Queries to server
On Thu, 3 May 2001, Ryan Mahoney wrote:
Is it possible to view the last 100 queries issued to the database?
If you have set the backend to log queries this should be trivial. You
can set the level of output from command line or from postgresql.conf,
which I think is a better approach. If you don't log the queries I
don't think there is a way to implement it.
- Einar Karttunen
Re: View Queries to server
Ryan Mahoney writes:
Is it possible to view the last 100 queries issued to the database?
Turn on query logging and search the log file.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter