Skip to content

Instantly share code, notes, and snippets.

@did
Created January 23, 2023 17:35
Show Gist options
  • Save did/3e7b3df032775d35c858b75f08cb5029 to your computer and use it in GitHub Desktop.
Save did/3e7b3df032775d35c858b75f08cb5029 to your computer and use it in GitHub Desktop.
| | client backend
u4urnn0ls335s3 | puma: cluster worker 2: 4 [app] - 18.212.29.14:40402 | 2023-01-23 16:40:49.487402+00 | SELECT "users".* FROM "users" WHERE "users"."uuid" = '75421385-e16b-4103-bb47-b7df6a3408e2' LIMIT 1 | ClientRead | client backend
u4urnn0ls335s3 | puma: cluster worker 1: 4 [app] - 44.200.193.120:36662 | 2023-01-23 16:58:28.601713+00 | SELECT "users".* FROM "users" WHERE "users"."uuid" = 'fea009bd-53b6-44cf-8685-61d702e711ce' LIMIT 1 | ClientRead | client backend
u4urnn0ls335s3 | puma: cluster worker 1: 4 [app] - 3.228.20.213:55750 | 2023-01-23 16:03:15.777024+00 | SELECT "pet_requests"."id" AS t0_r0, "pet_requests"."sender_id" AS t0_r1, "pet_requests"."receiver_id" AS t0_r2, "pet_requests"."status" AS t0_r3, "pet_requests"."created_at" AS t0_r4, "pet_requests"."updated_at" AS t0_r5, "pet_requests"."request_source" AS t0_r6, "pet_requests"."pet_type_id" AS t0_r7, "pet_types"."id" AS t1_r0, "pet_types"."name" AS t1_r1, "pet_types"."code" AS t1_r2, "pet_types"."created_at" AS t1_r3, "pet_types"."updated_at" AS t1_r4, "users"."id" AS t2_r0, "users"."uuid" AS t2_r1, "users"."refresh_token" AS t2_r2, "users"."phone_number" AS t2_r3, "users"."avatar" AS t2_r4, "users"."username" AS t2_r5, "users"."amplitude_id" AS t2_r6, "users"."onesignal_id" AS t2_r7, "users"."last_seen_at" AS t2_r8, "users"."phone_country_code" AS t2_r9, "users"."created_at" AS t2_r10, "users"."updated_at" AS t2_r11, "users"."colour" AS t2_r12, "users"."is_blocked" AS t2_r13, "users"."coins_quantity" AS t2_r14, "users"."has_installed_widget" AS t2_r15, "users"."has_deep_link" AS t2_r16, "users"."locale" A | | client backend
u4urnn0ls335s3 | puma: cluster worker 0: 4 [app] - 3.235.144.237:46782 | 2023-01-23 16:51:13.694051+00 | SELECT "users".* FROM "users" WHERE "users"."uuid" = 'bd2d2bd3-de0c-4706-8fce-10b9f487808f' LIMIT 1 | ClientRead | client backend
u4urnn0ls335s3 | puma: cluster worker 3: 4 [app] - 3.239.215.230:52934 | 2023-01-23 16:53:40.479217+00 | EXPLAIN SELECT "pets"."id" AS t0_r0, "pets"."unique_id" AS t0_r1, "pets"."level" AS t0_r2, "pets"."health_state" AS t0_r3, "pets"."streak_counter" AS t0_r4, "pets"."created_at" AS t0_r5, "pets"."updated_at" AS t0_r6, "pets"."image" AS t0_r7, "pets"."name" AS t0_r8, "pets"."streak_dead_time" AS t0_r9, "pets"."last_streak_update_at" AS t0_r10, "pets"."background_url" AS t0_r11, "pets"."is_hidden" AS t0_r12, "pets"."last_care_at" AS t0_r13, "pets"."message" AS t0_r14, "pets"."background_unlocked" AS t0_r15, "pets"."is_dead" AS t0_r16, "pets"."accessory_id" AS t0_r17, "pets"."accessories_unlocked" AS t0_r18, "pets"."wallpapers_unlocked" AS t0_r19, "pets"."pet_type_id" AS t0_r20, "pets"."next_check_state_at" AS t0_r21, "pet_types"."id" AS t1_r0, "pet_types"."name" AS t1_r1, "pet_types"."code" AS t1_r2, "pet_types"."created_at" AS t1_r3, "pet_types"."updated_at" AS t1_r4, "pet_metrics"."id" AS t2_r0, "pet_metrics"."pet_id" AS t2_r1, "pet_metrics"."streak_counter" AS t2_r2, "pet_metrics"."rename_pet_counter" AS t2_ | ClientRead | client backend
u4urnn0ls335s3 | puma: cluster worker 5: 4 [app] - 54.204.70.41:52684 | 2023-01-23 16:42:49.593404+00 | SELECT "pet_requests"."id" AS t0_r0, "pet_requests"."sender_id" AS t0_r1, "pet_requests"."receiver_id" AS t0_r2, "pet_requests"."status" AS t0_r3, "pet_requests"."created_at" AS t0_r4, "pet_requests"."updated_at" AS t0_r5, "pet_requests"."request_source" AS t0_r6, "pet_requests"."pet_type_id" AS t0_r7, "pet_types"."id" AS t1_r0, "pet_types"."name" AS t1_r1, "pet_types"."code" AS t1_r2, "pet_types"."created_at" AS t1_r3, "pet_types"."updated_at" AS t1_r4, "users"."id" AS t2_r0, "users"."uuid" AS t2_r1, "users"."refresh_token" AS t2_r2, "users"."phone_number" AS t2_r3, "users"."avatar" AS t2_r4, "users"."username" AS t2_r5, "users"."amplitude_id" AS t2_r6, "users"."onesignal_id" AS t2_r7, "users"."last_seen_at" AS t2_r8, "users"."phone_country_code" AS t2_r9, "users"."created_at" AS t2_r10, "users"."updated_at" AS t2_r11, "users"."colour" AS t2_r12, "users"."is_blocked" AS t2_r13, "users"."coins_quantity" AS t2_r14, "users"."has_installed_widget" AS t2_r15, "users"."has_deep_link" AS t2_r16, "users"."locale" A | | client backend
u4urnn0ls335s3 | puma: cluster worker 1: 4 [app] - 3.228.20.213:41300 | 2023-01-23 16:46:26.015536+00 | SELECT COUNT(*) FROM "user_pets" WHERE "user_pets"."user_id" = 380501
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment