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 .
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?
ill be much happier to log just committed executing [past] quires for now .
Then check the
events table. One of the logged events is for every executed query.