WordPress database error: [Table 'wp_stemmadocs.wp_eazydocs_view_log' doesn't exist]
SELECT count FROM wp_eazydocs_view_log WHERE post_id = '5630' AND created_at = '2023-05-30' /* From [docs.stemma.ai/docs/stemma/frequently-asked-questions-faqs/how-does-stemma-calculate-top-5-columns-frequent-users-etc/] in [/nas/content/live/stemmadocs/wp-content/plugins/eazydocs/includes/Frontend/post-views.php:42] */

WordPress database error: [Table 'wp_stemmadocs.wp_eazydocs_view_log' doesn't exist]
SHOW FULL COLUMNS FROM `wp_eazydocs_view_log` /* From [docs.stemma.ai/docs/stemma/frequently-asked-questions-faqs/how-does-stemma-calculate-top-5-columns-frequent-users-etc/] in [/nas/content/live/stemmadocs/wp-content/plugins/eazydocs/includes/Frontend/post-views.php:47] */

How Does Stemma Calculate “Top 5 Columns”, “Frequent Users”, etc?

Estimated reading: 1 minute

The table details page in the Stemma UI provides usage information, derived as follows:

To calculate the top five upstream and downstream columns, Stemma multiplies the number of unique users by the number of queries to get the ranking. The time frame is 30 days.
To identify tables commonly usesd with this one, Stemma counts the joins that were part of any query in the past 90 days.
To identify frequent users of a table, Stemma counts any user who has run a query on this table in the last 30 days.