How do I get the all-time playtime?

[TomasGnG]

Where is the playtime stored in the db?
I want to code a Top 10 most active player Leaderboard but its difficult when I dont even know where plan stores the playtime.
I need the table to I can use SQL commands.

[AuroraLS3]

Playtime is in plan_sessions
SELECT SUM(session_end-session_start) as playtime FROM plan_sessions;

[TomasGnG]

Thanks for the reply but do you know if there is a method to update the query instance? Because everytime I use queryService.getCommonQueries().fetchPlaytime() the value stays the same untill I rejoin

[AuroraLS3]

The online playtime can be taken with the queryService.getCommonQueries().fetchCurrentSessionPlaytime() :)

The playtime in database is only updated when player leaves since online sessions are not yet stored there

[TomasGnG]

Love you man! :D