Tyk Dashboard Analytics “1‑Day Shift”

If your Tyk Dashboard (and Portal analytics that depend on it) uses PostgreSQL for analytics and the database timezone is set to a non‑UTC timezone, daily analytics can shift by 1 day: “today” appears under “yesterday”, and “today” shows 0 hits.

To fix it, please check what Timezone your postgresql instance is deployed in, you can check using the following commands:

SHOW timezone;

// You should see something like this:

TimeZone 
----------
 UTC
(1 row)

// If its something else please change it to UTC:

SET timezone TO 'UTC';
ALTER DATABASE {Your DB name} SET timezone TO 'UTC';

// Check to confirm it has been set

SHOW timezone;

Once the above is done, simply restart the Tyk Dashboard and the analytics will now show correctly.

Please ensure the above changes are configured by your own local DBA as it involves the Database and ensure backups are performed for changes in production environments.