Storm does not have a query log like you might know from Django. Not to my knowledge at least, the docs are still lacking.
If you need to know what queries are executed, you can do:
from storm import database database.DEBUG = True
This will print all statements to stdout. If you need more, I suppose there’s nothing stopping you from hooking into storm.database.Connection.raw_execute.