Show all commands executed

Started by Anderson dos Santos Dondaover 17 years ago2 messagesgeneral
Jump to latest
#1Anderson dos Santos Donda
andersondonda@gmail.com

How can I show on terminal all commands executed by my postgre server?

Example: My system execute the comand : 'SELECT * FROM clients' and the
postgre show this commando on the terminal ?

Thanks

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Anderson dos Santos Donda (#1)
Re: Show all commands executed

"Anderson dos Santos Donda" <andersondonda@gmail.com> writes:

How can I show on terminal all commands executed by my postgre server?

You could turn on log_statements and then tail -f the postmaster log.

regards, tom lane