Is there a way to set the filter in p6spy, such that it only logs "insert/delete/update" and NOT "select" SQL statements?
Documentation of p6spy mentions: "P6Spy allows you to monitor specific tables or specific statement types"
An example they gave was the following:
An example showing capture of all select statements, except the orders table follows:
filter = true # comma separated list of tables to include include = select # comma separated list of tables to exclude exclude = orders
So I thought, there must be a way to include insert, delete, updates and exclude select... hence, I prepared my properties file like so:
filter = true
# comma separated list of tables to include
include = insert,update,delete
# comma separated list of tables to exclude
exclude = select
but that does not seem to work. Anyone with any suggestions??