---json
{
    "h1": "ComboStrap URL Management - Log redirections History",
    "page_id": "7kdfauhb7rnhe92xkkdmh"
}
---
====== ComboStrap Routing - Log redirections History ======



===== About =====

This page shows you how you can [[docs:analytics:query|query]] the  [[redirection|redirection]] history table  stored in the [[docs:analytics:database|secondary database]]



===== Example =====


  * All redirections from the last 5 minutes:

<code sql>
select
  source, target, type, method
from
  redirections_log
where
  datetime(timestamp) > datetime('now','-5 minutes')
order by
  datetime(timestamp) desc;
</code>

  * Count of redirections by minutes

<code sql>
select
  strftime('%H:%M', timestamp),
  count(1)
from
  redirections_log
group by
  strftime('%H:%M', timestamp)
</code>