List of queries in psql

[blakeoldride]

Hello everyone!

Running Postgresql 7.4 (I think) in psql is it possible to view a list of the most recent queries run against a particular DB?

I can get the most recent in .psql_history but this is for queries used in the psql monitor, I am after queries that were made against the system from the web sever or

http://wwwrun

user? Is this information logged or stored anywhere?

Thanks All!

 

[ceco]

you can see this, but not with psql, there you can see the version by the way if you are unsure

select version();


if you realy use 7.4 then see here

http://www.postgresql.org/docs/7.4/static/runtime-config.html

you have to change the configuration parameters, the important for you is log_statement

then you will see in the DB logs the statements that are executed