Why Ruby?

.MD

UpdateGithubDataJob

…

Most impactful sections

http83%
code14%
sql2%
gc<1%
cache<1%
unknown<1%


http app/models/concerns/user/github_syncable.rb:163	83%
Average Self 4,775ms Calls 105x Total Self 501,469ms Total Children 0ms Total runtime 501,469ms `POST api.github.com`
code app/jobs/update_github_data_job.rb:6	14%
Average Self 84,115ms Calls 1x Total Self 84,115ms Total Children 515,866ms Total runtime 599,981ms `UpdateGithubDataJob#perform`
sql app/models/project.rb:29	<1%
Average Self 0.24ms Calls 20,176x Total Self 4,848ms Total Children 0ms Total runtime 4,848ms `BEGIN immediate TRANSACTION SELECT ? AS one FROM "star_snapshots" WHERE "star_snapshots"."recorded_on" = ? AND "star_snapshots"."project_id" = ? LIMIT ? INSERT INTO "star_snapshots" ("project_id", "stars", "recorded_on", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) RETURNING "id" COMMIT TRANSACTION`
gc ruby/gc.c	<1%
Average Self 135ms Calls 22x Total Self 2,989ms Total Children 0ms Total runtime 2,989ms `GC.start`
sql app/models/project.rb:28	<1%
Average Self 0.37ms Calls 5,044x Total Self 1,848ms Total Children 0ms Total runtime 1,848ms `SELECT "star_snapshots".* FROM "star_snapshots" WHERE "star_snapshots"."project_id" = ? AND "star_snapshots"."recorded_on" = ? LIMIT ?`
sql app/models/project.rb:22	<1%
Average Self 0.3ms Calls 4,929x Total Self 1,466ms Total Children 0ms Total runtime 1,466ms `SELECT "star_snapshots"."stars" FROM "star_snapshots" WHERE "star_snapshots"."project_id" = ? ORDER BY "star_snapshots"."recorded_on" DESC LIMIT ?`
sql app/models/concerns/user/github_syncable.rb:125	<1%
Average Self 0.25ms Calls 5,044x Total Self 1,253ms Total Children 0ms Total runtime 1,253ms `SELECT "projects".* FROM "projects" WHERE "projects"."user_id" = ? AND "projects"."github_url" = ? LIMIT ?`
sql app/models/concerns/user/github_syncable.rb:121	<1%
Average Self 2.7ms Calls 429x Total Self 1,164ms Total Children 0ms Total runtime 1,164ms `UPDATE "projects" SET "archived" = ? WHERE "projects"."user_id" = ? AND "projects"."archived" = ? AND "projects"."github_url" NOT IN (?) UPDATE "projects" SET "archived" = ? WHERE "projects"."user_id" = ? AND "projects"."archived" = ? AND ?=? UPDATE "projects" SET "archived" = ? WHERE "projects"."user_id" = ? AND "projects"."archived" = ? AND "projects"."github_url" != ?`
sql app/models/concerns/user/github_syncable.rb:143	<1%
Average Self 1.9ms Calls 429x Total Self 809ms Total Children 0ms Total runtime 809ms `SELECT "projects".* FROM "projects" WHERE "projects"."user_id" = ? AND "projects"."hidden" = ? AND "projects"."archived" = ?`
sql app/models/concerns/user/github_syncable.rb:145	<1%
Average Self 1.7ms Calls 429x Total Self 750ms Total Children 0ms Total runtime 750ms `SELECT COUNT(*) FROM "projects" WHERE "projects"."user_id" = ? AND "projects"."hidden" = ? AND "projects"."archived" = ?`
sql app/models/concerns/user/github_syncable.rb:146	<1%
Average Self 1.6ms Calls 429x Total Self 673ms Total Children 0ms Total runtime 673ms `SELECT SUM("projects"."stars") FROM "projects" WHERE "projects"."user_id" = ? AND "projects"."hidden" = ? AND "projects"."archived" = ?`
sql app/models/concerns/user/github_syncable.rb:227	<1%
Average Self 0.28ms Calls 2,356x Total Self 661ms Total Children 0ms Total runtime 661ms BEGIN immediate TRANSACTION SELECT ? AS one FROM "users" WHERE "users"."slug" = ? AND "users"."id" != ? LIMIT ? SELECT ? AS one FROM "users" WHERE "users"."email" = ? AND "users"."id" != ? LIMIT ? UPDATE "users" SET "updated_at" = ?, "github_data_updated_at" = ? WHERE "users"."id" = ? SELECT "friendly_id_slugs".* FROM "friendly_id_slugs" WHERE "friendly_id_slugs"."sluggable_id" = ? AND "friendly_id_slugs"."sluggable_type" = ? ORDER BY "friendly_id_slugs"."id" DESC LIMIT ? COMMIT TRANSACTION UPDATE "users" SET "avatar_url" = ?, "updated_at" = ?, "github_data_updated_at" = ? WHERE "users"."id" = ?
sql app/models/concerns/user/github_syncable.rb:144	<1%
Average Self 0.18ms Calls 1,946x Total Self 343ms Total Children 0ms Total runtime 343ms BEGIN immediate TRANSACTION SELECT ? AS one FROM "users" WHERE "users"."slug" = ? AND "users"."id" != ? LIMIT ? SELECT ? AS one FROM "users" WHERE "users"."email" = ? AND "users"."id" != ? LIMIT ? SELECT "friendly_id_slugs".* FROM "friendly_id_slugs" WHERE "friendly_id_slugs"."sluggable_id" = ? AND "friendly_id_slugs"."sluggable_type" = ? ORDER BY "friendly_id_slugs"."id" DESC LIMIT ? COMMIT TRANSACTION UPDATE "users" SET "updated_at" = ?, "stars_gained" = ? WHERE "users"."id" = ? UPDATE "users" SET "updated_at" = ?, "github_stars_sum" = ?, "github_repos_count" = ?, "stars_gained" = ? WHERE "users"."id" = ? UPDATE "users" SET "updated_at" = ?, "github_repos_count" = ? WHERE "users"."id" = ? UPDATE "users" SET "updated_at" = ?, "github_stars_sum" = ?, "github_repos_count" = ? WHERE "users"."id" = ? UPDATE "users" SET "updated_at" = ?, "github_stars_sum" = ?, "stars_gained" = ? WHERE "users"."id" = ? UPDATE "users" SET "updated_at" = ?, "github_stars_sum" = ? WHERE "users"."id" = ?
sql app/models/team.rb:44	<1%
Average Self 0.18ms Calls 1,040x Total Self 183ms Total Children 0ms Total runtime 183ms `BEGIN immediate TRANSACTION SELECT ? AS one FROM "teams" WHERE "teams"."id" IS NOT NULL AND "teams"."slug" = ? LIMIT ? SELECT ? AS one FROM "teams" WHERE "teams"."name" = ? LIMIT ? SELECT ? AS one FROM "teams" WHERE "teams"."slug" = ? LIMIT ? ROLLBACK TRANSACTION`
sql app/jobs/update_github_data_job.rb:13	<1%
Average Self 1.1ms Calls 87x Total Self 98ms Total Children 0ms Total runtime 98ms `SELECT "users".* FROM "users" WHERE NOT (("users"."username" = ? OR "users"."username" IS NULL)) ORDER BY "users"."id" ASC LIMIT ? SELECT "users".* FROM "users" WHERE NOT (("users"."username" = ? OR "users"."username" IS NULL)) AND "users"."id" > ? ORDER BY "users"."id" ASC LIMIT ?`
sql app/models/provider_credential.rb:34	<1%
Average Self 71ms Calls 1x Total Self 71ms Total Children 0ms Total runtime 71ms `SELECT "provider_credentials".* FROM "provider_credentials"`
sql app/models/team.rb:32	<1%
Average Self 0.29ms Calls 221x Total Self 65ms Total Children 0ms Total runtime 65ms `SELECT "teams".* FROM "teams" WHERE "teams"."name" = ? LIMIT ?`
sql app/models/setting.rb:22	<1%
Average Self 0.61ms Calls 87x Total Self 53ms Total Children 0ms Total runtime 53ms `SELECT "settings".* FROM "settings" ORDER BY "settings"."id" ASC LIMIT ?`
sql app/models/user.rb:227	<1%
Average Self 0.19ms Calls 221x Total Self 41ms Total Children 0ms Total runtime 41ms `SELECT ? AS one FROM "memberships" WHERE "memberships"."user_id" = ? AND "memberships"."team_id" = ? LIMIT ?`
cache app/models/user.rb:296	<1%
Average Self 28ms Calls 1x Total Self 28ms Total Children 4ms Total runtime 32ms `delete`
sql app/models/concerns/user/github_syncable.rb:138	<1%
Average Self 0.19ms Calls 129x Total Self 25ms Total Children 0ms Total runtime 25ms BEGIN immediate TRANSACTION UPDATE "projects" SET "forks_count" = ?, "updated_at" = ? WHERE "projects"."id" = ? COMMIT TRANSACTION UPDATE "projects" SET "topics" = ?, "updated_at" = ? WHERE "projects"."id" = ? UPDATE "projects" SET "forks_count" = ?, "topics" = ?, "updated_at" = ? WHERE "projects"."id" = ? SELECT ? AS one FROM "projects" WHERE "projects"."github_url" = ? AND "projects"."user_id" = ? LIMIT ? INSERT INTO "projects" ("user_id", "name", "description", "stars", "github_url", "forks_count", "size", "topics", "pushed_at", "hidden", "archived", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING "id" UPDATE "projects" SET "size" = ?, "pushed_at" = ?, "updated_at" = ? WHERE "projects"."id" = ? UPDATE "projects" SET "pushed_at" = ?, "updated_at" = ? WHERE "projects"."id" = ? UPDATE "projects" SET "stars" = ?, "size" = ?, "pushed_at" = ?, "updated_at" = ? WHERE "projects"."id" = ? UPDATE "projects" SET "stars" = ?, "updated_at" = ? WHERE "projects"."id" = ?
sql app/models/team.rb:92	<1%
Average Self 0.17ms Calls 29x Total Self 5ms Total Children 0ms Total runtime 5ms `SELECT ? AS one FROM "teams" WHERE "teams"."id" IS NOT NULL AND "teams"."slug" = ? LIMIT ?`
sql app/models/user.rb:296	<1%
Average Self 4ms Calls 1x Total Self 4ms Total Children 0ms Total runtime 4ms `DELETE FROM "solid_cache_entries" WHERE "solid_cache_entries"."key_hash" = ?`
code /usr/local/bundle/ruby/4.0.0/bundler/gems/rails-a0da6b991a1c/activesupport/lib/active_support/callbacks.rb:130	<1%
Average Self 3ms Calls 1x Total Self 3ms Total Children 599,981ms Total runtime 599,984ms

Slowest executions

loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-

Last errors

JSON::ParserError: unexpected end of input at line 1 column 1 app/models/concerns/user/github_syncable.rb:166	1	20 May 02:06