citusdata / citusdata/postgresql-topn

Weighted Add

Open
#72 6 comments 1 reaction 0 assignees View on GitHub
Dominant language
C
Stars
249
Forks
27
PR merge metrics
No merged PRs in 30d

Description

I'm not sure if this is possible or not but I have account session data that we're storing in a massive table. Data like mac address, bytes downloaded, uploaded, session duration etc.

I'd like to report on that data in a Top users (mac address) report. E.G top 10 users by downloads. or top 10 users by session duration. Is there a way to do that.. using this extension it seems like this is what its for?

I think I can do a top 10 users by session count.. as that is just the frequency of the mac address in the account sessions table.. however that is the only one of the reports (order by's) that I need. My idea was to have multiple topN columns in a summary table and then lookup those mac addresses in the main table once I have the list of top 10 to narow down my query. e.g. topUsersBySessionCount topUsersByDuration topUsersByDownloads etc.

Can you confirm if this is possible or not using TopN..

Regards
Rod

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.