# dashboard_version

created: 2026-06-12 18:25:04
data:
  {"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","name":"Annotations \u0026 Alerts","target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":6,"iteration":1781288599770,"links":[],"liveNow":false,"panels":[{"columns":[],"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"Shows company PRs in the given repository groups","fontSize":"80%","gridPos":{"h":22,"w":24,"x":0,"y":0},"hideTimeOverride":true,"id":1,"interval":"","links":[],"pageSize":200,"scroll":true,"showHeader":true,"sort":{"col":0,"desc":false},"styles":[{"alias":"Time","align":"auto","dateFormat":"YYYY-MM-DD HH:mm:ss","pattern":"Time","type":"hidden"},{"alias":"","align":"auto","colors":["rgba(245, 54, 54, 0.9)","rgba(237, 129, 40, 0.89)","rgba(50, 172, 45, 0.97)"],"dateFormat":"YYYY-MM-DD HH:mm:ss","decimals":0,"mappingType":1,"pattern":"Opened PRs","thresholds":[],"type":"number","unit":"none"},{"alias":"","align":"auto","colors":["rgba(245, 54, 54, 0.9)","rgba(237, 129, 40, 0.89)","rgba(50, 172, 45, 0.97)"],"decimals":2,"pattern":"/.*/","thresholds":[],"type":"string","unit":"none"}],"targets":[{"alias":"","dsType":"influxdb","format":"table","group":[],"groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"metricColumn":"none","orderByTime":"ASC","policy":"default","query":"SELECT \"name\", \"value\" FROM \"top_commenters_[[repogroup]]_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  row_number() over (order by value desc, split_part(name, '$$$', 3) asc) as \"Rank\",\n  split_part(name, '$$$', 2) as \"Company\",\n  split_part(name, '$$$', 1) as \"Repository group\",\n  split_part(name, '$$$', 3) as \"GitHub ID\",\n  split_part(name, '$$$', 4) as \"User names\",\n  split_part(name, '$$$', 6) as \"Country\",\n  value as \"Opened PRs\"\nfrom\n  scompany_prs\nwhere\n  period = '[[period]]'\n  and ('[[repogroups:csv]]' = 'null' or split_part(name, '$$$', 1) in ([[repogroups]]))\n  and ('[[companies:csv]]' = 'null' or split_part(name, '$$$', 2) in ([[companies]]))\n  and ('[[countries:csv]]' = 'null' or split_part(name, '$$$', 6) in ([[countries]]))","refId":"A","resultFormat":"table","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]}],"title":"[[full_name]] company PRs (Range: [[period_name]])","transform":"table","type":"table-old"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":14,"w":24,"x":0,"y":22},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"refresh":false,"schemaVersion":36,"style":"dark","tags":["dashboard","apicurioregistry","table","companies","repogroups"],"templating":{"list":[{"current":{"selected":false,"text":"Last decade","value":"Last decade"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Range","multi":false,"name":"period_name","options":[],"query":"select quick_ranges_name from tquick_ranges order by time","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"y10","value":"y10"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"period","options":[],"query":"select quick_ranges_suffix from tquick_ranges where quick_ranges_name = '[[period_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"null","current":{"selected":true,"text":["All"],"value":["$__all"]},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":true,"label":"Repository groups","multi":true,"name":"repogroups","options":[],"query":"select repo_group_name from trepo_groups order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"Apicurio Registry","value":"Apicurio Registry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"full_name","options":[],"query":"select value_s from gha_vars where name = 'full_name'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry company PRs in repository groups dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric (repository groups) \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/company_prs.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eMetric (repositories) \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/company_prs_repos.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ecompany_prs\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/company-prs-in-repository-groups.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows how many PRs were open by given company's developer in given repository groups\u003c/li\u003e\n\u003cli\u003eYou can select one, two or more companies or All to select all of them.\u003c/li\u003e\n\u003cli\u003eYou can select one, two or more repository groups or All to select all fo them (for the top panel).\u003c/li\u003e\n\u003cli\u003eYou can select repositories for the bottom panel showing separate repositories statistics.\u003c/li\u003e\n\u003cli\u003eYou can select last day, month, week etc. range or date range between releases, for example \u003ccode\u003ev1.9 - v1.10\u003c/code\u003e.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003cli\u003eWe are determining user's company affiliation from \u003ca href=\"https://github.com/cncf/devstats/blob/master/github_users.json\" target=\"_blank\"\u003ethis file\u003c/a\u003e, which is imported from \u003ccode\u003ecncf/gitdm\u003c/code\u003e.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry company PRs in repository groups dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric (repository groups) \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/company_prs.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eMetric (repositories) \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/company_prs_repos.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ecompany_prs\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/company-prs-in-repository-groups.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows how many PRs were open by given company's developer in given repository groups\u003c/li\u003e\n\u003cli\u003eYou can select one, two or more companies or All to select all of them.\u003c/li\u003e\n\u003cli\u003eYou can select one, two or more repository groups or All to select all fo them (for the top panel).\u003c/li\u003e\n\u003cli\u003eYou can select repositories for the bottom panel showing separate repositories statistics.\u003c/li\u003e\n\u003cli\u003eYou can select last day, month, week etc. range or date range between releases, for example \u003ccode\u003ev1.9 - v1.10\u003c/code\u003e.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003cli\u003eWe are determining user's company affiliation from \u003ca href=\"https://github.com/cncf/devstats/blob/master/github_users.json\" target=\"_blank\"\u003ethis file\u003c/a\u003e, which is imported from \u003ccode\u003ecncf/gitdm\u003c/code\u003e.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'company_prs_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"null","current":{"selected":true,"text":["All"],"value":["$__all"]},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":true,"label":"Companies","multi":true,"name":"companies","options":[],"query":"select companies_name from tcompanies order by time asc","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"null","current":{"selected":true,"text":["All"],"value":["$__all"]},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"select country_name from tcountries order by time","hide":0,"includeAll":true,"label":"Countries","multi":true,"name":"countries","options":[],"query":"select country_name from tcountries order by time","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-5y","to":"now"},"timepicker":{"hidden":true,"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"Company PRs in Repository Groups Table","uid":"55","version":2,"weekStart":""}


created: 2026-06-12 18:25:45
data:
  {"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","name":"Annotations \u0026 Alerts","target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","query":"SELECT title, description from annotations WHERE $timeFilter order by time asc","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tagsColumn":"title,description","textColumn":"","titleColumn":"[[full_name]] release","type":"alert"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":23,"iteration":1781288626902,"links":[],"liveNow":false,"panels":[{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"Current median age of opened PRs.","fieldConfig":{"defaults":{"color":{"mode":"thresholds"},"mappings":[{"options":{"match":"null","result":{"text":"N/A"}},"type":"special"}],"thresholds":{"mode":"absolute","steps":[{"color":"green","value":null},{"color":"red","value":80}]},"unit":"none"},"overrides":[]},"gridPos":{"h":3,"w":14,"x":0,"y":0},"id":2,"links":[],"maxDataPoints":100,"options":{"colorMode":"none","graphMode":"none","justifyMode":"auto","orientation":"horizontal","reduceOptions":{"calcs":["lastNotNull"],"fields":"/^descr$/","values":false},"textMode":"auto"},"pluginVersion":"8.5.27","targets":[{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"descr\" FROM \"autogen\".\"prs_age_[[repogroup]]_median_[[period]][[aggregate]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  descr\nfrom\n  sprs_age\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'prs_age[[repogroup]]m'\norder by\n  time desc\nlimit 1","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]}],"title":"Current median age of opened PRs in [[repogroup_name]] repository group ([[period]])","type":"stat"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"Current average number of opened PRs.","fieldConfig":{"defaults":{"color":{"mode":"thresholds"},"mappings":[{"options":{"match":"null","result":{"text":"N/A"}},"type":"special"}],"thresholds":{"mode":"absolute","steps":[{"color":"green","value":null},{"color":"red","value":80}]},"unit":"none"},"overrides":[]},"gridPos":{"h":3,"w":10,"x":14,"y":0},"id":4,"links":[],"maxDataPoints":100,"options":{"colorMode":"none","graphMode":"none","justifyMode":"auto","orientation":"horizontal","reduceOptions":{"calcs":["lastNotNull"],"fields":"/^descr$/","values":false},"textMode":"auto"},"pluginVersion":"8.5.27","targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"value\" FROM \"autogen\".\"prs_age_[[repogroup]]_number_[[period]][[aggregate]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time, value\nfrom\n  sprs_age\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'prs_age[[repogroup]]n'\norder by\n  time desc\nlimit 1","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]}],"title":"Current average number of opened PRs in [[repogroup_name]] repository group ([[period]])","type":"stat"},{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"decimals":2,"description":"Median age and number of pull requests created in [[repogroup]] repository group.","fill":3,"fillGradient":0,"gridPos":{"h":13,"w":24,"x":0,"y":3},"hiddenSeries":false,"id":1,"legend":{"alignAsTable":false,"avg":true,"current":true,"hideEmpty":false,"hideZero":false,"max":true,"min":true,"rightSide":false,"show":true,"total":false,"values":true},"lines":false,"linewidth":0,"links":[],"nullPointMode":"null","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":1,"points":false,"renderer":"flot","seriesOverrides":[{"alias":"Median age of opened PRs","fill":2,"lines":true,"linewidth":0,"yaxis":1},{"alias":"Average number of PRs opened","fill":0,"lines":true,"linewidth":1,"yaxis":2}],"spaceLength":10,"stack":false,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"hide":false,"measurement":"reviewers_d","orderByTime":"ASC","policy":"autogen","query":"SELECT \"value\" FROM \"autogen\".\"prs_age_[[repogroup]]_number_[[period]][[aggregate]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Average number of PRs opened\"\nfrom\n  sprs_age\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'prs_age[[repogroup]]n'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"hide":false,"measurement":"reviewers_d","orderByTime":"ASC","policy":"autogen","query":"SELECT \"value\" FROM \"autogen\".\"prs_age_[[repogroup]]_median_[[period]][[aggregate]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Median age of opened PRs\"\nfrom\n  sprs_age\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'prs_age[[repogroup]]m'\norder by\n  time","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"timeRegions":[],"title":"Number/Age of Pull requests in [[repogroup_name]] repository group ([[period]])","tooltip":{"shared":true,"sort":0,"value_type":"individual"},"type":"graph","xaxis":{"mode":"time","show":true,"values":["total"]},"yaxes":[{"format":"h","label":"Median PRs age","logBase":1,"min":"0","show":true},{"format":"short","label":"Average opened PRs number","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"columns":[],"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"Median age and number of pull requests created in [[repogroup]] repository group.","fontSize":"90%","gridPos":{"h":12,"w":24,"x":0,"y":16},"id":3,"links":[],"pageSize":10,"scroll":true,"showHeader":true,"sort":{"col":0,"desc":true},"styles":[{"alias":"Time","align":"auto","dateFormat":"MM/DD/YYYY","pattern":"Time","type":"date"},{"alias":"","align":"auto","colors":["rgba(245, 54, 54, 0.9)","rgba(237, 129, 40, 0.89)","rgba(50, 172, 45, 0.97)"],"decimals":2,"pattern":"/.*/","thresholds":[],"type":"number","unit":"short"}],"targets":[{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"descr\" FROM \"autogen\".\"prs_age_[[repogroup]]_median_[[period]][[aggregate]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time as \"Time\",\n  descr as \"Median opened PRs age\"\nfrom\n  sprs_age\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'prs_age[[repogroup]]m'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"value\" FROM \"autogen\".\"prs_age_[[repogroup]]_number_[[period]][[aggregate]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time as \"Time\",\n  value as \"Average number of opened PRs\"\nfrom\n  sprs_age\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'prs_age[[repogroup]]n'\norder by\n  time","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]}],"title":"Number/Age of Pull requests in [[repogroup_name]] repository group ([[period]])","transform":"timeseries_to_rows","type":"table-old"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":11,"w":24,"x":0,"y":28},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"refresh":false,"schemaVersion":36,"style":"dark","tags":["dashboard","apicurioregistry"],"templating":{"list":[{"current":{"tags":[],"text":"7 Days MA","value":"d7"},"hide":0,"includeAll":false,"label":"Period","multi":false,"name":"period","options":[{"selected":false,"text":"Day","value":"d"},{"selected":true,"text":"7 Days MA","value":"d7"},{"selected":false,"text":"Week","value":"w"},{"selected":false,"text":"Month","value":"m"},{"selected":false,"text":"Quarter","value":"q"},{"selected":false,"text":"Year","value":"y"}],"query":"d,d7,w,m,q,y","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"All","value":"All"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Repository group","multi":false,"name":"repogroup_name","options":[],"query":"select all_repo_group_name from tall_repo_groups order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"all","value":"all"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"label":"","multi":false,"name":"repogroup","options":[],"query":"select all_repo_group_value from tall_repo_groups where all_repo_group_name = '[[repogroup_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"Apicurio Registry","value":"Apicurio Registry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"full_name","options":[],"query":"select value_s from gha_vars where name = 'full_name'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry PRs age dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/prs_age.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003eprs_age\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/prs-age.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows number of PRs opened in given periods and median age of those PRs.\u003c/li\u003e\n\u003cli\u003ePR age is defined as time from open to either merge or now (for non-merged PRs).\u003c/li\u003e\n\u003cli\u003eYou can select single repository group or summary for all of them.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will calculate data in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry PRs age dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/prs_age.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003eprs_age\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/prs-age.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows number of PRs opened in given periods and median age of those PRs.\u003c/li\u003e\n\u003cli\u003ePR age is defined as time from open to either merge or now (for non-merged PRs).\u003c/li\u003e\n\u003cli\u003eYou can select single repository group or summary for all of them.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will calculate data in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'prs_age_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-1y","to":"now-1w"},"timepicker":{"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"Open PR Age by Repository Group","uid":"19","version":2,"weekStart":""}


created: 2026-06-12 18:26:00
data:
  {"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","name":"Annotations \u0026 Alerts","target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","query":"SELECT title, description from annotations WHERE $timeFilter order by time asc","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tagsColumn":"title,description","textColumn":"","titleColumn":"[[full_name]] release","type":"alert"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":24,"iteration":1781288628329,"links":[],"liveNow":false,"panels":[{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"decimals":2,"description":"Median, 15th and 85th percentile of number of hours from open to merging for PR","fill":0,"fillGradient":0,"gridPos":{"h":13,"w":24,"x":0,"y":0},"hiddenSeries":false,"id":2,"legend":{"alignAsTable":true,"avg":true,"current":true,"max":true,"min":true,"rightSide":false,"show":true,"total":false,"values":true},"lines":true,"linewidth":1,"links":[],"nullPointMode":"null","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":5,"points":false,"renderer":"flot","seriesOverrides":[{"alias":"15th percentile time opened to merged (in hours)","yaxis":2}],"spaceLength":10,"stack":false,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"orderByTime":"ASC","policy":"default","query":"SELECT \"value\" FROM \"opened_to_merged_[[repogroup]]_percentile_85_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  value as \"85th percentile time opened to merged (in hours)\"\nfrom\n  sopened_to_merged\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'open2merge[[repogroup]]p85'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"orderByTime":"ASC","policy":"default","query":"SELECT \"value\" FROM \"opened_to_merged_[[repogroup]]_median_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Median time opened to merged (in hours)\"\nfrom\n  sopened_to_merged\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'open2merge[[repogroup]]med'\norder by\n  time","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"orderByTime":"ASC","policy":"default","query":"SELECT \"value\" FROM \"opened_to_merged_[[repogroup]]_percentile_15_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  value as \"15th percentile time opened to merged (in hours)\"\nfrom\n  sopened_to_merged\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'open2merge[[repogroup]]p15'\norder by\n  time","refId":"C","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"timeRegions":[],"title":"Time from open to merge ([[repogroup_name]], [[period]])","tooltip":{"shared":true,"sort":0,"value_type":"individual"},"type":"graph","xaxis":{"mode":"time","show":true,"values":[]},"yaxes":[{"format":"h","label":"Opened to merged (median \u0026 85th percentile)","logBase":10,"min":"0","show":true},{"format":"short","label":"Opened to merged (15th percentile)","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"columns":[],"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"Time PRs from open to merge","fontSize":"90%","gridPos":{"h":12,"w":24,"x":0,"y":13},"id":3,"links":[],"pageSize":10,"scroll":true,"showHeader":true,"sort":{"col":0,"desc":true},"styles":[{"alias":"Time","align":"auto","dateFormat":"MM/DD/YYYY","pattern":"Time","type":"date"},{"alias":"","align":"auto","colors":["rgba(245, 54, 54, 0.9)","rgba(237, 129, 40, 0.89)","rgba(50, 172, 45, 0.97)"],"decimals":2,"pattern":"/.*/","thresholds":[],"type":"number","unit":"short"}],"targets":[{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"descr\" FROM \"opened_to_merged_[[repogroup]]_percentile_15_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time as \"Time\",\n  descr as \"Median\"\nfrom\n  sopened_to_merged\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'open2merge[[repogroup]]med'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"descr\" FROM \"opened_to_merged_[[repogroup]]_median_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time as \"Time\",\n  descr as \"15th percentile\"\nfrom\n  sopened_to_merged\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'open2merge[[repogroup]]p15'\norder by\n  time","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"descr\" FROM \"opened_to_merged_[[repogroup]]_percentile_85_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time as \"Time\",\n  descr as \"85th percentile\"\nfrom\n  sopened_to_merged\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'open2merge[[repogroup]]p85'\norder by\n  time","refId":"C","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]}],"title":"Time from open to merge ([[repogroup_name]], [[period]])","transform":"timeseries_to_rows","type":"table-old"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":10,"w":24,"x":0,"y":25},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"schemaVersion":36,"style":"dark","tags":["dashboard","apicurioregistry"],"templating":{"list":[{"current":{"selected":false,"text":"Apicurio Registry","value":"Apicurio Registry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"full_name","options":[],"query":"select value_s from gha_vars where name = 'full_name'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"tags":[],"text":"7 Days MA","value":"d7"},"hide":0,"includeAll":false,"label":"Period","multi":false,"name":"period","options":[{"selected":true,"text":"7 Days MA","value":"d7"},{"selected":false,"text":"Week","value":"w"},{"selected":false,"text":"Month","value":"m"},{"selected":false,"text":"Quarter","value":"q"},{"selected":false,"text":"Year","value":"y"}],"query":"d7,w,m,q,y","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"All","value":"All"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Repository group","multi":false,"name":"repogroup_name","options":[],"query":"select all_repo_group_name from tall_repo_groups order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"all","value":"all"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"label":"","multi":false,"name":"repogroup","options":[],"query":"select all_repo_group_value from tall_repo_groups where all_repo_group_name = '[[repogroup_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry opened to merged dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/opened_to_merged.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003eopened_to_merged\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/opened-to-merged.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows median, 15th and 85th percentiles of the time from open to merge for PRs opened in given periods.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will calculate percentiles in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry opened to merged dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/opened_to_merged.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003eopened_to_merged\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/opened-to-merged.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows median, 15th and 85th percentiles of the time from open to merge for PRs opened in given periods.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will calculate percentiles in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'opened_to_merged_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-6M","to":"now-1w"},"timepicker":{"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"Opened to Merged","uid":"16","version":2,"weekStart":""}


created: 2026-06-12 18:26:39
data:
  {"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","name":"Annotations \u0026 Alerts","target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","query":"SELECT title, description from annotations WHERE $timeFilter order by time asc","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tagsColumn":"title,description","textColumn":"","titleColumn":"[[full_name]] release","type":"alert"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":27,"iteration":1781288630889,"links":[],"liveNow":false,"panels":[{"aliasColors":{},"bars":true,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"Shows review counts for given users and repository.","fill":1,"fillGradient":0,"gridPos":{"h":22,"w":24,"x":0,"y":0},"hiddenSeries":false,"hideTimeOverride":false,"id":1,"legend":{"alignAsTable":true,"avg":true,"current":true,"hideEmpty":false,"hideZero":false,"max":true,"min":true,"rightSide":true,"show":true,"sort":"avg","sortDesc":true,"total":true,"values":true},"lines":false,"linewidth":1,"links":[],"nullPointMode":"null as zero","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":5,"points":false,"renderer":"flot","seriesOverrides":[],"spaceLength":10,"stack":true,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"measurement":"sig_federation_d","orderByTime":"ASC","policy":"default","query":"SELECT /^[[reviewers]]$/ FROM \"reviews_per_user_[[repo]]_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  ${reviewers:csv}\nfrom\n  suser_reviews\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'rev_per_usr[[repo]]'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"timeRegions":[],"title":"Reviews per user/repo ([[repo_name]], [[period]])","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"transparent":true,"type":"graph","xaxis":{"mode":"time","show":true,"values":["total"]},"yaxes":[{"format":"short","label":"Number of PR review comments","logBase":1,"min":"0","show":true},{"format":"short","label":"","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":12,"w":24,"x":0,"y":22},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"schemaVersion":36,"style":"dark","tags":["dashboard","apicurioregistry"],"templating":{"list":[{"current":{"selected":true,"text":"Week","value":"w"},"hide":0,"includeAll":false,"label":"Period","multi":false,"name":"period","options":[{"selected":false,"text":"Day","value":"d"},{"selected":true,"text":"Week","value":"w"},{"selected":false,"text":"7 Days MA","value":"d7"},{"selected":false,"text":"Month","value":"m"},{"selected":false,"text":"Quarter","value":"q"},{"selected":false,"text":"Year","value":"y"}],"query":"d,w,d7,m,q,y","queryValue":"","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"All","value":"All"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Repository","multi":false,"name":"repo_name","options":[],"query":"select top_repos_name_with_all from ttop_repos_with_all order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"all","value":"all"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"label":"","multi":false,"name":"repo","options":[],"query":"select top_repos_value_with_all from ttop_repos_with_all where top_repos_name_with_all = '[[repo_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"","current":{"selected":true,"text":["\"jsenko\"","\"carlesarnal\"","\"eameh\"","\"EricWittmann\"","\"pwright\"","\"vandanayadav7\"","\"emouty\"","\"AdityaTeltia\"","\"krickert\""],"value":["\"jsenko\"","\"carlesarnal\"","\"eameh\"","\"EricWittmann\"","\"pwright\"","\"vandanayadav7\"","\"emouty\"","\"AdityaTeltia\"","\"krickert\""]},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Reviewer","multi":true,"name":"reviewers","options":[],"query":"select '\"' || reviewers_name || '\"' from treviewers","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"Apicurio Registry","value":"Apicurio Registry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"full_name","options":[],"query":"select value_s from gha_vars where name = 'full_name'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry user reviews dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/reviews_per_user.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ereviews_per_user\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/user-reviews.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows number of PR reviews most active reviewers.\u003c/li\u003e\n\u003cli\u003eReview means user added PR review comment.\u003c/li\u003e\n\u003cli\u003eYou can select reviewer from the reviewers drop-down, it shows top active reviewers from last 3 months.\u003c/li\u003e\n\u003cli\u003eTo find top active reviewers we sum number of reviews per user.\u003c/li\u003e\n\u003cli\u003eYou can select single repository or summary for all of them.\u003c/li\u003e\n\u003cli\u003eYou can filter by period and choose multiple reviewers to stack their data.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show reviews in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry user reviews dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/reviews_per_user.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ereviews_per_user\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/user-reviews.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows number of PR reviews most active reviewers.\u003c/li\u003e\n\u003cli\u003eReview means user added PR review comment.\u003c/li\u003e\n\u003cli\u003eYou can select reviewer from the reviewers drop-down, it shows top active reviewers from last 3 months.\u003c/li\u003e\n\u003cli\u003eTo find top active reviewers we sum number of reviews per user.\u003c/li\u003e\n\u003cli\u003eYou can select single repository or summary for all of them.\u003c/li\u003e\n\u003cli\u003eYou can filter by period and choose multiple reviewers to stack their data.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show reviews in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'user_reviews_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-1y","to":"now"},"timepicker":{"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"PR Reviews by Contributor","uid":"29","version":2,"weekStart":""}


created: 2026-06-12 18:27:02
data:
  {"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","name":"Annotations \u0026 Alerts","target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","query":"SELECT title, description from annotations WHERE $timeFilter order by time asc","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tagsColumn":"title,description","textColumn":"","titleColumn":"[[full_name]] release","type":"alert"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":28,"iteration":1781288633642,"links":[],"liveNow":false,"panels":[{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"decimals":2,"description":"Time before any comments or activities from someone other than the author","fill":0,"fillGradient":0,"gridPos":{"h":13,"w":24,"x":0,"y":0},"hiddenSeries":false,"id":2,"legend":{"alignAsTable":true,"avg":true,"current":true,"max":true,"min":true,"rightSide":false,"show":true,"total":false,"values":true},"lines":true,"linewidth":1,"links":[],"nullPointMode":"null","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":5,"points":false,"renderer":"flot","seriesOverrides":[{"alias":"15th percentile time opened to merged (in hours)"}],"spaceLength":10,"stack":false,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"orderByTime":"ASC","policy":"default","query":"SELECT \"value\" FROM \"non_author_[[repogroup]]_percentile_85_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  value as \"85th percentile time\"\nfrom\n  sfirst_non_author\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'non_auth[[repogroup]]p85'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"orderByTime":"ASC","policy":"default","query":"SELECT \"value\" FROM \"non_author_[[repogroup]]_median_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Median time\"\nfrom\n  sfirst_non_author\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'non_auth[[repogroup]]med'\norder by\n  time","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"orderByTime":"ASC","policy":"default","query":"SELECT \"value\" FROM \"non_author_[[repogroup]]_percentile_15_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  value as \"15th percentile time\"\nfrom\n  sfirst_non_author\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'non_auth[[repogroup]]p15'\norder by\n  time","refId":"C","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"timeRegions":[],"title":"Time before any comments or activities from someone other than the author ([[repogroup_name]], [[period]])","tooltip":{"shared":true,"sort":0,"value_type":"individual"},"type":"graph","xaxis":{"mode":"time","show":true,"values":[]},"yaxes":[{"format":"h","label":"","logBase":2,"min":"0","show":true},{"format":"short","label":"","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"columns":[],"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"Time to first non-author activity","fontSize":"90%","gridPos":{"h":12,"w":24,"x":0,"y":13},"id":3,"links":[],"pageSize":10,"scroll":true,"showHeader":true,"sort":{"col":0,"desc":true},"styles":[{"alias":"Time","align":"auto","dateFormat":"MM/DD/YYYY","pattern":"Time","type":"date"},{"alias":"","align":"auto","colors":["rgba(245, 54, 54, 0.9)","rgba(237, 129, 40, 0.89)","rgba(50, 172, 45, 0.97)"],"decimals":2,"pattern":"/.*/","thresholds":[],"type":"number","unit":"short"}],"targets":[{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"descr\" FROM \"non_author_[[repogroup]]_percentile_15_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time as \"Time\",\n  descr as \"15th percentile\"\nfrom\n  sfirst_non_author\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'non_auth[[repogroup]]p15'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"descr\" FROM \"non_author_[[repogroup]]_median_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time as \"Time\",\n  descr as \"Median\"\nfrom\n  sfirst_non_author\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'non_auth[[repogroup]]med'\norder by\n  time","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]},{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"SELECT \"descr\" FROM \"non_author_[[repogroup]]_percentile_85_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time as \"Time\",\n  descr as \"85th percentile\"\nfrom\n  sfirst_non_author\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'non_auth[[repogroup]]p85'\norder by\n  time","refId":"C","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]}],"title":"Time to first non-author activity ([[repogroup]], [[period]])","transform":"timeseries_to_rows","type":"table-old"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":11,"w":24,"x":0,"y":25},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"schemaVersion":36,"style":"dark","tags":["dashboard","apicurioregistry"],"templating":{"list":[{"current":{"selected":false,"text":"Apicurio Registry","value":"Apicurio Registry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"full_name","options":[],"query":"select value_s from gha_vars where name = 'full_name'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"tags":[],"text":"7 Days MA","value":"d7"},"hide":0,"includeAll":false,"label":"Period","multi":false,"name":"period","options":[{"selected":true,"text":"7 Days MA","value":"d7"},{"selected":false,"text":"Week","value":"w"},{"selected":false,"text":"Month","value":"m"},{"selected":false,"text":"Quarter","value":"q"},{"selected":false,"text":"Year","value":"y"}],"query":"d7,w,m,q,y","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"All","value":"All"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Repository group","multi":false,"name":"repogroup_name","options":[],"query":"select all_repo_group_name from tall_repo_groups order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"all","value":"all"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"label":"","multi":false,"name":"repogroup","options":[],"query":"select all_repo_group_value from tall_repo_groups where all_repo_group_name = '[[repogroup_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry first non-author activity dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/first_non_author_activity.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003efirst_non_author_activity\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/first-non-author-activity.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows median, 15th and 85th percentiles of time before issue creation and first non-author activity on the issue.\u003c/li\u003e\n\u003cli\u003eYou can choose repository group (or all of them) and aggregation period.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will calculate percentiles in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003cli\u003eWe are skipping bots activity, see \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/excluding_bots.md\" target=\"_blank\"\u003eexcluding bots\u003c/a\u003e for details.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry first non-author activity dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/first_non_author_activity.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003efirst_non_author_activity\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/first-non-author-activity.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows median, 15th and 85th percentiles of time before issue creation and first non-author activity on the issue.\u003c/li\u003e\n\u003cli\u003eYou can choose repository group (or all of them) and aggregation period.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will calculate percentiles in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003cli\u003eWe are skipping bots activity, see \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/excluding_bots.md\" target=\"_blank\"\u003eexcluding bots\u003c/a\u003e for details.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'non_author_activity_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-1y","to":"now-2w"},"timepicker":{"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"PR Time to Engagement","uid":"10","version":2,"weekStart":""}


created: 2026-06-12 18:27:18
data:
  {"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","name":"Annotations \u0026 Alerts","target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":37,"iteration":1781288638018,"links":[],"liveNow":false,"panels":[{"columns":[],"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"[[full_name]] Repository Groups definitions","fontSize":"90%","gridPos":{"h":24,"w":24,"x":0,"y":0},"hideTimeOverride":false,"id":1,"interval":"","links":[],"pageSize":25,"scroll":true,"showHeader":true,"sort":{"col":0,"desc":true},"styles":[],"targets":[{"alias":"","dsType":"influxdb","format":"table","group":[],"groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"metricColumn":"none","orderByTime":"ASC","policy":"default","query":"","rawQuery":true,"rawSql":"select\n  distinct coalesce(case repo_group when '' then 'Not specified' else repo_group end, 'Not specified') as \"Repository group\",\n  name as \"Repository\"\nfrom\n  gha_repo_groups\nwhere\n  name like '%_/_%'\n  and name not like '%/%/%'\n  and ('[[repogroups:csv]]' = 'null' or coalesce(case repo_group when '' then 'Not specified' else repo_group end, 'Not specified') in ([[repogroups]]))\n","refId":"A","resultFormat":"table","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]}],"title":"[[full_name]] Repository Groups definitions","transform":"table","type":"table-old"}],"refresh":false,"schemaVersion":36,"style":"dark","tags":["dashboard","apicurioregistry","table"],"templating":{"list":[{"current":{"selected":false,"text":"Apicurio Registry","value":"Apicurio Registry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"full_name","options":[],"query":"select value_s from gha_vars where name = 'full_name'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"null","current":{"selected":true,"text":["All"],"value":["$__all"]},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"select repo_group_name from trepo_groups union select 'Not specified' order by 1","hide":0,"includeAll":true,"label":"Repository groups","multi":true,"name":"repogroups","options":[],"query":"select repo_group_name from trepo_groups union select 'Not specified' order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-7d","to":"now"},"timepicker":{"hidden":true,"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"Repository groups","uid":"68","version":2,"weekStart":""}


created: 2026-06-12 18:27:39
data:
  {"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","name":"Annotations \u0026 Alerts","target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","query":"SELECT title, description from annotations WHERE $timeFilter order by time asc","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tagsColumn":"title,description","textColumn":"","titleColumn":"[[full_name]] release","type":"alert"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":38,"iteration":1781288639433,"links":[],"liveNow":false,"panels":[{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"decimals":0,"description":"Community stats ([[repo_name]])","fieldConfig":{"defaults":{"links":[]},"overrides":[]},"fill":0,"fillGradient":0,"gridPos":{"h":14,"w":24,"x":0,"y":0},"hiddenSeries":false,"id":1,"legend":{"alignAsTable":false,"avg":true,"current":true,"hideEmpty":false,"hideZero":false,"max":true,"min":true,"rightSide":false,"show":true,"total":false,"values":true},"lines":true,"linewidth":1,"links":[],"nullPointMode":"null","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":1,"points":false,"renderer":"flot","seriesOverrides":[{"alias":"Stargazers","yaxis":1},{"alias":"Forks","yaxis":2},{"alias":"Open Issues and PRs","yaxis":2}],"spaceLength":10,"stack":false,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Stargazers\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'watch[[repo]]watch'\n  and period = 'w'\norder by\n  time\n;","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]},{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Forks\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'watch[[repo]]forks'\n  and period = 'w'\norder by\n  time\n;","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]},{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Open Issues and PRs\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'watch[[repo]]opiss'\n  and period = 'w'\norder by\n  time\n;","refId":"C","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]}],"thresholds":[],"timeRegions":[],"title":"Community stats ([[repo_name]])","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"transparent":true,"type":"graph","xaxis":{"mode":"time","show":true,"values":["total"]},"yaxes":[{"format":"none","label":"Stargazers","logBase":1,"min":"0","show":true},{"format":"none","label":"Forks, Open issues and PRs","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"decimals":0,"description":"Community stats combined","fieldConfig":{"defaults":{"links":[]},"overrides":[]},"fill":0,"fillGradient":0,"gridPos":{"h":14,"w":24,"x":0,"y":14},"hiddenSeries":false,"id":12,"legend":{"alignAsTable":false,"avg":true,"current":true,"hideEmpty":false,"hideZero":false,"max":true,"min":true,"rightSide":false,"show":true,"total":false,"values":true},"lines":true,"linewidth":1,"links":[],"nullPointMode":"null","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":1,"points":false,"renderer":"flot","seriesOverrides":[{"alias":"All Stargazers","yaxis":1},{"alias":"All Forks","yaxis":1},{"alias":"All Open Issues and PRs","yaxis":2}],"spaceLength":10,"stack":false,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"All Stargazers\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'allwatchallwatch'\n  and period = 'w'\norder by\n  time\n;","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]},{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"All Forks\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'allwatchallforks'\n  and period = 'w'\norder by\n  time\n;","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]},{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"All Open Issues and PRs\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'allwatchallopiss'\n  and period = 'w'\norder by\n  time\n;","refId":"C","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]}],"thresholds":[],"timeRegions":[],"title":"Community stats combined","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"transparent":true,"type":"graph","xaxis":{"mode":"time","show":true,"values":["total"]},"yaxes":[{"format":"none","label":"Stargazers","logBase":1,"min":"0","show":true},{"format":"none","label":"Forks, Open issues and PRs","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":10,"w":24,"x":0,"y":28},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"refresh":false,"schemaVersion":36,"style":"dark","tags":["dashboard","apicurioregistry"],"templating":{"list":[{"current":{"selected":false,"text":"Apicurio Registry","value":"Apicurio Registry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"full_name","options":[],"query":"select value_s from gha_vars where name = 'full_name'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"Apicurio/apicurio-registry","value":"Apicurio/apicurio-registry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Repository","multi":false,"name":"repo_name","options":[],"query":"select top_repo_names_name from ttop_repo_names order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":1,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"apicurioapicurioregistry","value":"apicurioapicurioregistry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"label":"","multi":false,"name":"repo","options":[],"query":"select top_repo_names_value from ttop_repo_names where top_repo_names_name = '[[repo_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry community stats dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/watchers_by_alias.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ewatchers\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/community-stats.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows forks, stars, open issues and PRs charts for a given repository\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show maximum value in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry community stats dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/watchers_by_alias.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ewatchers\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/community-stats.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows forks, stars, open issues and PRs charts for a given repository\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show maximum value in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'community_stats_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-1y","to":"now"},"timepicker":{"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"Stars and Forks by Repository","uid":"3","version":2,"weekStart":""}


created: 2026-06-12 18:28:21
data:
  {"annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","limit":100,"name":"Annotations \u0026 Alerts","showIn":0,"target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","query":"SELECT title, description from annotations WHERE $timeFilter order by time asc","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tagsColumn":"title,description","textColumn":"","titleColumn":"[[full_name]] release","type":"alert"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":41,"iteration":1781288645003,"links":[],"liveNow":false,"panels":[{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"decimals":2,"description":"Measures user [[metric]].","fill":6,"fillGradient":0,"gridPos":{"h":18,"w":24,"x":0,"y":0},"hiddenSeries":false,"id":1,"legend":{"alignAsTable":true,"avg":true,"current":true,"hideEmpty":false,"hideZero":false,"max":true,"min":true,"rightSide":true,"show":true,"sort":"avg","sortDesc":true,"total":false,"values":true},"lines":true,"linewidth":0,"links":[],"nullPointMode":"null as zero","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":5,"points":false,"renderer":"flot","seriesOverrides":[{"alias":"All","bars":false,"fill":0,"lines":true,"linewidth":1,"stack":false,"yaxis":2}],"spaceLength":10,"stack":true,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"measurement":"sig_federation_d","orderByTime":"ASC","policy":"default","query":"","rawQuery":true,"rawSql":"select\n  time,\n  ${users:csv}\nfrom\n  suser_activity\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'user[[repogroup]][[metric]]'\norder by\n  time","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"timeRegions":[],"title":"Users [[metric]] metric ([[repogroup_name]], [[period]])","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"transparent":true,"type":"graph","xaxis":{"mode":"time","show":true,"values":[]},"yaxes":[{"format":"short","label":"Value","logBase":1,"min":"0","show":true},{"format":"short","label":"All","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"decimals":2,"description":"Measures user [[metric]].","fill":6,"fillGradient":0,"gridPos":{"h":16,"w":24,"x":0,"y":18},"hiddenSeries":false,"id":2,"legend":{"alignAsTable":true,"avg":true,"current":true,"hideEmpty":false,"hideZero":false,"max":true,"min":true,"rightSide":true,"show":true,"sort":"avg","sortDesc":true,"total":false,"values":true},"lines":true,"linewidth":0,"links":[],"nullPointMode":"null as zero","options":{"alertThreshold":true},"percentage":true,"pluginVersion":"8.5.27","pointradius":5,"points":false,"renderer":"flot","seriesOverrides":[],"spaceLength":10,"stack":true,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"measurement":"sig_federation_d","orderByTime":"ASC","policy":"default","query":"","rawQuery":true,"rawSql":"select\n  time,\n  ${users:csv}\nfrom\n  suser_activity\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'user[[repogroup]][[metric]]'\norder by\n  time","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"timeRegions":[],"title":"Users [[metric]] metric ([[repogroup_name]], [[period]])","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"transparent":true,"type":"graph","xaxis":{"mode":"time","show":true,"values":[]},"yaxes":[{"format":"short","label":"","logBase":1,"max":"100","min":"0","show":true},{"format":"short","label":"","logBase":1,"max":"100","min":"0","show":true}],"yaxis":{"align":false}},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":16,"w":24,"x":0,"y":34},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"schemaVersion":36,"style":"dark","tags":["dashboard","apicurioregistry"],"templating":{"list":[{"current":{"selected":false,"text":"Apicurio Registry","value":"Apicurio Registry"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"full_name","options":[],"query":"select value_s from gha_vars where name = 'full_name'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":true,"text":"Week","value":"w"},"hide":0,"includeAll":false,"label":"Period","multi":false,"name":"period","options":[{"selected":false,"text":"Day","value":"d"},{"selected":false,"text":"7 Days MA","value":"d7"},{"selected":true,"text":"Week","value":"w"},{"selected":false,"text":"Month","value":"m"},{"selected":false,"text":"Quarter","value":"q"},{"selected":false,"text":"Year","value":"y"}],"query":"d,w,m,q,y","queryValue":"","skipUrlSync":false,"type":"custom"},{"current":{"tags":[],"text":"Contributions","value":"contributions"},"hide":0,"includeAll":false,"label":"Metric","multi":false,"name":"metric","options":[{"selected":false,"text":"All activity","value":"activity"},{"selected":false,"text":"Issues created","value":"issues"},{"selected":false,"text":"Pull requests created","value":"prs"},{"selected":false,"text":"Reviews submitted","value":"reviews"},{"selected":false,"text":"Commits made","value":"commits"},{"selected":false,"text":"Pushes made","value":"pushes"},{"selected":true,"text":"Contributions","value":"contributions"},{"selected":false,"text":"Added comments","value":"comments"}],"query":"activity,issues,prs,pushes,commits,contributions,comments,reviews","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"All","value":"All"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Repository group","multi":false,"name":"repogroup_name","options":[],"query":"select all_repo_group_name from tall_repo_groups order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"all","value":"all"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"label":"","multi":false,"name":"repogroup","options":[],"query":"select all_repo_group_value from tall_repo_groups where all_repo_group_name = '[[repogroup_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"","current":{"selected":true,"text":["All"],"value":["$__all"]},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":true,"label":"Users","multi":true,"name":"users","options":[],"query":"select '\"' || users_name || '\"' from tusers order by time asc","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry users stats dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/user_activity.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003euser_activity\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/users-stats.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows various user statistics.\u003c/li\u003e\n\u003cli\u003eContributor is defined as somebody who made a review, comment, commit, created PR or issue.\u003c/li\u003e\n\u003cli\u003eContribution is a review, comment, commit, issue or PR.\u003c/li\u003e\n\u003cli\u003eYou can select statistic from the metrics drop down (All activity means all events registered by GitHub).\u003c/li\u003e\n\u003cli\u003eYou can select single repository group or summary statistics for all of them combined.\u003c/li\u003e\n\u003cli\u003eYou can select multiple users or all of them in a multi select dowp down.\u003c/li\u003e\n\u003cli\u003eWe are showing top 255 most active users in the drop-down list.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show data in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003cli\u003eWe are skipping bots activity, see \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/excluding_bots.md\" target=\"_blank\"\u003eexcluding bots\u003c/a\u003e for details.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eApicurio Registry users stats dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/user_activity.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003euser_activity\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/apicurioregistry/users-stats.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows various user statistics.\u003c/li\u003e\n\u003cli\u003eContributor is defined as somebody who made a review, comment, commit, created PR or issue.\u003c/li\u003e\n\u003cli\u003eContribution is a review, comment, commit, issue or PR.\u003c/li\u003e\n\u003cli\u003eYou can select statistic from the metrics drop down (All activity means all events registered by GitHub).\u003c/li\u003e\n\u003cli\u003eYou can select single repository group or summary statistics for all of them combined.\u003c/li\u003e\n\u003cli\u003eYou can select multiple users or all of them in a multi select dowp down.\u003c/li\u003e\n\u003cli\u003eWe are showing top 255 most active users in the drop-down list.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show data in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003cli\u003eWe are skipping bots activity, see \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/excluding_bots.md\" target=\"_blank\"\u003eexcluding bots\u003c/a\u003e for details.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'users_stats_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-1y","to":"now"},"timepicker":{"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"Users Statistics by Repository Group","uid":"48","version":2,"weekStart":""}


# user_auth_token

auth_token: c0f2ebaff7172764d00f5b097684e2d72dad9840ff63e5682d7b80a2f9bd2f8b
prev_auth_token: 8b8ed3074776d85ede6de76a0967bb39a6171d59a5cb0ff94eddb5f2fa79dacf
client_ip: 95.130.4.167
user_agent:
  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36


# alert_configuration

configuration_version: v1
configuration_hash: 8c409350c88d78d2ee938448449e628d
alertmanager_configuration:
  {
  	"alertmanager_config": {
  		"route": {
  			"receiver": "grafana-default-email"
  		},
  		"receivers": [{
  			"name": "grafana-default-email",
  			"grafana_managed_receiver_configs": [{
  				"uid": "",
  				"name": "email receiver",
  				"type": "email",
  				"isDefault": true,
  				"settings": {
  					"addresses": "<example@email.com>"
  				}
  			}]
  		}]
  	}
  }


