===========
Utilization
===========

This section will give you some example sql statements that might help you to
list all requests of a specific user in a specific interval.

You can execute the queries below, e.g. when you are logged in the psql terminal (see
the `documentation <http://www.postgresql.org/files/documentation/books/pghandbuch/html/app-psql.html>`_
for more information about psql):

- List all requests of user *my-user* in the last 7 days::

    SELECT * FROM myowsaccounting WHERE starttime > (current_timestamp - interval '7 days') AND username = 'my-user';


- List all requests of user *my-user* in the last month::

    SELECT * FROM myowsaccounting WHERE starttime > (current_timestamp - interval '1 month') AND username = 'my-user';