Skip to content

Instantly share code, notes, and snippets.

version: '3.1'
services:
postgres:
container_name: psql01
image: postgres:10.1-alpine
restart: always
ports:
- "5432:5432"
- "5433:5433"
ApiKey Load (0.4ms) SELECT `api_keys`.* FROM `api_keys` WHERE `api_keys`.`access_token` = 'api_key_tutor' ORDER BY expires_at DESC LIMIT 1
User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 1037363152 LIMIT 1
Tutor Load (0.3ms) SELECT `tutors`.* FROM `tutors` WHERE `tutors`.`id` = 1 LIMIT 1
CACHE (0.0ms) SELECT `tutors`.* FROM `tutors` WHERE `tutors`.`id` = 1 LIMIT 1 [["id", 1]]
User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`tutor_id` = 1 LIMIT 1
SQL (16.2ms) SELECT `tutoring_appointments`.`id` AS t0_r0, `tutoring_appointments`.`starts` AS t0_r1, `tutoring_appointments`.`ends` AS t0_r2, `tutoring_appointments`.`tutoring_appointment_series_id` AS t0_r3, `tutoring_appointments`.`tutor_response` AS t0_r4, `tutoring_appointments`.`student_response` AS t0_r5, `tutoring_appointments`.`deleted_at` AS t0_r6, `tutoring_appointments`.`created_at` AS t0_r7, `tutoring_appointments`.`updated_at` AS t0_r8, `online_sessions`.`id` AS t1_r0, `online_sessions`.`session
After: calendar_appointments
Not sure this made it better.
SQL (15.7ms) SELECT `tutoring_appointments`.`id` AS t0_r0, `tutoring_appointments`.`starts` AS t0_r1, `tutoring_appointments`.`ends` AS t0_r2, `tutoring_appointments`.`tutoring_appointment_series_id` AS t0_r3, `tutoring_appointments`.`tutor_response` AS t0_r4, `tutoring_appointments`.`student_response` AS t0_r5, `tutoring_appointments`.`deleted_at` AS t0_r6, `tutoring_appointments`.`created_at` AS t0_r7, `tutoring_appointments`.`updated_at` AS t0_r8, `online_sessions`.`id` AS t1_r0, `online_sessions`.`session_uid` AS t1_r1, `online_sessions`.`created_at` AS t1_r2, `online_sessions`.`updated_at` AS t1_r3, `online_sessions`.`current_tab` AS t1_r4, `online_sessions`.`math_text` AS t1_r5, `online_sessions`.`code_text` AS t1_r6, `online_sessions`.`ended_at` AS t1_r7, `online_sessions`.`time_passed` AS t1_r8, `online_sessions`.`conference_key` AS t1_r9, `online_sessions`.`svg_content` AS t1_r10, `online_sessions`.`pinned_tab` AS t1_r11, `online_session