About
This page shows you how you can query the redirection history table stored in the secondary database
Example
- All redirections from the last 5 minutes:
select
source, target, type, method
from
redirections_log
where
datetime(timestamp) > datetime('now','-5 minutes')
order by
datetime(timestamp) desc;
- Count of redirections by minutes
select
strftime('%H:%M', timestamp),
count(1)
from
redirections_log
group by
strftime('%H:%M', timestamp)