Basic ingimp Statistics
From StatsJam
Jump to: navigation, search
Contents |
[edit] Basic User Stats
On this page, we perform basic summaries of ingimp installations. These are for significant users, only (see Defining Significant Users for more information about this concept).
[edit] Installed Versions
This form gives you a chance to modify the query and quickly see the results but it does not update the wiki page..
<query>
SELECT
gimp_version AS "GIMP Version",
COUNT(user_id) AS "count"
FROM
(SELECT
DISTINCT user_id,
gimp_version
FROM
interaction_log
WHERE
user_id IN (
SELECT
users_who_saved_table.user_id
FROM
(SELECT
interaction_log.user_id,
EXTRACT(EPOCH FROM (MAX(interaction_log.log_date)-MIN(interaction_log.log_date)))/60/60/24 AS num_days_diff
FROM
interaction_log,
(SELECT
DISTINCT event_record.log_num
FROM
event_record
WHERE
event_record.event_type_id = 7 -- This is the ID for an image save event
) AS logs_with_save_table
WHERE
interaction_log.log_num = logs_with_save_table.log_num
AND user_id NOT IN (SELECT user_id FROM ingimp_developer_ids)
GROUP BY
interaction_log.user_id
) AS users_who_saved_table
WHERE
num_days_diff >= 1
)
) AS user_version_table
GROUP BY
gimp_version
ORDER BY
gimp_version
</query>
<view type="table" caption="Installed Versions of ingimp"/>
| GIMP Version | count |
|---|---|
| 2.2.13 | 7 |
| 2.2.14 | 52 |
| 2.2.15 | 53 |
| 2.2.16 | 22 |
| 2.2.17 | 76 |
| 2.3.16 | 3 |
| 2.4.2 | 1 |
| 2.4.3 | 12 |
| 2.4.4 | 11 |
| 2.4.5 | 11 |
| 2.4.6 | 5 |
[edit] Platforms
This form gives you a chance to modify the query and quickly see the results but it does not update the wiki page..
<query>
SELECT
platform AS "Platform",
COUNT(user_id) AS "count"
FROM
(SELECT
DISTINCT user_id,
platform
FROM
interaction_log
WHERE
user_id IN (
SELECT
users_who_saved_table.user_id
FROM
(SELECT
interaction_log.user_id,
EXTRACT(EPOCH FROM (MAX(interaction_log.log_date)-MIN(interaction_log.log_date)))/60/60/24 AS num_days_diff
FROM
interaction_log,
(SELECT
DISTINCT event_record.log_num
FROM
event_record
WHERE
event_record.event_type_id = 7 -- This is the ID for an image save event
) AS logs_with_save_table
WHERE
interaction_log.log_num = logs_with_save_table.log_num
AND user_id NOT IN (SELECT user_id FROM ingimp_developer_ids)
GROUP BY
interaction_log.user_id
) AS users_who_saved_table
WHERE
num_days_diff >= 1
)
) AS user_version_table
GROUP BY
platform
ORDER BY
platform
</query>
<view type="table" caption="Platform Stats"/>
| Platform | count |
|---|---|
| darwin | 1 |
| linux2 | 53 |
| win32 | 148 |
[edit] Monitors
This form gives you a chance to modify the query and quickly see the results but it does not update the wiki page..
<query>
SELECT
monitor_width AS "Width",
monitor_height AS "Height",
num_monitors AS "n",
ROUND(num_monitors * 100.0 / total_monitors) AS "%"
FROM
(SELECT
monitor_width,
monitor_height,
COUNT(user_id) AS num_monitors
FROM
(SELECT
DISTINCT user_id,
monitor_width,
monitor_height
FROM
monitor_sizes
WHERE
user_id IN (
SELECT
users_who_saved_table.user_id
FROM
(SELECT
interaction_log.user_id,
EXTRACT(EPOCH FROM (MAX(interaction_log.log_date)-MIN(interaction_log.log_date)))/60/60/24 AS num_days_diff
FROM
interaction_log,
(SELECT
DISTINCT event_record.log_num
FROM
event_record
WHERE
event_record.event_type_id = 7 -- This is the ID for an image save event
) AS logs_with_save_table
WHERE
interaction_log.log_num = logs_with_save_table.log_num
AND user_id NOT IN (SELECT user_id FROM ingimp_developer_ids)
GROUP BY
interaction_log.user_id
) AS users_who_saved_table
WHERE
num_days_diff >= 1
)
) AS user_version_table
GROUP BY
monitor_width,
monitor_height
ORDER BY
monitor_width,
monitor_height
) AS per_user_monitor_counts,
(SELECT
COUNT(user_id) AS total_monitors
FROM
(SELECT
DISTINCT user_id,
monitor_width,
monitor_height
FROM
monitor_sizes
WHERE
user_id IN (
SELECT
users_who_saved_table.user_id
FROM
(SELECT
interaction_log.user_id,
EXTRACT(EPOCH FROM (MAX(interaction_log.log_date)-MIN(interaction_log.log_date)))/60/60/24 AS num_days_diff
FROM
interaction_log,
(SELECT
DISTINCT event_record.log_num
FROM
event_record
WHERE
event_record.event_type_id = 7 -- This is the ID for an image save event
) AS logs_with_save_table
WHERE
interaction_log.log_num = logs_with_save_table.log_num
AND user_id NOT IN (SELECT user_id FROM ingimp_developer_ids)
GROUP BY
interaction_log.user_id
) AS users_who_saved_table
WHERE
num_days_diff >= 1
)
) AS user_version_table
) AS total_monitor_counts
</query>
<view type="table" caption="Monitor Size Counts"/>
| Width | Height | n | % |
|---|---|---|---|
| 768 | 1024 | 2 | 1.0 |
| 800 | 600 | 8 | 3.0 |
| 900 | 1440 | 1 | 0.0 |
| 1024 | 768 | 50 | 20.0 |
| 1024 | 1280 | 1 | 0.0 |
| 1152 | 864 | 9 | 4.0 |
| 1280 | 768 | 3 | 1.0 |
| 1280 | 800 | 27 | 11.0 |
| 1280 | 960 | 5 | 2.0 |
| 1280 | 1024 | 76 | 31.0 |
| 1360 | 1024 | 1 | 0.0 |
| 1400 | 1050 | 3 | 1.0 |
| 1440 | 900 | 16 | 6.0 |
| 1600 | 1024 | 1 | 0.0 |
| 1600 | 1050 | 1 | 0.0 |
| 1600 | 1200 | 14 | 6.0 |
| 1680 | 1028 | 1 | 0.0 |
| 1680 | 1050 | 19 | 8.0 |
| 1920 | 1080 | 1 | 0.0 |
| 1920 | 1200 | 10 | 4.0 |
This form gives you a chance to modify the query and quickly see the results but it does not update the wiki page..
<query>
SELECT
num_monitors AS "Number of Monitors",
per_user_monitor_count AS "Monitor Count",
ROUND(per_user_monitor_count * 100.0 / total_monitor_count) AS "%"
FROM
(SELECT
num_monitors,
COUNT(num_monitors) AS per_user_monitor_count
FROM
(SELECT
MAX(monitor_num)+1 AS num_monitors
FROM
interaction_log,
monitor
WHERE
interaction_log.log_num = monitor.log_num
AND interaction_log.user_id IN (
SELECT
users_who_saved_table.user_id
FROM
(SELECT
interaction_log.user_id,
EXTRACT(EPOCH FROM (MAX(interaction_log.log_date)-MIN(interaction_log.log_date)))/60/60/24 AS num_days_diff
FROM
interaction_log,
(SELECT
DISTINCT event_record.log_num
FROM
event_record
WHERE
event_record.event_type_id = 7 -- This is the ID for an image save event
) AS logs_with_save_table
WHERE
interaction_log.log_num = logs_with_save_table.log_num
AND user_id NOT IN (SELECT user_id FROM ingimp_developer_ids)
GROUP BY
interaction_log.user_id
) AS users_who_saved_table
WHERE
num_days_diff >= 1
)
GROUP BY
interaction_log.user_id) AS num_monitors_per_user_table
GROUP BY
num_monitors
ORDER BY
num_monitors
) AS monitor_count,
(SELECT
COUNT(num_monitors) AS total_monitor_count
FROM
(SELECT
MAX(monitor_num)+1 AS num_monitors
FROM
interaction_log,
monitor
WHERE
interaction_log.log_num = monitor.log_num
AND interaction_log.user_id IN (
SELECT
users_who_saved_table.user_id
FROM
(SELECT
interaction_log.user_id,
EXTRACT(EPOCH FROM (MAX(interaction_log.log_date)-MIN(interaction_log.log_date)))/60/60/24 AS num_days_diff
FROM
interaction_log,
(SELECT
DISTINCT event_record.log_num
FROM
event_record
WHERE
event_record.event_type_id = 7 -- This is the ID for an image save event
) AS logs_with_save_table
WHERE
interaction_log.log_num = logs_with_save_table.log_num
AND user_id NOT IN (SELECT user_id FROM ingimp_developer_ids)
GROUP BY
interaction_log.user_id
) AS users_who_saved_table
WHERE
num_days_diff >= 1
)
GROUP BY
interaction_log.user_id) AS num_monitors_per_user_table
) AS total_monitor_count_table
</query>
<view type="table" caption="Number of Monitors Summary"/>
| Number of Monitors | Monitor Count | % |
|---|---|---|
| 1 | 173 | 86.0 |
| 2 | 28 | 14.0 |
Retrieved from "http://www.ingimp.org/statsjam/index.php/Basic_ingimp_Statistics"
