◼ 最も長くセッションを保持していたリストは? mysql> SELECT -> sqlset_session_id, -> sqlset_id, -> query_session_id, -> CONCAT(LEFT(dbuser_name, 0), REPEAT('*', CHAR_LENGTH(dbuser_name) -0)) dbuser_name, -> CONCAT(LEFT(target_dbname, 0), REPEAT('*', CHAR_LENGTH(target_dbname) -0)) target_dbname, -> session_start_datetime, -> session_end_datetime, -> ROUND(TIMESTAMPDIFF(MICROSECOND, session_start_datetime, session_end_datetime) / 1000000.0, 6) AS session_duration_sec -> FROM -> sqlset_sessions -> ORDER BY -> session_duration_sec DESC -> LIMIT 5; +-------------------+-----------+------------------+----------------+-------------------+----------------------------+----------------------------+----------------------+ | sqlset_session_id | sqlset_id | query_session_id | dbuser_name | target_dbname | session_start_datetime | session_end_datetime | session_duration_sec | +-------------------+-----------+------------------+----------------+-------------------+----------------------------+----------------------------+----------------------+ | 11390 | 1 | 14295 | ************** | | 2025-07-09 09:00:20.363211 | 2025-07-10 08:36:10.082707 | 84949.7195 | | 5861 | 1 | 12633 | ********** | ********** | 2025-07-09 12:35:26.147334 | 2025-07-10 08:26:26.769400 | 71460.6221 | | 12111 | 1 | 13008 | ********** | ********** | 2025-07-09 12:45:12.608671 | 2025-07-10 08:36:10.075717 | 71457.4670 | | 10969 | 1 | 13010 | ********** | ********** | 2025-07-09 12:45:12.839912 | 2025-07-10 08:36:07.641749 | 71454.8018 | | 20385 | 1 | 12550 | ************** | ***************** | 2025-07-09 12:34:04.142573 | 2025-07-10 08:24:41.351471 | 71437.2089 | +-------------------+-----------+------------------+----------------+-------------------+----------------------------+----------------------------+----------------------+ 5 rows in set (0.02 sec)