Logging all executed queries


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?


Hi Arik,
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.


@arikfr - how to locate the event table, kindly guide i am new to redash… my requirement is to capture / log all the queries executed on redash for security purpose. since anyone (who have access on redash can execute any query - we can not control right? at present).