spotify / postgresql-metrics
File Change Frequency

File change frequency (churn) shows the distribution of file updates (days with at least one commit).

Overview
File Change Frequency Overall
  • There are 8 files with 935 lines of code.
    • 0 files changed more than 100 times (0 lines of code)
    • 0 files changed 51-100 times (0 lines of code)
    • 0 files changed 21-50 times (0 lines of code)
    • 5 files changed 6-20 times (618 lines of code)
    • 3 files changed 1-5 times (317 lines of code)
0% | 0% | 0% | 66% | 33%
Legend:
101+
51-100
21-50
6-20
1-5

explore: grouped by folders | grouped by update frequency | data
Contributors Count Frequency Overall
  • There are 8 files with 935 lines of code.
    • 0 files changed by more than 25 contributors (0 lines of code)
    • 0 files changed by 11-25 contributors (0 lines of code)
    • 3 files changed by 6-10 contributors (418 lines of code)
    • 5 files changed by 2-5 contributors (517 lines of code)
    • 0 files changed by 1 contributor (0 lines of code)
0% | 0% | 44% | 55% | 0%
Legend:
26+
11-25
6-10
2-5
1

explore: grouped by folders | grouped by contributors count | data
File Change Frequency per File Extension
py, txt, yaml, gitignore, md, json
File Change Frequency per Extension
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
py0% | 0% | 0% | 66% | 33%
File Change Frequency per Logical Decomposition
primary
primary (file change frequency)
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
postgresql_metrics0% | 0% | 0% | 65% | 34%
ROOT0% | 0% | 0% | 100% | 0%
Most Frequently Changed Files (Top 9)

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
setup.py
in root
 19 1 2015-09-08 2021-07-12 14 7 varjo@spotify.com scherman@spotify.com
postgres_queries.py
in postgresql_metrics
 204 20 2015-09-07 2021-07-08 14 10 varjo@spotify.com dflemstr@users.noreply.gith...
metrics_logic.py
in postgresql_metrics
 195 13 2015-08-31 2021-03-11 9 6 varjo@spotify.com dflemstr@users.noreply.gith...
common.py
in postgresql_metrics
 62 7 2015-08-31 2021-02-25 7 5 varjo@spotify.com dflemstr@users.noreply.gith...
metrics_gatherer.py
in postgresql_metrics
 138 17 2018-10-16 2021-03-11 7 4 stefanp@spotify.com dflemstr@users.noreply.gith...
default_metrics.py
in postgresql_metrics
 114 21 2018-10-16 2021-03-11 4 3 stefanp@spotify.com dflemstr@users.noreply.gith...
prepare_db.py
in postgresql_metrics
 176 15 2015-09-10 2019-01-22 4 4 varjo@spotify.com hannu.varjoranta@spotify.com
localhost_postgres_stats.py
in postgresql_metrics
 27 2 2017-11-16 2021-03-11 3 4 hannu.varjoranta@spotify.com dflemstr@users.noreply.gith...
__init__.py
in postgresql_metrics
 1 -
Files With Most Contributors (Top 9)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
postgres_queries.py
in postgresql_metrics
 204 20 2015-09-07 2021-07-08 14 10 varjo@spotify.com dflemstr@users.noreply.gith...
setup.py
in root
 19 1 2015-09-08 2021-07-12 14 7 varjo@spotify.com scherman@spotify.com
metrics_logic.py
in postgresql_metrics
 195 13 2015-08-31 2021-03-11 9 6 varjo@spotify.com dflemstr@users.noreply.gith...
common.py
in postgresql_metrics
 62 7 2015-08-31 2021-02-25 7 5 varjo@spotify.com dflemstr@users.noreply.gith...
metrics_gatherer.py
in postgresql_metrics
 138 17 2018-10-16 2021-03-11 7 4 stefanp@spotify.com dflemstr@users.noreply.gith...
prepare_db.py
in postgresql_metrics
 176 15 2015-09-10 2019-01-22 4 4 varjo@spotify.com hannu.varjoranta@spotify.com
localhost_postgres_stats.py
in postgresql_metrics
 27 2 2017-11-16 2021-03-11 3 4 hannu.varjoranta@spotify.com dflemstr@users.noreply.gith...
default_metrics.py
in postgresql_metrics
 114 21 2018-10-16 2021-03-11 4 3 stefanp@spotify.com dflemstr@users.noreply.gith...
__init__.py
in postgresql_metrics
 1 -
Files With Least Contributors (Top 9)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
__init__.py
in postgresql_metrics
 1 -
