Logging all executed queries


#1

hi i would like to log and make a view page to log all running queries by userid ,time and sql text .from my understanding with every sql execute[POST] i have to pass the data to a html page and store in the database of postgres ,i need to know which method is actually doing the execute task and passing the query text .


#2

Do you need a view of currently executing queries or past executing queries? Do you need adhoc queries (triggered by a human) or scheduled as well?


#3

Hi Arik,
ill be much happier to log just committed executing [past] quires for now .


#4

Then check the events table. One of the logged events is for every executed query.