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 [] 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 [] 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.