default_metrics.py
in postgresql_metrics
 114 21 2018-10-16 2021-03-11 4 3 stefanp@spotify.com dflemstr@users.noreply.gith...
prepare_db.py
in postgresql_metrics
 176 15 2015-09-10 2019-01-22 4 4 varjo@spotify.com hannu.varjoranta@spotify.com
metrics_gatherer.py
in postgresql_metrics
 138 17 2018-10-16 2021-03-11 7 4 stefanp@spotify.com dflemstr@users.noreply.gith...
localhost_postgres_stats.py
in postgresql_metrics
 27 2 2017-11-16 2021-03-11 3 4 hannu.varjoranta@spotify.com dflemstr@users.noreply.gith...
common.py
in postgresql_metrics
 62 7 2015-08-31 2021-02-25 7 5 varjo@spotify.com dflemstr@users.noreply.gith...
metrics_logic.py
in postgresql_metrics
 195 13 2015-08-31 2021-03-11 9 6 varjo@spotify.com dflemstr@users.noreply.gith...
setup.py
in root
 19 1 2015-09-08 2021-07-12 14 7 varjo@spotify.com scherman@spotify.com
postgres_queries.py
in postgresql_metrics
 204 20 2015-09-07 2021-07-08 14 10 varjo@spotify.com dflemstr@users.noreply.gith...
Correlations

File Size vs. Number of Changes: 8 points

setup.py x: 19 lines of code y: 14 # changes postgresql_metrics/postgres_queries.py x: 204 lines of code y: 14 # changes postgresql_metrics/default_metrics.py x: 114 lines of code y: 4 # changes postgresql_metrics/localhost_postgres_stats.py x: 27 lines of code y: 3 # changes postgresql_metrics/metrics_gatherer.py x: 138 lines of code y: 7 # changes postgresql_metrics/metrics_logic.py x: 195 lines of code y: 9 # changes postgresql_metrics/common.py x: 62 lines of code y: 7 # changes postgresql_metrics/prepare_db.py x: 176 lines of code y: 4 # changes
14.0
# changes
  min: 3.0
  average: 7.75
  25th percentile: 4.0
  median: 7.0
  75th percentile: 12.75
  max: 14.0
0 204.0
lines of code
min: 19.0 | average: 116.88 | 25th percentile: 35.75 | median: 126.0 | 75th percentile: 190.25 | max: 204.0

Number of Contributors vs. Number of Changes: 8 points

setup.py x: 7 # contributors y: 14 # changes postgresql_metrics/postgres_queries.py x: 10 # contributors y: 14 # changes postgresql_metrics/default_metrics.py x: 3 # contributors y: 4 # changes postgresql_metrics/localhost_postgres_stats.py x: 4 # contributors y: 3 # changes postgresql_metrics/metrics_gatherer.py x: 4 # contributors y: 7 # changes postgresql_metrics/metrics_logic.py x: 6 # contributors y: 9 # changes postgresql_metrics/common.py x: 5 # contributors y: 7 # changes postgresql_metrics/prepare_db.py x: 4 # contributors y: 4 # changes
14.0
# changes
  min: 3.0
  average: 7.75
  25th percentile: 4.0
  median: 7.0
  75th percentile: 12.75
  max: 14.0
0 10.0
# contributors
min: 3.0 | average: 5.38 | 25th percentile: 4.0 | median: 4.5 | 75th percentile: 6.75 | max: 10.0

Number of Contributors vs. File Size: 8 points

setup.py x: 7 # contributors y: 19 lines of code postgresql_metrics/postgres_queries.py x: 10 # contributors y: 204 lines of code postgresql_metrics/default_metrics.py x: 3 # contributors y: 114 lines of code postgresql_metrics/localhost_postgres_stats.py x: 4 # contributors y: 27 lines of code postgresql_metrics/metrics_gatherer.py x: 4 # contributors y: 138 lines of code postgresql_metrics/metrics_logic.py x: 6 # contributors y: 195 lines of code postgresql_metrics/common.py x: 5 # contributors y: 62 lines of code postgresql_metrics/prepare_db.py x: 4 # contributors y: 176 lines of code
204.0
lines of code
  min: 19.0
  average: 116.88
  25th percentile: 35.75
  median: 126.0
  75th percentile: 190.25
  max: 204.0
0 10.0
# contributors
min: 3.0 | average: 5.38 | 25th percentile: 4.0 | median: 4.5 | 75th percentile: 6.75 | max: 10.0