Skip to content

Efficient querying of views table

  • Copy to elasticsearch with hourly resolution
{
  "resolution": "day",
  "@timestamp": 1568627843000,
  "entity_urn": "urn:activity:123",
  "owner_guid": "456",
  "views": 201
}
  • Cli script to run over views and update hourly and update the aggregated number
  • Forward plan reducing resolution on main views table
Edited by Mark Harding