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.

5

@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).

6

Does events table have info about the scheduled queries. didn’t found any action name for the scheduled queries.

7

It does not. This could be an easy addition, however.